Every marketer knows they should be tracking metrics like CAC, ROAS, and conversion rate. The challenge is pulling data from different places, remembering the formulas, and turning a collection of numbers into something you can actually use.
Instead of building another spreadsheet or searching Google for the right calculation, let ChatGPT do the heavy lifting.
Try this prompt:
You are a senior marketing analyst.
I'm going to give you raw marketing data from my business.
Based on the information I provide:
1. Calculate every marketing metric you can, including (where possible):
- Customer Acquisition Cost (CAC)
- Cost Per Lead (CPL)
- Customer Lifetime Value (LTV)
- Return on Ad Spend (ROAS)
- Marketing ROI
- Conversion Rate
- Lead-to-Sale Conversion Rate
- Average Order Value (AOV)
- Retention Rate
- Churn Rate
- Any other useful marketing metrics.
2. Present everything in a clean, executive-style dashboard.
3. For each metric include:
- The formula used
- The calculated value
- A plain English explanation of what it measures
- Any benchmarks or context that would help me interpret the result
4. Summarize the results by highlighting:
- My strongest metrics
- Any metrics that need attention
- Three practical recommendations based on the data
If I haven't provided enough information to calculate a metric, don't guess. Ask me for the additional information you need before continuing.
You'll have a single dashboard that shows where your marketing stands, without needing to calculate every metric yourself.
Happy prompting!
One brand shipped 30+ landing pages last week. No developers.
A DTC brand briefed Viktor inside Slack: one landing page per Meta ad group, mapped to a different headline variant. He wrote the code, deployed each page to their subdomain, posted the URLs back in #marketing, and now monitors performance across the set.
Their content team uses him to draft email flows, generate creative variants, and audit Klaviyo segments every Friday. Their growth lead uses him to catch spend anomalies before the day starts.
20,000+ teams now have the same setup: one AI employee across every marketing tool. A teammate who ships work in Slack and Microsoft Teams.

