Analyze lead conversion by campaign
SQL query for HubSpot
Get lead conversion by campaign from HubSpot data.
SELECT campaign, SUM(CASE WHEN lead_status = ‘converted’ THEN 1 ELSE 0 END) AS converted_leads, COUNT(*) AS total_leads FROM HubSpot_data GROUP BY campaign;
HubSpot data model
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed