Retrieve MCF Conversions tracking data from Google Bigquery

I use Google Bigquery to retrieve conversion path data from Google Analytics (GA).

When I analyze these conversion paths from the exported dataset, the last click conversions correspond to the GA purchase report, but not to the multi-channel sequence data (MCF). Apparently, Bigquery doesn't really export the raw data, but converts it, removing all the last direct clicks. as described here: https://support.google.com/analytics/answer/1319312?hl=en .

Is it possible for Bigquery data to match the data of a multi-channel sequence transform (MCF) channel? To undo the deletion of the last indirect click and get proper user level raw data?

+4
source share
1 answer

All fields trafficSourcein BigQuery Export for Google Analytics use campaign attribution, as described in this processing flow , which will overwrite direct traffic with the most recent campaign (if there is one and it is in the specified timeout), as you mentioned.

Universal Analytics, - , , 6- . , - , , , , , , . Classic Analytics, _setCampaignCookieTimeout. .

+1

All Articles