Using 'month' and 'quarter' through Adobe Reporting API 1.4 | Community
Skip to main content
Level 4
November 15, 2021
Solved

Using 'month' and 'quarter' through Adobe Reporting API 1.4

  • November 15, 2021
  • 1 reply
  • 730 views

Hi there,

 

I wanted to query the 'Month' and 'Quarter' dimensions using the Adobe Reporting API but was unable to find them. It looks like these dimensions are unavailable through the API. Any workarounds or combination of dimensions that would achieve the same goal?

 

Note: I can only use the Adobe Analytics Reporting API 1.4 for this task

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Alexis_Cazes_

You might want to use this method: https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/methods/r_GetElements.md 

 

Best solution might be to run a trended report: https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/methods/r_Run.md

Trended Report1 or more elements with a dateGranularity specified. Not supported by Run, use Report.Queue instead.

 

So you would need to use https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/methods/r_Queue.md

 

So in https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/data_types/r_reportDescription.md#

 

dateGranularityreportDescriptionDateGranularityThe time units used to display data in a report that organizes the data by date, such as an Overtime report. For example: dateGranularity = "day". One of the following values: -minute (Real-Time reports only). Specify a minute interval as "minute:[interval]". The interval is an integer between 1-60 that specifies the interval to report. For example, 'minute:3' reports the request date range in 3-minute intervals. -hour -day -week -month -quarter -year

 

I would also advise you to use API 2.0 instead of 1.4. Using API 2.0 you can reproduce exact same report as in analysis workspace as it is what is being used to return data in Analysis Workspace: 

https://github.com/AdobeDocs/analytics-2.0-apis

https://experienceleague.adobe.com/docs/analytics-learn/tutorials/apis/using-analysis-workspace-to-build-api-2-requests.html?lang=en

https://adobedocs.github.io/analytics-2.0-apis/

 

 

 

1 reply

Alexis_Cazes_
Alexis_Cazes_Accepted solution
Level 10
November 16, 2021

You might want to use this method: https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/methods/r_GetElements.md 

 

Best solution might be to run a trended report: https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/methods/r_Run.md

Trended Report1 or more elements with a dateGranularity specified. Not supported by Run, use Report.Queue instead.

 

So you would need to use https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/methods/r_Queue.md

 

So in https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/data_types/r_reportDescription.md#

 

dateGranularityreportDescriptionDateGranularityThe time units used to display data in a report that organizes the data by date, such as an Overtime report. For example: dateGranularity = "day". One of the following values: -minute (Real-Time reports only). Specify a minute interval as "minute:[interval]". The interval is an integer between 1-60 that specifies the interval to report. For example, 'minute:3' reports the request date range in 3-minute intervals. -hour -day -week -month -quarter -year

 

I would also advise you to use API 2.0 instead of 1.4. Using API 2.0 you can reproduce exact same report as in analysis workspace as it is what is being used to return data in Analysis Workspace: 

https://github.com/AdobeDocs/analytics-2.0-apis

https://experienceleague.adobe.com/docs/analytics-learn/tutorials/apis/using-analysis-workspace-to-build-api-2-requests.html?lang=en

https://adobedocs.github.io/analytics-2.0-apis/