@kapa.ai can we add transformation in google ads api to bigquery ?

Yes, you can add transformations to your Google Ads API data before sending it to BigQuery using Airbyte. However, the transformation process is not directly mentioned in the provided knowledge sources. Airbyte allows you to move data from various sources to destinations like BigQuery. For example, there are tutorials on how to move data from LinkedIn Ads to BigQuery, and from Google Analytics, Facebook Ads, and Salesforce to BigQuery. In the case of Google Ads, you can create additional streams using custom queries in the Google Ads Query Language. Here's an example of a custom query:

sql SELECT       campaign.name,       metrics.conversions,       metrics.conversions_by_conversion_date   FROM ad_group

You can add these custom queries when configuring the Google Ads source in Airbyte. Once the data is in BigQuery, you can perform further transformations and analysis. For more detailed steps on how to set up these transformations, you may want to refer to the official Airbyte documentation or tutorials. Sources: - [Google Ads Source Configuration](https://docs.airbyte.com/integrations/sources/google-ads#custom-query-understanding-google-ads-query-language) - [BigQuery Destination Tutorials](https://docs.airbyte.com/integrations/destinations/bigquery#tutorials) - [LinkedIn Ads to BigQuery Tutorial](https://airbyte.com/tutorials/linkedin-ads-api-marketing-data-to-bigquery)