{"id":120,"date":"2015-05-25T19:14:35","date_gmt":"2015-05-25T13:44:35","guid":{"rendered":"http:\/\/www.karooya.com\/blog\/?p=120"},"modified":"2017-07-06T14:22:22","modified_gmt":"2017-07-06T08:52:22","slug":"for-36-hours-adwords-conversion-data-was-incorrect-in-reports-and-apis","status":"publish","type":"post","link":"https:\/\/www.karooya.com\/blog\/for-36-hours-adwords-conversion-data-was-incorrect-in-reports-and-apis\/","title":{"rendered":"For 36 hours, AdWords conversion data was incorrect in reports and APIs"},"content":{"rendered":"<p class=\"lead\">On Sunday morning (or Saturday late night in US), we received an email from Google AdWords, about an error in reported conversion values. \u00a0The AdWords users who use AdWords Scripts, automated reports or the AdWords APIs, are affected by this error.<\/p>\n<p><!--more--><\/p>\n<p>Between\u00a0Thursday, <strong>21 May 2015 12:52 PM<\/strong> and Saturday, <strong>23 May 2015 12:22 AM<\/strong> Pacific Daylight Time ie. for about <strong>36 hours,\u00a0<\/strong>the data in reports was incorrect. As per the email, it seems, only the values of Clicks, Impressions and Cost (and their derivates like CTR, CPC,..) were correct. Rest of the columns returned incorrect values. Of which, the conversion-related columns are most crucial. If you have an AdWords\u00a0script that makes changes (such as modifying the bid, pausing the keywords\/ad groups\/campaigns,..)\u00a0to the account based on the conversion data, it probably made incorrect decisions during this window. Obviously, accounts that use a\u00a0third-party bid management\u00a0software, would also be affected.<\/p>\n<p>&nbsp;<\/p>\n<p>AdWords\u00a0API developers <a href=\"https:\/\/groups.google.com\/forum\/#!msg\/adwords-api\/pJeMVBa0gEs\/EJa3gOFf64EJ\" target=\"_blank\" rel=\"noopener noreferrer\">reported this problem<\/a> on AdWords API forum. An user <a href=\"https:\/\/groups.google.com\/forum\/#!msg\/adwords-api\/pJeMVBa0gEs\/gQ77xuTvd2YJ\" target=\"_blank\" rel=\"noopener noreferrer\">reported<\/a> that this problem existed even for the reports downloaded from the AdWords web interface. The AdWords API Team member confirmed on Sunday that the problem has been resolved.<\/p>\n<p>&nbsp;<\/p>\n<p>The email says, <em>&#8220;at least one of your reports may be affected,&#8221;<\/em>\u00a0which leaves two\u00a0question unanswered. One, did\u00a0this problem affect only some or all of\u00a0the AdWords accounts that use AdWords Scripts, automated reports and APIs? Second, did the web interface showed incorrect values as well during this window?<\/p>\n<p>&nbsp;<\/p>\n<p>I would guess, the large accounts that make frequent bid changes are probably among the worst affected. If the number of conversions were reported higher than the actual, the bidding software probably \u00a0increased the bids, causing you to spend more than you intended. \u00a0On the other hand, if the conversion data underestimated the real numbers, the bids may have gone down to take into account the fall in conversion. In which case, the account probably saw lower average position, resulting in lower click volume.<\/p>\n<p>&nbsp;<\/p>\n<p>To be safe, if you have made changes to your account during this window based on conversion metrics, you should review your changes. Please note that the aforementioned time is Pacific Timezone. You should convert that to your respective timezone (local or of the account) to find out the window in which your accounts were affected.<\/p>\n<p>&nbsp;<\/p>\n<p>The full text of the email.<\/p>\n<blockquote><p>&nbsp;<\/p>\n<p>Dear AdWords Advertiser,<\/p>\n<p>&nbsp;<\/p>\n<p>Due to a temporary issue, automated reports downloaded in AdWords incorrectly reported certain stats between Thursday, 21 May 2015 12:52 PM and Saturday, 23 May 2015 12:22 AM Pacific Daylight Time. The issue has been fixed and you will see correct stats if you download those reports now.<\/p>\n<p>&nbsp;<\/p>\n<p>If you downloaded a report during the times stated above, or used automated scripts that rely on these columns, you may have received incorrect stats from reports for all stat columns other than Clicks, Cost and Impressions (and their ratios). The most commonly affected stats were Conversions columns (ConversionRate, ConversionValue, EstimatedTotalConversions, etc.), Impression Share columns (SearchImpressionShare, SearchRankLostImpressionShare, etc.) and Invalid Click columns (InvalidClicks, InvalidClickRate).<\/p>\n<p>&nbsp;<\/p>\n<p>During the time of the issue, you may have seen the following for the affected stats columns:<\/p>\n<p>&nbsp;<\/p>\n<p>If the column was a regular stats column (e.g., Conversions), the reported value may have been greater than the actual value.<br \/>\nAn incorrect value (either greater than or less than the actual value) may have been reported for columns derived from one or more regular stats column (e.g., ConversionRate, since it is calculated as Conversions \/ ConversionTrackedClicks).<\/p>\n<p>Our logs show that at least one of your reports may be affected by this issue. While we\u2019ve fixed the issue, we recommend that you re-run these reports and use the corrected data. If you downloaded and stored this data in your local database or used the data to make bidding changes, these will need to be updated. AdWords automated bid strategies were not impacted by this issue.<\/p>\n<p>&nbsp;<\/p>\n<p>We apologize for any inconvenience this issue may have caused you. Please contact us or your Google representative if you have additional questions.<\/p>\n<p>&nbsp;<\/p>\n<p>Sincerely,<\/p>\n<p>The AdWords Team<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>On Sunday morning (or Saturday late night in US), we received an email from Google AdWords, about an error in reported conversion values. \u00a0The AdWords users who use AdWords Scripts, automated reports or the AdWords APIs, are affected by this error.<\/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":[3],"tags":[],"class_list":["post-120","post","type-post","status-publish","format-standard","hentry","category-googl-search-tips"],"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\/120","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=120"}],"version-history":[{"count":5,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":5090,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/posts\/120\/revisions\/5090"}],"wp:attachment":[{"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karooya.com\/blog\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}