{"id":4991,"date":"2022-02-16T16:56:38","date_gmt":"2022-02-16T13:56:38","guid":{"rendered":"https:\/\/trackingchef.com\/?p=4991"},"modified":"2022-09-04T17:13:22","modified_gmt":"2022-09-04T14:13:22","slug":"google-ads-automated-rules-scripts","status":"publish","type":"post","link":"https:\/\/trackingchef.com\/google-ads\/google-ads-automated-rules-scripts\/","title":{"rendered":"Automated Rules &#038; Scripts on Google Ads"},"content":{"rendered":"\n<p>In this post, we discuss automated rules &amp; scripts on Google Ads (including examples you can use immediately!).<\/p>\n\n\n\n<p>These tactics were extracted from an expert session given by Avishay Freund, CEO of <a href=\"https:\/\/logos.co.il\">Logos<\/a> at a professional meetup hosted by Fixel.<\/p>\n\n\n\n<p>Avishay Freund is the owner and founder of Logos Internet Marketing and an expert in Marketing, Advertising, and SEO. Advisor to public and private institutions in regards to Google advertising. Certified professional by Google. Senior lecturer at universities and colleges in internet marketing and Professional WEB technology.<\/p>\n\n\n\n<p>This session in the video below was held in Hebrew but is summarized fully in English below. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed\"><iframe title=\"Avishay Freund- Automated Rules &amp; Scripts on Google Ads\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/35op27p0kU4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<p>In this session, we will discuss the two out of the three levels of automation offered by Google Ads: Rules, Scripts, and API.<\/p>\n\n\n\n<p>Avishay&#8217;s presentation can be found <a href=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Google-Ads-Scripts-Avishay-Freund-EN.pdf\" data-type=\"URL\" data-id=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Google-Ads-Scripts-Avishay-Freund-EN.pdf\">here<\/a> and his scripts can be found <a href=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Avishay-Fruend-Scripts.zip\" data-type=\"URL\" data-id=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Avishay-Fruend-Scripts.zip\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"google-ads-automated-rules\">Google Ads Automated Rules<\/h2>\n\n\n\n<p>Automated rules are as implied, a set of rules that are triggered once a set criteria is met. You can also set these to execute on a timely basis &#8211; hourly, daily, weekly, or even monthly.<\/p>\n\n\n\n<p>For example, we can set an automated spend cap of 6,000$ across our account by using a rule. This will pause all campaigns in the account.<\/p>\n\n\n\n<p>Another example is scheduling a daily email with all keywords whose quality score is 3 or lower.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"creating-a-rule\">Creating a rule<\/h3>\n\n\n\n<p>To create a rule you must be logged into your Google Ads account. <\/p>\n\n\n\n<p>To create a rule that observes campaign data, navigate to the Campaigns screen, click the three dots at the top row of the campaign table and then &#8220;Create an automated rule&#8221;.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"608\" height=\"400\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-1712245.png\" alt=\"image-1712245\" class=\"wp-image-5321\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-1712245.png 608w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-1712245-300x197.png 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/figure><\/div>\n\n\n<p> Based on the specific screen you are on, you can create an automated rule that relates to that data.<\/p>\n\n\n\n<p>You can then select the type of automation you want to run: Enable campaigns, Pause campaigns, Change budgets or Send an email.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"rule-1-pausing-campaigns-at-6-000-budget\">Rule #1:  Pausing campaigns at $6,000 budget<\/h3>\n\n\n\n<p>For this example, we can choose &#8220;Pause campaigns&#8221;.  The condition should be set to &#8220;Cost >6000$&#8221; and should be checked daily compared to the stats of the month to date (i.e. Same month)<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"591\" height=\"591\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7324002.png\" alt=\"image-7324002\" class=\"wp-image-5322\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7324002.png 591w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7324002-300x300.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7324002-150x150.png 150w\" sizes=\"(max-width: 591px) 100vw, 591px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"rule-2-email-alerts-on-low-quality-score\">Rule #2: Email alerts on low Quality Score<\/h3>\n\n\n\n<p>Create a new automation rule from the Keywords screen and select &#8220;Send email&#8221;.<\/p>\n\n\n\n<p>Set the condition to &#8220;Quality Score &lt;= 3&#8221; and set it to repeat daily.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"621\" height=\"578\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-3344737.png\" alt=\"image-3344737\" class=\"wp-image-5323\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-3344737.png 621w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-3344737-300x279.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/figure><\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Important note: Rules can be set at either account or MCC level. The key difference is for agency MCCs from which a client can move away without keeping all the rules set up.<\/strong><\/p><\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"google-ads-scripts\">Google Ads Scripts<\/h2>\n\n\n\n<p>Google Ads scripts are code lines that can interact with various data points available on Google Ads. They are hosted on Google&#8217;s servers, which makes them easier to manage. While they are more complex than rules, they offer much more flexibility. These too can be set on an account or MCC level.<\/p>\n\n\n\n<p>Download Avishay&#8217;s scripts <a href=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Avishay-Fruend-Scripts.zip\" data-type=\"URL\" data-id=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Avishay-Fruend-Scripts.zip\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"creating-a-script\">Creating a Script<\/h3>\n\n\n\n<p>To create a script, simply click the Scripts option under Bulk Actions in Google Ads. Click the + button to add a new script.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-6130565.png\" alt=\"image-6130565\" class=\"wp-image-5325\" width=\"709\" height=\"307\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-6130565.png 912w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-6130565-300x130.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-6130565-768x333.png 768w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><figcaption>Navigating to the Scripts section<\/figcaption><\/figure><\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Important note: You must authorize script execution on your behalf. Since this is an advanced function, it isn&#8217;t open by default on Google Ads accounts.<\/strong><\/p><\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"script-1-pages-that-don-t-load\"> Script #1: Pages that don&#8217;t load<\/h3>\n\n\n\n<p>Working with clients, too often I have come across landing pages that were unavailable, although traffic from campaigns was still being forwarded to them. Technically speaking, these can be identified as pages with a 4XX or 5xx response (e.g. 404 or 503). Sending traffic to such pages is simply flushing our ad budget down the drain.<\/p>\n\n\n\n<p>The solution I&#8217;ve devised for such errors is a simple script that runs hourly and <a href=\"https:\/\/techterms.com\/definition\/ping\">pings<\/a> all the landing pages associated with the account. The script contains two variables:<\/p>\n\n\n\n<ol><li>Send an email to the address provided<\/li><li>Pause the campaigns (TRUE\/FALSE). If false is chosen, the script will only alert on a page being down.<\/li><\/ol>\n\n\n\n<p>You can open the script in any notepad and paste it directly into the code section. Here you can also edit the two variables available (email and pausing the campaign).<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Make sure you delete the existing placeholder script before pasting in the actual script<\/strong><\/p><\/blockquote>\n\n\n\n<p>Name the script (e.g. Broken pages) and save it. That&#8217;s it.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-4810020.png\" alt=\"image-4810020\" class=\"wp-image-5326\" width=\"1034\" height=\"506\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-4810020.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-4810020-300x147.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-4810020-768x377.png 768w\" sizes=\"(max-width: 1034px) 100vw, 1034px\" \/><figcaption>Pasting the script in Google Ads<\/figcaption><\/figure><\/div>\n\n\n<p>After you save the script, you can set the interval for which it will run (once, hourly, daily, weekly or monthly). I usually set it to run every hour. In some cases, I was able to identify changes in pages that caused downtime, much before my client did. This earned me valuable credit at the client, and also saved them some ad spend.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"286\" height=\"164\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-4814777.png\" alt=\"image-4814777\" class=\"wp-image-5327\"\/><figcaption>Setting the script&#8217;s frequency<\/figcaption><\/figure><\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>After the script has run, you will be able to see detailed reports of its runs on the &#8220;Script History&#8221; tab in the Scripts section.<\/strong><\/p><\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"script-2-self-updating-google-sheets-report\">Script #2: Self updating Google Sheets Report<\/h3>\n\n\n\n<p>This is a simple script to create an automated report of your campaigns. While this can also be done using tools such as Google&#8217;s Data Studio, this script gives an out-of-the-box solution for simple dashboarding.<\/p>\n\n\n\n<p>You can also tweak the script to add\/remove and edit elements to the Google Sheet. These work just like a standard SQL Query, any developer can adjust these to add additional data points.<\/p>\n\n\n\n<p>The only variable in this script is the file&#8217;s name which you can of course edit. Currently, it&#8217;s set to &#8216;AccountDailyStats&#8217;.<\/p>\n\n\n\n<p>Create a new script and name a memorable name (e.g.  Account Daily Stats). Paste the script&#8217;s content and save it. Set the script&#8217;s run frequency to daily.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Please note that using this script requires additional permissions as it will need to access your Google Drive to create and update the reports it creates<\/strong><\/p><\/blockquote>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"561\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2774062.png\" alt=\"image-2774062\" class=\"wp-image-5328\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2774062.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2774062-300x164.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2774062-768x421.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Google Sheets report created with the script<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"script-3-pausing-inefficient-ads\">Script #3: Pausing Inefficient Ads<\/h3>\n\n\n\n<p>Within an account, we can run a large number of ads. Naturally, some of these ads will be inefficient, i.e. not driving enough conversions or driving conversions at a cost that&#8217;s significantly higher than the account&#8217;s average. In such cases, we would want to identify and pause these ads.<\/p>\n\n\n\n<p>The key factor to edit in this script is the window for conversions, i.e. the number days for which we want to evaluate the ad&#8217;s performance.<\/p>\n\n\n\n<p>I&#8217;ve set the script for All Time (&#8216;ALL_TIME&#8217;), but you can also use Last 30 days (&#8216;LAST_30_DAYS&#8217;) or any other time frame that resonates with you.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"script-4-hidden-keywords\">Script #4: Hidden Keywords<\/h3>\n\n\n\n<p>This script is one of my personal favorites.<\/p>\n\n\n\n<p>When we&#8217;re working on a Search campaign, we can often have keywords that are driving conversions, but since we use Phrase or BMM (Broad Match Modifiers) these aren&#8217;t part of the account&#8217;s keyword targeting.<\/p>\n\n\n\n<p>This script observes the keywords that have driven conversions and adds these as keywords in the relevant campaign. Now we can adjust the bids for these specific keywords (unlike BMM).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"other-examples-for-scripts\">Other examples of scripts<\/h3>\n\n\n\n<p>You can create Google Ads scripts to run virtually any task you can imagine. Here are a few examples of scripts I&#8217;ve created over the years:<\/p>\n\n\n\n<ol><li>Out of stock &#8211; Monitoring an eCommerce site by scraping the product page&#8217;s HTML to identify out-of-stock items and pause  their  ads<\/li><li>Feed based campaigns &#8211; Creating ads for new feed items (e.g. &#8220;Exclusive discount for 24 hours&#8221;), pausing ads when out of stock, updating product pricing in ads and more<\/li><li>Budget management &#8211; Pausing a campaign or account exactly at a set limit<\/li><li>Data injection &#8211; Infusing external data into the ad account (e.g. weather data)<\/li><li>Alert system &#8211; Triggering alerts on custom events from the account<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>In this post, we discuss automated rules &amp; scripts on Google Ads (including examples you can use immediately!). These tactics were extracted from an expert session given by Avishay Freund, CEO of Logos at a professional meetup hosted by Fixel. Avishay Freund is the owner and founder of Logos Internet Marketing and an expert in [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,4],"tags":[],"_links":{"self":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4991"}],"collection":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/comments?post=4991"}],"version-history":[{"count":5,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4991\/revisions"}],"predecessor-version":[{"id":5329,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4991\/revisions\/5329"}],"wp:attachment":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/media?parent=4991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/categories?post=4991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/tags?post=4991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}