Outbound sales that runs on your data.

-- Which campaign generated the most CRM-qualified pipeline this quarter?
SELECT campaign_name, product_line, COUNT(*) AS crm_handoffs
FROM MART.OUTBOUND_CAMPAIGN_ATTRIBUTION
WHERE crm_handoff_date >= DATEADD('quarter', -1, CURRENT_DATE())
GROUP BY 1, 2
ORDER BY 3 DESC;

-- Which industries have the highest reply rate across all campaigns?
SELECT p.industry_de, AVG(reply_rate) AS avg_reply_rate
FROM MART.CAMPAIGN_SEND_EVENTS s
JOIN PSA.PROSPECT_PROFILES_CURRENT p USING (prospect_id)
GROUP BY 1 ORDER BY 2 DESC;

-- Who is returning from OOO this week?
SELECT first_name, last_name, company, ooo_return_date, campaign_name
FROM MART.CAMPAIGN_REPLY_EVENTS
WHERE reply_classification = 'out_of_office'
  AND ooo_return_date BETWEEN CURRENT_DATE() AND DATEADD('day', 7, CURRENT_DATE());