{"id":2287,"date":"2016-03-25T19:26:54","date_gmt":"2016-03-25T13:56:54","guid":{"rendered":"http:\/\/www.karooya.com\/blog\/?p=2287"},"modified":"2019-05-31T17:56:05","modified_gmt":"2019-05-31T12:26:05","slug":"free-adwords-script-to-analyze-quality-score-in-detail","status":"publish","type":"post","link":"https:\/\/www.karooya.com\/blog\/free-adwords-script-to-analyze-quality-score-in-detail\/","title":{"rendered":"Free AdWords Script to Analyze Quality Score in Detail"},"content":{"rendered":"<p class=\"lead\">When a user searching for something sees a relevant ad, clicks on it, and visits the advertiser&#8217;s landing page, Google wants that entire experience to be good. Quality Score for keywords is a Google&#8217;s way of ensuring that advertisers create most relevant ads and landing pages for the search terms. Google awards, by means of a lower Cost Per Click, those who take great effort of ensuring right ads are shown for right keywords and the landing page is relevant to the keyword.<\/p>\n<p><!--more--><\/p>\n<a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/qualityscore_adwords_script.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"300\" class=\"size-full wp-image-2298 aligncenter\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/qualityscore_adwords_script.jpg\" alt=\"QS AdWords Script\" \/><\/a>\n<p>&nbsp;<\/p>\n<p>Quality Score has 3 components &#8211; Expected Clickthrough Rate, Ad Relevance and Landing Page Experience. Each of these components is given a score of Below Average, Average and Above Average. Final Quality Score is a weighted combination of these 3 attributes and it results in a number between 1 to 10. A score of 6 is considered average.<\/p>\n<p>&nbsp;<\/p>\n<p>Typical workflow to identify QS problems involves filtering keywords by &#8220;low&#8221; QS and going through them. Hovering the mouse on the keyword status provides the details of the 3 attributes. Here&#8217;s a screen that shows quality score for a keyword along with how that keyword performs for each of the attribute.<\/p>\n<p>&nbsp;<\/p>\n<a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/kw-qs-diagnostics.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2289 size-full\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/kw-qs-diagnostics.png\" alt=\"kw-quality-score-diagnostics\" width=\"371\" height=\"289\" \/><\/a>\n<p>&nbsp;<\/p>\n<p>If you want to find out all the keywords where Ad Relevance is rated as &#8220;Below Average&#8221;, it is rather tedious to go through all the keywords&#8217; status.<\/p>\n<p>&nbsp;<\/p>\n<p>Last month (February, 2016), Google released an update on Quality Score in their APIs. Now, in addition to the Quality Score number, Google provides the break down of individual components for a keyword. This update makes working with quality very easy.<\/p>\n<p>&nbsp;<\/p>\n<p>But, this data is available only with APIs and AdWords scripts. It is not yet available through the AdWords Web UI or AdWords Editor. Hence, we are publishing an AdWords script that will provide you break up of the Quality Score attributes for each keyword. Let&#8217;s understand what insights the script will provide you.<\/p>\n<p>&nbsp;<\/p>\n<p>Here&#8217;s a report that is very similar to keyword performance report that you can download from AdWords Web UI. There is one addition to it. For each keyword, you can see the 3 components of Quality Score for that keyword. To help you visually understand the data, the Below Average score is highlighted with red background and Above Average score has green background. Average score has a neutral grey background. For example, in the result below, you can see Ad Relevance for many many keywords is Below Average. Time to write some new ad copies.<\/p>\n<p>&nbsp;<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"1835\" height=\"823\" class=\"size-full wp-image-2288 aligncenter\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/kw-qs-breakup.png\" alt=\"kw-qs-breakup\" \/>\n<p>&nbsp;<\/p>\n<p>Since this data is available in Excel, you can sort and filter it in any way you want. This wealth of raw data is waiting for you to mould it to your liking.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h1><strong>Beautiful Quality Score Charts Pre-Cooked for You<\/strong><\/h1>\n<p>&nbsp;<\/p>\n<p>If you want a bird&#8217;s eye view of your account or campaign, this AdWords script creates a summary sheet for your data. It also creates some great looking charts that you can take a look at and understand exactly what is happening.<\/p>\n<p>&nbsp;<\/p>\n<p>For example, this chart will show you total number of impressions happening at each quality score. That is, for each quality score from 1 to 10, impressions for all the keywords at a particular QS are clubbed together and that becomes the cumulative impression for that score. Here, you can see that QS of 8 has the highest impressions with score of 6 being the next highest one.<\/p>\n<p>&nbsp;<\/p>\n<p>You can create similar chart for <em>Quality Score vs Clicks\/Spend\/CPC<\/em>, etc.<\/p>\n<p>&nbsp;<\/p>\n<a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/impr-vs-qs.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"371\" class=\"size-full wp-image-2294 aligncenter\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/impr-vs-qs.png\" alt=\"impr-vs-qs\" \/><\/a>\n<p>&nbsp;<\/p>\n<p>Now, some charts using the newly available data. Let&#8217;s find out performance of landing page across the account.<\/p>\n<p>&nbsp;<\/p>\n<p>This pie chart will show that 88% of the impressions for the keywords have Landing page experience of Above Average. High Five!<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"371\" class=\"size-full wp-image-2293 aligncenter\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/impr-by-landing-page.png\" alt=\"impr-by-landing-page\" \/>\n<p>Similarly, this chart will show you impressions by expected CTR and Ad Relevance.<\/p>\n<a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/impr-by-exp-ctr.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"371\" class=\"alignnone size-full wp-image-2292\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/impr-by-exp-ctr.png\" alt=\"impr-by-exp-ctr\" \/><\/a> <a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/impr-by-ad-relevance.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"371\" class=\"alignnone size-full wp-image-2291\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/impr-by-ad-relevance.png\" alt=\"impr-by-ad-relevance\" \/><\/a>\n<p>If you wish, you can draw similar chart for Cost vs any of quality score attribute. The summarized data is right there.<\/p>\n<p>&nbsp;<\/p>\n<a href=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/cost-by-exp-ctr.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"371\" class=\"size-full wp-image-2290 aligncenter\" src=\"https:\/\/www.karooya.com\/blog\/wp-content\/uploads\/2016\/03\/cost-by-exp-ctr.png\" alt=\"cost-by-exp-ctr\" \/><\/a>\n<p>&nbsp;<\/p>\n<h2><strong>The Quality Score Script<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p>Now that you know all the data that you can get from this script, let&#8217;s talk about the script.<\/p>\n<p><a href=\"https:\/\/www.karooya.com\/resources\/aw-script\/quality-score-analysis_kw.js\">You can get this script here<\/a>.<\/p>\n<p>Here are the variables that you can change to customize it to your requirement.<\/p>\n<ul>\n<li><strong>REPORTS_FOLDER_PATH<\/strong> : This is the name of the folder that gets created in your Google drive. By default the name is \u2018Quality Score Analysis\u2019. If you wish to change the name you can do so here.<\/li>\n<li><strong>DATE_RANGE<\/strong>: You can use some pre-defined ranges like LAST_30_DAYS or LAST_14_DAYS. By default, the script will get the data for last 30 days.<\/li>\n<li><strong>USE_CUSTOM_DATE_RANGE<\/strong> : If you want a particular date range to be used then, set this flag to &#8220;true&#8221; and modify the START_DATE and END_DATE to indicate the date range. The date format is \u201cyyyy-mm-dd\u201d aka \u201cYear-Month-Date.\u201d For example, if you want a report from last quarter of 2015, the START_DATE would be \u201c2015-09-01\u201d and END_DATE would be \u201c2015-12-31.\u201d<\/li>\n<li><strong>IS_MCC_ACCOUNT<\/strong> : 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 a separate sheet. Be careful, if you have many many accounts.<\/li>\n<li><strong>IGNORE_PAUSED_CAMPAIGNS<\/strong> and <strong>IGNORE_PAUSED_ADGROUPS<\/strong> : These flags indicate to ignore paused campaigns and ad groups. By default, these are set to true. All paused keywords are ignored by default.<\/li>\n<li><strong>MAX_KEYWORDS<\/strong> : You will get report for top 1,000 keywords (ordered by impressions in the decreasing order) in the account. You can get results for more keywords by changing the value here.<\/li>\n<li><strong>FILTER_ACCOUNTS_BY_LABEL<\/strong> : 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.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Once again, <a href=\"https:\/\/www.karooya.com\/resources\/aw-script\/quality-score-analysis_kw.js\">here is the link to the AdWords script<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<p>Feel free to send us an email (support AT karooya.com) if you have any queries for this script.<\/p>\n<p>&nbsp;<\/p>\n<h4><strong><span style=\"text-decoration: underline;\"><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><\/span><\/strong><\/h4>\n<p>&nbsp;<\/p>\n<p><strong>Related Links:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.karooya.com\/blog\/quality-score-essential-component-ppc-audit\/\" target=\"_blank\" rel=\"noopener\">Why quality score is an essential component of PPC audit<\/a><\/li>\n<li><a href=\"https:\/\/www.karooya.com\/blog\/track-expanded-text-ads-performance-adwords-script\/\" target=\"_blank\" rel=\"noopener\">Track expanded text ads performance with Adwords script<\/a><\/li>\n<li><a href=\"https:\/\/www.karooya.com\/blog\/7-ideas-to-improve-google-ads-performance\/\" target=\"_blank\" rel=\"noopener\">Important Adwords scripts released in 2016<\/a><\/li>\n<li><a href=\"https:\/\/www.karooya.com\/services\" target=\"_blank\" rel=\"noopener\">API\/Script development services<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When a user searching for something sees a relevant ad, clicks on it, and visits the advertiser&#8217;s landing page, Google wants that entire experience to be good. Quality Score for keywords is a Google&#8217;s way of ensuring that advertisers create most relevant ads and landing pages for the search terms. Google awards, by means of&#8230;  <a href=\"https:\/\/www.karooya.com\/blog\/free-adwords-script-to-analyze-quality-score-in-detail\/\" class=\"more-link\" title=\"Read Free AdWords Script to Analyze Quality Score in Detail\">Read more &raquo;<\/a><\/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":[14],"tags":[],"class_list":["post-2287","post","type-post","status-publish","format-standard","hentry","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\/2287","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=2287"}],"version-history":[{"count":17,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts\/2287\/revisions"}],"predecessor-version":[{"id":8853,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts\/2287\/revisions\/8853"}],"wp:attachment":[{"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/media?parent=2287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/categories?post=2287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/tags?post=2287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}