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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Adobe Analytics API - how get metrics out of Adobe to send to tableau?

balazst85486658
Level 1
Level 1

Hey Guys,

currently we are trying to export data via webservice api to push it to a vizualisation tool like tableau or microstrategy.

Unfortunately the description of the Reporting REST API is not clear. I would need a list of REST calls that do the following things:

  1. 1.   Identify a ReportID by a report name
  2. 2.   Get the data of the ReportID (ideally as a CSV)

Has someone a solution for this?

Thank you very much

BR Balázs

1 Accepted Solution
MichRich2184
Correct answer by
Employee
Employee

1 - The ReportID that is returned from the Analytics 1.4 Reporting API is a generated ID for the specific instance of a report that was run so there is no way to go from a report name to a specific ReportID.

2 - The following link to the getting started page for the reporintg API will take you to the documentation for how to get the data after running a report. The data is returned in a JSON object.

Analytics Reporting API 1.4 Getting Started:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/get_star...

Other helpful documentation links for running reports:

Report Description:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/data_typ...

Analytics Elements:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/methods/...

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/elements...

Analytics Metrics:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/methods/...

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/metrics....

View solution in original post

2 Replies
MichRich2184
Correct answer by
Employee
Employee

1 - The ReportID that is returned from the Analytics 1.4 Reporting API is a generated ID for the specific instance of a report that was run so there is no way to go from a report name to a specific ReportID.

2 - The following link to the getting started page for the reporintg API will take you to the documentation for how to get the data after running a report. The data is returned in a JSON object.

Analytics Reporting API 1.4 Getting Started:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/get_star...

Other helpful documentation links for running reports:

Report Description:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/data_typ...

Analytics Elements:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/methods/...

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/elements...

Analytics Metrics:

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/methods/...

https://github.com/Adobe-Experience-Cloud/analytics-1.4-apis/blob/master/docs/reporting-api/metrics....

View solution in original post

cristinafoit
Level 3
Level 3

Hi @balazst85486658 

 

hi there, not sure if this is still relevant but the company I work for (Daexus) actually released a free web data connector that imports Adobe analytics data in Tableau.

The tool is super secure as it only runs on users' computers. No sign-up or download required, all you need to do is open the web data connector link (found on our website) in Tableau and start importing your data in no time.

You can find more information on our website  but I'm happy to answer any questions!