The following article details the Google Analytics 360 Service Level Agreement (SLA) for BigQuery Export.
Analytics guarantees when the BigQuery Export data will arrive each day for premium properties categorized as “Normal” or “Large” based on the number of events collected. Learn more about property categories.
Users who wish to utilize the SLA for BigQuery Export must select the Fresh daily option when setting the frequency for BigQuery Export. Learn more.
Since the Fresh Daily export occurs frequently to provide you with the fastest access to your data, traffic source fields for recent Google Ads events might have the value Data Not Available. This is because the Fresh Daily export is sometimes faster than the Google Ads attribution process. For options to backfill the missing data, read about Backfill “Not Available” traffic source dimensions in [GA4] BigQuery Export.
Use the Google Ads API
Users can look up fallback values by querying the click_view resource of the Google Ads API. Below is a sample query that retrieves all GCLIDs for the previous day. Use the Google Ads Query Builder to build or modify this query as needed.
SELECT
click_view.gclid,
campaign.name,
segments.ad_network_type
FROM click_view
WHERE segments.date DURING YESTERDAY
Use the results of this query as a fallback source for Data Not Available values by joining rows where the collected_traffic_source.gclid in Analytics BigQuery Export data matches the click_view.gclid in the Google Ads data. The results from the query map to the export schema as follows:
| click_view field | Event schema field | Notes |
|---|---|---|
| click_view.gclid | collected_traffic_source.gclid | Use these fields to join records in the two data sets. |
|
segments.ad_network_type |
traffic_source.source | Refer to the Google Ads API reference docs for possible values of segments.ad_network_type. |
| N/A | traffic_source.medium | Fallback to a value of cpc on joined records. |
| campaign.name | traffic_source.name | The campaign.name will contain the complete Google Ads campaign name. |
click_view resource for a single date value for segments.date. To query data for a specific day instead of the previous day, modify the WHERE clause above to segments.date = 'YYYY-MM-DD' and replace YYYY-MM-DD with any date within the last 90 days.Use Google Ads Scripts
Users can issue the click_view query above using the reporting feature of Google Ads Scripts. Results of the query can be exported to a spreadsheet or incorporated into query processing within a script.
Use the BigQuery Data Transfer Service for Google Ads
Users who have set up the BigQuery Data Transfer Service for Google Ads can join the collected_traffic_source.gclid from GA4 event data to the click_view_gclid field of ads_ClickStats_CUSTOMER_ID from the Google Ads transfer, then map fields to the export schema as follows:
| ClickStats field | Event schema field | Notes |
|---|---|---|
| click_view_gclid | collected_traffic_source.gclid | Use these fields to join records in the two data sets. |
| segments_ad_network_type | traffic_source.source | Refer to the Google Ads API reference docs for possible values of segments.ad_network_type. |
| N/A | traffic_source.medium | Fallback to a value of cpc on joined records. |
| campaign_id | traffic_source.name | The ClickStats.campaign_id field contains the ID of the campaign. Use this ID to look up the campaign name in the Campaign match table. |
ads_ClickStats_CUSTOMER_ID table per customer.