BKY Data Consulting
Live demo
Built for your HubSpot setup

HubSpot Marketing Health

Your HubSpot contact list activity and MQL readiness, live demo on synthetic data.

Hi [client] — here's a working demo I built for your HubSpot setup; click anything, every number is live from the sample data below.

Total Contacts
15
■ active in HubSpot
Marketing Qualified Leads
5
▲ ready for sales
Avg. Engagement Score
73
▲ higher is better

Contacts by Lifecycle Stage

This shows where all your contacts are in their journey, from new leads to customers.

MQLs by Lead Source

See which sources bring in your most qualified leads, helping you focus your efforts.

What I'd do for you

Clean up your contact list
We'll find and merge duplicates, fix formatting, and fill in missing contact details in HubSpot.
Build smart marketing forms
Create custom forms that capture the right information and update HubSpot automatically.
Design effective email campaigns
Craft engaging emails and set up automated sequences within HubSpot Marketing Hub.
Automate your workflows
Turn your marketing vision into hands-off HubSpot workflows that save you time.
Plus, repetitive work I'd put on autopilot
Auto-assign MQLs to sales
HubSpot Workflows · HubSpot API · Slack
Clean up old contacts
HubSpot Workflows · Python (pandas) · HubSpot API
Sync new form submissions to Google Sheet
HubSpot Webhooks · n8n · Google Sheets API
See how I'd build this on your live system — and the data behind it

How it works in production

How I'd set this up on your live system:

Source
HubSpot Marketing Hub
Your live contacts, forms, emails, and workflows.
Automation
HubSpot API · n8n · Python
Custom logic for cleaning, enrichment, and advanced automations.
Output
HubSpot Reports · Google Sheets · Slack/Email
Actionable insights and timely notifications for your team.

Recent Contact Activity

First NameLast NameEmailLifecycle StageLast Activity DateEngagement Score
AliceSmithalice@example.comLead2023-10-2575
BobJohnsonbob@example.comMarketing Qualified Lead2023-11-0192
CharlieBrowncharlie@example.comLead2023-09-1558
DianaMillerdiana@example.comCustomer2023-11-0588
EveDaviseve@example.comLead2023-10-0162

Raw source data

dataset.csv — showing 12 of 15 rows. Everything above is computed from this file, untouched.

Contact IDEmailFirst NameLast NameLifecycle StageLast Activity DateLead SourceEngagement ScoreLast Email Open DateIs Marketing Qualified Lead
101alice@example.comAliceSmithLead2023-10-25Website752023-10-24No
102bob@example.comBobJohnsonMarketing Qualified Lead2023-11-01Referral922023-10-30Yes
103charlie@example.comCharlieBrownLead2023-09-15Social Media582023-09-10No
104diana@example.comDianaMillerCustomer2023-11-05Website882023-11-03Yes
105eve@example.comEveDavisLead2023-10-01PPC622023-09-28No
106frank@example.comFrankWilsonMarketing Qualified Lead2023-10-28Website852023-10-27Yes
107grace@example.comGraceTaylorLead2023-09-20Social Media552023-09-18No
108heidi@example.comHeidiMooreCustomer2023-11-02Referral952023-11-01Yes
109ivan@example.comIvanWhiteLead2023-10-10PPC682023-10-08No
110judy@example.comJudyHarrisMarketing Qualified Lead2023-11-04Website902023-11-02Yes
111karen@example.comKarenClarkLead2023-09-25Social Media502023-09-22No
112liam@example.comLiamLewisCustomer2023-11-06PPC932023-11-05Yes

Want this on your real data?

I can wire this to your live HubSpot in days.

bing@bkydataconsulting.com