CUSTOMER STORY
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).
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.
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
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
The ability to reuse standard Google Cloud Dataprep recipes across clients ensured more accurate results and better social media recommendations
PlusUp is among the elite companies delivering thoughtful advertising consulting services on social networks including Facebook, Instagram, YouTube, Snapchat, Pinterest, Twitter and LinkedIn.
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.
