- This topic is empty.
- January 23, 2020 at 1:52 am #12873Matthias KraazKeymaster
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
- 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.
- After entering the correct information the cells below
Datesand the cells below
Costsshould be loaded from the selected database table.
- Analyse the query in cell B8 and customise it to your liking
- Change the contents of the cell B12 to load other metrics. More information on the available metrics can be found here
- Here is an example of an API call:
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
- This is then put into a cell with the value:
The API functions are documented here: https://www.windsor.ai/api-documentation/