Select your media channels
Choose every channel for which you have weekly spend and impressions data.
What are you measuring?
Select the outcome the model will explain. The column name is set automatically.
External control variables
Non-media factors that affect your KPI. The model accounts for them so media ROI estimates stay accurate.
Common examples
TDP · Promoted sales ($) · Google query volume · Seasonality index · Promotion flag (0/1) · Price index · Competitor spend
Download your data template
Pre-built with exactly the right column headers for your selections. Fill it in and upload it in Step 5.
1
Open in Excel or Google Sheets
2
Fill in one row per week. Dates must be YYYY-MM-DD format — Mondays only.
3
Use 0 for any week where a channel was inactive. Never leave media cells blank.
4
Save as CSV and upload in Step 5.
Upload your completed data
Upload the filled-in template from Step 4, or paste CSV content directly.
— or paste below —
Validate & map columns
Review your data and confirm column mappings. If you used the template from Step 4 everything should auto-match.
Ready to export
Download the Meridian-ready CSV and auto-generated Colab loader code for this client.