Connect Churn Buster to Your Data Warehouse

Churn Buster can send real-time event data to your data warehouse — Snowflake, BigQuery, Redshift, Databricks, or any other destination. This lets you analyze dunning and cancel flow performance alongside all your other business data using SQL, your BI tools, or dbt.

Any tool that accepts incoming webhooks can serve as the pipeline. This guide walks through setup using Fivetran, though the process is similar for Airbyte, Segment, Census, Hightouch, or a custom webhook handler.

Why Connect Your Warehouse?

‍Centralized analytics — Combine Churn Buster data with your CRM, payment processor, and marketing tools for a complete picture of customer behavior‍
No code required — Set up once in minutes, then data flows automatically‍
BI-tool ready — Query with SQL or plug into Looker, Tableau, Mode, Metabase, or whatever your team already uses‍
Enterprise-grade reliability — Automated syncing, error handling, and data quality monitoring built in

What Data Gets Synced?

Churn Buster sends events to your warehouse in real time as dunning and cancel flow activity occurs. Here are examples of available event types:

‍campaign_started — A dunning campaign begins for a failed payment‍
campaign_won — Payment recovered, customer back in good standing‍
campaign_lost — Payment not recovered, customer churned‍
cancel_session_won — Customer retained through a cancel flow‍
cancel_session_lost — Customer completed cancellation‍
email_bounced — Email delivery failed

You can choose to sync all event types or only the ones relevant to your analysis.

Setup Instructions (Fivetran)

Step 1 — Create a Webhooks Connector in Fivetran

In your Fivetran dashboard:

Click + Connector in the top navigation
Search for and select Webhooks‍
Configure the connector:‍
- Destination schema: churn_buster (or your preferred name)‍
- Destination table: events (or your preferred name)‍
- Sync format: Unpacked (recommended for easier querying)
Copy the Webhook URL that Fivetran generates — it will look like: https://webhooks.fivetran.com/v1/webhook/YOUR_UNIQUE_ID
Click Save and Test

Step 2 — Add the Webhook in Churn Buster

In your Churn Buster account:

Go to Settings → Integrations → Webhooks‍
Add a webhook subscription
Configure the subscription:‍
- Webhook URL: Paste the Fivetran webhook URL from Step 1
- Select which event type to sync (we recommend subscribing to all)
Optionally, review the sample payloads on the same page to understand the data structure for each event type
Click Save — events will immediately start flowing to Fivetran

Step 3 — Verify Data Is Flowing

Back in your Fivetran dashboard:

Confirm the connector status shows Connected with a green indicator
Wait 2–3 minutes for the initial sync to complete
Run a quick query in your warehouse to confirm data is arriving:

SELECT
  event_type,
  COUNT(*) AS event_count
FROM churn_buster.events
GROUP BY event_type
ORDER BY event_count DESC;

If you see results, you're all set. Events will continuously sync going forward.

Quick verification checklist:

Fivetran connector shows "Connected" status
Webhook subscription has been created in Churn Buster
Data is visible in your warehouse via a SELECT query
The event_type field contains expected values

What You Can Do Next

Once data is flowing, you can:

Build dashboards in your BI tool to track recovery rates and cancel flow performance
Write SQL queries to analyze customer behavior and campaign effectiveness
Create dbt models to transform and aggregate Churn Buster events
Join with data from your payment processor, CRM, or other sources for deeper analysis

See the Webhook Data Reference for complete schema documentation, SQL query examples, and dbt model templates.

Troubleshooting

Events not appearing in your warehouse?

Verify the webhook subscription is active in Churn Buster settings‍
Check that the Fivetran connector status is "Connected" (not "Paused" or "Error")
Make sure events are actually occurring — e.g., you can trigger a test campaign to confirm
Check Fivetran's sync logs for error messages

Data structure looks different than expected?

Fivetran's Unpacked format automatically flattens nested JSON into columns — this is the recommended setting
If you chose Packed format, you'll need to parse JSON manually in your SQL queries
Review the sample payloads in Churn Buster webhook settings to understand the raw structure

Historical data not showing?

Webhook-based connectors only capture events from the moment of connection forward — historical data is not backfilled automatically
Historical data is available via CSV export in your Churn Buster account

Using a Different Data Pipeline Tool?

This integration works with any platform that supports incoming webhooks. The setup process is the same: get a webhook URL from your tool, add it as a subscription in Churn Buster, and data flows automatically.

Common alternatives to Fivetran include Airbyte, Segment, Census, Hightouch, and custom webhook handlers.

Need Help?

‍View sample payloads: Visit your Webhook Integration settings in Churn Buster‍
Technical docs: See the Webhook Data Reference for complete schema details

‍