How We Did It: Custom Reporting

Posted by: Bri Guarnieri Date Posted: November 8, 2024
Back to Case Studies

Issue

The client wanted simplicity when it cames to graphs and filtering – something easy to understand and minimal clutter.

Solution

I created two custom reports! One of which was shared during the meeting – https://lookerstudio.google.com/reporting/dc37c90b-846e-4879-84f7-941a507e676a. This report makes easy filtering for the client and answers for him: how many deals came from ‘x’ channel? What is the associated value?

The other was shared just recently – https://lookerstudio.google.com/reporting/a19fc01b-d40e-46e8-802e-65b0325bfa77. This highlights the key metrics that are most important to him based on our discussions together!

  1. Revenue Value at each Stage of the Pipeline
  2. Number of Deals from each Sales Rep
  3. Revenue Value from each Sales Rep
  4. Channel Revenue Metrics
  5. Initial Lead Event Breakdowns

Sales performance is a big thing for him! He wants accuracy and to track their performance. He was also really curious on where deals are originating from on the deal level. In MCFX, it’s less clear for clients – calls are labeled PPC & SEO, alongside form names. I have had numerous instances of confusion for clients & this cleared it up!

Overall, the client left super happy!

Achievement

We had a new POC at Tracked Lifts that came into the CMO role! He was taking over with little experience in HubSpot and a completely fresh mindset when it came to MarketingCloudFX and the information that he wanted to see. On the AM and client’s annual strategy meeting, the AM highlighted some of the metrics that he was looking for & great for passing along to higher ups.

Snippet/Screenshot/Link