Case Study: the7stars achieves automated client reporting and centralized marketing data with Funnel

the7stars - Customer Case Study

The 7 Stars is the largest independent media agency in the UK (172 employees, £250M billing) that was spending hours on manual Excel reporting—Account Managers downloading CSVs from multiple ad platforms and building pivot tables, producing clunky client reports. Seeking to centralize marketing data in Google BigQuery and automate reporting across a wide mix of platforms, The 7 Stars evaluated options and chose Funnel to provide platform connectors and data pipeline automation.

Funnel automatically connected the agency’s ad platforms to Google BigQuery and fed clean data into Tableau, cutting client onboarding to under 2 hours and automating data exports, transformations and client reports. For a major client (Nintendo) the solution eliminated roughly 16 man-hours per week of manual work, enabled live interactive dashboards for clients within four days, and let The 7 Stars focus Account Managers on optimization rather than data wrangling.

the7stars

Johnathan Romero

Head of Analytics