[Task] Generate monthly reports on OC data updates

[tschaffter]

What product(s) is this story for?

OpenChallenges

As a user, I want

As a Product Owner, I want to get a summary of the OC data that have been created or changed so that I can share this summary with stakeholders.

Description

One approach would be to create SQL queries that can be run against the OC DB. This query could then continue to be used when the DB has been migrated to an AWS managed DB.

Alternatively, we could create an endpoint to access these data to enable anyone to fetch them.

Acceptance criteria

The following metrics can be generated for an arbitrary period of time defined by two datetimes:

• number of challenges added
• number of challenges updated
• number of organization added
• number of organization updated
• number of challenge contributions added ("challenge x organization" objects)
• number of challenge contributions updated

Tasks

No response

Anything else?

No response

Have you linked this story to a GitHub Project?

• I have linked this story to a GitHub Project and set its metadata.