Almost every day I share a post on LinkedIn about marketing analytics, BigQuery, GA4, GTM, and other aspects of working with data. This is a comprehensive list of my favorite queries which I love to use on the daily basis for getting insights from my GA4 export. Feel free to get access to all the SQL files. And don't forget to leave a feedback!

Have a question about analytics? Feel free to schedule a short meeting.

Top GA4-BigQuery Queries

1. avg_event_count_per_user
2. bigquery_cost
3. dau_mau
4. engagement_rate
5. first_click
6. ga4_product_funnel
7. hit_dimension_to_session_scope
8. landing_page_defining
9. last_non_direct_click
10. last_paid_click
11. linear_attribution_1conv
12. merging_user_id_and_user_pseudo_id
13. n_day_active_users
14. new_and_all_users
15. open_funnel
16. retention_by_cohorts
17. session_table
18. session_table_with_session_duration
19. timestamp_difference
20. top_items_added_to_cart
21. rolling_mau

💬 How to Get in Touch

• https://www.linkedin.com/in/aleksandr-ignatenko/
• https://www.alexignatenko.com
• https://twitter.com/auignatenko