"Days in Status" Export

Admins are able to track how Submissions are progressing through Statuses by exporting one of our available reports. These exports are available at the System-, Community-, and Initiative-levels.

Each day will start counting at 12am UTC the day of submission to the next day 12am.

• For example if a Submission is created at 11pm UTC Wednesday, then at 12am UTC on Thursday it will begin its first countdown. Admins will then see "1 Day in Status" at Friday 12am UTC. 

Two types of exports are available:

• Submission Days in Status: This shows how long individual submissions stayed in custom and system statuses

  • Export columns:

    1. Code

    2. Title

    3. Category

    4. Status: The current status of the submission

    5. Submitted: The date the submission was submitted

    6. Days since Submitted: The number of days from submission to today (when the report is generated)

    7. Days in “[STATUS]”: For each custom status, the number of days that the submission was in that status

       1. One column should appear for each status in the Initiative

    8. Total days in Active system statuses: Total number of days the submission was in statuses with an "Active" system status; this should be aggregated across multiple statuses sharing the same “Active” system status

    9. Total days in Paused system statuses: Total number of days the submission was in statuses with a "Paused" system status; this should be aggregated across multiple statuses sharing the same “Paused” system status

    10. Time to Closed system statuses: If the submission is currently in a “Stopped” or “Complete” system status, the total number of days between submission and the when it is moved to a “Stopped” or “Complete” system status

    11. User Name: Submitter user name

    12. User Email

    13. Member ID

• Status Summary: This shows at the initiative-level the average time that submissions stayed in custom and system status

  • Export columns:

    1. Submissions in "[STATUS]”: For each custom status, the number of submissions currently in that status

    2. Average days in “[STATUS]”: For each custom status, the average number of days submissions were in that status

       • NOTE: Submissions in “[STATUS]” and Average days in “[STATUS]” columns should always be paired together for each status (e.g. Submissions in “Open”, Average days in “Open”, Submissions in “Paused”, Average days in “Paused”, etc.)

    3. Submissions in Active system status: Number of submissions moved to a “Active” system status

    4. Average days in Active system status: Average number of days that submissions remain "Active" system statuses

    5. Submissions in Complete system status: Number of submissions moved to a “Complete” system statuses

    6. Average days to Complete system status: Average number of days between submission date to being moved to “Complete" system statuses

    7. Submissions in Stopped system status: Number of submissions moved to a "Stopped" system status

    8. Average days to Stopped system status: Average number of days between submission to being moved to "Stopped" system statuses

    9. Average days to Closed system status: For submissions currently in a “Stopped” or “Complete” system status, the average number of days before submissions are moved to either a “Stopped” or “Complete” system status

Important Note:

• Excel enforces a 30,000 character limit per cell for exported XLSX files; additional characters will be truncated.
• There is no character limit per cell for CSV exports.