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

    portThe Windsor.ai platform supports API calls to retrieve and send information. In this article, we explain how to extract data and visualise it in Google Sheets.

    The prerequisites are:

    • Windsor.ai account
    • Windsor.ai API key
    • Access to Google Sheets
    1. Open the sample Google Sheets file here and fill in the green highlighted. Username here is not your email but the client_name, the company name you registered with.google sheets API call 1
    2. After entering the correct information the cells below Dates  and the cells below Costs should be loaded from the selected database table.
    3. Analyse the query in cell B8 and customise it to your liking
    4. Change the contents of the cell B12 to load other metrics. More information on the available metrics can be found here

     

    More details:

    1. Here is an example of an API call:
      https://api.windsor.ai/windsor/windsor_attribution/public/windsor_attributions_and_costs?_renderer=xml&_page=2&_page_size=10&api_key=APIKEY&_select=date,source,medium,campaign,sum:markov,sum:totalcost&_groupby=date,source,medium,campaign&_order=-date
      Replace the APIKEY.
      This would get all costs and attributed revenues and sum them by date and source medium and campaign.
      Finally it would sort it by date
    2. This is then put into a cell with the value:
      =IMPORTXML(APICALL, “//date”)

    The API functions are documented here: https://www.windsor.ai/api-documentation/

Viewing 1 post (of 1 total)
Reply To: How to connect Windsor.ai (Google Ads, Facebook, Bing, Google Analytics, DoubleClick, …) to Google Sheets
Your information: