Link AdWords + Google Analytics + BigQuery
We have connected AdWords to our Google Analytics views and it works: AdWords campaigns are shown in Google Analytics. For deeper analysis we would like to analyze the data also in BigQuery.
We have setup the import from Google Analytics to BigQuery using a data view which is linked to AdWords. The import itself works, but if we search in BigQuery for TrafficCampaigns with TrafficMedium = cpc (AdWords-Campaigns), the campaigns are missing (null).
We are also importing all AdWords data directly to BigQuery, but we could not find how to relate this data to the Google Analytics data.
Does anybody know how this works? What do we have to do to link the AdWords campaigns with the Google Analytics data in BigQuery?
Thanks for your help! Kind regards, Al