Friday Pack — data guide (English)
==================================

Goal: ~14 days (two weeks) of daily rows so WoW gaps work.
Internal schema after mapping: date, channel, spend, revenue|leads

------------------------------------------------
1) Sheets / CSV template
------------------------------------------------
- Download friday-pack-template.csv from this site (header link or Swap data drawer).
- Or copy columns: date,channel,spend,revenue,leads,campaign
- channel must be one of: meta | google | shopify | other
- Paste your numbers; keep two full weeks (Mon–Sun or your reporting week).

------------------------------------------------
2) Meta Ads Manager → Export
------------------------------------------------
- Ads Manager → Campaigns (or Ad sets) → set date range to last 14 days
- Breakdown: Day (required)
- Columns: Amount spent, Results (or Purchases / Leads), optional Purchase conversion value
- Export → CSV / Excel export as CSV
- Upload here with source preset "Meta Ads" (or Auto)
- Mapped: Day→date, Amount spent→spend, Results→leads, Purchase conversion value→revenue
- Channel defaults to meta when the export has no Platform column

------------------------------------------------
3) Google Ads → Export
------------------------------------------------
- Campaigns → Date range: last 14 days → Segment: Day
- Columns: Cost, Conversions (or Conv. value for ecommerce)
- Download → CSV
- Upload with preset "Google Ads"
- Mapped: Day→date, Cost→spend, Conversions→leads, Conv. value / Conversion value→revenue
- Channel defaults to google

------------------------------------------------
4) Shopify → Orders / Analytics export
------------------------------------------------
- Analytics → Reports → Sales over time (or Orders export)
- Date range: last 14 days, daily grain
- Columns: Day/Date, Total sales or Net sales
- Export CSV; upload with preset "Shopify"
- Mapped: Date→date, Total sales / Net sales→revenue; spend usually blank (OK)
- Channel defaults to shopify

------------------------------------------------
5) Tips
------------------------------------------------
- Mix platforms: export each, paste into one sheet with a channel column, or upload one platform at a time and merge offline.
- Currency symbols and commas are stripped ($1,200.00 → 1200).
- Missing columns show in red; you can still download a placeholder pack.
- Truth lock (Shopify net / CRM SQL) picks the headline; platform rows stay context.