BigQuery Attribution Workshop Series

Three workshop videos covering the following topics:

1. Setting up export and building a session table in BigQuery:

0h:53m workshop video

Additional materials:

• Export organization documentation for BigQuery doc
• Creating a Google Cloud account docs
• About the BigQuery database doc
• Differences between GA4 interface and BigQuery data doc
• Key queries doc
• Session Table SQL query

2. Last Non-Direct Click attribution in BigQuery:

0h:30m workshop video

Additional materials:

• Conditions in BigQuery doc
• Window Functions in BigQuery doc
• Example of calculating The Last Non-Direct Click
• The final Last Non Direct Click Attribution Query 

3. Non-standard attribution models (First Click, Last Paid Click, Linear) in BigQuery:

Oh:30m workshop video

Additional materials:

• About Attribution Models in Google Analytics 
• First Click SQL Query
• Last Paid Click SQL Query
• Linear Attribution SQL Query
• Luka Cempre Linear Attribution Example

All video recordings come with links to documentation and code query examples. All attribution models were thoroughly discussed during the workshops. If you have any questions while watching, I'll be more than happy to answer them.

Follow me:

https://www.linkedin.com/in/aleksandr-ignatenko/

https://www.alexignatenko.com

https://twitter.com/auignatenko