Update Google Ads google / organic fix.

[dgitis]

Google has added data from the Google Ads integration to GA4 to the BigQuery export.

We've added a new record to the GA4 BigQuery Event export that contains the Google Ads and Manual campaign context information for each session present in the export. This information is repeated for every event in a session to enable fast and easy channel analysis in BigQuery of any event within a session. The exported data is the same as the data used in GA4 behavioral reporting.

from this update

It only exports to the events_ table. Intraday is not supported.

We could support this in place of what we currently do, which is use UTMs if they are present and fall back to using google / cpc if we see a gclid parameter.

The GA4_dataform package also has a novel approach to this problem.

It uses the Google Data Transfer connection to Google Ads and replaces the mis-attributed google / organic traffic with data from Google Ads.

This would work with intraday GA4 tables.

I think our approach is good enough but I think the Google Data Transfer approach is better since it should track google / display properly, for example, and works with intraday.

However, any time that data source changes, particularly when adding new ads products, we would need to update the integration.

Using the new fields in the export wouldn't work with intraday, but it would offload the support of data schema changes to Google.