Youtube analytics reports response empty rows

171 Views Asked by At

sorry if this question already exists, i'm trying to get audience retention data from Youtube API: (https://youtubeanalytics.googleapis.com/v2/reports), most of them are FINE, but some of videos response empty rows, meanwhile I can export audience retention data to Google Sheets on Youtube manage page.

My headers:

        headers = {
            'Accept': 'application/json', 
            'Authorization': 'Bearer {}'.format(access_token)
        }

Parametters:

        params = {
            'dimensions': 'elapsedVideoTimeRatio',
            'ids': 'channel==MINE',
            'metrics': 'audienceWatchRatio',
            'startDate': video_published_date,
            'endDate': execute_date,
            'filters': 'video=={};audienceType=={}'.format(youtube_video_id, audience_type),
            'key': *youtube_api_key*
        }

audience_type is ORGANIC and AD_INSTREAM

Response:

root - INFO : {
  "kind": "youtubeAnalytics#resultTable",
  "columnHeaders": [
    {
      "name": "elapsedVideoTimeRatio",
      "columnType": "DIMENSION",
      "dataType": "FLOAT"
    },
    {
      "name": "audienceWatchRatio",
      "columnType": "METRIC",
      "dataType": "FLOAT"
    }
  ],
  "rows": []
}

Here is one of video audience retention data i got empty rows

What do I need to pay attention to in order to get audience retention data, Please let's me know

0

There are 0 best solutions below