Customer.io connector

Use your Customer.io data for reporting, automation and AI.

Data Panda brings your Customer.io data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
Customer.io logo
About Customer.io

Where your product event becomes a message.

Customer.io was founded in 2012 by Colin Nederkoorn as a messaging platform wired to product events rather than to a marketing list. It has grown into a full customer engagement stack with Journeys for orchestration, Audiences for behavioural segmentation, Data Pipelines for CDP-style event collection, and channels across email, SMS, push and in-app. The company reports over seven thousand four hundred brands using it, with Notion, Buffer, Attio and IMAX among the named customers, skewing heavily to SaaS and product-led teams.

The reason to pull Customer.io into a warehouse is that it reports on the send and not on what the send caused. Journey conversion inside the tool stops at the click or the in-app tap. Activation twenty-eight days later, paid conversion after the trial, retention in month three, and the subscription that renewed all live outside Customer.io by design. Next to Stripe charges, product usage and support tickets, the same Customer.io journey gets one honest number: how many of the users it touched became paying customers who stayed.

What your Customer.io data is for

What you get once Customer.io is connected.

Reporting that follows the user

Journey activity, campaign sends and customer events on one timeline, tied to paid conversion and retention.

  • Paid-conversion rate per journey, per segment, per cohort
  • Activation rate within twenty-eight days of a triggered message
  • Channel mix (email vs SMS vs push vs in-app) per stage of the lifecycle

Event-driven automation

Let Customer.io fire on signals the rest of the stack already produced.

  • Stripe subscription state drives churn-save and dunning journeys
  • HubSpot or Salesforce pipeline stage rewrites audience membership
  • Open support tickets mute non-essential journeys until the case is resolved

AI workflows

Turn Customer.io history into scoring that reshapes the next journey before it starts.

  • Activation-likelihood scoring per trial user at day three
  • Next-best-channel scoring across email, SMS, push and in-app
  • Churn-risk scoring layered onto paying customers with dropping usage

Custom apps on your data

Internal tools on Customer.io data for teams that do not live in the Customer.io UI.

  • Activation cockpit with journey impact per product cohort
  • Journey-ROI board with paid revenue per triggered send
  • Customer-success lookup with full journey and event history
Use cases

Use cases we deliver with Customer.io data.

A list of concrete reports, automations and AI features we have built on Customer.io data. Pick the one that matches your situation.

Trial-to-paid per journeyPaid conversion attributed to the journey that nudged the trial.
Activation within 28 daysUsers hitting the activation event per triggered message.
Channel mix by lifecycleEmail, SMS, push and in-app share per lifecycle stage.
Journey-to-retentionMonth-three and month-six retention per first-touched journey.
Dunning recoveryFailed-payment recoveries attributed to the Customer.io dunning journey.
Segment driftWhich audience segments are quietly becoming inactive.
In-app vs emailConversion lift of an in-app message against the same message by email.
Message fatigueUsers receiving three or more journeys in a seven-day window.
Event-coverage auditWhich product events are pushed to Customer.io and which are missing.
Multi-workspace consolidationOne picture across several Customer.io workspaces or brands.
Real business questions

Answers you will finally get.

Which journey turns trials into paying customers?

Trial-to-paid conversion per Customer.io journey, thirty days after first touch, with the send cost and design time beside it. Separates the journey that opens well and converts poorly from the journey that nobody opens and yet quietly produces renewals, which is the split that decides where the next iteration of copy is worth spending.

Is in-app pulling its weight next to email?

Conversion lift on the same message delivered as an in-app nudge against the same message delivered by email, per segment. Shows the cohorts where in-app earns the engineering cost of instrumenting the event and the cohorts where email alone would have produced the same result.

Are we burning users on three journeys in the same week?

Cross-journey fatigue report showing users that entered three or more journeys inside a seven-day window, with the unsubscribe and in-app-dismiss rate for that overlap group. The fix is suppression rules and journey priority, not louder copy, and the fatigue rarely shows up in a single journey's own report.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Journey cost, channel fees (SMS, push) and platform spend against paid conversion and retained revenue per cohort. The messaging budget stops being defended on opens and starts being defended on subscriptions that renewed in month three.

For sales leaders

Trial accounts with their full Customer.io journey history on the profile before the AE picks up the phone. The outbound rep sees which activation emails the prospect ignored and which in-app nudge they engaged with, instead of guessing from a CRM timestamp.

For operations

Event-coverage audit, suppression rules and cross-journey fatigue over twelve months. The fragile product-event that half the journeys depend on stops being rediscovered the week it stops firing, and instead shows up as a trend on an operations dashboard.

Ideas

What you can automate with Customer.io.

Pair with Stripe

Let Stripe subscription state drive Customer.io journeys

Stripe subscription starts, upgrades, downgrades, failed payments and cancellations push into Customer.io as events on the customer profile. The dunning journey fires the hour Stripe retries the charge, churn-save journeys trigger on the cancel itself, and the loyalty journey pauses for a customer whose last payment failed.

Pair with HubSpot

Sync HubSpot pipeline stage with Customer.io audiences

HubSpot lifecycle stage, deal stage and owner push into Customer.io as user attributes and audience membership. Sales signals rewrite the audience a user sits in, so a trial that just moved to a sales-qualified opportunity stops getting the self-serve onboarding journey and starts getting the enterprise sequence.

Pair with Intercom

Mute Customer.io journeys during open Intercom cases

Users with an open severity-one Intercom case are suppressed from non-essential Customer.io journeys until the case is resolved. Marketing does not send an upsell nudge to a customer who is actively waiting on an apology, and the support conversation does not fight a cheerful onboarding email in the same inbox.

Pair with Google Analytics GA4

Route GA4 behavioural audiences into Customer.io segments

GA4 audiences defined on on-site behaviour, feature-page visits and funnel drop-off push into Customer.io as user attributes and audience membership. The winback journey can target users who looked at the pricing page three times without starting a trial, a signal that Customer.io's own event stream usually does not see on its own.

Data model

Tables we make available.

These are the 24 tables we currently pull from Customer.io into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Activities
  • Broadcast Actions
  • Broadcast Metrics
  • Broadcast Triggers
  • Broadcasts
  • Campaign Actions
  • Campaign Metrics
  • Campaigns
  • Collections
  • Customer Attributes
  • Customers
  • Exports
  • Messages
  • Newsletter Metrics
  • Newsletter Variants
  • Newsletters
  • Object Types
  • Reporting Webhooks
  • Segment Membership
  • Segments
  • Sender Identities
  • Snippets
  • Subscription Topics
  • Transactional Messages

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Customer.io data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Customer.io to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Customer.io connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Does the sync support multiple Customer.io workspaces or brands?

Yes. Each workspace lands in its own schema, with a shared user and event dimension on top. Holding groups and multi-brand setups get isolation per brand and a deduped user view at group level, without merging audiences by hand in the Customer.io UI.

How are custom events and attributes handled when they change?

Event types and user attributes land in the warehouse as they arrive. New ones appear as new columns or tables on the next run. Renamed or retired attributes are tracked as slowly-changing dimensions, so a journey report from six months ago stays readable when an admin retitles the attribute it depends on.

Does this replace the Customer.io Data Pipelines CDP?

No. Data Pipelines keeps routing events into Customer.io and onwards to other destinations in real time. The warehouse sync sits next to it, pulling the modelled result: Journeys, segments, campaign statistics, profile attributes and message events, so reporting has the full history without replaying the event stream.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Customer.io setup and the systems around it. Together we pick the first thing worth building.