Historical Analytics by Date

[ThinhDinh]

@William_Ayer

The only reason I was thinking it would need to be external from Glide is so that I could schedule it to automatically run every 24 hours - as far as I can find, Glide doesn’t have that capability yet. So my thought was to build a schedule in Zapier which queries the data from “realtime-analytics” and posts it back into “historical-analytics”

I have the exact need as you for my last project. I think there are 2 ways to go here:

• If you have access to Glide API’s query (on Business/Enterprise), perhaps you can query the whole tables and do aggregation to get the right numbers (of Users, Events, Events Complete - basically re-calculating them in Make/Zapier), then push those to your analytics table.

• The alternative is to duplicate your app, which will keep your tables intact. Change your app to fully public, clear all tabs and add only one new, built on top of your realtime-analytics table. Add a button that will add a row to the historical-analytics table.

• To fully automate the 2nd option, I use Automa. My scenario looks like this.

I run it locally, at a time when I know my laptop is surely on.