Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit is happening now. Discover what's next in customer experience.

Download query information


Level 2

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,



1 Reply


Community Advisor

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:

    _experience.customerJourneyManagement.messageExecution.messageExecutionID AS messageExecutionID,
    _experience.customerJourneyManagement.messageInteraction.interactionType AS interactionType,
    count(1) eventCount
from cjm_email_tracking_experience_event_dataset

group by
order by
limit 100;


Query examples: Dataset query examples | Adobe Journey Optimizer

How to report datasets: Export datasets to cloud storage locations | Adobe Journey Optimizer

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now