Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

Reporting API / Dimensions / daterangemonth

Avatar

Level 1

Hello! There is a question related to `Reporting API`. We send a request containing a dimension `variables/daterangemonth`. According to this documentation ( https://github.com/AdobeDocs/analytics-2.0-apis/blob/master/reporting-guide.md#example-response ) we expect to get a response in the format "Month Year" (e.g. "Sep 2022"). But in some cases the response incorporates an additional information e.g. "Sep 2022 (Aug 28-Oct 1)".

Could you please explain why this is happening?
 
For example,
curl -X POST --data '{"rsid":"rsid",
"globalFilters":[{"type":"dateRange","dateRange":"2022-09-01T00:00:00.000/2022-09-30T23:59:59.999"}],
"metricContainer":"metrics":{"columnId":"0","id":"metrics/visitors","filters":[],"sort":"desc"}, {"columnId":"1","id":"metrics/visits","filters":[],"sort":"desc"}, {"columnId":"2","id":"metrics/orders","filters":[],"sort":"desc"},{"columnId":"3","id":"metrics/revenue","filters":[],"sort":"desc"}]},
"dimension": "variables/daterangemonth",
"settings": {"limit":1000,"page":0}}' 
 
Response:
{
"totalPages": 1,
"firstPage": true,
"lastPage": true,
"numberOfElements": 1,
"number": 0,
"totalElements": 1,
"columns": {
"dimension":"id": "variables/daterangemonth""type": "time"},
"columnIds": ["0","1","2","3"
},
"rows": [
{
"itemId": "<itemId>",
"value": "Sep 2022 (Aug 28-Oct 1)",
"data": [1,1,0,0]
}],
"summaryData": {
"filteredTotals": [1,1,0,0],
"totals": [1,1,0,0]
}}
 
1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Ohh... I don't use the API much.. but it just made me think... are you using a Weekly Granularity in that call?

 

Aug 28 is the first day of the week, and Oct 1 was the last day of a week...

 

I bet this is an indication of that... just like in workspace when you select the month of Sept and then do a breakdown by week, you get this:

 

Jennifer_Dungan_0-1664901752393.png

 

 

The first "week" shown runs Aug 28 - Sept 3, and the last "week" runs Sept 25 - Oct 1....

 

Those two weeks are probably partial data, based on your Sept 1-30 constraint....

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Ohh... I don't use the API much.. but it just made me think... are you using a Weekly Granularity in that call?

 

Aug 28 is the first day of the week, and Oct 1 was the last day of a week...

 

I bet this is an indication of that... just like in workspace when you select the month of Sept and then do a breakdown by week, you get this:

 

Jennifer_Dungan_0-1664901752393.png

 

 

The first "week" shown runs Aug 28 - Sept 3, and the last "week" runs Sept 25 - Oct 1....

 

Those two weeks are probably partial data, based on your Sept 1-30 constraint....