[Idea] Publish stats page of visits of looked up data and/or missing data

[geekygirlsarah]

Description

In #480, @hegold suggested "Publish data on oops page visits so contributors can see the most requested missing items". I also thought a stats page of most commonly looked up comparisons or reference sheets would be interesting. Perhaps a "Stats" page at the top of the site along with different types of data looked up from the database?

This issue is to think through how this might work or what this might look like.

Additional Notes

Since early March, lookups have been tracked in a database. There's presently no record on whether the lookup passed or failed, but this data can be used towards this.

This issue probably needs to be thought about a bit more before assigning to work on.

[xomiamoore]

Hi @geekygirlsarah! I think I could help with this issue, if you're open to using something like Google Analytics. I don't have a ton of coding experience, but I've worked with analytics tools before.

Let me know your thoughts and we can talk through what this would look like!

[geekygirlsarah]

Hello! Actually it's probably a bit simpler: There's two database tables that track stats. So you can just use some Python model wrangling to probably get data. You could do SQL if you felt up to it. No G'analytics.

How do you feel about that?

[sarthakjalan05]

@geekygirlsarah i would like to work for this.....please assign me under the hacktoberfest tag??!!

[geekygirlsarah]

@sarthakjalan05 I'll assign you to this too. Let me know if you have any questions!

[sarthakjalan05]

@geekygirlsarah I have raised a PR. Please let me know if any updation is needed.