Need a Google AdWords MCC script that sends an alert email if one of the thresholds apply to one of the search terms in the search query report.
Need to configure the following:
- Date Range:
forDateRange(dateRange) for example: ALL_TIME, LAST_30_DAYS etc.
- Campaign Name Contains:
Would like to use this if I only want to look at some campaigns. If I leave it empty it is a not wanted option.
- Campaign Name Does Not Contain:
Would like to use this if I want to exclude some campaigns. If I leave it empty it is a not wanted option.
- Ignore Paused Campaigns:
If I set this to true it will only look at the currently active campaigns and to false to include campaigns that had impressions but are currently paused.
- Ignore Paused Ad Groups:
If I set this to true it will only look at currently active ad groups and to false to include ad groups that had impressions but are currently paused.
- Clicks Threshold:
Search terms will be ignored if their clicks are lower than this threshold. If I leave it empty it is a not wanted option.
- Impressions Threshold:
Search terms will be ignored if their impressions are lower than this threshold. If I leave it empty it is a not wanted option.
- Include Already Added:
If I set this to true the email will include the already added search terms as a keyword (with match type) and to false not to include already added search terms.
- Include Already Excluded:
If I set this to true the email will include the already excluded search terms (with match type) and to false not to include already excluded search terms.
Now I will need 2 lists in 1 email from 1 AdWords Account from a campaigns Search Query Report:
- Potential positive keywords
- Potential negative keywords
1.) Potential positive keywords. Search terms will be listed (with match type) in the email if their statistics meet ANY of these thresholds (a search term can appear in the email multiple times):
- CTR > Threshold
- Conversions > Threshold
- Conv. Rate > Threshold
- CPC < Threshold
- Cost Per Conversion < Threshold
2.) Potential negative search terms. Search terms will be listed (with match type) in the email if their statistics meet ANY of these thresholds (a search term can appear in th email multiple times):
- CTR < Threshold
- Conversions < Threshold
- Conv. Rate < Threshold
- CPC > Threshold
- Cost Per Conversion > Threshold
- "Cost > Threshold" & "Conversions < Threshold"
So the positive and negative thresholds can be configured in the script separately. (If it is easier you can give me 2 separate scripts, no problem).
If I wouldn't like to include one of the positive or negative thresholds in the alert email I will simply comment it out.
If I would need some more thresholds I plan to modify the script and include new ones or combine more thresholds.
Finally the email should look something like this:
Account1
Campaign1
AdGroup1
Potential positive search terms
- Search term 1 CTR > Threshold
- Search term 2 Conversions > Threshold
...
Potential negative search terms
- Search term 3 CPC > Threshold
- Search term 4 "Cost > Threshold" & "Conversions < Threshold"
AdGroup2
Potential positive search terms
- Search term 5 Cost Per Conversions > Threshold
- Search term 6 Cost Per CPC < Threshold
...
Potential negative search terms
- Search term 7 Conv. Rate < Threshold
- Search term 8 CPC > Threshold
Campaing2
...
Let me know if you need more information.
Google Adwords + Google Apps Script
Hi There,
I have understood your requirement which is to send an email alert when a metrics value crosses the given threshold. The script should be easy to understand such that you can comment out things that you don't need.
I am a Google app script developer with 4 years of experience. I have coded automation software for SMB outside of freelancer, my specialty lies in automating workflow for industries like e-commerce, B2B & the finance sector.
Here are screenshots of some of my recent projects:
[login to view URL]
Feel free to drop me a message to discuss further.
Sincerely,
Hardik Thakkar
Founder & CEO | Super Simple Cloud