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


Google Analytics Dashboard

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

friendly)

@JohnWEllis


• 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

Google Analytics Report Automation (Magic).

• Script already created

• No coding required

@JohnWEllis

Using ‘Magic’


@JohnWEllis

Create Core Report


• Metrics & Dimensions

@JohnWEllis

developers.google.com/analytics


@JohnWEllis

Create Core Report


1. GA Profile ID

2. Date Range

3. Metrics

4. Dimensions

5. Filters

6. Sheet name

@JohnWEllis

Replicate a Google Analytics Reporting


@JohnWEllis

Replicate a Google Analytics Reporting – Why?


• User Access Issues• No Email or attachments

@JohnWEllis


• Custom Graphs / Charts


@JohnWEllis


• Triggers


@JohnWEllis

Where we are


• 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

Advantages

Custom AdWords Dashboard

• Automated

• No Limitations

• Live Report

• Custom Design

Thank You!

John W. Ellis@johnwellis

Thank You

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

Internet