July + August 2024 Data and Reporting

[kgkempe]

• [ ] Download Security Log for records

Prepare data for Tableau

Capture and prepare data from PMO reports

• [ ] Currently published/active challenges

• [ ] Challenges published

• [ ] Challenges created

• [ ] Number of submission by challenge

• [ ] List of user accounts "created"

• [ ] List of user accounts "deactivated"

• [ ] List of user accounts "reactivated"

• [ ] List of user accounts "decertified"

• [ ] List of user accounts "recertified"

• [ ] Download list of GovDelivery Challenge Followers

Capture and prepare data from social media platforms

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

Capture and prepare website data

• [x] Challenge.Gov Google Analytics
• [x] Challenge.Gov Search console
• [x] CitizenScience.Gov Google Analytics

  - [ ] Run full cycle to bring data into Tableau     Additional data sources

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

Monthly Presentation

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

[fbaloca]

Slides: https://docs.google.com/presentation/d/1v4bDFOnsKvwN4w2WMy_gIp8O9sxIwCP0KZzI4omDMAM/edit#slide=id.g2f798448b8b_0_3

[L-Bar11]

No longer able to download X/Twitter Analytics without a paid subscription.