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

Leadership |
Digital Marketing
Josh Barwa
Harnessing Synergy: Why Complimentary Agencies Should Partner with Be Found Online
August 17, 2023
Read More
B2B Brands |
Digital Marketing |
B2C Brands
Josh Barwa
The Power of Marketing: Why It's an Investment and Not an Expense
July 06, 2023
Read More
Content Marketing
Kyle Geib
Digital Burnout & How to Combat it In Your Marketing Strategy
June 22, 2023
Read More

Data and Analytics |
B2B Brands |
B2C Brands
The BFO Team
Why You Should Be Worried About Google Analytics 4
April 28, 2023
Read More
Content Marketing |
Digital Marketing
Kyle Geib
How to Avoid Manipulation in Your Marketing Messaging
April 21, 2023
Read More

SEO |
B2B Brands |
B2C Brands
Jon Pappas
Google Core Algorithm Update: March 2023
March 28, 2023
Read More
Curtiss Gulash
What Paid Media Can Learn from SEO Keywords (and Vice Versa) - Sharing Insights for More Intelligent Campaigns
March 25, 2023
Read More
B2C Brands |
Digital Marketing |
ECommerce
BFO
10 Quick Tips for Maximizing Holiday E-Commerce Revenue
October 28, 2021
Read More


B2B Brands |
B2C Brands |
Digital Marketing
BFO
Digital Marketing Predictions for 2023
December 08, 2022
Read More
B2B Brands |
B2C Brands |
Digital Marketing
BFO
DIY Marketing: Express Strategic Planning
January 01, 2022
Read More
B2B Brands |
B2C Brands |
Digital Marketing |
Paid Search
BFO
Finding Digital Success in Uncertain Times
June 21, 2023
Read More


B2C 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 More
B2B 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 More.png?width=339&height=179&name=Webinar%20Banner%20(1).png)
Digital Marketing |
SEO
BFO
Are You Ready for the May Google Algorithm Change?
May 25, 2021
Read More
B2B 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 More

Acccount-Based Marketing |
B2B Brands |
Digital Marketing |
Paid Social
BFO
Personalizing Your B2B LinkedIn Marketing Strategy
June 24, 2021
Read More.png?width=339&height=179&name=July%20Webinar%20(Newsletter).png)

B2B Brands |
B2C Brands |
Paid Search |
Paid Social |
Data and Analytics
BFO
Recover Facebook Advertising Tracking Data with Conversion API
September 30, 2021
Read More
.png?width=339&height=179&name=Webinar%20Banner-April-02%20(1).png)
B2B Brands |
Paid Search
BFO
Secrets for Effective B2B Audience Targeting with Google Ads
April 22, 2021
Read More%20(4).png?width=339&height=179&name=Webinar%20Banner-May-02%20(1)%20(4).png)



B2B Brands |
B2C Brands |
Digital Marketing |
SEO
BFO
The Intersection of Brand & Digital Marketing
August 26, 2021
Read More
Digital Marketing |
SEO
BFO
Tools & Technology to Develop a Successful SEO Strategy
February 08, 2022
Read More.png?width=339&height=179&name=March%202023%20Webinar%20Ad%20(autoresponder).png)
Data and Analytics
BFO
Universal Analytics to Google Analytics 4: What to Know
May 26, 2022
Read More
Data and Analytics
BFO
Why You Should be Worried About Google Analytics 4: Webinar Replay
March 29, 2023
Read More
Acccount-Based Marketing |
B2B Brands |
Software & SaaS
BFO
Account-Based Marketing Best Practices for B2B SaaS Marketers
August 31, 2020
Read More
B2B Brands |
B2C Brands |
SEO
BFO
B2B + B2C Brand Guide to Search Marketing
September 10, 2021
Read More
Digital Marketing |
SEO
BFO
Biggest Challenges to SEO Success and How to Overcome Them
February 09, 2020
Read More

B2B Brands |
Digital Marketing
BFO
Four Simple Ways to Optimize Lead Generation Strategies
July 22, 2021
Read More
Acccount-Based Marketing |
Digital Marketing |
Paid Social
BFO
LinkedIn Account-Based Marketing: The Quick Start Guide
April 14, 2020
Read More
Acccount-Based Marketing |
B2B Brands |
Digital Marketing
BFO
Managing & Maximizing Lead Generation Success
March 26, 2021
Read More
B2B Brands |
B2C Brands |
Digital Marketing |
Leadership
BFO
Marketer's Guide to Healthy Agency Relationships
July 06, 2021
Read More
Digital Marketing |
Software & SaaS
BFO
SaaS Marketer's Guide to Digital Marketing Success
June 07, 2021
Read More


B2B Brands |
Digital Marketing |
SEO |
Data and Analytics
BFO
SHI Case Study
June 01, 2020
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 More