This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
database_caching [2021/07/28 09:15] windsor_ai |
database_caching [2021/12/16 08:27] (current) windsor_ai |
||
---|---|---|---|
Line 13: | Line 13: | ||
- | {{youtube> | + | ===== How to set it up ===== |
+ | |||
+ | |||
+ | ==== 1. Create a windsor dashboard from https:// | ||
+ | |||
+ | 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. | ||
+ | |||
+ | |||
+ | {{:: | ||
+ | |||
+ | |||
+ | |||
+ | ==== 2. Check your dashboard once its created ==== | ||
+ | |||
+ | You will get a link to https:// | ||
+ | |||
+ | {{: | ||
+ | |||
+ | |||
+ | |||
+ | ==== 3. Setup the data transfer ===== | ||
+ | |||
+ | Select " | ||
+ | |||
+ | {{:: | ||
+ | |||
+ | |||
+ | |||
+ | ==== 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. | ||
+ | |||
+ | {{:: | ||
+ | |||
+ | |||
+ | |||
+ | ==== 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 " | ||
+ | |||
+ | {{: | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==== Here is a video showing the process ==== | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | {{ youtube> | ||
Line 29: | Line 87: | ||
[[https:// | [[https:// | ||
- | === Google Sheets function used | + | === Google Sheets function used === |
< | < |