Expand my Community achievements bar.

SOLVED

Download query information

Avatar

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,

 

Andrea

1 Accepted Solution

Avatar

Correct answer by
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:

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


     Manoj
     Find me on LinkedIn

View solution in original post

1 Reply

Avatar

Correct answer by
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:

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


     Manoj
     Find me on LinkedIn