https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
a

Andras N.

05/18/2022, 8:06 PM
Hi everyone, I was playing around with Airbyte and the Google Ads connector and until recently using only the ad_group_ad_report stream I was able to get all the costs/metrics associated with a google ad account. However from my latest tests with this stream I observed that it is missing a lot of clicks and costs (as far as I was able to check Smart Campaign clicks, DSA's are not included anymore). I am not sure if this is an airbyte sync issue or something else, hope somebody can shed some light on it. Thanks!
m

Marcos Marx (Airbyte)

05/18/2022, 8:31 PM
Did you upgrade recently @Andras N. ? Do you have the previous version?
a

Andras N.

05/18/2022, 8:37 PM
Hi Marcos, yes, I am using latest for connectors (destination and source) and Airbyte version 0.38.4-alpha The issue was present before making these updates.
( also we checked, running with a GAQL custom query on ad_group_ad resource from Google Ads which seems that is mapped to ad_group_ad_report and it gets all the clicks & costs correctly )
m

Marcos Marx (Airbyte)

05/19/2022, 1:12 PM
Do you mind sharing the query you run in GAQL? Did you try to create a custom report with the custom query?
a

Andras N.

05/19/2022, 2:17 PM
sure @[DEPRECATED] Marcos Marx, this is the query which we used in our Source setup:
Copy code
SELECT customer.id,customer.descriptive_name,customer.currency_code,campaign.id,campaign.name,ad_group.id,ad_group.name,ad_group.type,segments.ad_network_type,segments.device,metrics.cost_micros,metrics.impressions,metrics.clicks,metrics.conversions,metrics.video_views,metrics.video_quartile_p25_rate,metrics.video_quartile_p50_rate,metrics.video_quartile_p75_rate,metrics.video_quartile_p100_rate FROM ad_group
we successfully materialised in BigQuery (as destination) clicks and cost with this custom query, however I would like to use standard Airbyte connector & implementation for this.