About Services Tools Blog Contact us

Marketing Lead Dashboard

A monthly screen of enquiries, campaign results, influenced pipeline and form conversions for the leadership review.

  • Reporting Dashboards
  • Water utilities
  • Dashboard feature
  • Productised
  • Cloud
  • 2026

The problem

The monthly lead pack was rebuilt from Salesforce exports, campaign stats and the Google Ads invoice before every review. So the meeting started late and the figures differed from the month before. Form submissions were not tracked in Google Analytics, so reporting fell back to counting the inbox.

What it does

Enquiries, form fills and campaign sends are grouped by month, campaign and product interest, with the change against the previous month. The Google Ads invoice is checked against the live account. Each form shows whether the Google Analytics record and the Salesforce record both arrived. A short commentary is written from the same figures for the review.

Outcomes

  • The review opens on one pack and no fresh export is needed.
  • Spend with no enquiries is called out.
  • A form that missed a Google Analytics event or a Salesforce record is visible.
  • The invoice figure matches what is paid, or it is flagged.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Lead review

New leads
86
+12 on February
Meetings
19
+3
Influenced pipeline
£184k
+£32k
Exhibition leads
24
+13
Web enquiries
41
+3
Leads by source
Paid-search invoice Does not match
Live account
£4,280
Invoice
£4,640

Out by £360. Do not approve it until the account is updated.

Campaigns
CampaignLeadsSpend
Catchment open day Show24Stand fee
Meter clinic pages Web41None
Paid search, brand Paid14£360 out
Partner newsletter Referral7£420
Town-hall posters Paid0£610, none
Commentary
  1. New leads are 86, up 12 on February, and the web form is still the largest source.
  2. The catchment open day brought 24 exhibition leads, and 19 meetings were held.
  3. Influenced pipeline is £184,000, up £31,600 on last month.
  4. Town-hall posters spent £610 and produced no enquiries.
  5. The paid-search invoice is £360 above the live account.

Form match

Forms
4
Matched
2
Open exceptions
2
Month
March 2026
March forms Last submit, analytics event, CRM record
FormLast submitAnalytics eventCRM recordStatus
Trade enquiry3 Mar 2026YesYesMatched
Brochure request3 Mar 2026YesYesMatched
Site survey request2 Mar 2026NoYesMissing event
Careers application28 Feb 2026YesNoMissing CRM
Two forms are still open. Recheck looks for a late event.
Trade enquiry and brochure request already match.

Review pack

Will freeze
86
March leads
Invoice gap
£360
Above the account
Form exceptions
2
Before recheck
Open pack · March 2026

Freezing copies the tiles, the invoice exception and the form match into a one-page note. Later exports will not change it.

  1. Month tiles and source mix
  2. Invoice check
  3. Form match
  4. Commentary
  5. Freeze the one-page pack
Ready to freeze
Pack is open. Freeze copies the March figures.

How it works

  1. Pull leads and campaign influence for the month.
  2. Check the Google Ads invoice against the live account and highlight a mismatch.
  3. Group new leads, meetings and open opportunities, with exhibition and web sources.
  4. List each form with its latest submission, Google Analytics record and Salesforce record.
  5. Write a short commentary from those figures.
  6. Save a one-page pack for the review.

Pipeline

flowchart LR
  Crm["Salesforce leads"] --> Tiles["Month tiles"]
  Ads["Google Ads"] --> Invoice["Invoice check"]
  Forms["Form events"] --> Match["Event and Salesforce match"]
  Tiles --> Pack["One-page pack"]
  Invoice --> Pack
  Match --> Pack
  Pack --> Note["Commentary"]