Campaign Performance Dashboard

I have a campaign performance dashboard built in React/Next.js with Tailwind CSS.

Current demo data structure:
- channels: Meta Ads, Google Search, TikTok Ads, Email, Organic Social
- metrics per channel: spend, impressions, clicks, leads, revenue

My actual data:
[PASTE YOUR CHANNEL LIST AND AVAILABLE METRICS HERE]

Please:
1. Update the channel list to match my data
2. Add or remove metrics based on what I track
3. Adjust the aggregation functions for my specific KPIs
4. Keep the same visual style and component structure
5. Replace demo numbers with a data loading pattern for my source

Note: The demo data must be completely replaced — do not ship sample numbers.

Create a Google Sheets template for a campaign performance dashboard.

Required columns:
- date (YYYY-MM-DD)
- channel (text: the marketing channel name)
- spend (number: total ad spend)
- impressions (number: total impressions)
- clicks (number: total clicks)
- leads (number: total conversions or leads)
- revenue (number: attributed revenue)

Optional columns:
- campaign_name (text)
- creative_id (text)
- landing_page (text)

Please:
1. Create the sheet structure with headers and data validation
2. Add a summary row with formulas for CTR, CPC, CPL, ROAS
3. Add conditional formatting to highlight underperforming channels
4. Include a tab with channel-level weekly rollup
5. Add notes explaining each column

The sheet should be ready to paste data from Meta Ads Manager, Google Ads, and TikTok Ads exports.

I need to connect live marketing data to a Next.js campaign dashboard.

Current setup:
- Next.js with static export
- Dashboard component expects an array of channel objects: { channel, spend, impressions, clicks, leads, revenue }
- No backend API routes available in static export mode

My data sources:
[LIST YOUR AD PLATFORMS: e.g., Meta Ads, Google Ads, TikTok Ads]

Please suggest:
1. The simplest way to get data from these platforms into my dashboard
2. A build-time data fetching approach (if using SSG/ISR)
3. A client-side approach (if I add an API endpoint later)
4. How to handle data freshness and caching
5. Error handling for missing or incomplete data

Constraints:
- Must work with static export for now
- No external chart libraries (using div-based bars and HTML tables)
- Must be deployable without environment variables in the static build

Review the KPI logic for a campaign performance dashboard.

Current metrics:
- CTR = clicks / impressions × 100
- CPC = spend / clicks
- CPL = spend / leads
- Conversion Rate = leads / clicks × 100
- ROAS = revenue / spend

Current dashboard sections:
1. Executive snapshot (total spend, leads, CPL, revenue, ROAS)
2. Channel performance table (per-channel breakdown)
3. Leads by channel (bar chart)
4. Spend vs Revenue by channel (comparison)
5. Conversion funnel (impressions → clicks → leads → revenue)

Please review and suggest:
1. Are these calculations standard and accurate?
2. What metrics am I missing that would improve decision-making?
3. Should I add time-series trends (week-over-week)?
4. How should I handle channels with zero spend (organic)?
5. What benchmarks should I compare against?
6. Any red flags in the dashboard structure?

My business type: [DESCRIBE YOUR BUSINESS]
My main goal: [LEADS / REVENUE / BRAND AWARENESS / OTHER]