export campaign results including namespace ids

[marc_stowe_za]

Hi

is there a way to export the data from a campaign, specifically the namespace id of the profiles and the campaign name, date, etc ? Thinking of sending a feed to a CRM system with the results of the send via customer so we can update records there

thanks

Marc

[SatheeskannaK]

@marc_stowe_za You can pull this data from the "AJO Message Feedback Event Dataset" and export it to the destination to feed into CRM.

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/data-management/datasets/datasets...

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/data-management/datasets/export-d...

[Mayank_Gandhi · Accepted solution]

@marc_stowe_za very commonly asked use case. Here is the approach:

• All campaign, message, and delivery events (including identity info and namespace) are stored in Adobe Experience Platform (AEP) datasets in XDM format.
• Every delivery (send, open, click, bounce, etc.) is recorded as an Experience Event with all available identityMap attributes (ECID, email, your custom IDs, etc.).
  
  How To Export the Data: 
  You can export datasets to 6 cloud storage destinations which are accessible from the Destinations menu, in the Catalog tab.

  Data Lake Access & Export

  AJO writes all delivery and event data (with namespace identity maps) to AEP Data Lake as mentioned above.
• You can query and export this data using:
  • Query Service (run SQL on datasets)
  • Data Access API (download raw parquet or JSON files)
  • Data Distiller/Adobe Data Access
  • Pull via scheduled jobs in your CRM stack (using Data Access API)

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/data-management/datasets/export-d...