Identifying Google Ads costing stream in Airbyte

Summary

User is looking for the stream that contains Google Ads costing in Airbyte.


Question

i am using Google Ads source. which stream that contains google ads costing <@U04SE163WC8>



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.

Join the conversation on Slack

["google-ads", "costing", "stream", "airbyte-connector"]

The Google Ads source connector in Airbyte can sync various tables, including custom queries using GAQL. However, based on the information provided, it seems that the ad_groups stream was requested to include the cost_micros field, which presumably contains cost information for Google Ads. This request was put on hold and it’s unclear if it has been implemented yet [source]. There were also requests to natively support the campaign_performance_report and search_query_performance_report streams, which might contain cost-related data. However, these streams are not natively supported and users would need to write a custom query to pull these reports [source1], [source2]. Please check the latest version of the Google Ads source connector in Airbyte to see if these streams are now supported or if the cost_micros field has been added to the ad_groups stream.

i am using v15 <@U04SE163WC8>

A message from http://kapa.ai|kapa.ai

Based on the information provided in the extracts, it’s not clear what specific information or assistance you need related to using v15. If you’re referring to a version of a specific connector in Airbyte, such as Google Ads, it would be helpful to have more context. However, if you’re referring to the Google Ads API version v15, it’s worth noting that in the setup guide for the Google Ads source in Airbyte, there’s a reference to the Google Ads documentation for the CustomerStatusEnum.CustomerStatus in v15 [source]. This suggests that the Google Ads source in Airbyte is compatible with Google Ads API v15. If you need more specific assistance, please provide more details about your question or issue.

i am using Google Ads v15 as a source. which stream that contains google ads costing <@U04SE163WC8>

Based on the information provided in the extracts, the ad_groups stream was requested to include the cost_micros field, which presumably contains cost information for Google Ads. This request was made in a GitHub issue, but it was put on hold and it’s unclear if it has been implemented yet [source]. However, you can create additional streams for Google Ads using custom queries with the Google Ads Query Language (GAQL). This allows you to query the Google Ads API and potentially retrieve cost information. You can review the Google Ads Query Language and use the query builder to validate your query. Once validated, you can add these as custom queries when configuring the Google Ads source [source]. Here’s an example of a GAQL custom query: SELECT campaign.name, metrics.conversions, metrics.conversions_by_conversion_date FROM ad_group Please replace the fields in the SELECT clause with the cost-related fields you need. Remember to check the Google Ads API documentation for the correct field names in v15.