Custom Looker Report to Speak My Client’s Language

Posted by: Gina Bennett Date Posted: May 30, 2024
Back to Case Studies

Issue

The POC at COCOON tends to need things spelled out exactly for her.   They use Monday as a CRM / Project Management tool, which means they don’t use terms like “Deals” or “MQLs”.  They do use terms like “leads” and “qualified leads”, but they don’t use them the same way we do.

The first draft of the report, which included KPIs like MQLs and Deals Opened, meant nothing to her and confused her.  The AM also didn’t understand the terminology, which made the issue even worse.  As the POC said “I want a report I can understand and present to the board.  Presenting this will confuse us more and make us lose trust with WebFX and your reporting.”

Solution

I joined a reporting call with the client to chat through the previous report and redefine exactly what she wanted reporting on as well as the definitions she uses for each.

We ended up with:

  • Total Calls/Forms fills = total forms and calls from LMFX and CTFX
  • Opened Leads in Monday = deals opened in MCFX
  • Qualified Leads in Monday = deals opened in MCFX in specific stages
    • created a custom filter (ss) for the Deals endpoint
  • Contracts Signed in Monday = Closed Won deals in MCFX
  • CPLs = total opened (or qualified) leads / investment

Since this client is very in the weeds with their day-to-day sales, I also added charts to list each person that fits under each category (ss).

Finally, to be 100% sure that everyone is on the same page about what each metric is referring to, I created an appendix/key at the end of the report (ss), which I linked on the actual report page for quick reference (ss).

While I don’t think every client needs quite this level of customization, the minor terminology changes and creating an appendix was super helpful to build back the relationship for this client!

Achievement

Created a report the client can understand that conveys how our campaigns are preforming.