pay-per-click reporting- automated dashboards using google analytics scripts

Hardcore PPC Tactics

John W. Ellis @johnWellis

Creating Custom AdWords Dashboard using App Script

@JohnWEllis

Current Reporting Options

Google Analytics Dashboard

@JohnWEllis

Current Reporting Options

Google Analytics Dashboard

• Limited amount of rows• No white-labeling• Automation is limited• Not user-friendly (or executive-

friendly)

@JohnWEllis

Current Reporting Options

• Bid management is not needed

• Paying for accessible data

• Allows GA data into Apps Scripts supported products

• Docs, Sites, Spreadsheets

@JohnWEllis

What does this mean for PPC Reporting?

Automate Reporting using Google Apps Script

@JohnWEllis

What does this mean for PPC Reporting?

Automate Reporting using Google Apps Script

@JohnWEllis

Google Analytics Report Automation (Magic).

• Script already created

• No coding required

@JohnWEllis

Using ‘Magic’

Google Analytics Report Automation (Magic).

@JohnWEllis

Create Core Report

Google Analytics Report Automation (Magic).

• Metrics & Dimensions

@JohnWEllis

developers.google.com/analytics

Google Analytics Report Automation (Magic).

@JohnWEllis

Create Core Report

Google Analytics Report Automation (Magic).

1. GA Profile ID

2. Date Range

3. Metrics

4. Dimensions

5. Filters

6. Sheet name

@JohnWEllis

Replicate a Google Analytics Reporting

Automate Reporting using Google Apps Script

@JohnWEllis

Replicate a Google Analytics Reporting – Why?

Automate Reporting using Google Apps Script

• User Access Issues• No Email or attachments

@JohnWEllis

Automate Reporting using Google Apps Script

• Custom Graphs / Charts

Replicate a Google Analytics Reporting – Why?

@JohnWEllis

Automate Reporting using Google Apps Script

• Triggers

Replicate a Google Analytics Reporting – Why?

@JohnWEllis

Where we are

Automate Reporting using Google Apps Script

• Install Google Analytics Report Automation (Magic)• Get fields from developers.google.com/analytics• Create schedule using Triggers

From Data to Dashboards

@JohnWEllis

Creating an AdWords Dashboard

@JohnWEllis

Creating an AdWords Dashboard

@JohnWEllis

Creating an AdWords Dashboard

@JohnWEllis

Advantages

Custom AdWords Dashboard

• Automated

• No Limitations

• Live Report

• Custom Design

Thank You!

John W. Ellis@johnwellis

Thank You