To complete the same quantity of reporting, PlusUp went from spending 180 hours of analyst time per week under Excel to one hour of analyst time per week with Google Cloud Dataprep.
Customer Story
PlusUp Empowers Marketers to Drive Business Growth with Google Cloud Dataprep
PlusUp Key StatsIndustry
: Data ServicesData Stack
: Google Cloud , Google Cloud Dataprep, BigQuery, Fivetran, Data StudioRegion
: North America
99.5%
Faster at preparing marketing data
180 Hours
Per week of analyst time saved
Core Challenges
Analyzing paid social media isn’t finite; as soon as one campaign ends, there are always more or new ads to run and assess. Previously, PlusUp routed all social media data through Excel spreadsheets where it was standardized and stitched together for analysis. But this manual, time-consuming process left PlusUp constantly playing catch up and spending more time on prep work than on the actual analysis. Worse yet, manual data preparation and cleaning is prone to error, which meant that PlusUp had to triple check its work—there were no cutting corners to save time. And as PlusUp grew its business, it couldn’t see any obvious ways to scale this process (except by hiring more analysts).
How Cloud Dataprep Solved this Problem
PlusUp built a modern data stack using SaaS products found on the Google Cloud Platform—Fivetran for data integration, BigQuery for storage, Google Cloud Dataprep for data engineering, and Data Studio for reporting and visualization. Instead of going back and forth between various Excel spreadsheets, PlusUp now has a “one stop shop” for all analytics on Google Platform that even its most novice analysts can operate. With Google Cloud Dataprep’s automation and scheduling features, PlusUp delivers in record time client analyzes thanks to automated data preparation. This has saved numerous hours in analyst time and the risk of data quality errors has dropped down to near zero.
Benefits
Improved Efficiency
Reduced Costs
Automation in Google Cloud Dataprep freed up analyst time and shifted their focus toward revenue-driving activities, such as onboarding new customers onto the PlusUp solution.
Reduced Errors
The ability to reuse standard Google Cloud Dataprep recipes across clients ensured more accurate results and better social media recommendations.
Company Background
PlusUp is among the elite companies delivering thoughtful advertising consulting services on social networks including Facebook, Instagram, YouTube, Snapchat, Pinterest, Twitter and LinkedIn.
Watch Webinar
Accelerating Marketing Analytics Time-To-Value by 99.5% at PlusUp With the Google Cloud Ecosystem
The beauty of Google Cloud Dataprep is that it’s very easy to use. We have people that don’t know how to write a line of SQL who are able to prep data at a pretty large scale, all because the interface is so easy to use
James Wilcox, Managing Partner
plus up
15 MINUTES OR LESS
Assess Your Analytics Maturity
Get a better understanding of where you stand on the analytics maturity scale – and where you want to be.
Get Started
Recommended Resources
Customer Story
BODi Supports Customer Health with Alteryx and Snowflake
BODi’s self-service analytics environment, powered by Snowflake and Alteryx, efficiently delivers meaningful insights to users across the organization.
Read Now
Customer Story
McLaren Racing fast tracks data analytics in the race to accelerate
McLaren Formula 1 team consolidates 11.8 billion data-points to maximize race performance.
Read Now
Customer Story
SearchKings Increases their Customer Base with Google Cloud Dataprep
SearchKings built data flows that introduced proprietary KPI that leverage data sets from various sources with Google Cloud Dataprep.
Read Now