Google Apps Script – simple query for Youtube Analitycs – part 042. – free-tutorials.org news free tutorials source code development scripts

This source code is used with Youtube Analitycs and will get information about my channel, like:
channel ID, start and end date , metric dimensions and sort by day using in one query.

function getVideoEstimatedMinutesWatched(channelId) {
  const oneMonthInMillis = 1000 * 60 * 60 * 24 * 30;
  const today = new Date();
  const lastMonth = new Date(today.getTime() - oneMonthInMillis);

  const metrics = [
    'views',
    'estimatedMinutesWatched',
    'averageViewDuration',
    'subscribersGained'
  ];
  const result = YouTubeAnalytics.Reports.query({
    ids: 'channel==' + channelId,
    startDate: formatDateString(lastMonth),
    endDate: formatDateString(today),
    metrics: metrics.join(','),
    dimensions: 'day',
    sort: 'day'
  });
  return result;
}

function getVideoEstimatedMinutesWatched(channelId) {

const oneMonthInMillis = 1000 * 60 * 60 * 24 * 30;

const today = new Date();

const lastMonth = new Date(today.getTime() - oneMonthInMillis);

const metrics = [

'views',

'estimatedMinutesWatched',

'averageViewDuration',

'subscribersGained'

];

const result = YouTubeAnalytics.Reports.query({

ids: 'channel==' + channelId,

startDate: formatDateString(lastMonth),

endDate: formatDateString(today),

metrics: metrics.join(','),

dimensions: 'day',

sort: 'day'

});

return result;

}

The result will be something like this:

getVideoEstimatedMinutesWatched {"rows":[["2022-06-10",2,2,63,0],["2022-06-11",10,6,41,0],...

1	getVideoEstimatedMinutesWatched {"rows":[["2022-06-10",2,2,63,0],["2022-06-11",10,6,41,0],...

Leave a Reply Cancel reply