Why do Stripe and BigQuery Need to Be Connected?
Stripe is a powerful payment processing SaaS platform. BigQuery is a data warehouse that helps businesses manage and analyze their data. Both offer a rich set of data, but connecting Stripe to BigQuery in a way that provides precise attributed data conversions can be tricky.
Stripe customer data without proper first-party attribution doesn’t allow you to leverage the reporting capabilities of other reporting tools you may be using alongside BigQuery Data Warehouse. It is impossible to accurately measure growth of monthly recurring revenue by channel without attributing sales to original marketing sources.
Combining browser and server-side tracking data allows to populate BigQuery with Stripe payments, subscriptions and other conversion events - each attributed to the original customer source.
A Complete Solution for Integrating Stripe and BigQuery
Able Customer Data Platform is the ultimate Stripe and BigQuery integration.
It combines browser tracking with server API integrations, sending website activity and purchases to BigQuery for management and analysis.
Able introduces an easy to use data schema that combines first-party tracking and first-touch attribution based on the concept of a Customer. Customer associates Events that happen on website and in Stripe 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.
All of this happens in Able CDP automatically, by using Able's own website and form tracking data and Stripe webhooks.
Connect Able to Google BigQuery to obtain access to all Stripe sales enriched with customer sources in real-time and use them to build reports in BI applications such as in Looker Studio (formerly Google Data Studio) and Google Sheets.
How Able CDP Integrates Stripe and BigQuery
Able makes it easy to feed all Stripe conversion data into BigQuery in real-time. It allows you to report on actual Stripe revenue rather than conversions to leads, attributing all subsequent Stripe revenue to the original visitor and campaign — even if it occurs weeks after the initial visit.
Able tracks Stripe subscriptions and payments by processing web hooks from Stripe and attributing them to the original visitor on Stripe tracked by Able, which Able sends information to BigQuery.
Able CDP combines browser and back-end tracking to:
4 Steps to Connect Stripe with BigQuery by Using Able CDP
Complete the sign up form to get instant access to your Able trial account for free.
After signing up for a free account, Able CDP will prompt you to add code to your website. The tracking code is necessary to allow Able to link further Stripe conversions with the original visitor and TikTok click Id.
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.
Click "Add Service Integration" on the "Funnel" tab and choose Stripe.
Follow the instructions displayed. They will differ depending on the type of Stripe payments you are using. The conversion event that needs to be tracked depends on whether you're using Stripe Subscriptions (and, correspondingly, generate Stripe Invoices for each payment) or just the Checkout alone.
Open Stripe Dashboard, and add a webhook endpoint, following the instructions displayed in Able.
Able CDP will now receive webhooks from Stripe, automatically attributing Purchases to Customers by customer emails and phones.
In addition to tracking Stripe invoice payments, Able supports tracking of Stripe one-off 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'. There are additional capabilities to track the start and cancellation of subscriptions as well as refunds.
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.
“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.