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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

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 Reply

Avatar

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