Hi guys,
I need some help with something , mainly an opinion.
I am wanting to set up a way to track app usage data.
I would like to log use off my app - user clicks and element interactions because I’d like to be able to show - for example; how many external users have clicked on a link on the app, and I would like to have the option to display this in time periods or ranges in the future.
I’m worried about building a datatype that grows to become huge at some point. I understand the importance of separating data, so I’d like some suggestion on what will be the best way to handle this.
One way that I thought of approaching this, is by creating one general data type and called ‘statistics ‘ and then create individual data types to associate to this table in a related fashion.
So for example, under the statistics data type, they’ll be a field called ‘related image clicks’ which would be related to a separate data type ‘statistics - image clicks’. My logic is that I don’t want all the data records to be loaded each time the data type - Statistics is loaded or called on, rather have them broken down into individual statistic data type components, if that makes sense.
- My first question is, should I create a general ‘statistics’ data type and then relate additional data types to Fields within that data type in order to keep it organised as above, or simply create each data type for the static’s I’m trying to track; example ‘statistics - image clicks’, ‘statistics - read more, etc? I guess creating the general ‘statistics’ data type would mean I best both.
Is it better that’s having one data type called statistics and then have various fields that trigger when it’s clicked for images clicks, links, scrolls, etc, etc? I could use an option set up identify that each click relates to. Or am I better creating individual data types? Hope this makes sense.
- In recording the image, click statistics, should I create a row in my ‘statistics - image clicks’ data type - one for each click? Or, am I better to simply add it to a numerical field in that data type, for example ‘Statistics’ and then have a field for ‘Image Clicks’ within - thats is a numerical value, that adds up to a value every time it’s clicked?
I think the limitation with this is that, although the number will continually increase every time, the clicks will not be date or time stamped, so I won’t be able to filter the stats based on whether it’s been done, monthly, weekly yearly and the like survey.
The other option is to create a new record under’Statistics - image clicks’ each time it’s clicked.
I’ve tested this and it works well and I’m able to show a repeating group in the app and demonstrate this data.
My only concern is that over time and possibly very quickly, there will be ‘millions’ of records created and could cause a problem.
Is this a concern or is this the best way to go about doing it? Does anyone have any recommendation on how such click interaction data can be tracked in bubble.
I want to do this as I think it’s critical to showing my app subscribers the value of the app by way of user interaction.
Any direction will be great.
Thanks
