Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
90 lines (81 sloc) 2.77 KB
/**
* Copyright Google LLC
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
// [START apps_script_youtube_report]
/**
* Creates a spreadsheet containing daily view counts, watch-time metrics,
* and new-subscriber counts for a channel's videos.
*/
function createReport() {
// Retrieve info about the user's YouTube channel.
var channels = YouTube.Channels.list('id,contentDetails', {
mine: true
});
var channelId = channels.items[0].id;
// Retrieve analytics report for the channel.
var oneMonthInMillis = 1000 * 60 * 60 * 24 * 30;
var today = new Date();
var lastMonth = new Date(today.getTime() - oneMonthInMillis);
var metrics = [
'views',
'estimatedMinutesWatched',
'averageViewDuration',
'subscribersGained'
];
var result = YouTubeAnalytics.Reports.query({
ids: 'channel==' + channelId,
startDate: formatDateString(lastMonth),
endDate: formatDateString(today),
metrics: metrics.join(','),
dimensions: 'day',
sort: 'day'
});
if (result.rows) {
var spreadsheet = SpreadsheetApp.create('YouTube Analytics Report');
var sheet = spreadsheet.getActiveSheet();
// Append the headers.
var headers = result.columnHeaders.map(function(columnHeader) {
return formatColumnName(columnHeader.name);
});
sheet.appendRow(headers);
// Append the results.
sheet.getRange(2, 1, result.rows.length, headers.length)
.setValues(result.rows);
Logger.log('Report spreadsheet created: %s',
spreadsheet.getUrl());
} else {
Logger.log('No rows returned.');
}
}
/**
* Converts a Date object into a YYYY-MM-DD string.
* @param {Date} date The date to convert to a string.
* @return {string} The formatted date.
*/
function formatDateString(date) {
return Utilities.formatDate(date, Session.getScriptTimeZone(), 'yyyy-MM-dd');
}
/**
* Formats a column name into a more human-friendly name.
* @param {string} columnName The unprocessed name of the column.
* @return {string} The formatted column name.
* @example "averageViewPercentage" becomes "Average View Percentage".
*/
function formatColumnName(columnName) {
var name = columnName.replace(/([a-z])([A-Z])/g, '$1 $2');
name = name.slice(0, 1).toUpperCase() + name.slice(1);
return name;
}
// [END apps_script_youtube_report]
You can’t perform that action at this time.