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
Calls
Campaigns
Campaign Emails
Conversation Threads
Companies
Company Contacts Association
Company Company Association
Company Deals Association
Company Line Items Association
Company Payments Association
Company Subscriptions Association
Contacts
Contacts Company Associations
Contacts Contacts Associations
Contacts Deals Associations
Contacts Subscriptions Associations
Contacts Payments Associations
Commerce Payments
Payments Deals Associations
Deals
Deals Company Associations
Deals Contacts Associations
Deals Deals Associations
Deals Line Items Associations
Deals Subscription Associations
Deals Payments Associations
Deals Pipeline
Engagements
Engagements Company Associations
Engagements Contacts Associations
Engagements Deals Associations
Engagements Subscriptions Associations
Engagements Payments Associations
Engagement Emails
Feedback Submissions
Forms
Form Submissions
Goals
Leads
Line Items
Meetings
Meetings Company Associations
Meetings Contacts Associations
Meetings Deals Associations
Meetings Leads Associations
Notes
Notes Deals Associations
Owners
Products
Quotes
Quotes Company Associations
Quotes Contacts Associations
Quotes Deals Associations
Quotes Line Items Associations
Subscriptions
Subscriptions Deals Associations
Teams
Tickets
Tickets Company Associations
Tickets Contacts Associations
Tickets Deals Associations
Tickets Engagements Associations
Tickets Tickets Associations
Tickets Subscriptions Associations
Tickets Payments Associations
Tickets Pipeline
Users
Workflows
Website Pages
Company Leads Associations
Contacts Leads Associations
Deals Leads Associations
Deleted
Deals Stage History
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