{"product_id":"postgres-mixpanel-churn-risk-scoring-n8n-workflow","title":"Postgres + Mixpanel Churn Risk Scoring n8n Workflow","description":"\u003ch3\u003eTurn customer signals into automated churn-risk alerts (every 6 hours)\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003ePostgres + Mixpanel churn risk scoring n8n workflow\u003c\/strong\u003e merges product usage, NPS responses, Mixpanel engagement, and Zendesk ticket signals—then calculates a churn risk level and triggers Customer Success interventions automatically through \u003cstrong\u003eGmail, Calendly, ClickUp, Slack\u003c\/strong\u003e, and a \u003cstrong\u003ePostgres intervention log\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e every 6 hours using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls data from Postgres\u003c\/strong\u003e for recent product usage and last-login information, plus recent \u003cstrong\u003eNPS\u003c\/strong\u003e responses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches engagement from Mixpanel\u003c\/strong\u003e (via Mixpanel API) to incorporate customer interaction signals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetrieves recent tickets from Zendesk\u003c\/strong\u003e to detect support-related churn risk indicators.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges all sources\u003c\/strong\u003e into a single per-customer record keyed by \u003cstrong\u003ecustomer_id\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a composite churn score\u003c\/strong\u003e and categorizes it as \u003cstrong\u003elow \/ medium \/ high\u003c\/strong\u003e using factors including login recency, feature usage change, seat utilization, NPS score, and ticket signals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips low-risk customers\u003c\/strong\u003e under your churn-risk threshold, and routes at-risk customers into intervention steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a personalized check-in email via Gmail\u003c\/strong\u003e for churn-risk customers. For \u003cstrong\u003ehigh-risk\u003c\/strong\u003e customers, it also:\n    \u003cul\u003e\n      \u003cli\u003eCreates a \u003cstrong\u003eCalendly\u003c\/strong\u003e scheduled event\u003c\/li\u003e\n      \u003cli\u003eOpens a follow-up task in \u003cstrong\u003eClickUp\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ePosts an escalation message to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs intervention details back to Postgres\u003c\/strong\u003e in a churn intervention log table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDetect churn risk when customers stop logging in or show negative engagement trends in \u003cstrong\u003eMixpanel\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSpot customers with poor \u003cstrong\u003eNPS\u003c\/strong\u003e scores and rising Zendesk ticket activity—then trigger CS outreach.\u003c\/li\u003e\n  \u003cli\u003eGive Customer Success teams consistent, automated follow-ups with Gmail + Calendly + ClickUp, and real-time Slack escalation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/blocks:\u003c\/strong\u003e if, code, merge, gmail, slack, click up, plus integrations for \u003cstrong\u003ePostgres\u003c\/strong\u003e, \u003cstrong\u003eMixpanel\u003c\/strong\u003e, and \u003cstrong\u003eZendesk\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e add Postgres credentials and update SQL query\/table\/column names for usage snapshots, NPS responses, and the churn_intervention_log insert; add Mixpanel API credentials and set \u003cstrong\u003eYOUR_MIXPANEL_PROJECT_ID\u003c\/strong\u003e; add Zendesk credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072078893235,"sku":"N8N-19796","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2YQ-6creuqPJrLlasg6fQ_gO36GYWR.png?v=1790068111","url":"https:\/\/buyflowscripts.com\/products\/postgres-mixpanel-churn-risk-scoring-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}