Create dashboards that show marketing performance at a glance.
Marketing overview dashboard
Create dashboard: "Marketing overview."
Share with: Marketing team, Sales team, Leadership.
Report 1: Funnel metrics
Shows progression through marketing funnel.
Create report: Funnel visualization.
Stages:
- Website visitors (sessions)
- Leads (contacts created)
- MQLs (lifecycle stage = MQL)
- SQLs (lifecycle stage = SQL)
- Opportunities (deals created)
- Customers (deals closed-won)
Filters: Time period = This quarter
This shows where drop-offs occur. If you have 10,000 visitors but only 200 leads, your lead capture rate is 2% (low). If you have 200 leads but only 50 MQLs, your lead quality or nurturing needs work.
Report 2: Traffic by channel
Shows which channels drive website traffic.
Create report > Website analytics.
Metrics: Sessions
Segmented by: Source (Organic Search, Paid Search, Social Media, Direct, Referral, Email)
Filters: Date range = This month
Visualisation: Pie chart or bar chart.
This reveals which channels are working. If organic search drives 60% of traffic, SEO is your most important channel and deserves continued investment.
Report 3: Lead generation by campaign
Shows which campaigns generate leads.
Create report > Contacts.
Metrics: Count of contacts created
Segmented by: Original source campaign
Filters: Created date = This quarter
Shows which specific campaigns (webinars, ebooks, ads) generate the most leads. Double down on high-performing campaigns.
Report 4: MQL to customer conversion rate
Shows whether marketing-generated leads actually become customers.
Create report > Contacts.
Calculation: (Count of contacts who are customers) / (Count of contacts who became MQL) × 100
Filters: Became MQL date is this quarter
Example: 250 contacts became MQL this quarter, 25 became customers = 10% conversion rate.
Track this rate over time. If it's increasing, lead quality is improving. If declining, you're generating more leads but lower quality.
Report 5: Marketing ROI
Shows revenue generated vs marketing spend.
Create report > Deals.
Metrics:
- Sum of Closed Won revenue (where original source is marketing)
- Marketing spend (manually entered or pulled from ad platform integrations)
Calculation: ROI = (Revenue - Spend) / Spend × 100
Example: £100k in marketing spend generated £500k in revenue = 400% ROI.
This is the report that proves marketing's value to CFO and CEO.