Almost 100 people have downloaded my hashtag SQL cheat sheet for GA4 and BigQuery! Wow!
I've added several more useful queries, and now I have a substantial list of 20 templates for calculating a variety of key product and marketing metrics using hashtag#GA4 export data in hashtag#BigQuery. These aren't just simple "SELECT *" queries. They include attribution calculations, retention, DAU, and other essential analytics tasks:
avg_event_count_per_user
bigquery_cost
dau_mau
engagement_rate
first_click
ga4_product_funnel
hit_dimension_to_session_scope
landing_page_defining
last_non_direct_click
last_paid_click
linear_attribution_1conv
merging_user_id_and_user_pseudo_id
n_day_active_users
new_and_all_users
open_funnel
retention_by_cohorts
session_table
session_table_with_session_duration
timestamp_difference
top_items_added_to_cart
All the queries are neatly packaged in a convenient Notion file. If you're interested in getting access to them for $4.99, just click the link and get it - https://ignatenko.gumroad.com/l/ohrxmc
