I suggest creating a new table to consolidate the entry installs report weekly

forge_entryInstallsReport

• entryReportId -> PK

• entrySlug → coldbox

• entryVersion → 2.1

• installs → 2000

• startDate → today

• endDate - > sunday

This way we can have reports weekly for each entry version and even by package

I suggest presenting this data in the UI weekly, monthly and in a 6-months view

To achieve this we need the following:

• A scheduled task that populates the table weekly (on Sunday night) for each package

• A scheduled task that removes the week installs older than 6 months (we can run this weekly or monthly)

• We also need to wipe out the data from the forge_entryVersionInstalls table (this can be run monthly and keep data for 1 year)

•  

• Subtask: weekly and monthly report for pro accounts