3

Since this feature request was answered with a good workaround, I am rather asking here for any tool to get the stats of the votes and visits of questions and the votes of the answers as a file.

Old heading was:

Since view statistics are not stored: Button "Save time series of the views of all questions to a user file". And: "Upload file for stats" on SE site

Old question was:

The number of views is not stored, that is why the users cannot get a chart or overview over time from Stack Exchange. Still: If storing is the problem, why not giving the users themselves the chance to store the views per question on their local drive or in an online "dropbox"?

Of course, everyone can just look up their most important questions and create an Excel sheet or print out a pdf of the question once in a while to have a history of its number of views, but that is manual work.

I suggest an export button that lets you manually export all of your queries together with their views and other information at the current timestamp into a json file or thelike on your local hard disk or into a "dropbox", at best updating the same existing file again and again so that you can extract data over time from just one file.

And in addition one might consider an option in the profile to do this automatically: store the csv after a certain time starting as soon as you visit the site, perhaps the file can also be saved online in a kind of dropbox so that it is not dependent on the computer you are working on. The highest possible storing frequency would be to update the file whenever you access a SO site, the lowest would be to store this once per quarter (or never).

This feature would meet a lot of interest, see the many earlier feature requests:

As a bonus to this feature-request, on Stack Exchange, there should be a feature that can load that local file and show the graphs and statistics for all questions saved locally in that file.

4

1 Answer 1

5

I have a Stack Exchange Data Explorer query which you can run to generate a list of your questions across the network, including statistics like the number of views. It needs your network account ID, which you can find by navigating to https://stackexchange.com/users/current – you'll find the number in the URL of the page you'll end up on. SEDE has a built-in functionality to export the results as CSV, so you can keep an archive yourself, or save the page in the Wayback Machine (the latter only works if you provide the AccountId parameter in the URL, so https://data.stackexchange.com/stackoverflow/query/740847/networkwide-questions-per-account-ordered-by-view-count?AccountId=6085540).

enter image description here

Please note that SEDE is updated only once a week, on Sunday morning.

4
  • 4
    @Lorenz Doing this all manually with the existing tools we have is the best you're going to get. We are not going to invest time building extremely complicated features that only a tiny number of people would ever find useful, especially when those users can already do mostly the same thing with SEDE.
    – animuson StaffMod
    Commented Sep 5, 2020 at 20:43
  • Shortcut to get the user ID in the URL: middle-click on the mouse on the badge symbol in the upper right menu. Commented Dec 21, 2020 at 22:51
  • 1
    This query does not work anymore, it seems: Line 1: Invalid object name 'Data.StackExchangePOC.dbo.Posts'. Commented Feb 17 at 15:03
  • 2
    @questionto42 thanks for the comment, you've found a bug in the Data Explorer.
    – Glorfindel Mod
    Commented Feb 17 at 17:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .