Customer targeting

Churn scoring

Know which customers are ready to churn while there's still time to save them — using ClickHouse

You will need a Faraday account to use this template. It is free to sign up and you will just need some sample data to start.

Get started for free

Sure thing. If you're a Faraday user and also a fan of ClickHouse, integrating churn scoring predictions into your analytics setup could be a smart move. Imagine being able to rapidly analyze which of your customers might be slipping away, all within the same lightning-fast database you're already using. This can help you act quickly and effectively, making your customer retention efforts more seamless. By keeping everything in one place, you can focus on understanding and addressing the needs of your at-risk customers without bouncing between platforms. It's a straightforward way to enhance your customer insights right where you need them.

Step 1
Connect your data sources
Use the link below to connect ClickHouse to Faraday. You can also skip this step and use CSV files to get started instead.
ClickHouse
Step 2
Ingest your data into event streams
This allows Faraday to understand what your data means. These links will guide you through ingesting the data necessary to power this template.
Transaction Cancellation
Step 3
Organize your customer data
You'll create groups, called cohorts, that are the essential building blocks of Faraday and allow you to easily predict any customer behavior.
Customers Churned customers
Step 4
Declare your prediction objectives
With your cohorts defined, it's easy to instruct Faraday to predict the necessary behaviors. Follow the docs with the link below.
Likelihood to churn
Step 5
Define your churn scoring pipeline and deploy to ClickHouse
Finally, deploy your prediction with the link below.
Churn scoring
Step 6
Deploy to ClickHouse
Create a deployment target using the ClickHouse connection you created above. Or, get started by simply deploying to CSV.
ClickHouse