Stay organized with collectionsSave and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-17 UTC."],[[["\u003cp\u003eDaily AdSense reports may not contain a row for every date if there were no clicks or earnings on that specific day.\u003c/p\u003e\n"],["\u003cp\u003eThe example response demonstrates missing rows for dates (2014-01-10 and 2014-01-11) with no click or earning events.\u003c/p\u003e\n"],["\u003cp\u003eIf you specify a date range in your report, be aware you may get an incomplete set of dates back depending on activity.\u003c/p\u003e\n"],["\u003cp\u003eThe report includes totals and averages for clicks and earnings over the specified date range.\u003c/p\u003e\n"]]],["The AdSense Management API daily report may not return data for every day in a specified range. The `DATE` dimension, along with `CLICKS` and `EARNINGS` metrics, can result in missing rows. If no events of the requested type occur on a given day, no data is logged. For example, the provided data from January 8th to 13th, 2014, has no entries for January 10th and 11th because there were no clicks or earnings on those days. The total matched rows indicate 4 days of activity.\n"],null,["# Missing Dates\n\nWhen 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.\n\nDimension: `DATE` \n\nMetric: `CLICKS`, `EARNINGS` \n\nResponse: \n\n```carbon\n{\n \"totalMatchedRows\": \"4\",\n \"headers\": [\n { \"name\": \"DATE\", \"type\": \"DIMENSION\" },\n { \"name\": \"CLICKS\", \"type\": \"METRIC_TALLY\" },\n { \"name\": \"EARNINGS\", \"type\": \"METRIC_CURRENCY\", \"currency\": \"USD\" }\n ],\n \"rows\": [\n { \"cells\":\n [ {\"value\": \"2014-01-08\"}, {\"value\": \"3\"}, {\"value\": \"0.41\"} ],\n [ {\"value\": \"2014-01-09\"}, {\"value\": \"5\"}, {\"value\": \"0.49\"} ],\n [ {\"value\": \"2014-01-12\"}, {\"value\": \"2\"}, {\"value\": \"0.19\"} ],\n [ {\"value\": \"2014-01-13\"}, {\"value\": \"1\"}, {\"value\": \"0.03\"} ]\n }\n ],\n \"totals\": {\n \"cells\": [\n {}, {\"value\": \"13\"}, {\"value\": \"1.12\"}\n ]\n },\n \"averages\": {\n \"cells\": [\n {}, {\"value\": \"2\"}, {\"value\": \"0.28\"}\n ]\n },\n \"startDate\": {\"year\": 2014, \"month\": 1, \"day\": 8},\n \"endDate\": {\"year\": 2021, \"month\": 1, \"day\": 13}\n}\n```\n\nAs 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.\n\nNext steps\n----------\n\n- [Specifying a Date Range](/adsense/management/reporting/date_ranges)\n- [Running Large Reports](/adsense/management/reporting/large_reports)"]]
