Customer Churn Rate
SQL query for Salesforce
Calculate the customer churn rate.
SELECT COUNT(DISTINCT customer_id) AS total_customers, COUNT(DISTINCT CASE WHEN last_purchase_date < DATE_SUB(NOW(), INTERVAL 30 DAY) THEN customer_id END) AS churned_customers, (COUNT(DISTINCT CASE WHEN last_purchase_date < DATE_SUB(NOW(), INTERVAL 30 DAY) THEN customer_id END) / COUNT(DISTINCT customer_id)) * 100 AS churn_rate FROM tables
Salesforce data model
Objects
Account
Account Feed
Agent Work
App Menu Item
Appointment Category
Asset
Business Brand
Buyer Group
Campaign
Case
Customer
Contact
Contract
Document
Dashboard
Folder
Group
Invoice
Inventory Reservation
Lead
Opportunity
Order
Participant
Partner
Payment
Product
Refund
Report
Return Order
Sales Store
Seller
Service Contract
Site
Skill
Solution
Task
Waitlist Participant
Work Order Line Item
Work Step History
Web Store
Work Order
Email Message
Event
Order History
Order Item History
User
User License
User Role
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