Return to Question

• What percent of the time is my answer accepted?
• How many views does a particular tag generate for the site?
• During a period where the site was running a promotion, how much activity did we see around a promoted tag?
• Am I upvoted or downvoted more on average than other people?

I found myself asking questions along these lines relatively frequently, and with my knowledge of the API I could usually whip up a quick custom "throwaway" tool to answer them with real, live data. This is the result of an experiment to generalize those throwaway tools into something that might have wider appeal.

If you wanted to find out how many questions a site has that have score less than zero, you could set up a "Questions" query with "Max Score" equal to -1, and "Users" set to "Everyone."

• What percent of the time is my answer accepted?
• How many views does a particular tag generate for the site?
• During a period when the site was running a promotion, how much activity did we see around a promoted tag?
• Am I upvoted or downvoted more on average than other people?

I found myself asking questions along these lines relatively frequently, and with my knowledge of the API, I could usually whip up a quick custom "throwaway" tool to answer them with real, live data. This is the result of an experiment to generalize those throwaway tools into something that might have wider appeal.

If you wanted to find out how many questions a site has that have a score less than zero, you could set up a "Questions" query with "Max Score" equal to -1, and "Users" set to "Everyone."

To load the application, click this link.

BSD 2-clause. Source code is available from this BitBucket repository.

To load the application, click this link.

BSD 2-clause. Source code is available from this GitHub repository.

StatsExchange is an app that's designed to leverage the filtering and data reporting features of the StackExchange API. With StatsExchange, you can quickly and easily generate statistics on just about any question or answer metrics that you can filter on using the API.

Sometimes you've got a question about the SE sites you frequent. For example:

I found myself asking questions along these lines relatively frequently, and with my knowledge of the API I could usually whip up a quick custom "throwaway" tool to answer them with real, live data. This is the result of an experiment to generalize those throwaway tools into something that might have wider appeal.

You can think of it as a similar tool to Stack Exchange Data Explorer but designed with a less-technical audience in mind, and focused more on "instant gratification." If you feel comfortable with SQL along with the StackExchange DB schema, and you don't mind the fact that the data's a bit stale, the Data Explorer site has a wealth of information and can help you answer many different questions.

Sometimes, though, there are questions that the API could answer better, faster, and with fresher data. The purpose of this app is to make interfacing with this data easier.

To load the app, click this link.

Start by clicking the "Add New" button. This will allow you to specify the name of the query you wish to create, and set the filtering options.

You can specify multiple tags - they will be logically AND'ed by the API. Therefore, ALL tags in a query must appear on a question for it to show up in the final count.

Once you've set up the query, you can run it by pressing the "refresh" button, or "edit" or "remove" it if you need to make changes or are finished with the query. When a query is running, you can "Abort" it if it's taking too long or you need to make changes.

You can create as many queries as you like, and use them to compare and contrast different aspects of data. For instance, you might be interested in comparing the statistics of a set of users, or of a set of tags.

If you'd like to share a query or set of queries with others, you can use the "Import/Export" dialog to print the queries in JSON, which you can then copy and paste to chat or email, if you so desire. The queries are saved in your browser's local data storage until you clear them.

###Caveats/Known Issues/Limitations

The filtering on tags only works at the API level for "Questions" by "Everyone" - so if you're expecting to do a "Answers" by "Everyone" query and filter it by tags, you'll have to load every answer and question on the site in order to do this. This is likely to take far too long to be useful in any normal situation. Limiting the query's scope by other means would be a good idea.

I'd like to figure out a way to expose more of the data collection and reporting aspects for people to add their own statistics and tracking information. This would make it possible to add your own columns displaying custom data to the report.

BSD 2-clause. Source code is available from this BitBucket Repo.

If you run into bugs, come find me using the chat system. This is one of the more complex apps I've built, so it's likely to have its fair share of issues.

StatsExchange is an application that's designed to leverage the filtering and data reporting features of the Stack Exchange API. With StatsExchange, you can quickly and easily generate statistics on just about any question or answer metrics that you can filter on using the API.

Sometimes you've got a question about the Stack Exchange sites you frequent. For example:

I found myself asking questions along these lines relatively frequently, and with my knowledge of the API I could usually whip up a quick custom "throwaway" tool to answer them with real, live data. This is the result of an experiment to generalize those throwaway tools into something that might have wider appeal.

You can think of it as a similar tool to Stack Exchange Data Explorer but designed with a less-technical audience in mind, and focused more on "instant gratification." If you feel comfortable with SQL along with the Stack Exchange database schema, and you don't mind the fact that the data's a bit stale, the Data Explorer site has a wealth of information and can help you answer many different questions.

Sometimes, though, there are questions that the API could answer better, faster, and with fresher data. The purpose of this application is to make interfacing with this data easier.

To load the application, click this link.

Start by clicking the "Add New" button to specify the name of the query you wish to create, and set the filtering options.

You can specify multiple tags - they will be logically AND'ed by the API. Therefore, ALL tags in a query must appear on a question for it to show up in the final count.

Once you've set up the query, you can run it by pressing the "refresh" button, or "edit" or "remove" it if you need to make changes or are finished with the query. When a query is running, you can "Abort" it if it's taking too long or you need to make changes.

You can create as many queries as you like, and use them to compare and contrast different aspects of data. For instance, you might be interested in comparing the statistics of a set of users, or of a set of tags.

If you'd like to share a query or set of queries with others, you can use the "Import/Export" dialog to print the queries in JSON, which you can then copy and paste to chat or email, if you so desire. The queries are saved in your browser's local data storage until you clear them.

###Caveats, Known Issues, and Limitations

The filtering on tags only works at the API level for "Questions" by "Everyone" - so if you're expecting to do a "Answers" by "Everyone" query and filter it by tags, you'll have to load every answer and question on the site in order to do this. This is likely to take far too long to be useful in any normal situation. Limiting the query's scope by other means would be a good idea.

I'd like to figure out a way to expose more of the data collection and reporting aspects for people to add their own statistics and tracking information. This would make it possible to add your own columns displaying custom data to the report.

BSD 2-clause. Source code is available from this BitBucket repository.

If you run into bugs, come find me using the chat system. This is one of the more complex applications I've built, so it's likely to have its fair share of issues.