Can I export data about my journal?
Scholastica provides some basic Peer Review analytics for your journal on a rolling basis, but what if you need to look into a particular time period of activity or answer a question not covered in those analytics?
When those occasions arise, you can reach out to us at firstname.lastname@example.org to request a pull of your journal's raw data. Scholastica will, upon request, provide you with a .csv of your journal's data which you can then manipulate to do any reporting you may need.
Please note: We will provide you with the data for your journal, but we cannot assist you in creating Excel formulas to manipulate your data or answer specific questions. Luckily, there are a lot of resources on the internet that can help you with answering those questions instead! Just search "Excel help" or "Google Sheets help" to pull up resources.
What data do you provide?
The .csv includes 10 separate sheets, each of which is described below:
- Reviewer Invitations
The first page of the data pull answers some commonly asked questions like "How many submissions (not including revisions) did I receive this year?", "How long, on average, did it take us to make a desk rejection decision this year?"
You can look at those metrics for different years by manually typing in a different year in the "Year" column.
The Manuscripts sheet displays all information to do with manuscripts submitted to your journal — including revised versions.
The Decisions sheet includes basic information about when you've made decisions, what type of decisions you've made, and the ID of the manuscript for which that decision was issued.
The Reviewers sheet includes information around all reviewers whom you've invited to review any content for your journal. Whether or not they've ever accepted a review invitation, if they've been invited to review something on Scholastica for your journal, they'll appear on this sheet.
The Reviews sheet includes basic information about submitted reviews — including when they were submitted, which reviewer, and what their recommendation was.
The Reviewer Invitations sheet includes basic information around the reviewer invitations you've sent — including when they were sent, the submission to which they're attached, the original due date of the reviewer invitation, etc.
The Authors sheet includes basic information around all authors who have a submission on your journal's account. Please note: Non-submitting authors are also included in the Authors sheet if their information was added by the submitting author during upload.
Only pertinent for journals that publish on Scholastica: The Articles sheet includes basic information about articles you've created on Scholastica, including their publishing status, abstract, links to the URLs of their PDFs, etc.
Only pertinent for journals that publish on Scholastica: The Issues sheet includes basic information about issues you've created on Scholastica, including their publication date, volume and issue number, etc.
Only pertinent for journals that publish on Scholastica: The Posts sheet includes basic information about blog posts you've created on Scholastica, including their title, publication date, short description, etc.