LinkedIn
Twitter
Hello,
We are using Google Ads Data Transfer to export campaign information and gclid data from Google Ads to BigQuery.
We manage multiple accounts, and since July 22, 2022, we've noticed discrepancies in some accounts where data is missing or reported revenue and clicks are significantly lower compared to Google Ads reports. In certain accounts, a lot of data is missing, while others have partial missing data.
I've attached a screenshot comparing clicks and costs between Google Ads and Data Transfer Data. Additionally, I’ve included the SQL query we use to modify the data from the transfer. We have not changed the report configuration.
We’re uncertain whether the issue lies on our end, with Google Ads, or with BigQuery. Is anyone else experiencing similar problems?
Thank you!
select
c.externalcustomerid as google_ads_customer_id,
cus.accountdescriptivename,
cus.accountcurrencycode as currency_code,
c.campaignid as campaign_id,
c.campaignname as campaign_name,
c.campaignstatus as campaign_status,
cs.date,
sum(cs.impressions) as impressions,
sum(cs.interactions) as interactions,
sum(cs.clicks) as clicks,
(sum(cs.cost) / 1000000) as cost
from
(
select *
from `Campaign_X`
) c
left join
(
select *
from `CampaignBasicStats_X`
) cs
on (
c.campaignid = cs.campaignid
and cs._data_date between date("2023-07-25") and date_add(
current_date(), interval - 1 day
)
)
left join
(
select
externalcustomerid,
accountdescriptivename,
accountcurrencycode,
from
(
select *
from `Customer_X`
) cs
qualify
row_number() over (
partition by externalcustomerid order by _data_date desc
)
= 1
) cus
on c.externalcustomerid = cus.externalcustomerid
where c._data_date = c._latest_date
group by 1, 2, 3, 4, 5, 6, 7, 8
Solved
1 ACCEPTED SOLUTION
