Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi everyone
I want to make local changes in google_ads connector - I’d like to add stream geo_target_constant
In which files should I make edits to change connector?
Right now I make changes in source_google_ads/schemas
source_google_ads/googleads.py
source_google_ads/source.py
source_google_ads/streams.py

Because it’s not in list <https://docs.airbyte.com/integrations/sources/google-ads/#supported-streams>

<https://docs.airbyte.com/integrations/sources/google-ads/#understanding-google-ads-query-language>

image.png

you can use custom queries like this one:
```select ad_group_ad.ad.type, campaign.id, campaign.name, ad_group_ad.ad.id,  segments.device, ad_group_ad.ad.final_urls, segments.ad_network_type, ad_group_ad.ad_group, ad_group.name, customer.descriptive_name, campaign.name, customer.id, campaign.name, metrics.clicks, metrics.all_conversions, metrics.conversions, metrics.view_through_conversions, metrics.conversions, metrics.impressions, metrics.all_conversions_value, metrics.cost_micros, metrics.video_views, metrics.conversions_value from ad_group_ad```

Thank you Marcos
But I think my problem caused that segments.date parameter is inapplicable to geo_target_constant
My GAQL is:
`SELECT geo_target_constant.country_code, geo_target_constant.id FROM geo_target_constant`
I getting error
`message: "Cannot select or filter on the following segments: \'segments.date\'(could not support requested resources: \'GEO_TARGET_CONSTANT\'), since segment is incompatible with the resource in the FROM clause or other selected segmenting resources."`

Thanks for sharing this <@U03LFFKL1HV>, you’re correct probably you need to create a new stream in Google Ads. Also do you mind creating an issue in Github saying you’re not able to use custom queries don’t allow segments.date parameter?

`you need to create a new stream in Google Ads.`
Do you have guidelines for that?

<@U02TQLBLDU4> done <https://github.com/airbytehq/airbyte/issues/14446>