1. Create database connection to ad platforms. If the connection to the connectors have not been setup already it has to be created. a. give the database a name with your username b. as connection string put connectors:///?api_key=<api_key>&user_name=<username> c. test that the connection works d. c...

Use as CSV document Apply and close Create your charts

How to get any analytics or marketing data into powerBI. 1. Sign-up for windsor.ai here: https://onboard.windsor.ai/register 2. Connect your datasources 4. Go to a table with the data and transformations you want to visualise in powerbi and click the CSV button 2020-09-09_22-15.png Copy the URL: 202...

There are three main ways to export data from windsor.ai: 1. The REST API documented here https://www.windsor.ai/api-documentation/ 2. Direct database connection via eg. ODBC 3. From the dashboards Here we describe method 3 directly from the dashboards. 1. Login to your windsor dashboard at https://...

In this example, we create a custom brand channel-grouping for campaigns with keyword scs After exploring a table, click edit data-source: https://i.imgur.com/di7UZsO.png Select the legacy editor https://i.imgur.com/IlmyDdD.png Edit the channelgrouping column and set the case statement https://i.img...

To add the ‘every visit’ conversion goal as described below, you will need to have edit access for the view you are going to modify [/b] Go to Google Analytics Click on add new goal (in case your goal list is full, you will need to update an existing goal) https://www.windsor.ai/wp-content/uploads/...

Step 1: Go to Business Manager Settings Once you’ve logged in to Business Manager, click “Go to Settings” on the right side of the page. https://www.windsor.ai/wp-content/uploads/2019/12/facebook_1-700x453.png Step 2: Click Ad Accounts Click “Ad Accounts” on the left column. https://www.windsor.ai/...

How to replace values in dashboard data using SQL The Windsor.ai dashboards allow users to update column definitions using custom SQL code to modify the results and even to create new columns based on existing ones: Open the Sources -> Tables menu Click the Edit button next next to the table to upda...