I am creating a social media monitoring database for esports players for how many followers they have between several platforms. I have it up and running pretty good but I now want to keep a history of how those numbers change over time instead of just always updating to the latest follower count.
I’m using integromat to update the numbers via the API and in the record’s activity these changes can be seen. However, I would like to save these changes in the record forever, obviously by date it changed. So that I may make queries about these changes, create graphs and show the delta of the change each time (up 2% etc).
Is this possible?