Create Last Click Campaign Reports with Google BigQuery and GA4. One of the great possibilities that Google Analytics 4 offers us is the ability to automatically export all our data to Google BigQuery, Google’s BigData-orient database.
This export was initially very basic
Practically relegat to the events that were captur from your account, without any processing. However, little by little it has been improv by adding details and filters to the export , allowing user management as GA does and adding details, until in July 2024 it began to associate data from process campaigns within the export. Yes, the GA4 fantuan phone number database, whatever you read on the internet, already has campaign data (at least at last-click ).
What campaign data looks like in BigQuery
BigQuery campaign data is easy to locate and use. It occupies its own columns in the events tables (“events_YYYYMMDD”) within the “session_traffic_source_last_click” record and is split into two sets:
manual_campaing: This includes data from your 3 best wordpress media library folders alternatives natural campaigns. Creat with the utm_* variables (utm_mium, utm_source, etc.) and overlapp with the automatic capture of campaigns perform by GA. Therefore, it is the richest version of your data, as it contains both automatic payment data, payment data with manual tagging, and organic and natural data.
Google_ads_campaign:
This is the specialization of campaigns only in data deriv from Google tools that have been link to Google Analytics. It is therefore a much more bias view of the information, but at the same time much more similar to the data that we would find in Google’s ad management tools.
In short, if you are a Google Ads campaign manager usa data you should look at data from both sets (google_ads_campaing for day-to-day and manual_campaing to cross-reference with the marketing mix) and if you don’t use it you should only use manual_campaing. Within these two collections you will find the different campaign data available.