Contents:

  • Why do Chargebee and BigQuery Need to Be Connected?
  • A Complete Solution for Integrating Chargebee and BigQuery
  • How Able CDP Integrates Chargebee and BigQuery
  • 4 Steps to Connect Chargebee with BigQuery by Using Able CDP

Connect Chargebee and BigQuery

Why do Chargebee and BigQuery Need to Be Connected?

Chargebee is a subscription payment processing SaaS platform, which is processed using Stripe.  BigQuery is a serverless data storage platform that helps businesses manage and analyze their data. Both offer a rich set of data, but connecting Chargebee to BigQuery and creating a custom dashboard with a complete data set can be tricky.

Chargebee customer data without proper first-party attribution doesn’t allow you to leverage the reporting capabilities of other tools you may be using, such as BigQuery.

Combining browser and server-side tracking to report conversions via the server-to-server integration solves these problems.

A Complete Solution for Integrating Chargebee and BigQuery

Able Customer Data Platform is the ultimate Chargebee and BigQuery integration.

It introduces first-party tracking and first-touch attribution based on the concept of a CustomerCustomer associates Events that happen on website, in CRM or offline by associating these Events using Customer KeysCustomer Keys are Customer attributes that uniquely identify a customer across events and devices. The most common ones are email and phone.

It combines browser tracking with server API integrations, sending website activity with purchases to BigQuery for management and analysis.

Connect Able to Google BigQuery to obtain full access to raw tracking data and use them to build reports in BI applications such as in Google Data Studio and Google Sheets.

All of this happens in Able Customer Data Platform automatically, provided Able is used to send Chargebee data to BigQuery.

How Able CDP Integrates Chargebee and BigQuery

Able makes it easy to consolidate all Chargebee user data in BigQuery. It allows you to report on actual Stripe revenue rather than conversions to leads, attributing all subsequent Chargebee revenue to the original visitor and campaign — even if it occurs weeks after the initial visit.

Able tracks Chargebee subscriptions and payments by processing web hooks from Stripe (the payment processor) and attributing them to the original visitor, which Able sends information on to BigQuery.

Able CDP combines browser and back-end tracking to:

  1. store user click id, including the original ad click id, when available, as well as browser id.
  2. send conversion data from Chargebee to BigQuery with additional customer match parameters.
  3. send Advanced Match Parameters. Customer email, phone, name and address when a click id parameter isn't available or is inconclusive

4 Steps to Connect Chargebee with BigQuery by Using Able CDP

Step 1. Sign up for a free account

Complete the sign up form to get instant access to your Able trial account for free.

Step 2. Install Able tracking code on the website

Add following code to the website to track website events:

<script type="text/javascript" src="https://app.ablecdp.com/ue.js"></script>
<script>
window.addEventListener('DOMContentLoaded', function () {
uipe('init', '%%FUNNEL_MARK%%')
uipe('track', 'PageView')
})
</script>

Where %%FUNNEL_MARK%% is the unique code of your Able CDP Funnel.

Able CDP page view tracking doesn't install its own cookies and relies on third-party identifiers such as Facebook Click id to connect customer activity between website pages.

Step 3. Connect Able to Stripe

Able Customer Data Platform attributes Chargebee payments (processed using Stripe) to the original marketing source.

To send Purchase events from Stripe to Able:

  1. Open Stripe Webhook Dashboard
  2. Add Webhook Endpoint https://app.ablecdp.com/api/properties/%%PROPERTY_ID%%/webhooks/stripe (where %%PROPERTY_ID%% is the id of your Able CDP Funnel) and enable the 'invoice.paid' event

Able CDP will now receive webhooks from Stripe, automatically attributing Purchases to Visitors by customer emails and phones and sending Purchase conversions with detailed Invoice Lines where supported.

To send Stripe payments from Stripe to Able:

In addition to tracking Stripe invoice payments, Able supports tracking of Stripe payments. The set up is almost identical to tracking paid invoices, except the event name set in Stripe webhook settings should be 'payment_intent.succeeded' instead of 'invoice.paid'.

Step 4. Connect Able to BigQuery

To connect, open Able Dashboard, open "BigQuery" tab and follow the steps to connect Able to your Google Cloud account and choose Google Cloud project to create a database for syncing the data to.

After connection, Able will create a new BigQuery dataset named according to the selected funnel UUID. The dataset will conform to the following schema.

  • Visitors belong to the Funnel. Each Visitor represents a single unique customer. In Able BigQuery connector each dataset has data for a single funnel and this relationship is effectively unused.
  • Visitor Keys belong the Visitors. Visitor keys are unique identifiers used to identify a customer and link customer activity (Events) across platforms.
  • Events are events that happen to a Visitor. PageViews and Purchases are examples of the supported events.

See more on the BigQuery Connector page.

Learn More

Read more about Able CDP tracking and attribution engine and how it utilizes a customer journey database to correctly attribute all purchases to the original visitors.

E-Commerce Conversion Funnel Tracking
Able CDP helps to track modern multiple step e-commerce funnels where customers interact with multiple services prior to eventually making a purchase, resolving issues with incorrect Google Analytics attribution and conversions missing from Google Ads and Facebook Ads reports.

Send Purchases to Google Ads

Sending conversions to Google Ads is an extremely common integration scenario. Its used to add conversion value to Google Ads’ reports, allowing to report on ROI, as well as to use performance-based targeting and optimization capabilities.

Send Purchases to Facebook Conversions API

Attributing conversions to Facebook Ads is a common task, however doing it with sufficient precision is hard. Sales might happen in CRM, or, when they happen online, customer might not come back to the website, so tracking with Facebook Pixel JS produces substandard results. Able solves this problem with its Facebook Conversions API integration.

BigQuery
+
Chargebee
Start integrating Chargebee and BigQuery right now
“A valuable insight we've got because of using Able Customer Data Platform is that display ads aren't working for us at all... we've been wasting money for years on paid display ads.

Before Able we'd be excited about every lead or email that came through, but after the last year we've determined that those don't convert at all.

And so we've been focusing on paid search, which does have return on investment.”

— Bryan Brinton, Co-Founder, Aluvii Software

Contact us for more help if you didn't find what you were looking for

📈

Achieve results

Continuously improve marketing strategy with actionable data produced by Able tracking.

Drive sales

Understand how your customers buy and how segments perform across campaigns even on low volume experimental conversion data when you're still perfecting your pipeline.

Boost ad ROI

Stream back-end conversion data to Google Ads and Facebook Ads Conversion APIs to facilitate ad platforms' AI/ML ad delivery optimization and to create super effective lookalike audiences in real time.

Analyze

Use standard tools such as Facebook Ads, Google Analytics and CRM reports to see exact performance and revenue of each channel and landing page even when sales happen weeks after the initial ad click.