{"id":26647,"date":"2023-05-22T12:37:46","date_gmt":"2023-05-22T20:37:46","guid":{"rendered":"https:\/\/www.intentwise.com\/blog\/?p=26647"},"modified":"2023-07-06T08:21:03","modified_gmt":"2023-07-06T16:21:03","slug":"why-amcs-instructional-queries-are-not-enough","status":"publish","type":"post","link":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/","title":{"rendered":"\u00a0Why AMC\u2019s instructional queries are not enough","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"\n<p>Right now, plenty of agencies and brands are beginning to explore the possibilities of Amazon Marketing Cloud, Amazon\u2019s newest ads measurement solution.<\/p>\n\n\n\n<p>As we\u2019ve discussed before, AMC lets you unlock everything from path-to-purchase mapping to <a href=\"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-marketers-can-use-new-to-brand-metrics\/\">New-To-Brand metrics<\/a> for Sponsored Products ads. Then, you can turn your query results into <a href=\"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-new-custom-audiences-tool-is-so-powerful\/\">custom audiences<\/a> that you can target with ads later.<\/p>\n\n\n\n<p><strong>But how do you actually extract these insights? <\/strong>Most AMC newcomers will probably rely on one of AMC\u2019s ~60 instructional queries.&nbsp;<\/p>\n\n\n\n<p>These instructional queries include pre-written SQL code to get you started. Among the instructional queries that AMC offers, for instance, is an \u201cAudience that Added to Cart but Did not Purchase.\u201d<\/p>\n\n\n\n<p>The instructional queries are a good start. But many of them need to be modified. What if you wanted to do something a little more sophisticated\u2014or more custom\u2014in AMC?<\/p>\n\n\n\n<p>While the possibilities with AMC are pretty much limitless, the instructional query library <em>does<\/em> have limits:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>There are only so many instructional queries.&nbsp;<\/li>\n\n\n\n<li>Most of them are not designed in a way that will meet your brand\u2019s unique reporting and analytics needs. Modifications are usually needed.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/amc-instructional-1024x607.png\" alt=\"\" class=\"wp-image-26648\" srcset=\"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/amc-instructional-1024x607.png 1024w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/amc-instructional-300x178.png 300w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/amc-instructional-768x455.png 768w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/amc-instructional-1536x910.png 1536w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/amc-instructional-2048x1213.png 2048w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/amc-instructional-560x332.png 560w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-text-align-center\"><em>(An example of an instructional query in AMC)<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-how-do-instructional-queries-fall-short\"><strong>How do instructional queries fall short?&nbsp;<\/strong><\/h3>\n\n\n\n<p>Let\u2019s take an example: path to purchase.&nbsp;<\/p>\n\n\n\n<p>AMC\u2019s instructional query for path to purchase automatically removes duplicate views of the same ad format. Let\u2019s say a customer viewed a Sponsored Products ad, then another Sponsored Products ad, and then a Sponsored Display ad before converting.&nbsp;<\/p>\n\n\n\n<p>The instructional query will remove the second Sponsored Products ad, and show the path as 1 SP, then 1 SD.&nbsp;<\/p>\n\n\n\n<p>What if you <em>didn\u2019t<\/em> want those duplicates removed? So that the path to purchase shows 1 SP, 1 SP, and 1 SD?&nbsp;<\/p>\n\n\n\n<p>The answer: You\u2019re probably going to have to write a custom SQL query.<\/p>\n\n\n\n<p>We recently created a custom query for a client exactly along these lines. The client wanted to see a more complete view of how its ads were informing the path to purchase, so we wrote them a SQL query that didn\u2019t condense the path to purchase.<\/p>\n\n\n\n<p>Or take another example: AMC\u2019s instructional path-to-purchase only tracks impressions, <em>not<\/em> clicks, when measuring the path to purchase.&nbsp;<\/p>\n\n\n\n<p>That can get unwieldy quickly, considering it\u2019s hard to visit Amazon without seeing a bunch of search ads.&nbsp;<\/p>\n\n\n\n<p>What if you wanted to show only ads that a customer actually clicked in the path to purchase results? Again, you\u2019ll need to write your own query.&nbsp;<\/p>\n\n\n\n<p>These are the kinds of limitations that pop up all the time with instructional AMC queries.&nbsp;<\/p>\n\n\n\n<p>Yes, the built-in queries give you a great starting place to pull incredible new kinds of data. But if you want to analyze that data in a way that speaks the language of your brand, you\u2019re probably going to need to customize your queries.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-how-do-you-write-a-custom-query\"><strong>How do you write a custom query?<\/strong><\/h3>\n\n\n\n<p>Intentwise now writes custom queries for AMC as a part of <a href=\"https:\/\/www.intentwise.com\/services\/intentwise-analytics-services\">Intentwise Analytics Services<\/a>, so this topic has been top of mind.&nbsp;<\/p>\n\n\n\n<p>So far, we\u2019ve learned a few things from crafting custom queries for clients. Namely: Writing a custom AMC query is probably impossible if you\u2019re not well versed in SQL and Amazon ads.<\/p>\n\n\n\n<p>Amazon\u2019s instructional queries have around <strong>300 lines of code<\/strong>, and some sophisticated custom queries can stretch far longer.&nbsp;<\/p>\n\n\n\n<p><strong>So how does it work? <\/strong>One of the key tasks of creating custom queries is joining together disparate AMC tables.&nbsp;<\/p>\n\n\n\n<p>You have to decide which tables to use, and then you have to unify them into a single query result.<\/p>\n\n\n\n<p><strong>For example:<\/strong> To create your own path-to-purchase query, you have to join together data tables using a series of customer user IDs. These user IDs will ensure that you\u2019re tracking the same shopper across all of the tables.<\/p>\n\n\n\n<p>In this case, we joined the following tables:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>dsp_impressions<\/li>\n\n\n\n<li>dsp_clicks<\/li>\n\n\n\n<li>sponsored_ads_traffic<\/li>\n\n\n\n<li>amazon_attributed_events_by_traffic_time<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>These aren\u2019t simple coding tasks. Ultimately, to build a custom query, you need a few skill sets:&nbsp;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You should know <strong>SQL<\/strong> front to back.<\/li>\n\n\n\n<li>You should be familiar with <strong>joining complex tables of data<\/strong>.<\/li>\n\n\n\n<li>You should have intimate knowledge of <strong>AMC and Amazon Ads<\/strong>, so nothing gets lost in translation.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-don-t-forget-validate-validate-validate\"><strong>Don\u2019t forget: Validate, validate, validate<\/strong><\/h3>\n\n\n\n<p>Many newcomers to AMC often forget the most critical step of building a new query: you have to validate that it produces the correct results.<\/p>\n\n\n\n<p>Any number of errors can crop up during the coding process. Once you\u2019ve written your query, you need to make sure the data it spits out is right. At Intentwise, for example, we run several rounds of validation for each of the SQL queries we write.<\/p>\n\n\n\n<p>To do this, verify that the total number of impressions, sales, product units, etc from your AMC query matches your actual data for the same period.<\/p>\n\n\n\n<p><strong>If you skip the validation step, you risk relying on bad data. <\/strong>A non-validated SQL query could spit out inaccurate results that you might, unknowingly, use to make business decisions.<\/p>\n\n\n\n<p>For instance, a faulty SQL query might suggest that one specific path to purchase is optimal for your brand, when in reality it isn\u2019t one of the top paths at all.&nbsp;<\/p>\n\n\n\n<p>If you don\u2019t realize that your tables were joined poorly, you might put extra marketing spend behind this less-than-optimal path to purchase.<\/p>\n\n\n\n<p>That\u2019s why SQL and AMC expertise is so important right now. Instructional queries have their limits. And you also want to make sure you aren\u2019t building faulty SQL queries of your own.&nbsp;<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>Right now, plenty of agencies and brands are beginning to explore the possibilities of Amazon Marketing Cloud, Amazon\u2019s newest ads measurement solution. As we\u2019ve discussed before, AMC lets you unlock everything from path-to-purchase mapping to New-To-Brand metrics for Sponsored Products ads. Then, you can turn your query results into custom audiences that you can target [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":22,"featured_media":26651,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","cybocfi_hide_featured_image":"","footnotes":""},"categories":[135],"tags":[96,155],"class_list":["post-26647","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-amazon-marketing-cloud","tag-mobile","tag-newsletter"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>\u00a0Why AMC\u2019s instructional queries are not enough<\/title>\n<meta name=\"description\" content=\"Amazon Marketing Cloud&#039;s instructional queries offer a useful starting point. But they aren&#039;t customized to the needs of your company.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00a0Why AMC\u2019s instructional queries are not enough\" \/>\n<meta property=\"og:description\" content=\"Amazon Marketing Cloud&#039;s instructional queries offer a useful starting point. But they aren&#039;t customized to the needs of your company.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/\" \/>\n<meta property=\"og:site_name\" content=\"Intentwise Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-22T20:37:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-06T16:21:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/Blog-SQL-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1462\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Waters\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Waters\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/\"},\"author\":{\"name\":\"Michael Waters\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/person\\\/b792a03444bf9fe1673eec5daf7fae99\"},\"headline\":\"\u00a0Why AMC\u2019s instructional queries are not enough\",\"datePublished\":\"2023-05-22T20:37:46+00:00\",\"dateModified\":\"2023-07-06T16:21:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/\"},\"wordCount\":960,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/Blog-SQL-scaled.jpg\",\"keywords\":[\"Mobile\",\"Newsletter\"],\"articleSection\":[\"Amazon Marketing Cloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/\",\"name\":\"\u00a0Why AMC\u2019s instructional queries are not enough\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/Blog-SQL-scaled.jpg\",\"datePublished\":\"2023-05-22T20:37:46+00:00\",\"dateModified\":\"2023-07-06T16:21:03+00:00\",\"description\":\"Amazon Marketing Cloud's instructional queries offer a useful starting point. But they aren't customized to the needs of your company.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/Blog-SQL-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/Blog-SQL-scaled.jpg\",\"width\":2560,\"height\":1462},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-marketing-cloud\\\/why-amcs-instructional-queries-are-not-enough\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Amazon Marketing Cloud\",\"item\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/.\\\/amazon-marketing-cloud\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00a0Why AMC\u2019s instructional queries are not enough\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/\",\"name\":\"Intentwise Blog\",\"description\":\"Amazon Analytics &amp; Advertising Software\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#organization\",\"name\":\"Intentwise\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/favicon256.png\",\"contentUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/favicon256.png\",\"width\":256,\"height\":256,\"caption\":\"Intentwise\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/person\\\/b792a03444bf9fe1673eec5daf7fae99\",\"name\":\"Michael Waters\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/a\\\/ACg8ocK8NgD1p_6vDhk06IqnMKXDnxTfjSjK3-VxS9-MMBHnowhzlfI\",\"url\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/a\\\/ACg8ocK8NgD1p_6vDhk06IqnMKXDnxTfjSjK3-VxS9-MMBHnowhzlfI\",\"contentUrl\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/a\\\/ACg8ocK8NgD1p_6vDhk06IqnMKXDnxTfjSjK3-VxS9-MMBHnowhzlfI\",\"caption\":\"Michael Waters\"},\"description\":\"Senior content writer, Intentwise\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/author\\\/michaelwatersintentwise-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u00a0Why AMC\u2019s instructional queries are not enough","description":"Amazon Marketing Cloud's instructional queries offer a useful starting point. But they aren't customized to the needs of your company.","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":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/","og_locale":"en_US","og_type":"article","og_title":"\u00a0Why AMC\u2019s instructional queries are not enough","og_description":"Amazon Marketing Cloud's instructional queries offer a useful starting point. But they aren't customized to the needs of your company.","og_url":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/","og_site_name":"Intentwise Blog","article_published_time":"2023-05-22T20:37:46+00:00","article_modified_time":"2023-07-06T16:21:03+00:00","og_image":[{"width":2560,"height":1462,"url":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/Blog-SQL-scaled.jpg","type":"image\/jpeg"}],"author":"Michael Waters","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Michael Waters","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#article","isPartOf":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/"},"author":{"name":"Michael Waters","@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/person\/b792a03444bf9fe1673eec5daf7fae99"},"headline":"\u00a0Why AMC\u2019s instructional queries are not enough","datePublished":"2023-05-22T20:37:46+00:00","dateModified":"2023-07-06T16:21:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/"},"wordCount":960,"commentCount":0,"publisher":{"@id":"https:\/\/www.intentwise.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/Blog-SQL-scaled.jpg","keywords":["Mobile","Newsletter"],"articleSection":["Amazon Marketing Cloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/","url":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/","name":"\u00a0Why AMC\u2019s instructional queries are not enough","isPartOf":{"@id":"https:\/\/www.intentwise.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#primaryimage"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/Blog-SQL-scaled.jpg","datePublished":"2023-05-22T20:37:46+00:00","dateModified":"2023-07-06T16:21:03+00:00","description":"Amazon Marketing Cloud's instructional queries offer a useful starting point. But they aren't customized to the needs of your company.","breadcrumb":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#primaryimage","url":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/Blog-SQL-scaled.jpg","contentUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/05\/Blog-SQL-scaled.jpg","width":2560,"height":1462},{"@type":"BreadcrumbList","@id":"https:\/\/www.intentwise.com\/blog\/amazon-marketing-cloud\/why-amcs-instructional-queries-are-not-enough\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Amazon Marketing Cloud","item":"https:\/\/www.intentwise.com\/blog\/.\/amazon-marketing-cloud\/"},{"@type":"ListItem","position":2,"name":"\u00a0Why AMC\u2019s instructional queries are not enough"}]},{"@type":"WebSite","@id":"https:\/\/www.intentwise.com\/blog\/#website","url":"https:\/\/www.intentwise.com\/blog\/","name":"Intentwise Blog","description":"Amazon Analytics &amp; Advertising Software","publisher":{"@id":"https:\/\/www.intentwise.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.intentwise.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.intentwise.com\/blog\/#organization","name":"Intentwise","url":"https:\/\/www.intentwise.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2021\/07\/favicon256.png","contentUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2021\/07\/favicon256.png","width":256,"height":256,"caption":"Intentwise"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/person\/b792a03444bf9fe1673eec5daf7fae99","name":"Michael Waters","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocK8NgD1p_6vDhk06IqnMKXDnxTfjSjK3-VxS9-MMBHnowhzlfI","url":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocK8NgD1p_6vDhk06IqnMKXDnxTfjSjK3-VxS9-MMBHnowhzlfI","contentUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocK8NgD1p_6vDhk06IqnMKXDnxTfjSjK3-VxS9-MMBHnowhzlfI","caption":"Michael Waters"},"description":"Senior content writer, Intentwise","url":"https:\/\/www.intentwise.com\/blog\/author\/michaelwatersintentwise-com\/"}]}},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/posts\/26647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/comments?post=26647"}],"version-history":[{"count":0,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/posts\/26647\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/media\/26651"}],"wp:attachment":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/media?parent=26647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/categories?post=26647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/tags?post=26647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}