Connect Connectif to Power BI

Easily bring your Connectif data into Power BI with Windsor.ai for email marketing reporting.

Windsor.ai delivers Connectif email campaign sends, opens, clicks, unsubscribes, and purchases to Power BI Desktop or Power BI on the web in a structured format, so you can build dashboards without CSV exports.

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 Power BI connector

Get more from your Connectif data with Power BI

Connecting Connectif to Power BI with Windsor.ai gives marketing teams one report for email performance. Here are the key benefits of this integration:

Dashboards without exports

Power BI reads your Connectif data through Windsor.ai, so reports for emails, engagement, and purchases do not depend on manual file uploads.

Engagement and purchases in one view

Chart Emails Sent, Unique Opens, Unique Clicks, and Total Purchase Amount by Campaign to see which emails get read and which lead to purchases.

Rates next to volumes

Put Email Open Rate, Email Click Through Rate, and Email Unsubscribe Rate beside Emails Sent to see how engagement changes as volume changes.

Using Windsor.ai connector to import data from Connectif into Power BI

Supported fields: 13 metrics22 dimensions

Without Windsor.ai, getting Connectif data into Power BI means exporting reports from Connectif and loading the files by hand. Windsor.ai’s connector delivers your Connectif email campaign sends, opens, clicks, unsubscribes, and purchases to Power BI as a data source, with no code.

Connect in minutes and build reports from your Connectif data.

With Windsor.ai, you can:

Load Connectif data into Power BI Desktop or Power BI on the web with no manual exports.
Report on emails sent, opens, clicks, and unsubscribes in one dashboard.
Chart open rate, click through rate, and total purchase amount by email.
Combine Connectif with Shopify, Google Analytics 4, or Facebook Ads data in the same report.

Join over 30,000+ businesses that trust Windsor.ai to streamline Connectif to Power BI integration

How to connect Connectif to Power BI in Windsor.ai

Windsor.ai supports two Power BI integration methods: Desktop and Web. Follow our step-by-step guide and video tutorials to get started quickly.

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.

For Power BI Desktop: Save your query and select it in the app

Save a query if you’re building a custom report in Power BI Desktop
In Power BI Desktop, go to Get Data → Windsor → Sign in
Select your saved query from Windsor and click Load

Video instructions: https://www.youtube.com/watch?v=Zf-3JYC1d1Q.

For Power BI Web: Copy your Windsor query URL

Copy your query URL if you’re using Power BI Web
In Power BI, go to Get Data → Web, paste your copied query URL, and click Ok
Let the dashboard auto-load data

Video instructions: https://www.youtube.com/watch?v=L1NeAKUwqXk.

Build and refresh your report

You have connected your Connectif data to Power BI via Windsor.ai. Now you can visualize it the way you prefer.

data integrated into power bi with windsor

FAQs

What is Connectif?

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

What is Power BI?

Power BI is Microsoft’s business analytics tool for building interactive reports and dashboards from many data sources.

What Connectif data can I report on in Power BI?

Windsor.ai delivers your Connectif data to Power BI 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 Windsor.ai connect Connectif to Power BI?

There are two methods. In Power BI Desktop, you save a query in Windsor.ai, then go to Get Data, choose Windsor, sign in, and select the saved query. In Power BI on the web, you copy your Windsor.ai query URL and paste it under Get Data, then Web. Both are no-code.

Can I combine Connectif with other data sources in one Power BI report?

Yes. Windsor.ai supports 350+ data sources, so you can connect Connectif alongside tools such as Shopify, Google Analytics 4, or Facebook Ads and report on them together. 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 Power BI integration?

Connecting Connectif in Windsor.ai and loading the data into Power BI takes a few minutes, with no code.

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

The free forever plan covers 1 data source, so connecting Connectif on its own costs nothing and needs no credit card. Combining Connectif with other sources, such as Google Analytics 4 or Shopify, needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.

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

Yes, we have helpful resources to help you get started. You can explore our official documentation for Connectif to Power BI 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