- Help Center
- Integrations
-
Getting Started
-
Configuration
- Targeting
- Split URL
- Product Testing
- Full Stack
- Experiment Management
- CSP Configuration
- Experiment Execution
- Reports
- Exit Popups
- GTM Integration
- Troubleshooting
- Performance Optimization
- Event-Triggered Changes
- Holdout Groups
- Split URL Pages
- URL Parameters
- DataLayer
- Menu Configurations
- Traffic Exclusion
- Experiment Scheduling
- Dynamic Element Changes
- Price Targeting
- Experience Scheduling
- Privacy
- Hash Changes
- Async Tracking
- Selective Installation
- CSS Selectors
- Vue.js Integration
- Page Content
- Multipage Split URL
- Organic Traffic
- Visual Editor
- Server-Side Testing
- Traffic Bucketing
- GDPR Warnings
- Statistical Confidence
- Browser Privacy
- Query Parameters
- Embedded Videos
- Tracking Code Execution
- Simultaneous Experiments
- Tags
- Deployments
- Disable Testing
- Locations
- Programmatic Bucketting
- Query Parameter Handling
- Convert Library
- Variation Previews
- Experiment Editing
- Opt-Out Script
- Data Reset
- Body Hiding
- Visit-Specific Variations
- Variation Styling
- Preview Issues
- Variation Editing
- Full-Site Testing
- Blinking Variations
- Cross-Domain Cookies
- Regex Support
- Conversion Tracking
- SPA Testing
- Project Setup
- Cross-Domain Tracking
- Geo-Targeting
- Analytics Tools
- Campaign Tags
- Previewing
- IDs
- Query String Targeting
- Bounce Rate Goals
- Bot Filtering
- Query String Variables
- Custom Audiences
- Redirects
- Baseline
- Tracking Code Location
- Secure Cookies
- AngularJS
- Cloudflare
- Code Installation
-
Track Goals
- Form Tracking
- Cookie Management
- iFrame Click Tracking
- Performance Optimization
- Revenue Tracking
- Interaction Goals
- Form Submissions
- Advanced Goals
- Lazy Loading
- Multi-Conversions
- URL Parameters
- Bounce Rate Goals
- DataLayer Integration
- Scroll Depth
- Social Interactions
- Page Views
- Marketo Forms
- Feature Analysis
- AJAX Forms
- Revenue Tracking via GTM
- Order Outliers
- Cumulative Revenue
- Goal Templates
- Adding Revenue Goals
- JS-Based Goals
- Goal Basics
- Google Analytics Goals
- Social Sharing
- Dynamic Goals
- Typeform Integration
-
Target Visitors
- Geolocation
- Interaction Goals
- Goal-Based Targeting
- Weather Targeting
- Cookie-Based Targeting
- Page Visits
- Audience Management
- Audience Segmentation
- Experiment Targeting
- Advanced Audience Creation
- Audience Templates
- Audience Creation
- Data Layer Integration
- Manual Activation
- JavaScript Conditions
- Device Targeting
- Language Targeting
- IP-Based Exclusion
- Visitor Management
- Page Tagging
- Cookies
-
Troubleshooting
- Google Warnings
- Visual Editor
- HTTPS Content
- Logs
- Support Options
- Bootstrap
- Cookie Blocking
- Change History
- Mobile Debugging
- AdWords
- Bot Exclusion
- Domain Issues
- Cloudflare Issues
- Monitoring
- Cloaking Penalties
- Goal Editor Issues
- Variations
- Snippet Performance
- Changes Not Saved
- Blocked Visual Editor
- Goal Testing
- Visual Editor Browsing
- Experiment Issues
- Installation Verification
- Data Leak Prevention
- Usage Limits
- Experiment Previews
- GA4 Revenue
- Chrome Debugger Logs
- SPA Errors
- Checkout JSON Error
-
Analyze Results
-
Integrations
- Google Analytics
- Cookie Consent Platforms
- Microsoft Clarity
- Plausible
- Marketo
- HubSpot
- Tealium
- Smartlook
- Klaviyo
- Salesforce CRM
- FullStory
- Snowplow Analytics
- Webflow
- GA4 Roles
- Amplitude
- Segment
- React
- BigCommerce
- WooCommerce
- Active Campaign
- Google Tag Manager
- Mixpanel
- Zapier
- Inspectlet
- Crazy Egg
- LanderApp
- Unbounce
- Instapage
- Drupal
- PrestaShop
- Magento
- Roistat
- Piano Analytics
- Heap Analytics
- Kissmetrics
- Mouseflow
- Adobe Analytics
- Clicky
-
Account Management
-
Developers
-
What's New
-
Common Questions
-
Shopify
Integrate Convert Experiences with Microsoft Power BI
This Article Will Help You:
- Convert-Microsoft Power BI Integration
- Add Tracking Code Snippets
- Activate Convert-Segment Integration
- View Convert Data in Segment
- Add Stitch as Destination in Segment
- Add Panoply as Destination in Stitch
- View Convert Data in Panoply
- Connect Microsoft Power BI to Panoply
Convert-Microsoft Power BI Integration
Integration of Microsoft Power BI with Convert Experiences will help you to import Convert data into your central data warehouse (we will use Panoply) with an ETL tool (we will use Stitch). From there, it's easy to use Power BI to perform the in-depth analysis you need.
For each experiment, the integration uses track events to pass along the experiment name and variation name that the visitor is currently bucketed into (if any).
The general flow will look like this:
We will need:
- A Segment account to be used as the middleware to send data from Convert Experiences to the powerful ETL tool Stitch.
- A Stitch account to connect your Segment data with your other data sources in a data warehouse in minutes.
- A Panoply account or any other data warehouse account that Segment supports (see here) list:
- A Microsoft Power BI account to connect to your data warehouse. For Panoply read more instructions here.
Add Tracking Code Snippets
Make sure the Convert tracking code and the Segment tracking code (analytics.js) are installed on your pages. The Segment tracking code looks like this:
Activate Convert-Segment Integration
Add the code below to your website right after the Convert + Segment tracking codes which will send Convert Experience and Variation names to Segment Debugger/Schema:
var refObject = window['convert']['data']['experiments']
for (var key in window["convert"]["currentData"]["experiments"]) {
if (!window["convert"]["currentData"]["experiments"].hasOwnProperty(key)) {
continue;
}}
var currentExperiment = window["convert"]["currentData"]["experiments"][key];
var curExperimentName = refObject[key] && refObject[key].n ? refObject[key].n : "unknown experiment name";
curExperimentName = curExperimentName.replace("Test #", "Test ");
var curVariant = currentExperiment['variation_name'] ? currentExperiment['variation_name'] : "unknown variant";
curVariant = curVariant.replace("Var #", "Variation ");
analytics.track('Convert Experiences', {
Exp_Name: curExperimentName,
Var_Name: curVariant
});
View Convert Data in Segment
When you log in to your Segment account, you should go to your Schema. Inside your Schema, you can see all of the track events that you are sending through Segment, and if they are active or inactive.
Add Stitch as Destination in Segment
Then you should add an ETL tool (in our case we use Stitch) as your destination in Segment dashboard:
Add Panoply as Destination in Stitch
Then you should add your data warehouse (in our case we use Panoply) in your Stitch account and very quickly you will be able to see the tables/rows that are replicated:
View Convert Data in Panoply
In Panoply account you will be able to see the Convert Experiences data (experience + variation name) that you have sent initially:
Connect Microsoft Power BI to Panoply
To analyze your data, Panoply integrates with Business Intelligence (BI) tools such as Microsoft Power BI, Metabase, Tableau, Data Bricks, Looker, Chartio, Re:dash, Zeppelin, iPython Notebook, Shiny Apps by RStudio, and Sisense.
To connect Power BI, note the following requirements:
- You must use Power BI April 2018 or newer.
- Use the Postgres connector. Panoply does not support the Redshift driver for Power BI. For other BI tools, we recommend that you use the Redshift driver.
- Use port 5432 instead of the default port 5439.
- If you are using Connect with Google to log into Panoply, you must reset your password in Panoply. This creates a password for logging into Panoply via Power BI. You will still be able to log into Panoply via Google after the password reset.