BigQuery (Google Cloud) Quick-Start Guide
Start sending Confection data to BigQuery (Google Cloud) with a few simple steps.
Issues? Questions? Feedback? Leave a comment. Already have a Confection account? Already installed Confection on your site or app? Skip to step four. New to Confection? Learn more here.
If you haven’t already, create a Confection account. If you already have a Confection account, log in.
Click “My Account” (or “Set Up My Account” if you’re accessing your account for the first time). Enter your contact information, the domain(s) on which you want to use Confection, and select one of our two data storage options. Then, click “Save Changes.”
Click "Install Confection" (If you're accessing your account for the first time, this will be the default screen.) Select your preferred langauge, CMS, platform, or framework to download the relevant scripts.
At this point, use the relevant language, framework, CMS, or platform quick start guide to get Confection up and running on your site or app. Then, continue with step four.
By default, Confection stores data for 24 hours. During that timeframe, it’s available in your account to query and send anywhere via your account API, one of our lowcode/nocode connectors, and/or our native integrations. If you want to store and access data longer than 24 hours, please write it to your preferred endpoint using one of these methods.
For Google Cloud users, we also offer a native BigQuery storage integration. If you activate this option, Confection will make three attempts to write your account data to BigQuery before the 24-hour expiration point. We migrate all data as a JSON object that includes a UUID and all the data associated with it.
To set up the BigQuery integration, visit "My Account" in your Confection dashboard. Under "Data Storage," select "Send to Google BigQuery."
Next, visit your BigQuery Console. Click the vertical dots (⋮) beside the project name that will contain the Confection dataset, and select "Create dataset." (If you need to create project, see this list of instructions.)
Name the dataset confection. (Note, this is case sensitive. Confection won't work. confection will.) Then, select the relevant region, set an expiration timeframe (optional), and edit the advanced options as they're relevant to you. Lastly, click "Create Dataset."
Next, click the right-facing triangle beside your project name, click the vertical dots (⋮) beside the "confection" dataset, and select "Share." Click "Add Principal," and add [email protected] in the "New principals" field. In the "Role" dropdown, select "BigQuery" > "BigQuery Data Editor." This will give Confection write access to the dataset. Then, select "Save."
Lastly, copy your project name -- premium-trainer-360701 in the video -- and add it to the field in the "My Account" section of your Confection account. Click "Save Changes" to begin writing your Confection account data to BigQuery.
That's it. You're done.
After you complete the steps above -- and after your account has had a chance to write data into BigQuery -- you'll see a new table under your Confection dataset called leads. It will contain a list of UUIDs and data associated with those UUIDs.
Google Cloud Billing Info
There are no Confection charges to send information to BigQuery. And each month, Google allows you to make up to 1TB's worth of on-demand queries and store up to 10MB of data for free. However, to keep external data connections like Confection active, Google Cloud requires users add a payment method to their accounts. To do this, follow these steps.
Use Confection + BigQuery to Enrich Google Ads Campaigns
Once you've started writing data to BigQuery, you can easily use that session intelligence to enrich Google Ad campaigns. For more information, see this Google guide.
There are two other ways to do the same thing. You can use your Confection-enriched Google Analytics property and this Google guide.
If you want more granular level control, you can also use Confection's lowcode/nocode integrations at Zapier, Pipedream, Make (Integromat), and Tray.io.
Questions or comments about using Confection with BigQuery (Google Cloud)? Leave them below.
You can also use the chat app in the lower right corner.