{"id":75,"date":"2012-03-12T19:59:46","date_gmt":"2012-03-12T17:59:46","guid":{"rendered":"http:\/\/www.adwiserhq.com\/blog\/?p=75"},"modified":"2012-03-14T22:18:58","modified_gmt":"2012-03-14T20:18:58","slug":"what-keywords-got-me-those-search-terms","status":"publish","type":"post","link":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/","title":{"rendered":"What keywords got me those search terms?"},"content":{"rendered":"<p>Or, in other words, how broad is broad match?<\/p>\n<p>Any serious AdWords manager is watching the search terms attracted by her keywords religiously.<\/p>\n<p>And any serious AdWords manager has already been frustrated by the fact that he cannot see, in one table, side by side, the search term, the match type of the keyword, and the keyword which was triggered by it.<\/p>\n<p>Ok, it&#8217;s a known fact that you can go to your keywords tab, and select one keyword, and click on &#8220;See search terms&#8221;, so you can see only the search terms attracted by that particular keyword.<\/p>\n<p><a href=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-115\" title=\"seeSearchTerms\" src=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms.png\" alt=\"\" width=\"300\" height=\"83\" srcset=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms.png 300w, http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms-295x83.png 295w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>But would you do it a hundred times a day? Click, &#8220;See search terms&#8221;, click, &#8220;See search terms&#8221;, click, oh, no, I&#8217;ve already clicked that before, back to square one \u2026<\/p>\n<p><strong>Disclaimer:<\/strong> the solution I&#8217;m going to provide only works for search terms which <strong>attracted at least one click<\/strong>.<\/p>\n<p><!--more-->It does not work for those who only generated impressions. But after all, no click means no (direct) cost, right? Also, this solution does not involve AdWords alone, you need to have a linked Analytics account, with auto-tagging enabled. But there is no reason you shouldn&#8217;t have one, right? AdWords does give you impressions, and clicks, and conversions, but other than that, no post-click, on-site behaviour is available to you if you only use AdWords. You have no idea which keywords and search terms brought you engaged visitors, and which brought you nothing but bounces. And there&#8217;s quite a gap between converting and non-converting keywords and search terms.<\/p>\n<p>So here&#8217;s what you have to do:<\/p>\n<ul>\n<li>Google <em>&#8220;Data Feed Query Explorer&#8221;<\/em>, and find Google Analytics&#8217; excellent interface for its <em>Data Export API<\/em>. Use <em>Chrome<\/em> (you&#8217;ll see why later on).<\/li>\n<li>If you&#8217;re not logged in, log in with your <em>Google Account<\/em> which has access to the Analytics account you&#8217;d like to look at.<\/li>\n<li>Select the account, and choose the following dimensions: <em>ga:keyword,ga:adMatchType,ga:adMatchedQuery<\/em><\/li>\n<li>Choose <em>ga:visits<\/em> as metric<\/li>\n<li>As you don&#8217;t want data from all mediums in your result, create a <em>custom segment<\/em> in Google Analytics, which only includes AdWords visitors (<em>source<\/em> has to be Google, and <em>medium<\/em> has to be <em>cpc<\/em>). Use is as a segment.<\/li>\n<li>you don&#8217;t want keywords with &#8220;exact&#8221; as match type, as they obviously get search terms which are identical to them. So use the filter <em>ga:adMatchType!=Exact match<\/em>.<\/li>\n<li>sort by <em>ga:keyword<\/em>, and choose your start and end date<\/li>\n<li>get up to 9999 results<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/dataFeedQueryExplorer.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-94\" title=\"Google Analytics Data Feed Query Explorer\" src=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/dataFeedQueryExplorer.png\" alt=\"\" width=\"522\" height=\"313\" srcset=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/dataFeedQueryExplorer.png 522w, http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/dataFeedQueryExplorer-300x179.png 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\n<p>You&#8217;ll see a nicely formatted table. Right click the &#8220;ga:keyword&#8221; table cell, and choose &#8220;Inspect Element&#8221;.<\/p>\n<p><a href=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/inspectElement.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-96\" title=\"Inspect Element\" src=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/inspectElement.png\" alt=\"Inspect element HTML in Chrome\" width=\"307\" height=\"302\" srcset=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/inspectElement.png 307w, http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/inspectElement-300x295.png 300w\" sizes=\"auto, (max-width: 307px) 100vw, 307px\" \/><\/a><\/p>\n<p>Two-three lines above the selected element in the source code (td class=&#8221;google-visualization-table-th), you&#8217;ll see table class=&#8221;google-visualization-table-table&#8221;. That is the table containing all your data. Right click it and choose &#8220;Copy as HTML&#8221;.<\/p>\n<p>Open an Excel blank file, and paste all that HTML into it. You&#8217;ll get a nice table holding all the information you need.<\/p>\n<p><a href=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/copyAsHTML.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-98\" title=\"Copy as HTML\" src=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/copyAsHTML.png\" alt=\"Copy HTML content\" width=\"552\" height=\"262\" srcset=\"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/copyAsHTML.png 552w, http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/copyAsHTML-300x142.png 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/a><\/p>\n<p>That&#8217;s it. You now have keywords, match types, and search terms next to each other, and you can see what search terms were attracted by your keywords. And you can now see, how broad broad match really is.<\/p>\n<p>Alternate ways of getting the same data in a table are to create your own scripts which access the Google Analytics Data Export API, or a great free Excel plugin, called <a title=\"Excellent Analytics\" href=\"http:\/\/excellentanalytics.com\" target=\"_blank\">Excellent Analytics<\/a>. Maybe I should have started with this, but unfortunately, while it worked nicely with an older version of Excel, I could not get it to work with the 2010 version, so I preferred to show you something which works with nothing but a browser and Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Or, in other words, how broad is broad match? Any serious AdWords manager is watching the search terms attracted by her keywords religiously. And any serious AdWords manager has already been frustrated by the fact that he cannot see, in one table, side by side, the search term, the match type of the keyword, and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[5,6,7],"tags":[],"class_list":{"0":"post-75","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-google-adwords","7":"category-google-analytics","8":"category-mixed","9":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What keywords got me those search terms? - AdWiser<\/title>\n<meta name=\"description\" content=\"What the Google AdWords interface does not show you (yet): keywords and search terms, side by side. Here&#039;s how to get them.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Calin Sandici\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/\"},\"author\":{\"name\":\"Calin Sandici\",\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/#\\\/schema\\\/person\\\/650d7cd5b22381b695a20edd083bfc95\"},\"headline\":\"What keywords got me those search terms?\",\"datePublished\":\"2012-03-12T17:59:46+00:00\",\"dateModified\":\"2012-03-14T20:18:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/\"},\"wordCount\":620,\"commentCount\":1,\"publisher\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/#\\\/schema\\\/person\\\/650d7cd5b22381b695a20edd083bfc95\"},\"image\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/seeSearchTerms.png\",\"articleSection\":[\"Google AdWords\",\"Google Analytics\",\"Mixed\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/\",\"url\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/\",\"name\":\"What keywords got me those search terms? - AdWiser\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/seeSearchTerms.png\",\"datePublished\":\"2012-03-12T17:59:46+00:00\",\"dateModified\":\"2012-03-14T20:18:58+00:00\",\"description\":\"What the Google AdWords interface does not show you (yet): keywords and search terms, side by side. Here's how to get them.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/what-keywords-got-me-those-search-terms\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/seeSearchTerms.png\",\"contentUrl\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/seeSearchTerms.png\",\"width\":\"300\",\"height\":\"83\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/#website\",\"url\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/\",\"name\":\"AdWiser\",\"description\":\"Google AdWords, Analytics &amp; E-Commerce\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/#\\\/schema\\\/person\\\/650d7cd5b22381b695a20edd083bfc95\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\\\/\\\/www.adwiserhq.com\\\/blog\\\/#\\\/schema\\\/person\\\/650d7cd5b22381b695a20edd083bfc95\",\"name\":\"Calin Sandici\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g\",\"caption\":\"Calin Sandici\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g\"},\"description\":\"Father of two and husband of one, at the crossroads of Google AdWords, Analytics and E-Commerce.\",\"sameAs\":[\"http:\\\/\\\/adwiserhq.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What keywords got me those search terms? - AdWiser","description":"What the Google AdWords interface does not show you (yet): keywords and search terms, side by side. Here's how to get them.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/","twitter_misc":{"Written by":"Calin Sandici","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/#article","isPartOf":{"@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/"},"author":{"name":"Calin Sandici","@id":"http:\/\/www.adwiserhq.com\/blog\/#\/schema\/person\/650d7cd5b22381b695a20edd083bfc95"},"headline":"What keywords got me those search terms?","datePublished":"2012-03-12T17:59:46+00:00","dateModified":"2012-03-14T20:18:58+00:00","mainEntityOfPage":{"@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/"},"wordCount":620,"commentCount":1,"publisher":{"@id":"http:\/\/www.adwiserhq.com\/blog\/#\/schema\/person\/650d7cd5b22381b695a20edd083bfc95"},"image":{"@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/#primaryimage"},"thumbnailUrl":"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms.png","articleSection":["Google AdWords","Google Analytics","Mixed"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/","url":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/","name":"What keywords got me those search terms? - AdWiser","isPartOf":{"@id":"http:\/\/www.adwiserhq.com\/blog\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/#primaryimage"},"image":{"@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/#primaryimage"},"thumbnailUrl":"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms.png","datePublished":"2012-03-12T17:59:46+00:00","dateModified":"2012-03-14T20:18:58+00:00","description":"What the Google AdWords interface does not show you (yet): keywords and search terms, side by side. Here's how to get them.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.adwiserhq.com\/blog\/what-keywords-got-me-those-search-terms\/#primaryimage","url":"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms.png","contentUrl":"http:\/\/www.adwiserhq.com\/blog\/wp-content\/uploads\/2012\/03\/seeSearchTerms.png","width":"300","height":"83"},{"@type":"WebSite","@id":"http:\/\/www.adwiserhq.com\/blog\/#website","url":"http:\/\/www.adwiserhq.com\/blog\/","name":"AdWiser","description":"Google AdWords, Analytics &amp; E-Commerce","publisher":{"@id":"http:\/\/www.adwiserhq.com\/blog\/#\/schema\/person\/650d7cd5b22381b695a20edd083bfc95"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.adwiserhq.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/www.adwiserhq.com\/blog\/#\/schema\/person\/650d7cd5b22381b695a20edd083bfc95","name":"Calin Sandici","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g","caption":"Calin Sandici"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/a35e574b958437aea93b30c4d52f8f9413852ea51cd3b2a730cb7684bfc83b6c?s=96&r=g"},"description":"Father of two and husband of one, at the crossroads of Google AdWords, Analytics and E-Commerce.","sameAs":["http:\/\/adwiserhq.com"]}]}},"_links":{"self":[{"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/posts\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":20,"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":138,"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions\/138"}],"wp:attachment":[{"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.adwiserhq.com\/blog\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}