Why do Chargebee and Looker Studio Need to Be Connected?
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.
A Complete Solution for Integrating Chargebee and Looker Studio
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.
How Able CDP Integrates Chargebee and 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:
5 Steps to Connect Chargebee with Looker Studio by Using Able CDP
Complete the sign up form to create a trial account.
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.
Able Customer Data Platform attributes Chargebee payments (processed using Stripe) to the original marketing source.
To send Purchase events from Stripe to Able:
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.
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.
See more on the BigQuery Connector page.
To then link to Looker Studio:
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.
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.
“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
Continuously improve marketing strategy with actionable data produced by Able tracking.