Hello, if you know what marketing attribution is.
Task to build a Looker Studio dashboard based on GA4 BigQuery raw data.
The main event - purchase along with revenue.
The design of the dashboard - basic (the main thing is correct numbers).
Selectors/filters: (the ability to filter data)
1. new/returning user;
2. new_purchaser/recurring (those with one order or more);
3. order date or first session date.
We only make tables:
- comparison of attribution models (first-click, last non-direct, linear, time-decay, position-based, meta ads single attribution) - channel, attribution models, number of orders, revenue.
- channel path (which channels were involved for the order) with the number of sessions (session_id) - similar to GA4 report Advertising -> Attribution -> Attribution paths.
- ROAS table for Meta Ads channel - a Google sheet with advertising expenses for one month will be provided - day, Amount spent, revenue, ROAS.
A dataset with data for the month will be provided.
Work in your BigQuery project.
Data validation - mandatory. (project deliverables)
It is important to have a good knowledge of BigQuerySQL.
I would be happy to hear your proposals
