I need digital leads, …and now pls! ⏩Zoom, Mailchimp, PipeDrive, Web, Social medias..lot of systems, lot of challenges

Martin Zahumensky
May 14 · 7 min read

Lot of companies are now going through the same ~we were meeting prospects on conferences, breakfast briefings, meet-ups, .. how are we going to generate leads now? Answer is digital!

Search engines, digital advertisements, social medias, web pages, blogs, articles. But all this brings totally new challenges, the data are now even more important and I will explain why and what tools we use to manage all these challenges!

Leads, Opportunities, Deals, Customers

Image for post
Image for post

Now all this generates traffic to your web, some people go to webinar page, then they leave, then they get back to your page, they read something, watch video, and sometime fill-in the contact form, or chat with your chat-bot, or register to webinar, but the question is….

Do they attend the webinar? Are they real leads? or they are competitors, students, already your customers, lost deals? Your manager asks so how many deals we have really generated? How does the funnel look-like?

Image for post
Image for post

Hard to answer, yeah?? Because the data are scattered over different systems. It’s obviously must to integrate all these data in one central place and validate these data on the way.

Systems and data integration 💻

  • Our Web publishing platform
  • Keycloak single sign on where we register all our users
  • Zoom platform, where we register users, send reminders, some of partners use zoom landing pages to register attendees
  • Our internal app where we register attendees of events
  • Web forms for sign-ups and request of demos
  • Pipedrive as our CRM, keeping pipeline, contacts, organization in
  • Internal system to track behavior of people on our web
  • Mailchimp to send email invitation, follow-ups
  • Youtube to stream webinars and upload offline copies
  • CSV files with registered people from external partners, conferences
  • Social medias
  • Advertisement platforms
  • Google analytics
  • Ataccama Data Management platform to integrate, clean and master all the data

So whats typically happening

At the end it all boils down to having these data in one place, clean, de-duplicated and mastered and documented! Understanding what is coming from where, how is it integrated

“Master” Data Management & Governance is answer!

Image for post
Image for post
Central Data Model, flexible, allowing to work with hierarchies and relation-ships

The solution for these problems is Customer Integration Hub (or MDM Hub) ~ one place where you store all your contacts, companies, their roles, events, and relationships between them. And you not just store them but clean them, de-duplicate and master them. And then provide these data to Reporting system.

So what we do is that each of the systems above is connected to central Customer hub, the data are synchronized there. To give you an example this is what is happening

  • Customer comes to our web, he browses there, we track the events on web
  • Once the customer comes to webinar page and registers — he fills in info Martin Zahumensk, 0940 343 443, martin.zahumenky@gmail.com, company Ataccama. As this is web form lot of people provide incorrect or dummy information, lot of registrations is coming from our employees, partners, lot of people register with different email addresses, or use nick names for their companies such as ATA for Ataccama — so as part of our data integration job we run data quality and data cleansing jobs to resolve these issues, see more about this below
  • Once we have the data we ask our Customer Data Hub via API if the we know the person. Now the hub does it’s magic it does not only check the name but tries to use AI to match the record to existing records, so uses attributes like email, phone, company name, to find potential duplicity. It also checks data quality and filter out spam records. If the person exists we get ID or hub creates new one
  • We send all events for that person, such as webinar registration, important web activities, registration to our ONE Data Profiling Tool, or download of our Ataccama Data Quality Analyzer to Customer Integration Hub to have them in one central place with time-stamps as they were happening
  • We use the same synchronization principle when the customer registers to Zoom directly, we also synchronize after event data such if attended, if questions were posted, etc.
  • We synchronize all contact information from Hub to Mailchimp and Pipedrive. When some one clicks on email campaign in Mailchimp we again feed it back to Hub.
  • When some-one unsubscribes we again sync this to one place so we have correct consents information
  • When someone creates deal in Pipedrive for given person, or schedule activity we again get it back to MDM Hub.
  • When we get list of attendees from 3rd party conference we upload them to our internal event app and they again get synchronized, cleaned-up and mastered in the MDM Hub.

Data Quality & Data Cleansing process

Image for post
Image for post
example of data quality process

Part of our data integration jobs is data quality and cleansing process. At start we validate Company name, try to rule out obviously dummy data, remove special characters, we also filter out our company name. After this we validate the provided email address and look-it up in our master data, if not found, we try the same with person name. If we match this we assign the activity / event to existing persona, and by this we already have link to company and see if the registration is coming from existing customer, already known prospect, or partner, or is new. If we have a new one we make extended validations on dummy values, valid emails, valid phone numbers, prior we create new persona in master data. We also use the quality of provided data to score the lead relevance, and this is then transferred to our PiperDrive CRM so sales people can prioritize the deals by their quality.

So What are benefits of this approach?

  • We can clearly identify from which source the leads are coming in — is Linkedin better then Twitter or Instagram, or Email campaign?
  • We can clearly see if this is totally new prospect, or is existing customer or partner, you can easily report how many new deals you are generating, or active are you customers, if they were watching webinar about product they don’t yet use and so on
  • You can actually easily say how many new companies interacted with you instead of specific people who can still be from the same company
  • You can easily filter your employees, partners, or spam emails from the numbers
  • You can use the hub to enhance and enrich your data, e.g. to look-up company details based on the email domain, or look-up location / country based on the IP address

All this is now even more important then before, many companies are undergoing digital transformation, and as as physical is getting digital, the data are the GOLDEN EGG and you need to treat them in this way!

Ataccama Self-driving Data Management & Governance platform

Image for post
Image for post
One integrated platform — Data Quality, Master Data Management, Reference Data, Data Integration, using AI in all major modules to simplify the work for users

We also use Data Catalog and Meta-data management module which helps us out to track the systems, data models, business terms, linage of data, data quality.

Image for post
Image for post

And all this in ONE .. Ataccama ONE integrated platform. If you are interested in more details check our web https://www.ataccama.com and see our Digital Webinars to learn more and see the platform in action!

Ataccama

Self-Driving Data Management

Martin Zahumensky

Written by

Data Management & Visualization enthusiast, working as VP of Product Strategy @ Ataccama, co-founder of Instarea, and amateur endurance triathlete.

Ataccama

Ataccama

A blog about AI in data management & data governance—to improve time to market and reduce manual effort

Martin Zahumensky

Written by

Data Management & Visualization enthusiast, working as VP of Product Strategy @ Ataccama, co-founder of Instarea, and amateur endurance triathlete.

Ataccama

Ataccama

A blog about AI in data management & data governance—to improve time to market and reduce manual effort

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store