add a source
One export in. Every column mapped.
Paste the rows or choose the file. Wapsolut works out the delimiter, the date format and which column is which, then folds it into the model.
where the export lives
search console
- 01Search Console → Performance → Export → Download CSV.
- 02Set the date range to the last 3 months, and switch the chart to Date.
- 03The file that matters is Dates.csv.
ga4
- 01GA4 → Reports → Acquisition → Traffic acquisition.
- 02Add Date as the primary dimension, then Share → Download file → CSV.
- 03Sessions, engaged sessions and conversions all come across.
columns it recognises
- property
- site, domain, page, landing page, property
- date
- date, day, week
- clicks
- clicks, url clicks
- impressions
- impressions
- position
- position, average position
- sessions
- sessions, users
- engaged
- engaged sessions
- conversions
- conversions, key events, goal completions
A date column and either clicks or sessions is the minimum. Anything else it finds, it keeps.