• This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • #13137 Reply
    Matthias Kraaz
    Keymaster

    The Windsor.ai platform supports API calls to retrieve and send information. In this article, we explain how to extract data and visualise it in Microsoft Power BI.

    The prerequisites are:

    • Windsor.ai account
    • Windsor.ai API key
    • Microsoft PowerBI (Important: This feature is only available on PowerBI on Windows)

    Here are the steps required to load data into Microsoft Power BI

    1. In PowerBI open a new window and click on Get Data and then Webwindsorai powerbi 2
    2. In the URL box enter your API query.

      windsorai powerbi 1

      Here is an example query:
      https://api.windsor.ai/pied_piper_llc/pied_piper_llc_attribution/public/pied_piper_llc_attributions_and_costs?
      api_key=abcd
      &_select=date,source,medium,campaign,sum:totalcost
      &_groupby=date,source,medium,campaign
      &_order=-date

      The highlighted fields:

      pied_piper_llcshould be replaced with your username
      pied_piper_llc_attributions_and_costs should be replaced with the table you want to load
      abcd should be replaced with your API key
      &_select=date,source,medium,campaign,sum:totalcost should be replaced with the columns and metrics which you want to visualise
      &_groupby=date,source,medium,campaign should be replaced by the columns you want to group by
      &_order=-date should be replaced by the columns you want to order by

      The API documentation can be found here and the available fields can be found in the table definitions here.

       

    3. Click on To Tablewindsorai powerbi 3
    4. Keep the Select or enter delimiter dropdown to it’s defaul value None and click OKwindsorai powerbi 4
    5. Click on the button with the two arrows to expand the columnswindsorai powerbi 5
    6. Click on OKwindsorai powerbi 6
    7. Rename the columns to your liking so it will be easy to work with them once they are available in Power BI as fieldswindsorai powerbi 7
    8. Click on Close & Applywindsorai powerbi 8

       

    9. Great! Now you have the data integartion set up and the data will be available in Power BI for visualisation. Let’s create a simple chart showing us spend over time. Click on the Line chartwindsorai powerbi 10

       

    10. Fill date into axis and cost into valueswindsorai powerbi 11
    11. Repeat and add other charts and tables.

    If you would like to build another query to get different dimensions and metrics into Power BI please have a look at our API documentation, which can be found here, and our table definitions, which can be found here.

Viewing 1 post (of 1 total)
Reply To: How to visualise Windsor.ai (Google Ads, Facebook, Bing, Google Analytics, DoubleClick, …) data in Microsoft Power BI
Your information: