Extract calculated metrics with dimensions

[prerna]

Hey!

I wanted to extract a few calculated metrics along with certain number of dimensions (breakdowns) where in both calculated metrics and dimensions are greater than 1.

In the Adobe Data Warehouse UI, I couldn't find my calculated metrics so I assume warehouse doesn't support this? 

Any other API(1.4 / 2.0) that could fit my use case?

Any help would be highly appreciated, thank you!

[yuhuisg]

API 2.0 is probably your best option.

If you are going to be working in Excel, you could also consider installing the ReportBuilder add-on (Windows only) to get your segments and metrics.

[prerna]

The plan is to get it in a dataframe and do some transformation further on. In DWH API 1.4, we're able to get metrics broken down by dimensions- is there a similar work around for API 2.0 where in we can have calculated metrics broken down by dimensions?

[vibhatna · Accepted solution]

@prerna ,

Analysis workspace is always an option to extract data for dimensions and calc. metrics but you can use API as well. 

You can use swagger links to run the API requests which has made API so simpler:

API v1.4

https://adobedocs.github.io/analytics-1.4-apis/swagger-docs.html

API v2.0
https://adobedocs.github.io/analytics-2.0-apis/

[prerna]

@vibhatna- i suppose api1.4 cannot be used if i want to extract calculated metrics with dimensions as breakdowns

[amgup]

@prerna  In addition to @vibhatna  if you want response in JSON format without using the API then you can simply do this by enabling the debugger in Workspace Project from Help -> Enable Debugger. Once the debugger is enabled than simply hover on the right side of free form table (just below the date range selector) and you will see a bug icon. Click on that icon and then you will be able to see request and response in both XML and JSON format.

Note:- Use this approach only if you want to get data in JSON format without manually sending the request to API endpoint.

[avinash2711]

Hi @amgup, 

I have a similar requirement as @prerna and I am using the same procedure as you mentioned. 

The JSON query through debugger gives a request json like below:  

and the response as below : 

Instead of returning the dimension type values the response returns the calculated metric id 2 times. 

writing the data part in response to dataframe gives something like below: 

Hope I am clear with the above explanation. 

1. Is there any way I can get the dimension values in the response ?

2. If the above is not possible is it possible to get dimension values based on the itemids in the request  screenshot ?

[avinash2711]

I was able to achieve this ( not entirely though)  by requesting top n items for that dimension. 

This works well when your top n results coincide with the top n of the dimension with the segment and metric filters, else it would fail.

[jantzen_b]

Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?