When running a daily report in the AdSense Management API, you may expect to get a row for each day, regardless of what data is being returned. However, in some cases you may get no data back for a given day, simply because there were no logged events of the requested types.
Dimension: DATE
Metric: CLICKS, EARNINGS
Response:
{
"totalMatchedRows": "4",
"headers": [
{ "name": "DATE", "type": "DIMENSION" },
{ "name": "CLICKS", "type": "METRIC_TALLY" },
{ "name": "EARNINGS", "type": "METRIC_CURRENCY", "currency": "USD" }
],
"rows": [
{ "cells":
[ {"value": "2014-01-08"}, {"value": "3"}, {"value": "0.41"} ],
[ {"value": "2014-01-09"}, {"value": "5"}, {"value": "0.49"} ],
[ {"value": "2014-01-12"}, {"value": "2"}, {"value": "0.19"} ],
[ {"value": "2014-01-13"}, {"value": "1"}, {"value": "0.03"} ]
}
],
"totals": {
"cells": [
{}, {"value": "13"}, {"value": "1.12"}
]
},
"averages": {
"cells": [
{}, {"value": "2"}, {"value": "0.28"}
]
},
"startDate": {"year": 2014, "month": 1, "day": 8},
"endDate": {"year": 2021, "month": 1, "day": 13}
}
As you can see, there are no rows being returned for 2014-01-10 or 2014-01-11, since there were no click or earnings events.