Supercharging Reporting for Rooster and Its Clients
Goodway’s data science and analytics team created a cost-effective, 24/7-accessible custom reporting solution for Rooster, an agricultural creative agency, with key metrics for client campaign results and flexibility for client dashboards — bringing Rooster and its clients valuable benefits.
When Rooster first started working with Goodway as its media execution partner, this agency was looking for a reporting solution that was customizable, more robust and didn’t require a lot of time to build. Rooster’s reporting was handled by a third-party company with fees that often exceeded planned costs for maintaining reporting needs, adding in new data sources or creating customized reports for varying client needs. Rooster’s dashboards had data limitations; the agricultural agency did not have control over them. Plus, Rooster was limited in the data sources it could pull in, and the timing of the data wasn’t consistently updated and could take longer than expected for clients to see key metrics. Because of the added fees, data and reporting limitations and timeliness of the data, agency staff often spent hours building reports manually for clients, taking away valuable time from servicing campaigns.
Goodway immediately offered to find a better solution for Rooster. Members of our data science and analytics team met with Rooster to talk through the agency’s challenges, goals and data sources. We created a customized solution that delivered on all of Rooster’s reporting needs. Over a 12-week onboarding process, Goodway built a custom agency dashboard and individual dashboards for all of Rooster’s clients that evaluated all data sources, were tested for data accuracy, and built upon the data dashboards they already had to make the transition process as smooth as possible. We set up data pipelines to bring in the data they previously used, all of Goodway’s managed service media data (display, social, SEM, etc.) and additional data sources such as GA4 and The Trade Desk, plus first-party data sources like email and text marketing.
Rooster now has access to a reporting solution that’s seamless to access, updates in real time, has the connectivity to import data from any platform, loads faster, and has an easy-to-use UX allowing for quick and easy data visualizations that can be customized for clients. Moreover, each of Rooster’s clients has access to their own reporting dashboard. Rooster also is not burdened with additional custom reporting costs and can now invest more of its clients’ advertising dollars into working media. Beyond being able to access all their desired reporting sources, Rooster can also access crucial geographic data through The Trade Desk that shows performance by state or zip code at both the advertiser and campaign level. Rooster doesn’t have to generate monthly reports or pull data from disparate sources anymore. Everything is completely automated. The staff also saves valuable time reporting: James Arnold, the chief digital officer at Rooster, estimated that what took five hours for one client now takes only one.
Key Outcomes
Through the new reporting solution offered by Goodway, Rooster delivers a better service to its clients and is more poised to onboard new clients since setting up new dashboards takes a fraction of the time (and zero additional costs) compared to the agency’s original third-party reporting solution. With the time saved from reporting, Rooster can now spend more time activating on the learnings in the reports as well.
2 FTEs
estimated equivalent in cost savings