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

[balazst85486658]

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

[MichRich2184 · Accepted solution]

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....

[cristinafoit]

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!