How to analyze KPIs from Adobe campaign with KPIs from AJO together?

Question

My client generates campaigns in Adobe Campaign and journeys in AJO. He wants to analyze some KPIs together IN CJA, for example:

number of emails sent/delivered/opened/excluded/failed (sum of emails from AJO and from ACC)
number of SMS sent/outbound/exclusion/errors (sum of SMS from AJO and from ACC)

Is this possible? if yes, how can I do it?

Thanks!

Anuhya-Y · Accepted Answer

@hayanne

AJO datasets, delivery and tracking data (feedback, journey step events datasets etc.), are available in AEP automatically. Adobe Campaign datasets can be imported into AEP for campaign delivery and tracking data using the AEP Adobe Campaign source connection.

Once the datasets are available in AEP, create a connection using CJA with the required datasets (AJO+ACC).

Once the connection is ready, create a data view with necessary metrics and dimensions by selecting the required columns from the AJO/ACC datasets.

Once the data view is ready, create a project from the data view created above, which holds ACC and AJO data. This will help analyze KPIs of ACC and AJO.

Please refer to https://experienceleague.adobe.com/docs/journey-optimizer/using/reporting/cja-ajo.html?lang=en for a demonstration on how to analyze AJO data in CJA. Import ACC data into AEP, utilize it in CJA along with AJO data, and create different visualizations according to the AJO-journey and ACC-Campaign.