Custom Reporting on Deals Data for Original Channel AND Enter Page Drill Down

Posted by: Melissa Shoff Date Posted: March 12, 2024
Back to Case Studies

Issue

The client POC was very interested in developing a deep understand of what was driving contacts who would become customers to their site. They wanted to know not only MROI channel attribution, but also first visit details like source, medium and enter page details. Additionally, they wanted to know the ROI then of these layers!

Solution

A custom Looker Studio report was recommended!

Our best option for the immediate needs of the client were to showcase the Deals Data using available dimensions in Looker to filter down to first visit (FV) source, medium and channel then layer in a GA4 funnel report. To get down the the enter page per channel, we had to export data from Customer360FX focused on New Customer contact stage updates and then systematically pulling the first enter page details from the latest activity report of each contact’s journey. Once the sheet was fully configured we’d need to sync it as a data source in the client’s Looker Studio report.

Achievement

With this highly custom report, we could tell the client what their highest driving landing pages where per channel in terms of closed won revenue of new customers.  In this example, we were able to high light a few things!

  • Paid Search’s landing page for wall bunk beds was the highest performing page ($59,330 in closed won revenue of new customers) followed by the wall beds landing page ($56,182).
  • Direct traffic to the home page drove a higher closing revenue ( $55,867) than SEO organic to the same page ($31,513). PPC drove one of the lowest ($2,420).
  • The wall beds with sofa page drove a higher conversion value when entered from PPC ($14, 224) than from SEO ($12,634).

The goal of this type of highly custom report is to help the client POC fell more confident in the campaigns they invest in as well as the strategies recommended to focus on specific pages and elements of the site over others in terms of landing page usage and monthly on-page optimizations.

Snippet/Screenshot/Link

https://lookerstudio.google.com/reporting/9826b17b-5efe-4369-a987-cfa10209b98e