Looking for API/SDK to Retrieve Journey Report Data from Adobe Journey Optimizer | Community
Skip to main content
New Member
January 8, 2025
Solved

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

  • January 8, 2025
  • 3 replies
  • 914 views

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!

Best answer by DavidKangni

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

3 replies

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
January 8, 2025
David Kangni
Anuhya-Y
Community Advisor
Community Advisor
January 8, 2025

@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

DavidKangni
Community Advisor
Community Advisor
January 8, 2025

@anuhya-y 

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

David Kangni
Anuhya-Y
Community Advisor
Community Advisor
January 9, 2025

Thank you for pointing out data access API deprecation @davidkangni 

Silvio6
Level 5
January 20, 2025

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.