One of our analytics volunteers rolled up her sleeves and began automating quarterly and monthly reports, extensive data analysis work that was previously done manually by their team. The data for the reports came from a variety of sources like Google Analytics, Facebook, Facebook Ads, Mailchimp, Pardot, Salesforce, and Eventbrite. Our volunteer was also able to incorporate data from their newest media bureaus in Newark and Chicago into their automated spreadsheets, a long-term goal for Chalkbeat.
Chalkbeat had never seen their data so in-depth before, often distracted by the sheer process of simply gathering their data, and this project helped them realize that they still needed a solution to a larger problem – generating effective insights from their data. This led them to begin seeking out paid consulting work to pair with our PBA volunteer’s technical abilities.
They kept the volunteer focused on the technical aspects of getting the reporting automation up and running while deciding to incorporate a paid consultant to help with the insights. Their reason for doing so was that this was going to be a more intense engagement than they deemed appropriate to ask of a volunteer. They needed a consultant with deeper industry knowledge of marketing and media with a very current understanding of Google Analytics – the consultant they found was being considered for a permanent role. Chalkbeat is excited to be in a position with full report automation for all their various systems and with future plans for concrete recommendations to improve their editorial and product work.