How to track lead-to-MQL conversion rate by source and report weekly to Slack
Calculate how many leads convert to MQLs from each source (organic, paid, referral) and post a weekly breakdown to Slack so marketing and sales can see what's working.
Why track conversion by source?
Not all lead sources are equal. Your paid ads might generate 500 leads but only 10 MQLs, while your blog generates 50 leads and 15 MQLs. Without conversion tracking by source, you're flying blind on marketing spend.
A weekly Slack report keeps both marketing and sales aligned on what's actually working.
What you'll need
- HubSpot account with API access
- Lifecycle stages configured (at minimum: Lead, MQL)
- Lead source tracking in HubSpot (via UTM parameters or original source property)
- Slack workspace with bot access
Choose your approach
Select an approach below to see the full step-by-step guide.
n8n
mediumSchedule → HubSpot search leads and MQLs → Code to calculate rates → Slack
Make
mediumScheduler → HubSpot searches → Aggregators for counts → Slack message
Code + Cron
mediumPython script to query HubSpot for lead/MQL counts by source and post to Slack
Related Recipes
How to post a daily Slack leaderboard of rep activity from HubSpot
HubSpot + Slack
How to send a weekly Slack report on HubSpot sequence performance
HubSpot + Slack
How to automate a weekly pipeline report with HubSpot and Slack
HubSpot + Slack
How to send a Slack alert when a HubSpot deal changes stage
HubSpot + Slack
Frequently Asked Questions
Need help implementing this?
We build and optimize automation systems for mid-market businesses. Let's discuss the right approach for your team.