In Progress

Google AdWords MCC Search Terms Script

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.

Skills: Google Adwords, Javascript

See more: google search terms datafeed, google search engine script rapidshare, google adwords keyword script, google shopping scripts, search query report script, how to use scripts in adwords, negative keyword script, google ads scripts training, adwords scripts reports, google ads scripts, google script search terms, google adwords keyword tool script, auto google youtube video search script, google adwords report api xslt, google search suggestion script, adwords codes search voucher links google, search google adwords promotional codes 2009, java script free google adwords, google adwords closed report sample, google adwords report script

About the Employer:
( 1 review ) Szeged, Hungary

Project ID: #21553711

Awarded to:

corporatessc

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 More

$15 USD in 4 days
(7 Reviews)
3.2

3 freelancers are bidding on average $22 for this job

Chan1010

Dear Client! I read your description carefully and i'm very interested in your project. I am specialized in PHP. I am very familiar with HTML5, CSS3, and any javascript library. I am free now and I will start work righ More

$30 USD in 2 days
(5 Reviews)
2.8
mrityunjaykr1044

Hi Recruiter, Have seen the requirement and can fulfill it easily. I am capable of assisting my clients with entire development cycle starting from requirements gathering, application GUI, application front-end and bac More

$20 USD in 7 days
(1 Review)
0.9