Connect Connectif to BigQuery

Easily integrate your Connectif data into BigQuery with Windsor.ai for scalable analysis.

Windsor.ai loads Connectif email campaign sends, opens, clicks, unsubscribes, and purchases into BigQuery tables in a structured format, ready for SQL queries and reporting.

Forget CSVs. Stop copy/paste. Connect data in 2 minutes. No code required.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Connectif to Google BigQuery connector

Get more from your Connectif data with BigQuery

Connecting Connectif to BigQuery with Windsor.ai gives marketing teams one warehouse table set for email performance data. Here are the key benefits of this integration:

Query your Connectif data with SQL

BigQuery handles large tables, so you can analyze large volumes of email campaign data with SQL.

Automated loading

Windsor.ai writes new Connectif data to your BigQuery table on the schedule you set, so you do not maintain loading scripts.

One warehouse for every channel

Join Connectif with store, analytics, and ad data in BigQuery to compare channels in one place.

Using Windsor.ai connector to import data from Connectif into BigQuery

Supported fields: 13 metrics22 dimensions

Without Windsor.ai, getting Connectif data into BigQuery means exporting reports from Connectif and loading the files, or building a pipeline against Connectif’s APIs. Windsor.ai’s no-code connector collects your Connectif email campaign sends, opens, clicks, unsubscribes, and purchases and loads the data into BigQuery on a schedule.

In minutes, you can have Connectif tables ready for SQL analysis.

With Windsor.ai, you can:

Load Connectif data into BigQuery on a schedule, with no manual exports or API maintenance.
Query email campaign sends, opens, clicks, and purchases with SQL.
Join Connectif tables with store, analytics, and ad data in the same warehouse.
Use BigQuery’s access controls to manage who can see your email campaign data.

Join over 25,000+ businesses that trust Windsor.ai to streamline Connectif to Google BigQuery integration

How to connect Connectif to BigQuery in Windsor.ai

Make sure you have the following prerequisites before setting up the connector:

Connectif account with an API key and report ID
Google Cloud Platform (GCP) account with BigQuery enabled
Active Windsor.ai account

Register and log in to Windsor.ai

Create a new Windsor.ai account or log in if you already have one.

Select your data source

Choose Connectif as your data source and enter your Connectif report ID and API key.

Select your destination

Set BigQuery as the destination for your data.

Create a destination task

Click on the “Add Destination Task” button and fill out the required fields along with the advanced settings (optional). Save and run the task.

FAQs

What is Connectif?

Connectif is a marketing automation platform for online stores. The Windsor.ai Connectif connector brings email campaign data into your warehouse: emails sent, opens, clicks, unsubscribes, purchases, and engagement rates.

What is BigQuery?

BigQuery, also known as Google Cloud BigQuery, is Google Cloud’s data warehouse for storing and querying large datasets with SQL.

What Connectif data can I load into BigQuery?

Windsor.ai loads your Connectif data into BigQuery in five groups. These are some of the fields in each; the Connectif field reference lists all of them:

Campaign and delivery: Campaign, Emails Sent, Unsubscribes.
Opens and clicks: Total Opens, Unique Opens, Total Clicks, Unique Clicks.
Rates: Email Open Rate, Email Click Through Rate, Email Click To Open Rate, Email Unsubscribe Rate.
Purchases: Email Conversion Rate, Total Purchase Amount, and the number of purchases linked to each email.
Date and account fields: Date, Week, Month, Year, Account ID, Account Name.

How does Connectif data get into BigQuery?

You create a destination task in Windsor.ai with your Google Cloud project, dataset, and table name, then choose a schedule and, optionally, a backfill of earlier data. Windsor.ai writes your Connectif data to that table on the schedule you set.

Can I combine Connectif with other data sources in BigQuery?

Yes. Windsor.ai supports 350+ data sources, so you can load Connectif alongside tools such as Shopify, Google Analytics 4, or Facebook Ads into the same dataset and join them in SQL. For example, you can compare Connectif purchase amounts with orders in Shopify, or compare email clicks with sessions in Google Analytics 4.

How much time do I need to create the Connectif and BigQuery integration?

Connecting Connectif in Windsor.ai and creating a BigQuery destination task takes a few minutes, with no code.

How much does it cost to integrate Connectif with BigQuery using Windsor.ai?

Testing is free for the first 30 days. After that, scheduled syncs to BigQuery run on the paid plans: $19/month for 3 data sources and up to 5 destination tasks, or $99/month for 7 data sources and unlimited destination tasks. See the pricing page.

Do you have helpful links to get started with integrating Connectif and BigQuery using Windsor.ai?

Yes, we have helpful resources to help you get started. You can explore our official documentation for Connectif to BigQuery integration with Windsor.ai:

Tired of manual Connectif data exports? Get started with Windsor.ai today to automate your reporting

Access all your data from various sources in one place. Get started for free.

Start for Free Book a Demo