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