v1.4 of the AdSense Management API is now deprecated. This version will stop returning data on October 12, 2021. Please migrate to v2 as soon as possible.

Missing Dates

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:

{
 "kind": "adsense#report",
 "totalMatchedRows": "4",
 "headers": [
  { "name": "DATE", "type": "DIMENSION" },
  { "name": "CLICKS", "type": "METRIC_TALLY" }
  { "name": "EARNINGS", "type": "METRIC_CURRENCY" }
 ],
 "rows": [
  [ "2014-01-08", "3", "0.41" ],
  [ "2014-01-09", "5", "0.49" ],
  [ "2014-01-12", "2", "0.19" ],
  [ "2014-01-13", "1", "0.03" ]
 ],
 "totals": [ "", "13", "1.12" ],
 "averages": [ "", "2", "0.28" ],
 "startDate": "2014-01-08",
 "endDate": "2014-01-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.

Next steps