Google Analytics Report Api v4 Report Request reports contain the number of rows, but empty rows

Question

I have 980+ viewids. I process report requests daily. They are loaded into rs db.

I have requests to send an initial 3-month mortgage for all identifiers.

When checking the data, we noticed that some of the identifiers did not seem to have backfill for them. I looked through the logs and did not get any errors from the api.

I started to run single report requests for individual views and returned the row values ​​in the response.

I added more of our log to make requests, because I thought that maybe I just did not catch the error.

For the first 850 or so, I return the expected. Data for the last 3 months, if any.

The last 100+ identifiers I get answers for viewers that have the number of rows, highs, lows and totals that are not 0, and an empty element. And this is where I am stuck now. Not sure if this is a bug or api function. Could not find any mention of any similar problem anywhere.

Some notes:

We have 12 report requests simultaneously on one server. On the Api console, we see about 12,000 requests per day. This is a node application that makes requests. We did not notice that this happens when performing daily requests for reports for all viewers. We do not push the daily limit of 50,000 requests, we have an exponential shutdown, and we repeat ourselves when we encounter speed limit errors.

An example of one of our queries:

`{
"reportRequests": [
{
"dateRanges": [
{
  "startDate": "2017-06-01",
   "endDate" : "2017-09-01"
}
],
"metrics": [
  {"expression": "ga:entrances"}, 
  {"expression": "ga:goalAbandonsAll"}, 
  {"expression": "ga:users"}, 
  {"expression": "ga:sessions"}, 
  {"expression": "ga:bounces"}, 
  {"expression": "ga:goalStartsAll"}, 
  {"expression": "ga:sessionDuration"}, 
  {"expression": "ga:goalValueAll"}, 
  {"expression": "ga:pageviews"}, 
  {"expression": "ga:timeOnPage"}
],
"pageSize": 10000, 
"includeEmptyRows": true, 
"dimensions": [
  {"name": "ga:adwordsCreativeID"},
  {"name": "ga:adSlot"},
  {"name": "ga:adTargetingType"},
  {"name": "ga:adDistributionNetwork"},
  {"name": "ga:adKeywordMatchType"},
  {"name": "ga:hour"},
  {"name": "ga:date"}
],
"samplingLevel": "LARGE",
"viewId": "123456789"
}
]
}`

We see a strange answer:

`{
"columnHeader":{
"dimensions":[
"ga:adwordsCreativeID",
"ga:adSlot",
"ga:adTargetingType",
"ga:adDistributionNetwork",
"ga:adKeywordMatchType",
"ga:hour",
"ga:date"
],
"metricHeader":{
"metricHeaderEntries":[
{"name":"ga:entrances","type":"INTEGER"},{"name":"ga:goalAbandonsAll","type":"INTEGER"},{"name":"ga:users","type":"INTEGER"},{"name":"ga:sessions","type":"INTEGER"},{"name":"ga:bounces","type":"INTEGER"},{"name":"ga:goalStartsAll","type":"INTEGER"},{"name":"ga:sessionDuration","type":"TIME"},{"name":"ga:goalValueAll","type":"CURRENCY"},{"name":"ga:pageviews","type":"INTEGER"},{"name":"ga:timeOnPage","type":"TIME"}
]
}},
"data":{
"totals":[
{"values":["1235","0","1245","1235","1091","0","63517.0","0.0","1450","63515.0"]}
],
"rowCount":602,
"minimums":[
{"values":["0","0","1","0","0","0","0.0","0.0","1","0.0"]}
],
"maximums":[
{"values":["10","0","10","10","8","0","4920.0","0.0","16","4909.0"]}
],
"rows":[]}`

Answer 1

? , "" ( min/max/totals) Google Analytics, . ['data] [' rows '] - , "" .

response = [...]
while self.is_response_empty(response):
    response = [...]

def is_response_empty(self, response):
    for report in response.get('reports', []):
        try:
            report['data']['rows']
            return False
        except:
            return True