Case Study
HOW WE IMPLEMENTED DATA STUDIO FOR CLIENT'S PARTNER PROGRAM, SAVING 117 HOURS PER QUARTER
The client, SHI, is a provider of technology products and services, headquartered in Somerset, New Jersey. SHI has academic, corporate, enterprise, and public sector customers. From software and hardware procurement to deployment planning, configuration, data center optimization, IT asset management, and cloud computing, SHI offers custom IT solutions for every aspect of the business environment.
SHI works with many top brand partners that request quarterly reporting to see how their pages are performing on the SHI site. These reports help influence campaigns the partners run through SHI to increase revenue for their products.
THE CHALLENGE
In 2016, during the infancy of SHI's partner program, reporting was annually compiled to summarize top-line stats including landing page screenshots, page referral traffic, impressions, clicks, and keywords. This reporting was time-intensive for the client as a single report took them, on average, 30-40 minutes from start to finish. Initially, this was not a problem for SHI, because it allowed the team to develop a deeper understanding of how all the metrics interacted in each system.
As the partner program began taking off, reporting was becoming unmanageable; with so many partners needing individual reporting and manual pulling from several Google Analytics custom reports, the client spent roughly 33 hours each quarter just to create the reports.
In 2019, when the client started working with their Austin division:
- They added another 43 reports to their current 177 they were running
- Of these reports, 21 were added in Q4 of 2019
- Google Analytics reporting was confusing
The client began using finite BFO consulting hours on questions about the data:
- What do data points mean?
- Was the data accurate?
Countless Google Analytics reports meant the same users needed to complete the reporting each month to understand which reports were used, and how they were input into the client's own reporting out to their partners.
THE SOLUTION
BFO proposed working closely with the client to move partner reporting to Data Studio, which would automate the reporting process and simplify it as any member of the client's team could handle the task.
A massive time saver, this also meant no more manual pulling of Google Analytics reports and no more confusion in reading them.
Together, BFO and the client created a custom Data Studio report that fit the client's needs. We started with a skeleton report that wasn't being used by the client, as it simply didn't work with their specific needs.
After meeting with the client's analyst to discuss what they currently provided and also what they aren't able to show partners, BFO worked to add these elements into Data Studio to pull automatically from their Google Analytics account.
With our experience in knowing what's important to a lot of clients, we started designing the template with other visuals and metrics the client may want to eventually provide to their partners. BFO created different page design options so the client could easily select what they like, and what they didn't.
Approximately one month in, these new reports were in a working format, allowing the client to introduce them to partners, converting them to the new style of reporting. These reports focused solely on Google analytics data.
Soon, the client wanted to add LinkedIn and Google Ads data into the dashboards for partners that were running campaigns. We continued our previous process of understanding what needed to be shown, designing layout options, receiving feedback, and adjusting - a whole lot of adjusting - to meet the client's needs.
THE RESULTS
"BFO's implementation of dashboards using Data Studio for our partner program has saved time, money, and our sanity! we were using a very archaic way of reporting and knew we needed to change. It was just a matter of finding the time to commit to revamping the process. Knowing what we know now, we wish we had migrated sooner. Instead of wasting time manually piecemealing reports together, we now use our time productively by providing valuable guidance to our partners with rich data provided in the dashboards. It has made working in this field exciting again - instead of feeling bogged down by mindless tasks."
RELATED ARTICLES
Paid Search |
Digital Marketing |
B2C Brands
Scott Diebel
Pmax Strikes Back
October 08, 2024
Read MorePaid Search |
Digital Marketing |
B2C Brands
Curtiss Gulash
Pumpkin Spice & Everything Nice: Fall Preparations for Holiday Shopping Season
October 03, 2024
Read MoreSEO |
Content Marketing
Jon Pappas
Site Speed Matters: Optimizing Your Website for Performance and SEO
September 24, 2024
Read MoreDigital Marketing
Kyle Geib
Marketing Resources We Love: Books, Blogs, Events, and Courses That Inspire Us
September 13, 2024
Read MoreSEO |
Content Marketing
Kyle Geib
Semrush's New AI Overview Tracking: A Game-Changer for SEO
September 06, 2024
Read MoreSEO |
Content Marketing
Jon Pappas
The New Rules of Content Optimization: Moving Beyond Keywords
September 05, 2024
Read MorePaid Social |
Paid Search
Curtiss Gulash
Paid Search vs. Paid Social: Choosing the Right Strategy for Your Goals
August 30, 2024
Read MorePaid Search |
Content Marketing |
Digital Marketing
Curtiss Gulash
What Is a Landing Page and Why are They Important?
August 21, 2024
Read MoreB2C Brands |
Digital Marketing |
ECommerce
BFO
10 Quick Tips for Maximizing Holiday E-Commerce Revenue
October 28, 2021
Read MoreB2B Brands |
B2C Brands |
Digital Marketing
BFO
Digital Marketing Predictions for 2023
December 08, 2022
Read MoreB2B Brands |
B2C Brands |
Digital Marketing
BFO
DIY Marketing: Express Strategic Planning
January 01, 2022
Read MoreB2B Brands |
B2C Brands |
Digital Marketing |
Paid Search
BFO
Finding Digital Success in Uncertain Times
June 21, 2023
Read MoreB2C Brands |
Content Marketing |
Digital Marketing |
ECommerce |
Paid Search |
Paid Social |
SEO
BFO
Holiday Planning Starts NOW: Stay Ahead of Your Goals
September 22, 2022
Read MoreB2B Brands |
B2C Brands |
Content Marketing |
Digital Marketing |
Paid Search |
SEO |
Data and Analytics
BFO
Mastering the 2022 Pie: Assess your Digital Media Mix in the Post Pandemic World
December 09, 2021
Read MoreDigital Marketing |
SEO
BFO
Are You Ready for the May Google Algorithm Change?
May 25, 2021
Read MoreB2B Brands |
B2C Brands |
Content Marketing |
Digital Marketing
BFO
Not Your Grandma's Content Webinar: How Content Marketing Is Changing With User Behavior
June 30, 2022
Read MoreAcccount-Based Marketing |
B2B Brands |
Digital Marketing |
Paid Social
BFO
Personalizing Your B2B LinkedIn Marketing Strategy
June 24, 2021
Read MoreB2B Brands |
B2C Brands |
Paid Search |
Paid Social |
Data and Analytics
BFO
Recover Facebook Advertising Tracking Data with Conversion API
September 30, 2021
Read MoreB2B Brands |
Paid Search
BFO
Secrets for Effective B2B Audience Targeting with Google Ads
April 22, 2021
Read MoreB2B Brands |
B2C Brands |
Digital Marketing |
SEO
BFO
The Intersection of Brand & Digital Marketing
August 26, 2021
Read MoreDigital Marketing |
SEO
BFO
Tools & Technology to Develop a Successful SEO Strategy
February 08, 2022
Read MoreData and Analytics
BFO
Universal Analytics to Google Analytics 4: What to Know
May 26, 2022
Read MoreData and Analytics
BFO
Why You Should be Worried About Google Analytics 4: Webinar Replay
March 29, 2023
Read MoreAcccount-Based Marketing |
B2B Brands |
Software & SaaS
BFO
Account-Based Marketing Best Practices for B2B SaaS Marketers
August 31, 2020
Read MoreB2B Brands |
B2C Brands |
SEO
BFO
B2B + B2C Brand Guide to Search Marketing
September 10, 2021
Read MoreDigital Marketing |
SEO
BFO
Biggest Challenges to SEO Success and How to Overcome Them
February 09, 2020
Read MoreB2B Brands |
Digital Marketing
BFO
Four Simple Ways to Optimize Lead Generation Strategies
July 22, 2021
Read MoreAcccount-Based Marketing |
Digital Marketing |
Paid Social
BFO
LinkedIn Account-Based Marketing: The Quick Start Guide
April 14, 2020
Read MoreAcccount-Based Marketing |
B2B Brands |
Digital Marketing
BFO
Managing & Maximizing Lead Generation Success
March 26, 2021
Read MoreB2B Brands |
B2C Brands |
Digital Marketing |
Leadership
BFO
Marketer's Guide to Healthy Agency Relationships
July 06, 2021
Read MoreDigital Marketing |
Software & SaaS
BFO
SaaS Marketer's Guide to Digital Marketing Success
June 07, 2021
Read MoreB2B Brands |
B2C Brands |
Digital Marketing |
ECommerce |
Paid Search |
SEO
BFO
SEO Without Paid Media? Here's What You're Missing!
September 27, 2023
Read MoreB2C Brands |
Digital Marketing |
Display and Programmatic |
ECommerce |
Paid Search |
Paid Social |
Travel and Hospitality
BFO
I Mustache You a Question...
March 06, 2024
Read More60% Increase in Page 1 Keyword Rankings!
American Marketing Association of Chicago Case Study
February 19, 2024
Read More