BigQuery Marketing Data Warehouse

Obtain instant access to complete tracking and first-party data without ugly ETL processes

BigQuery is a serverless data warehouse in which you can store data to get greater insight and analysis on your company and its performance. It facilitates easier analysis for large amounts of data, that otherwise would be very difficult to sort through and understand.

Able CDP provides a quick way to connect conversions with website tracking and attribution and send marketing data to BigQuery for storage and analysis. Able automatically transforms information about customer interactions from other platforms to a unified data schema, combining it with website visitor details, making it easier for you to see all your business's marketing data and reports in one place. All of this without coding and complex manual set-up — Able already knows how to transform marketing data from disparate sources to a common format ready for analysis, making building a marketing data warehouse with BigQuery easier than ever.

Understand What Drives Sales

See what marketing campaings convert to leads and paying customers

Able Customer Data Platform builds a 360-degree view of each customer by tracking website visitors before they become customers. Able then begins to build a customer profile by tracking all website activity and, most importantly, lead and signup form submissions, as well as recording personal information such as e-mail, phone, and proprietary customer identifiers. This allows Able Customer Data Platform to associate each paying customer with the original customer source, implement first-touch attribution and understand what marketing activity brought each customer and each dollar of revenue. By sending all of this information to BigQuery's data warehouse, you will be able to better analyse it and adjust your strategy to make sure you are investing in marketing that will bring you the most revenue.

Understand What Drives Sales

Send Revenue Data To Reporting Tools

Optimize your marketing strategy

Able CDP is capable of using its customer tracking data to attribute all subsequent revenue (Purchases) to the source. Source of each customer is tracked when a sign up form is completed. Revenue can then be sent to Able CDP using a Stripe webhook. Able CDP then attributes each Purchase event to the original visitor and sends Purchase events to all standard integrations such as Google Analytics, Facebook Ads Conversions API, Google Ads API etc. It allows to leverage reporting capabilities of the reporting tools you're already using. Correct first-touch attribution as implemented by Able allows to capture of up to 24 months of LTV data attributed to the original campaign inside Google Analytics.

Send Revenue Data To Reporting Tools

How does it work?

Build an entire journey of each customer from the first ad click

Attribute 99% of your sales

Connect BigQuery with other software without coding

Able CDP is a low-cost solution that combines browser tracking with server-side API integrations, linking BigQuery to other platforms such as Chargebee and Stripe to ensure all data about your company's marketing performance as well as website and clicks is sent to BigQuery.

In BigQuery's data warehouse, see how all purchases are attributed to the website visitors signing up using forms to understand sources of sales and calculate complete LTV. Attributed conversions are sent to reporting and conversion APIs throughout entire customer lifecycle. Sending all of this data directly to BigQuery will strongly aid your analysis of your strategy.

Skip complex manual set-up of the connection between BigQuery and other software in your funnel. Able automatically merges data from website tracking and multiple marketing integrations into a common schema, simplifying building a data warehouse.

Read how Able CDP works in our docs

Able Customer Data Platform is easy to set up

1

Sign up for a free trial account, install tracking code on the website and connect external data sources.

2

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.

3

After connection, Able will create a new BigQuery dataset named according to the selected funnel UUID and will start sending populating it with marketing data in real-time.

4

Use the data automatically converted into an easy-to-use schema to build reports in BI applications such as in Google Data Studio and Google Sheets.

Sample Integration Scenarios

Resources

“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