This script leverages the recently announced integration of AdWords Scripts with the Google Slides API. Because this is one of the advanced APIs, the code is a bit more complicated and you will have to enable the Google Slides API from the script through an additional authorization step.
The code below appends a new slide to your Google Slide deck and adds some basic AdWords metrics. You can modify this code to add exactly the data from AdWords you want.
/*
// AdWords Script: Add a Slide with AdWords Data
// --------------------------------------------------------------
// Copyright 2017 Optmyzr Inc., All Rights Reserved
//
// This script takes a Google Presentation as input and appends a slide with basic AdWords metrics.
// Use this to automate creating an appendix of AdWords data to existing PPC report slides.
// The AW data we append is basic but can easily be tweaked to your own needs.
//
// For more PPC management tools and reports, visit www.optmyzr.com
//
*/
// Update this line with the presentation you want to edit.
// E.g. this is for presentation https://docs.google.com/presentation/d/1RxIzTJC6Jwwd3H5aaRjA-zj3d5IhcG9uOTuOfwk8PUg/edit#slide=id.optmyzr_slide_a1f911e6-9538-427d-9e2f-12fdc951f752
var PRESENTATION_ID = "1RxIzTJC6Jwwd3H5aaRjA-zj3d5IhcG9uOTuOfwk8PUg"
function main() {
var pageId = createSlide(PRESENTATION_ID);
// Get the page element IDs for a basic TITLE_AND_BODY layout
var baseElementId = readPageElementIds(PRESENTATION_ID, pageId);
var titleId = baseElementId + "_0";
var textId = baseElementId + "_1";
// Edit the following with the text for the slide's title
var titleText = "Automatically Fetched AdWords Data";
updateElement(PRESENTATION_ID, titleId, titleText);
// The next line gets text for the body section
var dataForSlide = getLastMonthData();
updateElement(PRESENTATION_ID, textId, dataForSlide);
Logger.log("Done updating slides at https://docs.google.com/presentation/d/" + PRESENTATION_ID);
}
function getLastMonthData() {
var currentAccount = AdWordsApp.currentAccount();
//Logger.log('Customer ID: ' + currentAccount.getCustomerId() +
// ', Currency Code: ' + currentAccount.getCurrencyCode() +
// ', Timezone: ' + currentAccount.getTimeZone());
var stats = currentAccount.getStatsFor('LAST_MONTH');
var clicks = stats.getClicks();
var impressions = stats.getImpressions();
var text = clicks + " clicks from " + impressions + " impressions.";
return(text);
}
function createSlide(presentationId) {
// You can specify the ID to use for the slide, as long as it's unique.
var pageId = Utilities.getUuid();
var requests = [{
"createSlide": {
"objectId": pageId,
//"insertionIndex": 1,
"slideLayoutReference": {
"predefinedLayout": "TITLE_AND_BODY"
}
}
}];
var slide =
Slides.Presentations.batchUpdate({'requests': requests}, presentationId);
//Logger.log(slide);
//Logger.log("Created Slide with ID: " + slide.replies[0].createSlide.objectId);
return (pageId);
}
function updateElement(presentationId, elementId, textToAdd) {
var requests = [{
"insertText": {
"objectId": elementId,
"text": textToAdd,
}
}];
var result =
Slides.Presentations.batchUpdate({'requests': requests}, presentationId);
//Logger.log(result);
}
function readPageElementIds(presentationId, pageId) {
// You can use a field mask to limit the data the API retrieves
// in a get request, or what fields are updated in an batchUpdate.
var response = Slides.Presentations.Pages.get(
presentationId, pageId, {"fields": "pageElements.objectId"});
//Logger.log(response);
var objectIds = response.pageElements[0].objectId;
var parts = objectIds.split("_");
var objectIdBase = parts[0] + "_" + parts[1];
//Logger.log("objectIdBase: " + objectIdBase);
return(objectIdBase);
}
We maintain the most current version of this code on GitHub.
For a fully automated way to create PPC reports with interesting visualizations like Quality Score, a word cloud, a cause chart, or a heatmap, take a look at Optmyzr, my company.
Thanks,
Fred
