Getting impressions for Ads in Bigquery

[Johan Strand]

I have imported all our Shopping ads data into BQ and are now trying to get nr of impressions for one campaign during one day. 

But the result i get is around 100 times higher then nr in Google Ads, same if i get nr of Clicks. 

Any ideas? 

SELECT

  shopping.date,

  name.CampaignName,

    SUM(shopping.Impressions) AS Impressions
FROM
  `xxxxxx.google_cost_dataset.ShoppingProductStats_xxxxxxxxxx` AS shopping
INNER JOIN
  `xxxxxx.google_cost_dataset.Campaign_xxxxxxxxxx` AS name
ON
  shopping.CampaignId = name.CampaignId
WHERE
  date = "2019-07-01"
  AND CampaignName = "se_google_generic_shopping"

[Google Ads API Forum Advisor Prod]

Hello Johan, 

We will be able to address concerns specific to AdWords API/Google Ads API on this forum. It looks like you are having an issue generating the report data in BigQuery, you will need to get in touch with the BigQuery team by contacting them through the support channels available here. If you are seeing any data discrepancies with Google Ads API reporting and Google Ads account, please elaborate and we will be happy to take a look.

Thanks,
Bharani, Google Ads API Team 

ref:_00D1U1174p._5001UCc0U2:ref