Differences

This shows you the differences between two versions of the page.

--- database_caching [2021/07/28 07:01]
windsor_ai created
+++ database_caching [2021/12/16 08:27] (current)
windsor_ai
@@ Line 11: / Line 11: @@
 You can then directly stream the data in a CSV or JSON format to your BI tool.
+===== How to set it up =====
+==== 1.  Create a windsor dashboard from https://onboard.windsor.ai ====
+This will also create a database for you. You can select any of the windsor attribution dashboards. You need to have googleanalytics and a goal configured.
+{{::windsor_dashboard2.png?1200|}}
+==== 2. Check your dashboard once its created ====
+You will get a link to https://charts.windsor.ai where you can login and check it.
+{{:marketing_dashboard.png?1200|}}
+==== 3. Setup the data transfer =====
+Select "Windsor.ai Cloud Database"
+{{::select_cloud_database.png?1200|}}
+==== 4. Select the fields and create the table ====
+When the fields have been filled and you press save it will create the scheduled datatransfer to the database.
+{{::select_fields_and_create_table.png?1200|}}
+==== 5. Query your data in charts.windsor.ai =====
+After this you can start querying the data from the dabase.
+Once you have the query like you want it you can use the "Download to CSV" even as a datafeed for your other tools or then you can create a table and get it as a JSON data-feed.
+{{:query_the_data.png?1200|}}
+ ==== Here is a video showing the process ====
+{{ youtube>tEfsjl7sHvU?large }} \\
@@ Line 26: / Line 87: @@
 [[https://datastudio.google.com/datasources/create?connectorId=AKfycbwx4Ixzwm6Gi99VbTwJUM1vTZTux6q7TffLGhP7rYOsqI6EIS01xEYYUPi4kS2cPoKw_Q|Windsor.ai JSON Connector]]
-=== Google Sheets function used
+=== Google Sheets function used ===
 <code>=IMPORTDATA("http://charts.windsor.ai/r/6462?api_key=[Your API Key]")</code>

Knowledge Base

User Tools

Site Tools

Differences

Page Tools