Blog: Introducing the Data Warehouse Connector feature
…AS user_type, — Assuming ‘user_type’ is stored in a custom dimension COUNT(*) AS total_visits, AVG(visit_total_time) AS avg_duration, SUM(conversion.revenue) AS total_spent FROM `your_project.your_dataset.matomo_log_visit` AS visit LEFT JOIN `your_project.your_dataset.matomo_log_conversion` AS conversion ON…