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
(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_changePeriod to Watch:
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.
Campaign Name, Impressions, Clicks, AverageCpc, Cost, CostOfSales, CostOfSalesMerged, Conversions, ConversionRate, CostPerAquisition, Position, Time on Page, Bounce Rate, Ctr
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.
You can share single sheets within the spreadsheets individually. So it is possible to give client access to each single dashboard if you like.
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.
You've purchased this product
See it in your libraryView in Library
We charged your card and sent you a receipt
You'll need an account to access this in our app. Please create a password to continue.
Download from the App Store or text yourself a link to the app
Good news! Since you already have a Gumroad account, it's also been added to your library.