Connect Chargebee and Looker Studio (formerly Google Data Studio)

Chargebee is a subscription payment processing SaaS platform.  Looker Studio helps businesses convert raw data into informative reports on the business's growth by marketing channel. Both offer a rich set of data, but connecting Chargebee to DataStudio and ensuring complete data is sent to create the reports 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 Looker Studio.

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

Able Customer Data Platform is the ultimate Chargebee and Looker Studio integration.

It introduces first-party tracking and first-touch attribution based on the concept of a Customer. Customer associates Events that happen on website, in CRM or offline by associating these Events using Customer Keys. Customer 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 Looker Studio for management and analysis to be turned into marketing reports.

You can 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.

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

Able makes it easy to consolidate all Chargebee user data in Looker Studio. It allows you to report on actual Stripe revenue rather than conversions to leads, attributing all subsequent Chargebee revenue to the original source 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, which you can then forward on to Looker Studio.

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 Looker Studio 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‍
   

‍Step 1. Sign up for a free Able trial account

Complete the sign up form to create a trial account.

Step 2. Install Able tracking code on the website

After signing up for a free account, Able CDP will prompt you to add code to your website.

This tracking code will record ad click ids and details of the original landing page visit, as well as lead form submissions, allowing to attribute customers to website visitors. Able CDP uses its tracking to capture UTM parameters, referrer URL and landing page URL, store them in its own attribution database together with the personal identifiers such as email or phone, entered by customer in lead and order forms, allowing it to associate all future customer activity with the original website visitor source.

Add lead form URLs to the HTML Forms Tracking section to let Able automatically recognize the sign-up and lead forms you're using. Any standard lead form widgets that we could detect during the account setup will appear in the Dynamic Lead Forms Tracking section.

Press "Generate" in the Get Code section to generate a unique tracking code to add to your site.

Able CDP page view tracking doesn't install its own cookies and relies on third-party identifiers such as Google Analytics Client Id to connect customer activity between website pages. Please enable cross-domain measurement in Google Analytics if your landing and lead/order pages are hosted on different domains.

Step 3. In the Funnel tab, click add service integration to select which platforms you want to integrate with

‍Step 4. Connect Able to Chargebee

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/10/webhooks/stripe (where 10 is the id of your Able CDP Funnel) and enable the 'payment_intent.succeeded' event

Able CDP will now receive webhooks from Stripe, automatically attributing Purchases by customer emails and phones and sending Purchase conversions with payment amounts.

If you need to recognize conversion during user actions (for example, immediately after a service is consumed, rather than when its successfully billed), consider a direct integration with Able REST API.

Step 5. Connect Able to BigQuery, and link Looker Studio (formerly Data Studio)

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.

To then link to Looker Studio:

1. Sign in to Looker Studio.
2. In the top left, click. then select Data Source.
3. Select the BigQuery connector. The Configuration panel appears.
4. Select PUBLIC DATASETS.
5. For the Dataset, select samples.
6. For the Table, select shakespeare.
7. Select your Billing Project.
8. Click CONNECT. The Fields panel appears.

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.