Alteryx Case Studies PlusUp Boosts Efficiency and Reduces Errors with Google Cloud Dataprep

Edit This Case Study Record

	PlusUp Boosts Efficiency and Reduces Errors with Google Cloud Dataprep Alteryx

PlusUp Boosts Efficiency and Reduces Errors with Google Cloud Dataprep

Alteryx

Applicable Functions	Sales & Marketing
Use Cases	Leasing Finance Automation Time Sensitive Networking
Services	Cloud Planning, Design & Implementation Services
Challenge	PlusUp, a leading company in advertising consulting services on social networks, was facing a significant challenge in analyzing paid social media. The company was routing all social media data through Excel spreadsheets where it was standardized and stitched together for analysis. This manual, time-consuming process left PlusUp constantly playing catch up and spending more time on prep work than on the actual analysis. Furthermore, manual data preparation and cleaning is prone to error, which meant that PlusUp had to triple check its work. As PlusUp grew its business, it couldn’t see any obvious ways to scale this process except by hiring more analysts. Read More
About Customer	PlusUp is a leading company in the field of advertising consulting services on social networks. They provide thoughtful advertising consulting services on various social networks including Facebook, Instagram, YouTube, Snapchat, Pinterest, Twitter, and LinkedIn. PlusUp is known for its expertise in analyzing paid social media and delivering effective advertising strategies for its clients. The company operates in the data services industry and is based in North America. Read More
Solution	To overcome these challenges, PlusUp built a modern data stack using SaaS products found on the Google Cloud Platform. This included 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. Read More Log in to view content
Contents

Applicable Functions

Sales & Marketing

Use Cases

Leasing Finance Automation

Time Sensitive Networking

Services

Cloud Planning, Design & Implementation Services

Challenge

PlusUp, a leading company in advertising consulting services on social networks, was facing a significant challenge in analyzing paid social media. The company was routing all social media data through Excel spreadsheets where it was standardized and stitched together for analysis. This manual, time-consuming process left PlusUp constantly playing catch up and spending more time on prep work than on the actual analysis. Furthermore, manual data preparation and cleaning is prone to error, which meant that PlusUp had to triple check its work. As PlusUp grew its business, it couldn’t see any obvious ways to scale this process except by hiring more analysts.

About Customer

PlusUp is a leading company in the field of advertising consulting services on social networks. They provide thoughtful advertising consulting services on various social networks including Facebook, Instagram, YouTube, Snapchat, Pinterest, Twitter, and LinkedIn. PlusUp is known for its expertise in analyzing paid social media and delivering effective advertising strategies for its clients. The company operates in the data services industry and is based in North America.

Solution

To overcome these challenges, PlusUp built a modern data stack using SaaS products found on the Google Cloud Platform. This included 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.

Impact #1	The implementation of Google Cloud Dataprep has brought about significant operational improvements for PlusUp. The company has seen improved efficiency in its operations, with the same quantity of reporting now requiring significantly less analyst time. This has freed up analyst time and shifted their focus toward revenue-driving activities, such as onboarding new customers onto the PlusUp solution. Furthermore, the ability to reuse standard Google Cloud Dataprep recipes across clients has ensured more accurate results and better social media recommendations. This has not only reduced errors but also improved the quality of the company's services.

Impact #1

The implementation of Google Cloud Dataprep has brought about significant operational improvements for PlusUp. The company has seen improved efficiency in its operations, with the same quantity of reporting now requiring significantly less analyst time. This has freed up analyst time and shifted their focus toward revenue-driving activities, such as onboarding new customers onto the PlusUp solution. Furthermore, the ability to reuse standard Google Cloud Dataprep recipes across clients has ensured more accurate results and better social media recommendations. This has not only reduced errors but also improved the quality of the company's services.

Benefit #1	99.5% Faster at preparing marketing data
Benefit #2	180 Hours Per week of analyst time saved
Benefit #3	Reduced the time spent on reporting from 180 hours per week to one hour per week

Benefit #1

99.5% Faster at preparing marketing data

Benefit #2

180 Hours Per week of analyst time saved

Benefit #3

Reduced the time spent on reporting from 180 hours per week to one hour per week

Download PDF Version

Overview

PlusUp Boosts Efficiency and Reduces Errors with Google Cloud Dataprep

Operational Impact

Quantitative Benefit