Skip to main content
Question

How can I create a Zap for offline phone call conversion tracking using Google Sheets?

  • August 20, 2024
  • 6 replies
  • 57 views

Hi, 

I need help, if someone guide me, I’ll be thankful to u.

I want to create a zap for Offline conversion tracking for “phone calls” based on Google Sheet. Is there any way to do this just like OCT for leads we do.

 

Regards,

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 20, 2024

Hi @nicolebernardino 

What app are you trying to use for tracking the offline conversions? (name/screenshot)


I am trying to use Google sheet template the same we used for lead tracking, while using zapier for OCT. We can’t do Offline conversion tracking with GCLID for phone calls?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 20, 2024

Hi @nicolebernardino 

If you are trying to use GAds there is this Zap action: Send Offline Conversion

In the settings, there is a field: Conversion User Identifier Source

With an option for: Phone Number

 


Thank you for your response. Do we have to add some extra columns in our Google sheet template for it? like phone caller ID, timings, etc.?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 20, 2024

@nicolebernardino

I recommend trying to configure the desired Zap action step so you can see the fields.

  • Check which fields are required/optional/conditionally required
  • Check the field types and descriptions for guidance about expected values
  • Adjust your GSheet as necessary

 

When in doubt, test it out.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • August 29, 2024

Hi @nicolebernardino 👋

How did you get on with Troys suggestions here, is the Zap working now?

Keen to ensure you’re all set so please let us know whether you need any further help at all 🙂