如何通过适用于Google Ads的BigQuery数据传输服务来解决从Google Ads到Google Bigquery的转换中的数据差异 [英] How to fix data discrepancy in conversions from Google Ads into Google Bigquery via BigQuery Data Transfer Service for Google Ads

问题描述

我正在将BigQuery数据传输服务用于Google Ads，并且发现我们的一位客户的转化数据存在差异.这些转化与我在Google Ads中获得的转化和浏览型转化都不同.最初，我认为可能是最后30天的数据没有刷新，但是当我回顾4月份时，即使5月匹配，我仍然会看到一些差异.奇怪的是，Google BigQuery的转化次数超过了Google Ads中显示的转化次数.想知道是否还有其他人可以解决此问题，并且可以提供修复程序以获取准确的报告.预先感谢！

I'm using BigQuery Data Transfer Service for Google Ads and I'm seeing data discrepancy for one of our client's conversions. The conversions differ in both conversions and view-through conversions from what I'm getting in Google Ads. Initially, I thought it was perhaps maybe the last 30 days of data not being refreshed, but when I look back in April, I'm still seeing some discrepancy even though May matched up. The weird part is that Google BigQuery has more conversions than what is shown in Google Ads. Wondering if anyone else has this issue and can provide a fix to get accurate reporting. Thanks in advance!

尝试了不同的日期以验证数据的准确性

Tried different dates to verify accuracy in data

SELECT 
  ConversionTypeName, 
  SUM(AllConversions) 
FROM ###.CampaignCrossDeviceConversionStats_######
WHERE (Date BETWEEN '2019-04-01' AND '2019-04-30') AND ConversionAttributionEventType = 'IMPRESSION'
GROUP BY ConversionTypeName

我希望数据会在很大程度上匹配，除了自30日窗口刷新日期以来的最近30天之内的细微差异

I expect the data to match up for the most part except perhaps small discrepancies in the last 30 days since the date refreshes on a 30 day window

推荐答案

通常，通过设置

Discrepancies issues on BigQuery transfers in general, including Google Ads to BigQuery transfers are often resolved by setting up a backfill for the affected time period.

除此之外，我建议您与 Google Ads支持联系.

Other than that, I would recommend you to contact the Google Ads support.

这篇关于如何通过适用于Google Ads的BigQuery数据传输服务来解决从Google Ads到Google Bigquery的转换中的数据差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！