‍What Is Fivetran?

Fivetran is an automated data pipeline platform that syncs data from business applications into your data warehouse (Snowflake, BigQuery, Redshift, Databricks, etc.). This integration allows you to analyze Churn Buster events alongside all your other business data in one centralized location.

Why Use a Data Warehouse Integration?

Centralized Analytics — Combine Churn Buster data with your CRM, payment processor, and marketing tools for complete customer insights

‍No Code Required — Set up once in minutes, data flows automatically in real-time

‍BI Tool Ready — Query data with SQL, Looker, Tableau, dbt, or any analytics tool your team already uses

‍Enterprise-Grade — Automated syncing, error handling, and data quality monitoring built-in

What Data Gets Synced?

Churn Buster sends real-time events to your data warehouse whenever key dunning or cancel flow events occur:

‍Setup Instructions

Step 1: Set Up Fivetran Webhooks Connector In your Fivetran dashboard:

1. Click + Connector in the top navigation
2. Search for and select Webhooks
3. Configure the connector settings:
   
   • Destination schema: churn_buster (or your preferred name)
   • ‍Destination table: events (or your preferred name)‍
   • Sync format: Choose Unpacked (recommended for easier querying)

4. Copy the Webhook URL that Fivetran provides — it will look like: https://webhooks.fivetran.com/v1/webhook/YOUR_UNIQUE_ID‍
5. Click Save & Test

Step 2: Configure Churn Buster Webhooks In your Churn Buster account:

1. Navigate to Settings → Integrations → Webhooks
2. Click "Add Webhook Subscription"‍
3. Configure your webhook:‍
   
   1. Webhook URL: Paste your Fivetran webhook URL‍
   2. Event Type: Select which events to sync (we recommend all 6 event types)‍
   3. Mode: Choose Live (production data) or Test (test data)‍
4. Review Sample Payloads: On the same page, you can view example payloads for each event type to understand the data structure
5. Click Save — events will immediately start flowing to Fivetran

Step 3: Verify Data Flow

Back in your Fivetran dashboard:

1. Check the connector status — you should see "Connected" with a green indicator
2. Wait 2-3 minutes for initial sync to complete
3. Query your data warehouse to verify data arrival:

SELECT   event_type,  COUNT(*) AS event_countFROM churn_buster.eventsGROUP BY event_typeORDER BY event_count DESC;

If you see results, you're all set! Events will now continuously sync to your warehouse.

Quick Verification Checklist

What's Next?

Now that your data is flowing, you can:

• Build dashboards in your BI tool (Looker, Tableau, Mode, Metabase)
• Write SQL queries to analyze recovery rates, win rates, and customer behavior
• Create dbt models to transform and aggregate Churn Buster data
• Join with other data sources like your payment processor, CRM, or customer data

Troubleshooting

Events not appearing in warehouse?

• Verify webhook subscription shows as "active" in Churn Buster settings
• Check that Fivetran connector status is "Connected" (not "Paused" or "Error")
• Ensure events are actually occurring — you can test by creating a test campaign
• Check Fivetran's sync logs for any error messages

Data structure looks different than expected?

• Fivetran's "Unpacked" format automatically flattens nested JSON
• If using "Packed" format, you'll need to parse JSON manually in SQL
• Review sample payloads in Churn Buster webhook settings to understand structure

Historical data not showing up?

• Fivetran's webhook connector only captures events from connection time forward
• Historical data is not automatically backfilled
• Contact Churn Buster support if you need historical data exports

Important Notes

Need Help?

• View sample payloads: Visit your Webhook Integration settings
• Technical documentation: See the Webhook Data Reference for complete schema details
• Contact support: Email support@churnbuster.io with any questions

Other Data Warehouse Tools

This integration approach works with any tool that supports webhook ingestion, including:

• Airbyte (open-source alternative to Fivetran)
• Segment (customer data platform)
• Census (reverse ETL platform)
• Hightouch (data activation platform)
• Custom webhook handlers (build your own integration)

The setup process is similar — get a webhook URL from your tool, add it to Churn Buster, and data will flow automatically.