September 2024 Data Reporting and Analysis

[kgkempe]

User story: As a Challenge.gov customer, I want to gain insights through data on Challenge.gov usage.

Acceptance Criteria: September data is captured, broader insights on the usage of Challenge.gov are identified and presented to drive program updates that lead to more challenges posted and more submissions through the platform.

• [x] Download Security Log for records

Prepare data for Tableau

Capture and prepare data from PMO reports

• [x] Currently published/active challenges
• [x] Challenges published
• [x] Challenges created
• [x] Number of submission by challenge
• [x] List of user accounts "created"
• [x] List of user accounts "deactivated"
• [x] List of user accounts "reactivated"
• [x] List of user accounts "decertified"
• [x] List of user accounts "recertified"
• [x] Download list of GovDelivery Challenge Followers

Prepare data from social media platforms

• [x] Challenge.Gov LinkedIn (multiple reports: Followers, Visitors, Content)
• [x] Challenge.Gov Facebook (multiple reports: Facebook, Hootsuite)
• [x] Challenge.Gov YouTube (multiple reports)

Capture and prepare website data

• [x] Challenge.Gov Google Analytics

• [x] Challenge.Gov Search console

• [x] CitizenScience.Gov Google Analytics

• [x] Run full cycle to update Tableau data

---

  Additional data sources

• [x] Office hours
• [x] Listserv
• [x] ZenDesk
• [x] Challenge.Gov Public Newsletter
• [ ] Challenge.Gov Federal Newsletter (quarterly)

Monthly Presentation

• [x] Review data, identify trends and insights
• [x] Prepare data presentation
• [x] Meet to review insights and make recommendations # #

[kgkempe]

Refine the submission data analysis