Hello Community,
We want to download a consolidated report from a query, as AJO only allows us to see reports per campaign or per jouney and we need to see the consolidated of all those reports.
Is it possible to download the query result information or how can we get a consolidated report of all journeys and campaigns?
Thank you,
Andrea
Hello @andreacastillom-1
You can use the query to create the dataset via query service and then export that dataset to an SFTP destination.
This query shows the breakdown of counts of different email interactions (opens, clicks) by message for a given journey:
select
_experience.customerJourneyManagement.messageExecution.messageExecutionID AS messageExecutionID,
_experience.customerJourneyManagement.messageInteraction.interactionType AS interactionType,
count(1) eventCount
from cjm_email_tracking_experience_event_dataset
group by
_experience.customerJourneyManagement.messageExecution.messageExecutionID,
_experience.customerJourneyManagement.messageInteraction.interactionType
order by
_experience.customerJourneyManagement.messageExecution.messageExecutionID,
_experience.customerJourneyManagement.messageInteraction.interactionType
limit 100;
Query examples: Dataset query examples | Adobe Journey Optimizer
How to report datasets: Export datasets to cloud storage locations | Adobe Journey Optimizer
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.