Spreadsheets
Marketing KPI Dashboard
Track your key marketing metrics week-by-week.
Updated: January 26, 2026
What does this AI prompt do?
This AI prompt helps UK SMEs by providing a ready-to-use template for track your key marketing metrics week-by-week.. Simply copy the template below, customize the variables for your business, and paste into any AI tool like ChatGPT or Claude.
AI Prompt Template
Act as a specialist consultant.
Here is the enhanced business prompt template, maintaining the exact structure and variables while boosting clarity, persuasiveness, and expected results:
**Objective: Generate a High-Impact, Actionable Weekly Marketing Performance Dashboard Structure.**
**Core Components (Rows/Metrics):**
* **Website Visits:** (Gauge overall traffic and reach.)
* **New Leads:** (Measure conversion effectiveness.)
* **Email Open Rate:** (Assess engagement quality.)
* **Social Impressions:** (Track brand visibility.)
* **Ad Spend:** (Monitor budgetary utilization.)
* **Cost Per Lead (CPL):** (Determine unit acquisition efficiency.)
**Time-Series Analysis (Columns):**
* **Week 1**
* **Week 2**
* **Week 3**
* **Week 4**
* **MoM Growth %** (Crucial for month-over-month trend analysis.)
**Required Output & Actions:**
1. **Visualization Blueprint:** Construct the complete, neatly formatted table structure based on the metrics and timeframes defined above.
2. **Efficiency Calculation (CPL):** Clearly state the precise formula required to accurately calculate the **Cost Per Lead** metric (Formula: $\text{Ad Spend} / \text{New Leads}$).
3. **Performance Comparison (MoM Growth):** Explicitly define the universally accepted formula for calculating **Month-over-Month Growth Percentage** (Formula: $\text{((Current Week Value - Previous Week Value) / Previous Week Value)}$).
How to use this prompt:
- Copy the template above
- Customize the variables in brackets [like this] with your business details
- Paste into ChatGPT, Claude, or your preferred AI tool
- Get professional results in minutes
Why this works:
This prompt uses proven business frameworks and UK-specific requirements. It's designed to give you professional results that comply with local regulations and industry best practices.