IntegrationsFX: Google Sheet

Posted by: Melissa Hostetter Date Posted: April 19, 2023
Back to Case Studies

Issue

The common use cases were unclear for FXers and for clients.

Solution

Benefits of Integrating with a Google Sheet:

  • Calculate marketing ROI & customer lifetime value
  • Sync CRM data to your online advertising campaigns
  • Ability to send highly targeted email campaigns through EmailMarketingFX

Common Integrations With a Google Sheet – An Overview:

  • Sync open, closed won, or closed lost in Rows to Customer360FX Deals 
  • We can also sync statuses such as qualified in Rows to Customer360FX Contact Stage

Common Integrations With a Google Sheet – In Detail:

  1. For these integrations, we sync to Customer360FX deals and/or Customer360FX.
    1. To sync with MarketingCloudFX deals we’ll need an export from your CRM that includes Name, email, phone, company (if applicable), opportunity ID (of job ID, deal ID, etc – whatever your CRM has), and opportunity stage or status (eg. closed won, closed lost, open)
      1. This calculates ROI.
      2. Note A and B (below) can be done together from a single Google Sheet.
    2. To sync with the MarketingCloudFX contact stage, we’ll need email, phone, and stage (eg. closed won, closed lost, qualified, etc).  This does not calculate ROI but does show the relationship of your Customer360FX contacts to your business so you can segment audiences for qualified leads, customers, etc.

Prerequisites for Google Sheets to Have a Successful Integration:

  • The client must be willing to update the Google Sheets with data on an ongoing basis.  At a minimum, this should be 1x a month.
  • Note that we keep these as basic as possible since there is manual work involved.  The more basic these are the more reliable they are in turn.

Achievement

We have listed the custom integrations that we offer when using a Google Sheet.

This helps clarify what our integrations do for our clients (and internal team)!

Snippet/Screenshot/Link