/export-time-series-data

Primary LanguageJavaScriptMIT LicenseMIT

Export Google Ads To Time Series Data

Export any query defined by Adwords Query Language into time series data.

Here's a handy generator for Adwords Queries.

Motivation

I wanted to answer questions not easily done in the Google Ads dashboard like:

  • Is it anomalous for this campaign to only get X conversions on Sundays?
  • Is this n-gram increasing or decreasing in volume and cost per acquisition?

How To Customize

This script takes in four diferrent inputs.

One: Write Your Query

To make this as readable as possible, I seperated out each clause from the query into multiple lines.

The during line is the date. Add your date ranges like so, with the older date in the past:

YYYYMMDD,YYYYMMDD

        {
            "select": "SELECT CampaignName, Clicks, Ctr, AverageCpc, CampaignId, CostPerConversion, AllConversionValue, InvalidClicks, SearchClickShare, TopImpressionPercentage, AbsoluteTopImpressionPercentage, Date, Impressions, Cost",
            "from": "FROM CAMPAIGN_PERFORMANCE_REPORT",
            "where": "WHERE Impressions > 0",
            "during": "DURING 20210501,20211107",
        ...

Two: Your Target Google Sheet

To get the sheet integration to work, you should update two variables: url and tabname.

            ...
            "url": "enter-sheet-url-here",
            "tabName": "enter-tabname-here",
        },

Three: If You Should Clear The Sheet

Handle clearing the sheet or adding column headers here:

var THE_SCRIPT_CLEAR_THE_CONTENTS_OF_THE_SHEET_CONTENTS = false;

var ADD_COLUMN_HEADERS = false;

Four: Have an MCC?

The export-data-account-view.js file is built for you. Be sure to add the ACCOUNT_IDS to this section. To have multiple, it looks like so:

var ACCOUNT_IDS = ["123-456-7890", "543-210-9876"];

Feature Request?

Drop into the issues tab and let me know if you want the script improved or something added.