Filtering by conversion name in bigquery and doing the same in google ads, I dont see both match.

Can you please clarify why this is happening and how to fix it?

I want to know why this is happening. I want to know how to fix it.

I am trying to build a report that shows metrics such as clicks, impressions and costs per targeted location from Google Ads.

I compare these numbers with Campaigns stats and it does not match. I got lower number from Geo stats actually. On the other hand, in google Ads application, the numbers are the same.

When I compare AdGrup stats with Campaing stats, it is matching for 100 %.

Thanks

I want to understand why there is this discrepancy and how can I solve it.

There are no matching costs between Google Ads Preview Data Transfer's tables - ads_GeoStats and ads_CampaignStats.

I'm interested in getting matched locations cost report for our world campaigns and I used ads_GeoStats table for that but when I check the value of metrics_cost_micros in ads_GeoStats, it shows that it is less than the value of metrics_cost_micros in ads_CampaignStats or Google Ads console.

Steps to reproduce:

select sum(metrics_cost_micros/1000000) from a.google_ads_preview.ads_CampaignStats_* where campaign_id = 123 and _DATA_DATE ='YYYY-MM-DD'

select sum(metrics_cost_micros/1000000) from a.google_ads_preview.ads_GeoStats_* where campaign_id =123 and _DATA_DATE = 'YYYY-MM-DD'

Any help in understanding why this gap exists?

Thanks, Roy

Expect the same costs from the google ads console and ads_GeoStats table.

we are working with Google Big Query data with Google Ads native connector which transfers data from Google Ads to Google Big Query. We see all data about products in Smart Shopping/Shopping campaigns, but we have no data about products in Performance Max campaigns in Big Query.

Does anyone knows how to get data from these campaigns to Google Big Query or when it will be available?

Thank you

Disclaimer...I'm a Noob

I am writing a query from CampaignStats table that aggregates based on a stripped campaign label. The query returns correct values for all metrics except Impressions and Cost. No matter what I've tried so far, this figure still doesn't match. Here are the totals for two of my campaigns from yesterday (June 17th):

CampaignStats:

Date    label   Impressions cost    clicks  avg_cpc 6/17/2022   sat_brand   2687    140.472666  15  9.3648444 

CampaignBasicStats:

Date    label   Impressions cost    clicks  avg_cpc 6/17/2022   sat_brand   699 152.620961  15  10.17473073 

Utilizing the CampaignBasicStats table, I receive aggregated totals for all metrics that match the UI, including Impressions and Cost. The issue is there are metrics in CampaignStats and getting some illumination/information on what I may not be doing correct, will help in the future.

I did a JOIN with the Campaign table originally; the below query refers to a permanent table that I pulled out separately in case this was a cause of the discrepancy.

Code Below:

  SELECT     cs.Date,      EXTRACT(ISOWEEK FROM cs.DATE) AS isoweek,      cl.label,      (SUM(cs.Cost) / 1000000) AS cost,     SUM(cs.Clicks) AS clicks,      CASE WHEN SUM(Clicks)=0 OR SUM(Cost)=0 THEN 0 ELSE     ((SUM(Cost)/SUM(Clicks))/1000000) END AS avg_cpc,      SUM(cs.Impressions) AS Impressions,      CASE WHEN SUM(cs.Clicks)=0 THEN 0 ELSE     (SUM(cs.Clicks)/SUM(cs.Impressions)) END AS ctr,      SUM(cs.Conversions) as conversions,      CASE WHEN SUM(cs.Conversions)=0 OR SUM(cs.Clicks)=0 THEN 0 ELSE     (SUM(cs.Conversions)/SUM(cs.Clicks)) END AS cvr,      CASE WHEN SUM(cs.Conversions)=0 OR SUM(cs.Cost)=0 THEN 0 ELSE     (SUM(cs.Cost)/SUM(cs.Conversions))/1000000 END AS cost_per_conversion FROM    `bold-quanta-######.######_google_ads_dataset.CampaignStats_##########` cs JOIN   `bold-quanta-######.queried_permanent_tables.process_campaign_labels` cl ON   cs.CampaignId = cl.CampaignId GROUP BY   1, 2, 3