缺少日期
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
在 AdSense Management API 中生成每日报告时,不管系统返回什么数据,您可能都希望每天的数据显示在一行中。但在某些情况下,您可能无法获得特定日期的返回数据,这仅仅是因为未记录到所请求类型的事件。
维度:DATE
指标:CLICKS
、EARNINGS
响应:
{
"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}
}
如您所见,2014-01-10 和 2014-01-11 没有返回任何行,因为没有点击或收入事件。
后续步骤
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-07-26。
[null,null,["最后更新时间 (UTC):2025-07-26。"],[[["\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)"]]