Google Sheet Integration Leads to Increase Spend and Nutshell Opportunity!

Posted by: Melissa Shoff Date Posted: January 17, 2024
Back to Case Studies

Issue

Client has been using QuickBooks Enterprise which is a desktop version that doesn’t integration. The client was wanting to better understand the quality of their leads and ultimately the ROI of our marketing campaigns beyond just the ecommerce reporting we could provide them to justify spend and strategy.

Solution

We integrated with a Google Sheet to gauge the success of our SEO, Social, Email marketing, and PPC efforts.

Achievement

By doing this, we achieved amazing data on campaign performance and built a lot of trust with the COO about how data-driven our marketing campaigns are.

Data we found includes:

    • They closed 1,816 deals total in 2023, which totaled $980,192.
  • PPC accounted for 926 deals and $486K in revenue.
  • SEO accounted for 411 deals and $191K in revenue.
  • Email accounted for 17 deals and $5.5K in revenue.
  • Social accounted for 6 deals and $4k in revenue.
    • They invested $738,995 with WebFX during this time frame and received a 33% ROI.
  • They invested $553,001 into PPC during this time frame and received a -12% ROI.
  • They invested $148,180 into SEO during this time frame and received a 29% ROI.
  • They invested $4,800 into Email during this time frame and received a 17% ROI.
  • They invested $2,400 into Social during this time frame and received a 71% ROI.

With this information in hand the client has increased SEO spend being the best marketing strategy for their ROI. They are now also exploring Nutshell as an option for their CRM as they have decided to transitioning from QuickBooks Enterprise to QuickBooks Online!

Snippet/Screenshot/Link