{"id":26148,"date":"2023-03-17T06:15:15","date_gmt":"2023-03-17T14:15:15","guid":{"rendered":"https:\/\/www.intentwise.com\/blog\/?p=26148"},"modified":"2024-03-14T03:55:30","modified_gmt":"2024-03-14T11:55:30","slug":"how-to-prepare-for-data-errors-from-amazons-apis","status":"publish","type":"post","link":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/","title":{"rendered":"How to Prepare for Data Errors From Amazon\u2019s APIs","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"\n<p>Last year, in the evening hours of Black Friday, brands and agencies on Amazon began noticing a <a href=\"https:\/\/www.insiderintelligence.com\/content\/amazon-ads-reporting-mishap-on-black-friday-gives-retail-media-temporary-black-eye\">peculiar problem<\/a>: Amazon was reporting inaccurate advertising data. <\/p>\n\n\n\n<p>The numbers associated with bids, budgets, and revenues on Amazon all seemed confusingly off the mark. In some cases, Amazon told advertisers that their ad spend was half of what they had expected.&nbsp;<\/p>\n\n\n\n<p>In the world of Amazon advertising, it was a high-profile example of what those of us who work with Amazon data every day already know: Amazon\u2019s reporting tools are not infallible. <a href=\"https:\/\/www.intentwise.com\/blog\/ad-performance-optimization\/4-common-data-mistakes-to-avoid\/\">Errors and incomplete data sets<\/a> are part of the price of doing business in e-commerce. And brands that make advertising and other spending decisions based on Amazon\u2019s reports have to prepare themselves to identify and neutralize these errors.\u00a0<\/p>\n\n\n\n<p>Preparedness is especially important because the typical error isn\u2019t a highly visible reporting blackout on the scale of Amazon\u2019s Black Friday issue. Rather, we usually encounter much smaller issues\u2014an incomplete data set, say, or a late-arriving report\u2014that can more easily slip through the cracks.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-what-do-we-mean-by-data-errors-nbsp\"><strong>What do we mean by data errors?&nbsp;<\/strong><\/h3>\n\n\n\n<p>Many companies, including us here at Intentwise, collect data from a network of Amazon APIs and from <a href=\"https:\/\/www.intentwise.com\/blog\/ad-optimization\/amazon-marketing-stream-a-new-paradigm-in-amazon-search-ads\/\">Amazon Marketing Stream<\/a>, Amazon\u2019s hour-by-hour look into a brand\u2019s ad performance and bid management strategy.&nbsp;<\/p>\n\n\n\n<p>These tools can tell you how much you spend on advertising, how much revenue those ads drove, and how your cost-per-click fluctuate throughout the day, among many other insights. They are powerful data feeds\u2014but they come with challenges.&nbsp;<\/p>\n\n\n\n<p>First, Amazon\u2019s APIs can be difficult to integrate into your business, as they require constant updating and fine-tuning. Last year alone, for instance, Amazon released five different versions of its Sponsored Ads API.<\/p>\n\n\n\n<p>Second, these APIs sometimes have errors and inconsistencies. Yes, in the aggregate, these issues are rare\u2014but if you\u2019re not proactive about identifying them, even a small mistake in Amazon\u2019s data can have outsized repercussions.&nbsp;<\/p>\n\n\n\n<p>Broadly, we find that data errors tend to fall into one of three major buckets:&nbsp;<\/p>\n\n\n\n<p><strong>Data not being available on time. <\/strong>Amazon usually estimates when the next rendition of a report is expected to become available\u2014say, at 6 a.m. eastern on Friday. But once in a while, Amazon will miss its own deadline, and brands will find that they don\u2019t have the data they expected at their fingertips.&nbsp;<\/p>\n\n\n\n<p><strong>Incomplete data.<\/strong> Once in a while, you might download an Amazon advertising report and\u2014whether you notice it right away or not\u2014realize it has some key data points missing. It\u2019s rare, but not totally uncommon, for a report from Amazon to be missing multiple rows or columns of data.&nbsp;<\/p>\n\n\n\n<p><strong>Delay on the API end. <\/strong>By far the most common data reporting issue we see is the lag time between reporting on the Amazon Advertising console and on Amazon\u2019s APIs.&nbsp;<\/p>\n\n\n\n<p>The console is what you see when you log into your Amazon Advertising dashboard, and it tends to have the most up-to-the-minute reporting.&nbsp;The APIs, meanwhile, allow you to migrate that ad data into other platforms and data warehouses\u2014but sometimes there is a lag associated. In the worst case scenario, these lags can stretch on for hours or even days. If you\u2019re not prepared, these discrepancies in reporting are incredibly confusing.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Ad-Console-Screenshot-1-1024x543.jpg\" alt=\"\" class=\"wp-image-26152\" srcset=\"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Ad-Console-Screenshot-1-1024x543.jpg 1024w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Ad-Console-Screenshot-1-300x159.jpg 300w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Ad-Console-Screenshot-1-768x408.jpg 768w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Ad-Console-Screenshot-1-1536x815.jpg 1536w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Ad-Console-Screenshot-1-2048x1087.jpg 2048w, https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Ad-Console-Screenshot-1-560x297.jpg 560w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>(A look inside the Amazon Ads console)<\/em><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>What problems can data errors cause?&nbsp;<\/strong><\/h3>\n\n\n\n<p>At Intentwise, we encounter data errors all the time. We have seen data errors from Amazon significant enough that they skew reported ad spend or revenue <strong>by as much as 3% to 4%<\/strong>.<\/p>\n\n\n\n<p>Often, the impact of an error varies a lot based on both the specifics of the mistake and the needs of the brand or agency that is impacted. As Raghu Kashyap, CTO of Intentwise, put it recently, \u201cIt really depends on the scale of a customer.\u201d<\/p>\n\n\n\n<p>While a major brand might not notice a few missing data points, a smaller one definitely will. We recently worked with a smaller agency, for instance, which found that Amazon underreported the sales generated from an ad campaign. Even though the difference amounted to only a small number of sales, those underreported sales made a big impact on how the agency evaluated the success of the ad campaign.&nbsp;&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>How do you resolve a data error?&nbsp;<\/strong><\/h3>\n\n\n\n<p>Our answer is simple: Build in systems that constantly check for data issues.<strong>&nbsp;<\/strong><\/p>\n\n\n\n<p>At Intentwise, we collect massive amounts of data from <a href=\"https:\/\/www.intentwise.com\/analytics-cloud\">Amazon\u2019s network of APIs and data streams<\/a> every day. We download every report that Amazon publishes, and we pull each one into our various platforms, including <a href=\"https:\/\/www.intentwise.com\/analytics-cloud\">Intentwise Analytics Cloud<\/a>.&nbsp;<\/p>\n\n\n\n<p>To ensure accuracy, we are constantly running automatic checks and balances on each new report from Amazon to make sure everything looks right.&nbsp;<\/p>\n\n\n\n<p>Let\u2019s take one of the above cases as an example. A brand downloads its latest ad spend report, and it looks shorter than usual. We know, for instance, that the same report last year had X number of rows, and we are able to automatically detect any discrepancies. If a metric looks amiss, or if a report seems incomplete, we will automatically flag it and investigate.&nbsp;<\/p>\n\n\n\n<p>Whether you opt to partner with an outside data manager like Intentwise or you build a data engine internally, you should be sure to implement a similar preparedness system. When Amazon\u2019s APIs are informing your business decisions, make sure you are prepared for delayed reports, incomplete data sets, and anything else that might crop up.&nbsp;<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>Last year, in the evening hours of Black Friday, brands and agencies on Amazon began noticing a peculiar problem: Amazon was reporting inaccurate advertising data. The numbers associated with bids, budgets, and revenues on Amazon all seemed confusingly off the mark. In some cases, Amazon told advertisers that their ad spend was half of what [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":22,"featured_media":26151,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","cybocfi_hide_featured_image":"","footnotes":""},"categories":[20],"tags":[69,37,109,96],"class_list":["post-26148","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-amazon-advertising","tag-amazon-advertising","tag-amazon-advertising-api","tag-data-errors","tag-mobile"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Prepare for Data Errors From Amazon\u2019s APIs<\/title>\n<meta name=\"description\" content=\"When you download reports from Amazon, data errors\u2014such as missing rows or columns\u2014are inevitable. Here\u2019s how brands can prepare.\" \/>\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-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Prepare for Data Errors From Amazon\u2019s APIs\" \/>\n<meta property=\"og:description\" content=\"When you download reports from Amazon, data errors\u2014such as missing rows or columns\u2014are inevitable. Here\u2019s how brands can prepare.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/\" \/>\n<meta property=\"og:site_name\" content=\"Intentwise Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-17T14:15:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-14T11:55:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Error-Post.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1750\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\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-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/\"},\"author\":{\"name\":\"Michael Waters\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/person\\\/b792a03444bf9fe1673eec5daf7fae99\"},\"headline\":\"How to Prepare for Data Errors From Amazon\u2019s APIs\",\"datePublished\":\"2023-03-17T14:15:15+00:00\",\"dateModified\":\"2024-03-14T11:55:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/\"},\"wordCount\":947,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/Error-Post.jpg\",\"keywords\":[\"Amazon Advertising\",\"Amazon Advertising API\",\"Data Errors\",\"Mobile\"],\"articleSection\":[\"Amazon Advertising\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/\",\"name\":\"How to Prepare for Data Errors From Amazon\u2019s APIs\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/Error-Post.jpg\",\"datePublished\":\"2023-03-17T14:15:15+00:00\",\"dateModified\":\"2024-03-14T11:55:30+00:00\",\"description\":\"When you download reports from Amazon, data errors\u2014such as missing rows or columns\u2014are inevitable. Here\u2019s how brands can prepare.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/Error-Post.jpg\",\"contentUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/Error-Post.jpg\",\"width\":1750,\"height\":1000},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/amazon-advertising\\\/how-to-prepare-for-data-errors-from-amazons-apis\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Amazon Advertising\",\"item\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/.\\\/amazon-advertising\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Prepare for Data Errors From Amazon\u2019s APIs\"}]},{\"@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":"How to Prepare for Data Errors From Amazon\u2019s APIs","description":"When you download reports from Amazon, data errors\u2014such as missing rows or columns\u2014are inevitable. Here\u2019s how brands can prepare.","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-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/","og_locale":"en_US","og_type":"article","og_title":"How to Prepare for Data Errors From Amazon\u2019s APIs","og_description":"When you download reports from Amazon, data errors\u2014such as missing rows or columns\u2014are inevitable. Here\u2019s how brands can prepare.","og_url":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/","og_site_name":"Intentwise Blog","article_published_time":"2023-03-17T14:15:15+00:00","article_modified_time":"2024-03-14T11:55:30+00:00","og_image":[{"width":1750,"height":1000,"url":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Error-Post.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-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#article","isPartOf":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/"},"author":{"name":"Michael Waters","@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/person\/b792a03444bf9fe1673eec5daf7fae99"},"headline":"How to Prepare for Data Errors From Amazon\u2019s APIs","datePublished":"2023-03-17T14:15:15+00:00","dateModified":"2024-03-14T11:55:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/"},"wordCount":947,"commentCount":0,"publisher":{"@id":"https:\/\/www.intentwise.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Error-Post.jpg","keywords":["Amazon Advertising","Amazon Advertising API","Data Errors","Mobile"],"articleSection":["Amazon Advertising"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/","url":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/","name":"How to Prepare for Data Errors From Amazon\u2019s APIs","isPartOf":{"@id":"https:\/\/www.intentwise.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#primaryimage"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Error-Post.jpg","datePublished":"2023-03-17T14:15:15+00:00","dateModified":"2024-03-14T11:55:30+00:00","description":"When you download reports from Amazon, data errors\u2014such as missing rows or columns\u2014are inevitable. Here\u2019s how brands can prepare.","breadcrumb":{"@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#primaryimage","url":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Error-Post.jpg","contentUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2023\/03\/Error-Post.jpg","width":1750,"height":1000},{"@type":"BreadcrumbList","@id":"https:\/\/www.intentwise.com\/blog\/amazon-advertising\/how-to-prepare-for-data-errors-from-amazons-apis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Amazon Advertising","item":"https:\/\/www.intentwise.com\/blog\/.\/amazon-advertising\/"},{"@type":"ListItem","position":2,"name":"How to Prepare for Data Errors From Amazon\u2019s APIs"}]},{"@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\/26148","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=26148"}],"version-history":[{"count":0,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/posts\/26148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/media\/26151"}],"wp:attachment":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/media?parent=26148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/categories?post=26148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/tags?post=26148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}