C Appendix: Add a New Email Campaign Event (Optional)

In this recipe, the following email campaign events are pre-configured:

• Sent Event
• Bounce Event
• Click Event
• Open Event

To add a new email campaign event other than what is pre-configured in the recipe, you must:

1. Add a new event in the lookup table ORACLE-BRT-SFMC_UNITY_EVENT_TYPE. See Configure the Lookup Tables.
2. In the Integration section, click the Oracle SFMC Automation Setup integration flow and perform the following tasks on the integration canvas.
   1. Assign global variables for the new event.
      1. On the integration canvas, select the AssignGlobalVariables element, and then click Actions and select Edit.
      2. Add new variables for the event.
   2. Add a SOAP adapter endpoint and a mapper for the new event.
      1. In the Main Scope, expand DataExtensions Scope.
      2. Add a SOAP adapter endpoint along with a mapper element.
      3. Update the mapper with the details specific to the new event.
   3. Add a status check for the data extension created.
      1. In the DataExtensions Scope, select the switch case (IF DataExtensionsCreated) element, and then click Actions and select Edit.
      2. Add a StatusCode for the new data extension created.
   4. Add query definitions for the event.
      1. In the Main Scope, expand QueryDefinitions Scope.
      2. Add a SOAP adapter endpoint and a mapper for a query definition to query events data from the Salesforce Marketing Cloud data view and import the same to the data extension created for the event.
      3. Update the query definition mapper with the details and query specific to the new event.
      4. Add another SOAP adapter endpoint and a mapper for a query definition to copy data from the event-specific data extension to the results data extension.
      5. Update the query definition mapper with the details and query specific to the new event.
      6. Add switch case conditions and assign variables for the data extensions created.
         1. In the QueryDefinitions Scope, select the switch case (IF QueryDefinitionsCreated) element, and then click Actions and select Edit.
         2. Add a StatusCheck for the new data extension created.
         3. To assign variables, select the AssignQueryDefinition element, and then click Actions and select Edit.
         4. Add a new variable in the similar format you added for other events.
   5. In the Automation Scope, update the mapper with the query definition created.
      1. In the Main Scope, expand AutomationScope.
      2. Select the Map to createAutomation element, and then click Actions and select Edit.
      3. On the mapping canvas, add a new AutomationTask and map the new query definition created with the relevant target attribute.