ACTsights Historical Trends Calculator

Marketing Performance Analysis

Historical Performance Data

Month Data Value Include
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6 (Latest)
  True Baseline (Avg)
0.00
Based on 0 valid months
  MoM Growth
--
Month 5 → Month 6
  Natural Projection
--
Need 2+ months of data
  12-Month Forecast
Need 2+ months of data

CPA & Budget Projections

$
$
  Current CPA
$0.00
  Projected Leads
0
With $0 increase
  Cost Per Lead
$0.00

AI Prompt for KPI Strategy Consultant

AI-Accelerate your analysis by pasting this prompt into your favorite AI tool. Interrogate your strategy. Give AI the template for KPI Strategy Record for it to populate for you.

Formula Reference

Baseline = Σ Valid Month Values / Count of Valid Months
CPA = Total Marketing Spend / Baseline
MoM Growth = ((M6 - M5) / M5) × 100%
Natural Projection = M6 × (1 + MoM Growth%)

Paste Data

Paste your 6 numbers separated by commas, spaces, or line breaks. Most recent month first.