Summary
Adding extra fields using GAQL in a Google Ads stream in Airbyte and considerations for custom queries and built-in streams
Question
Hey guys, I have a stream from google ads for ad_group, but I want to include some extra fields as metrics.average_cpc, metrics.average_cpm, I will do it by adding a custom query using GAQL in my source.
• In my custom query, should only add the extra columns that are not provided in the built-in stream?
• or should I add everything and pause the current built-in stream?
• is it ok to have both the stream and the custom query pointing to the same destination table?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.