Download query information

[andreacastillom]

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

[_Manoj_Kumar_ · Accepted solution]

Hello @andreacastillom 

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