Skip to main content
Level 2
Jan 8, 2025 6:15 AM UTC
Solved

Looking for API/SDK to Retrieve Journey Report Data from Adobe Journey Optimizer

Hello everyone,

I'm using Adobe Journey Optimizer and managing hundreds of journeys. 
Checking individual journey reports through the web interface has become time-consuming. I'm looking for a way to access journey report data programmatically.


I've reviewed the Adobe Journey Optimizer API documentation, but I couldn't find any specific function or endpoint for retrieving journey report data.


Does Adobe Journey Optimizer offer an API or SDK that allows developers to access or retrieve journey report data directly? If not, are there any alternative methods for automating this process? Thank you in advance for any insights or suggestions!

DavidKangni
DavidKangniAccepted solution
Adobe Champion and Community Advisor
Jan 8, 2025 5:19 PM UTC

Hi @eddiehuang 

You can generate the report using queries or data distiller.

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/data-management/datasets/datasets-query-examples

Thanks,

David

David Kangni

5 replies

DavidKangni
Adobe Champion and Community Advisor
DavidKangniAdobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
Jan 8, 2025 5:19 PM UTC

Hi @eddiehuang 

You can generate the report using queries or data distiller.

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/data-management/datasets/datasets-query-examples

Thanks,

David

Translate
David Kangni
Community Advisor
Jan 8, 2025 5:28 PM UTC

@eddiehuang 

There is no API available in AJO to retrieve journey report data at this phase.

 

However, to automate, use query service/data distiller to fetch Journey specific data and use data access API to export data. However, the data format is in parquet.  The parquet format needs to be converted into desirable format . this can be done using various programming languages

https://experienceleague.adobe.com/en/docs/experience-platform/data-access/api

Translate
DavidKangni
Adobe Champion and Community Advisor
Adobe Champion and Community Advisor
Jan 8, 2025 5:49 PM UTC

@anuhya-y 

FYI, the data access API is deprecated. It's the reason why I did not mention it in my reply 

Translate
David Kangni
Community Advisor
Jan 9, 2025 6:57 AM UTC

Thank you for pointing out data access API deprecation @davidkangni 

Translate
Silvio6
Level 6
Jan 20, 2025 7:24 PM UTC

Try using query service with, for example, Python. Save all data from query into .csv files and then you have all AJO journeys data in .csv files. Then you can use those .csv in, for example, power bi and create reports.

Translate