• Home

  • Automation with Zapier

  • Customer stories

Customer stories

3 min read

How a Systems Technologist Helps Her Team Differentiate New and Existing Leads with Automation

By Joey Blanco · May 22, 2019
lightmark-media primary img

In the sales world, you need to distinguish between new and existing leads. You probably have a specific workflow for new leads—maybe a call, demo, onboarding email campaign—that you wouldn't use for existing leads.

So how do you differentiate the new leads from those that you and your team have already contacted—without having to manually verify their status?

Tatiana Sharp, Senior Systems Technologist at Lightmark Media, a digital marketing firm for real estate companies, uses Zapier, an app automation tool that connects the multitude of apps you use professionally. Tatiana has a few Zaps, our word for automated workflows, that help her and the Lightmark Media team know when a lead is brand new.

This differentiation matters to the clients of Lightmark Media, who, as busy real estate investors, can't always check a customer relationship management (CRM) tool to see if they've already made initial contact with a lead. These Zaps keep their clients' CRM clean, organized, and easy-to-read—and best of all, they make the new leads easy to act on.

Most of those leads come in via phone call or text message. To track, analyze, and value those leads, Lightmark Media trusts CallRail. By assigning a phone number to the specific ad campaigns they run for each client, Lightmark Media takes full advantage of CallRail's extensive reporting data—helping them optimize future campaigns, which sends more and better leads to their clients.

And by connecting CallRail with Zapier, Tatiana can automatically sift through all the phone calls clients receive and only send new leads to their CRM.

Related reading: Discover popular ways to automate CallRail

About Lightmark Media

With a focus on pay-per-click (PPC) marketing campaigns on platforms like Facebook, Google, and Bing, Lightmark Media helps real estate investors and agents find motivated leads and close deals. But as a digital marketing firm, their efforts go beyond advertisement, into website design and creation, marketing automation, and branding.

At Lightmark Media, Tatiana is responsible for all things systems- and platform-related. She strategizes around how different systems and tools can work together to make their clients' lives easier. Zapier is their go-to for connecting everything.

By integrating their tools with Zapier, Tatiana and the team found a way to bring even more value to their real estate clients. After all, if Lightmark Media's clients don't have worry about the back-end and technical side of the equation, they can spend more time with their own clients, buying and selling houses and closing deals.

Lightmark Media's Tools



Used For:



Call tracking and analytics tool



Project management tool, used as a CRM



Filters for information based on conditions you set

Google Sheets

Google Sheets

Backup leads database

Send New Calls to a CRM as Leads

For Lightmark Media, handling their clients' leads means understanding the value of those leads. A clean lead management process, without duplicates, can be the difference between their client closing a deal and that lead taking its business elsewhere.

At the core of Lightmark Media's lead management are two Zaps: The first connects CallRail to their clients' CRM, which tends to be Podio. When a lead calls the phone number from a client's ad, Zapier takes that information and creates an item in Podio. Once created, the item can be updated by the realtor with more information like notes, face-to-face meeting dates, house showings, and more.

A second Zap sends the new call information from CallRail to Google Sheets, creating a new row full of the lead's information. This creates a back-up leads database, in case the client ever has trouble accessing their CRM.

But in order to only pass along only new leads, Tatiana added Zapier's Filter to each of the Zaps. Thanks to CallRail's data, Tatiana can filter based on whether or not that specific lead has called that number before. If they haven't called, they get added to Podio and Google Sheets. But if they have, the Zap doesn't add the lead and prevents a duplicate from adding to the clutter.

For simplicity's sake, we didn't include the Filter app in the following Zap templates, but you can always add it to your own Zaps.

Add completed phone calls in CallRail as new spreadsheet rows in Google Sheets

Add completed phone calls in CallRail as new spreadsheet rows in Google Sheets
  • CallRail logo
  • Google Sheets logo
CallRail + Google Sheets

With Zapier handling lead management, Tatiana and the rest of the team can spend more time with each client, enabling them to build relationships and craft successful campaigns.

Want to work as effectively as Tatiana and the Lightmark Media team? Give Zapier a try for free.

What's your story? Tell us how you use Zapier to do more. You can also read even more customer stories and find new ways to improve your workflow and productivity.

All images courtesy of Lightmark Media.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'