{"id":3208,"date":"2016-09-22T19:05:22","date_gmt":"2016-09-22T13:35:22","guid":{"rendered":"http:\/\/www.karooya.com\/blog\/?p=3208"},"modified":"2019-10-21T11:09:17","modified_gmt":"2019-10-21T05:39:17","slug":"track-expanded-text-ads-performance-adwords-script","status":"publish","type":"post","link":"https:\/\/www.karooya.com\/blog\/track-expanded-text-ads-performance-adwords-script\/","title":{"rendered":"Track Expanded Text Ads\u2019 Performance with AdWords Script"},"content":{"rendered":"<p class=\"lead\"><span style=\"font-weight: 400;\">It\u2019s been almost 2 months since <a href=\"https:\/\/www.karooya.com\/expanded-text-ad-preview-tool\">Expanded Text Ads<\/a> (ETA) went <\/span><a href=\"https:\/\/adwords.googleblog.com\/2016\/07\/three-ad-innovations-for-mobile-first-world.html\"><span style=\"font-weight: 400;\">live<\/span><\/a><span style=\"font-weight: 400;\"> for all the Google AdWords advertisers. Early results for <strong>Expanded Text Ads<\/strong> were <\/span><a href=\"http:\/\/searchengineland.com\/expanded-text-ads-ctr-early-results-merkle-254766\"><span style=\"font-weight: 400;\">mixed<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><!--more--><\/p>\n<p><span style=\"font-weight: 400;\">From our experience, the impression share for ETAs went up slowly, over the weeks. Even now, the total impressions are less than half of all the impressions an account gets. If you have started building ETAs for your accounts immediately after Google\u2019s account, right now, they are probably in a stable state. That is, ETAs are getting their allotted share of impressions. If you have set your ad rotation to optimize for conversions, Google has probably found a winning ETA.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Last week, Google <\/span><a href=\"https:\/\/adwords.googleblog.com\/2016\/09\/expanded-text-ads-more-time-to-test-and.html\"><span style=\"font-weight: 400;\">extended <\/span><\/a><span style=\"font-weight: 400;\">the support for standard ads. Advertisers can now transition to ETAs till 31st January, 2017 (instead of 26th October, 2016, as announced earlier.) This gives advertisers another 3 months to fully migrate to ETAs. \u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">I suspect, the impression share for ETAs in your account will continue to be throttled till 31st January. Till that time, you want to ensure that all of your ad groups have an ETA (or multiple of them) which is performing at least as good as your current standard ads. Though, standard ads will continue to be displayed alongside ETAs for some time, the competitive pressure will force you to move over to ETAs completely at some point in future. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">That brings us to this <strong>AdWords Script<\/strong>, which will help you easily track performance of ETAs compared to standard ads. \u00a0\u00a0When you run this script, you will get one sheet with following processed data.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">If you have used \u201cSegment\u201d feature in AdWords, this sheet is like having a \u201cSegment by Standard Ads vs Expanded Ads\u201d option at ad group level. For each ad group, you will see the cumulative performance of standard text ads and expanded text ads side by side. The columns are laid out to make it really easy for you to compare metrics (like CTR, Impressions, Conversions, etc.) for standard ads and expanded ads in an ad group.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">The ad groups are sorted by total cost, in descending order. That is, performance of your highest spending ad groups will show up at the top. (Please note, STA &#8211; Standard Text Ads and ETA &#8211; <strong>Expanded Text Ads<\/strong>).<\/span><\/p>\n<p>&nbsp;<\/p>\n<a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/09\/eta-standard-ads-performance-compare.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1515\" height=\"455\" class=\"alignnone size-full wp-image-3211\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/09\/eta-standard-ads-performance-compare.png\" alt=\"expanded ads vs standard ad performance comparison\" \/><\/a>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">With this AdWords script, you will easily be able to do the following. <\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Identify ad groups that do not have an active expanded text ad. These ad groups will be highlighted with red background for you already. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Identify ad groups where ETAs are underperforming standard ads on any of the key metric, such as CTR, CPC, Conversion Rate, etc. <\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For example, if you want to highlight all the ad groups where CTR for expanded ads is less than CTR for standard ads, with a minimum 500 impressions for expanded ads, all you have to do is apply conditional formatting available in Google Sheets, where the results of this AdWords script are available.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><strong>The possibilities of the Expanded Text Ads script are limitless.<\/strong><\/h4>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Then, there is a summary sheet, which visually tells you the account\u2019s performance for expanded ads vis a vis standard ads. The key metrics for the account are summarized. Then, the metrics for standard ads are normalized to 100. Now, we find out where ETAs stand for each of the metric. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">For example, here is a sample graph. The ETAs outperform standard ads significantly on all the important metrics. CTR for expanded ads is double that of standard ads. \u00a0CPC is about 20% higher, but a 40% higher conversion rate means, the cost per conversion is lower than the standard ads.<\/span><\/p>\n<p>&nbsp;<\/p>\n<a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/09\/eta-vs-standard-ads-normalized.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3210 size-full\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/09\/eta-vs-standard-ads-normalized.png\" alt=\"expanded text ads vs standard ads normalized\" width=\"904\" height=\"591\" \/><\/a>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><b>How to get the Expanded Text Ads script?<\/b><\/h4>\n<p><br data-cke-eol=\"1\" \/><span style=\"font-weight: 400;\">If you are in a hurry, just <\/span><a href=\"https:\/\/www.karooya.com\/resources\/aw-script\/eta-vs-standard-ad.js\"><b>grab this script<\/b><\/a><span style=\"font-weight: 400;\">, change the spreadsheet URL and run the script. \u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Here are the variables that you can change to customize it to your requirement.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>SPREADSHEET_URL<\/b><span style=\"font-weight: 400;\"> : <\/span><b>This is the only variable that you must change. <\/b><span style=\"font-weight: 400;\">This is the Google Sheet which will have the result once you execute the script. Create a new sheet with Google Sheet and copy-paste URL of that sheet in place of \u2018https:\/\/docs.google.com\/YOUR-SPREADSHEET-URL-HERE\u2019.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>MAX_ADGROUPS : <\/b><span style=\"font-weight: 400;\">This report is generated for top ad groups in the account, by spend. This variable specifies number of top ad groups to be included in the report. By default, this is set to 500. That is, the report is generated for top 500 ad groups, by spend. You can increase this limit, if you are running a large account. \u00a0From our experiments, we have see that it takes approximately one second to process one ad group. Increasing this limit will make the script run longer. A script can run for a maximum of 30 minutes, which means, about 2000 ad groups will be processed at a maximum.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>DATE_RANGE<\/b><span style=\"font-weight: 400;\">: You can use some predefined ranges like LAST_30_DAYS or LAST_14_DAYS, depending on the duration which you think best represents account\u2019s data. For example, if you have launched bunch of new expanded ads \u00a03 weeks ago, you can use data from last 7 or 14 days. By default, the script will get the data for last 14 days. <\/span><\/li>\n<li style=\"font-weight: 400;\"><b>IS_MCC_ACCOUNT<\/b><span style=\"font-weight: 400;\"> : This flag is to indicate whether you will be running this script at MCC-level. By default, it is set to false. Change it to \u201ctrue\u201d if you want to use for all the linked accounts in your MCC account. The results for each account will be stored in two separate sheets &#8211; one with raw data and one has the summary. Be careful, if you have many many accounts.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>FILTER_ACCOUNTS_BY_LABEL<\/b><span style=\"font-weight: 400;\"> : If your MCC account has tons of linked accounts, you may not want to run this script for all the accounts. In that case, turn this flag to \u201ctrue\u201d and then specify the label with ACCOUNT_LABEL_TO_SELECT variable. Only the accounts with the specified label will be analyzed to generate this report.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.karooya.com\/resources\/aw-script\/eta-vs-standard-ad.js\"><b>Take this script<\/b><\/a> <span style=\"font-weight: 400;\">and see how your account is performing for expanded text ads. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Feel free to send an email (support AT karooya.com) if you have any queries for this script.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/www.karooya.com\/blog\/category\/karooya-adwords-script\/\" target=\"_blank\" rel=\"noopener noreferrer\">Get all the AdWords scripts published by Karooya<\/a><\/strong><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Related AdWords Scripts and Tools<\/strong>:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.karooya.com\/blog\/free-adwords-script-to-analyze-quality-score-in-detail\/\" target=\"_blank\" rel=\"noopener\">Free Adwords script to analyze quality score in detail<\/a><\/li>\n<li><a href=\"https:\/\/www.karooya.com\/blog\/adwords-script-identify-duplicate-keywords-including-close-variants\/\" target=\"_blank\" rel=\"noopener\">Adwords script to identify duplicate\u00a0 keywords including close variants<\/a><\/li>\n<li><a href=\"https:\/\/www.karooya.com\/expanded-text-ad-preview-tool\" target=\"_blank\" rel=\"noopener\">Expanded text ads preview tool<\/a><\/li>\n<li><a href=\"https:\/\/www.karooya.com\/services\" target=\"_blank\" rel=\"noopener\">API\/Script development services<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>It\u2019s been almost 2 months since Expanded Text Ads (ETA) went live for all the Google AdWords advertisers. Early results for Expanded Text Ads were mixed.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[12,14],"tags":[],"class_list":["post-3208","post","type-post","status-publish","format-standard","hentry","category-expanded-text-ads","category-karooya-adwords-script"],"featured_image_src":null,"author_info":{"display_name":"Shashikant","author_link":"https:\/\/www.karooya.com\/blog\/author\/shashi\/"},"_links":{"self":[{"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts\/3208","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/comments?post=3208"}],"version-history":[{"count":17,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts\/3208\/revisions"}],"predecessor-version":[{"id":10164,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts\/3208\/revisions\/10164"}],"wp:attachment":[{"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/media?parent=3208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/categories?post=3208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/tags?post=3208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}