Can I export data about my journal?
Overview
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, your journal's admin editor can pull your journal's raw data as a series of .csv files which you can then manipulate to do any reporting you may need. Scroll down to "How do I request my journal's data?" for more details.
Please note: 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 zip file that you receive includes 10 separate .csv sheets, each of which is described below:
- Activities
- Articles
- Authors
- Decisions
- Issues
- Manuscripts
- Posts
- Reviewer Invitations
- Reviewers
- Reviews
Activities
The Activities sheet includes all of the peer review-associated activities shown in the Journal Activity Feed on the Peer Review side of your Scholastica account. Activities include things like: Edward Editor sent an editor invitation to scholar@university.edu and Silvia Scholar updated a reviewer invitation template.
Articles
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.
Authors
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.
Decisions
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.
Issues
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.
Manuscripts
The Manuscripts sheet displays all information to do with manuscripts submitted to your journal — including revised versions.
Posts
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.
Reviewer Invitations
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.
Reviewers
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.
Reviews
The Reviews sheet includes basic information about submitted reviews — including when they were submitted, which reviewer, and what their recommendation was.
How do I request my journal's data?
The admin editor for your journal account can request your journal's raw data at any time by navigating to My Journals > Settings > Data Export > Then clicking Export Data.
A link to download your data will be emailed to the admin editor's email address. Please note that the download link is only active for 7 days.
