Search found 27 matches

by niklaskolster
Fri Oct 09, 2020 9:27 am
Forum: Howto’s
Topic: How to pull any dimension into a table to join it with other data
Replies: 0
Views: 251

How to pull any dimension into a table to join it with other data

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...
by niklaskolster
Wed Sep 09, 2020 8:45 pm
Forum: Howto’s
Topic: Analytics and ad data into powerbi
Replies: 1
Views: 1366

Re: Analytics and ad data into powerbi

Use as CSV document
2020-09-09_22-17.png
2020-09-09_22-17.png (62.13 KiB) Viewed 1365 times
Apply and close
2020-09-09_22-18.png
2020-09-09_22-18.png (138.2 KiB) Viewed 1365 times
Create your charts
2020-09-09_22-26.png
2020-09-09_22-26.png (45.43 KiB) Viewed 1365 times
by niklaskolster
Wed Sep 09, 2020 8:44 pm
Forum: Howto’s
Topic: Analytics and ad data into powerbi
Replies: 1
Views: 1366

Analytics and ad data into powerbi

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...
by niklaskolster
Thu Aug 27, 2020 1:55 pm
Forum: Howto’s
Topic: Exporting data from windsor.ai
Replies: 0
Views: 1413

Exporting data from windsor.ai

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://...
by niklaskolster
Mon May 18, 2020 3:12 pm
Forum: Howto’s
Topic: Create custom channel grouping, eg. Brand and non-brand
Replies: 0
Views: 1946

Create custom channel grouping, eg. Brand and non-brand

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...
by niklaskolster
Mon May 18, 2020 3:07 pm
Forum: Howto’s
Topic: How to add the ‘every visit’ conversion goal
Replies: 0
Views: 1975

How to add the ‘every visit’ conversion goal

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/...
by niklaskolster
Mon May 18, 2020 3:02 pm
Forum: Howto’s
Topic: How to link Facebook Ads with Windsor.ai
Replies: 0
Views: 1921

How to link Facebook Ads with Windsor.ai

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/...
by niklaskolster
Mon May 18, 2020 2:56 pm
Forum: Howto’s
Topic: How to rename conversion types in front-end
Replies: 0
Views: 1945

How to rename conversion types in front-end

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...