AdWords MCC Account(s) Dashboard

What does it do?

The Script show percentual differences between two Periods,

for all Campaings of a Customer within an AdWords MCC Account per each labeled account.

That means: If you have 4 accounts in your MCC, you'll receive 4 sheets that list all the campaigns.

The Formular this is calculated on is for most of the values:

(value_current_period / value_past_period) - 1 = percentual_change

CostofSales:

(cost_current / conversionValue_current) / (cost_past / conversionValue_past)= percentual_change

CostOfSalesMerged is a little different:

(cost / (conversionValue + clickAssistedConversionsValue + impressionAssistedConversionValue)) = value_current_period

(cost / (conversionValue + clickAssistedConversionsValue + impressionAssistedConversionValue)) = value_past_period

(value_current_period / value_past_period) - 1 = percentual_change

The default period is 30 days. The default period can be adjusted in with the "defaultDays" variable.

After the first script run for an account, this value will be taken automatically.

If you want to adjust the period later, for a single account,

please change the value in the specific Customer-Dashboard.

Output Values:

Campaign Name, Impressions, Clicks, AverageCpc, Cost, CostOfSales, CostOfSalesMerged, Conversions, ConversionRate, CostPerAquisition, Position, Time on Page, Bounce Rate, Ctr

Language:

The Dashboard was designed for english Audience.

If you plan on using it for another language, habe a look around line 15 adjust the string variables there to match your language.

Tip:

You can share single sheets within the spreadsheets individually. So it is possible to give client access to each single dashboard if you like.

Installation:

1. Go to you AdWords MCC under Bulk operations > Scripts

2. Open a new Script with the "+ Script" Button.

3. Copy & Paste all lines of the script.txt document wich is content of this zip.

4. Create a new google Spreadsheet.

5. Insert the spreadsheet url where it says: INSERT_SPREADSHEET_URL_HERE

6. Adjust the Label Name for the accounts taken into the Dashboard. Standard Label is "AdWords Dashboard"

7. Set the Label for all Accounts that should be monitored.

8. Run the Script.