Understand your systems, workflows, and their impact on the overall data flow.

Lead Sources and Importing Process in CDHS

Lead Sources and Importing Process in CDHS

Welcome to ASTERRA's Lead Sources and Importing Standard Operating Procedure. This covers how records get into the CDHS, where they come from, how to import them, and how to check that the import worked. By the end, you will be able to run an import end-to-end on your own.

1 Four Lead Sources Overview

ASTERRA records come from four sources: the website form, which goes directly into HubSpot's Raw Leads, and three Excel lists from exhibitions, webinars, and publishers that you import. All three follow the same steps; only the downloaded template differs. Website forms have a separate SOP.
Four Lead Sources Overview

2 Where to get started

Make sure you have the CDHS login, HubSpot access, Zoho access (for verification), the source list from the event or publisher, the event's real name and date, and the HubSpot Event ID if adding to an existing event. If you are looking for a website form submission, another SOP covers the web form.
Where to get started

3 CDHS Decisions Admin Login

Start by logging in to the CDHS with your work email and password. Registration is by invitation only. If you do not yet have access, contact your Company Admin. Goto Login Click Here
CDHS Decisions Admin Login

4 CDHS Statistics Dashboard

After signing in you land on CDHS Stats. This is a live snapshot of the routing engine. It carries your configuration counts, operational health, and the most recent runs. You do not need anything from this screen to run an import, but this is where you verify numbers.
CDHS Statistics Dashboard

5 Comprehensive Lead Import Management

The 'Import Leads Lists' page is central to our lead management. It facilitates lead uploads and integrates with our routing engine. The system evaluates each contact against rules, ensuring efficient ownership assignment for timely follow-up and conversion.
Comprehensive Lead Import Management

6 The Template Comes First

Before importing, remember that the correct template comes first.
The Template Comes First

7 Download the template that matches your list

On the right side of the screen you will find three template cards, Webinar, Exhibition, and Publisher. Pick the one that matches your list and click its download button to get the excel file. Always download a fresh template. Do not reuse an old file, because the columns change as fields are added. Paste your list into the template and match your source columns to the template columns.
Download the template that matches your list

8 Template

Paste your list into the template you just downloaded. Anything without its own column goes in a new column to the right of Additional Info, and it lands in the Additional Info field in Zoho
Template

9 Executing the Import

To execute the import, each field must be filled out in the sequence we are about to outline.
Executing the Import

10 Event Name and Type

First, type the Event Name. Use the real event name exactly as it will be reported, for example, A W W A 2025. The funnel report groups by this, so consistency matters. Then choose the Event Type from the dropdown.
Event Name and Type

11 Importing to the Same Event

Leave the HubSpot Event ID blank for a new event. Fill it in only when you are adding another sheet to an event that already exists with the same name and type. Getting this wrong creates a duplicate event. This must match the template you filled out: Webinar, Exhibition, or Publisher. Enter the event date, then upload the completed template.
Importing to the Same Event

12 Reviewing Event Information

The Event Information section provides a comprehensive list of all marketing events within CDHS, each linked to its unique HubSpot Event ID. This page is essential for managing lead sheets. As mentioned earlier, you can copy an event's ID from an existing Event. This ensures all related leads are grouped correctly.
Reviewing Event Information

13 Event Date and Upload Template

Please enter the event date and upload the completed template. Use the date the event happened, not today's date.
Event Date and Upload Template

14 Excluding Domains from Imports

To exclude specific email domains from the import process. The system skips contacts from an excluded domain and creates no record. Be careful with free email domains like gmail.com. A water-utility commissioner with a Gmail address is a real lead. Exclude your own domain and known no-value domains.
Excluding Domains from Imports

15 Dry Run

Before committing changes, consider using the 'Dry Run' option. This validates the data and performs routing, scoring, and duplicate detection without updating Zoho CRM.
Dry Run

16 Upload & Process

When every field is filled, click Upload and Process. If you used Dry Run, check the result first, then come back and run the same file again with Dry Run switched off.
Upload & Process

17 Verifying Import Success

After running an import, how do we confirm its success?
Verifying Import Success

18 Troubleshooting a lead import

If a lead from an import is missing or in the wrong place, check the four steps in order.
Troubleshooting a lead import

19 1. Upload History (CDHS)

Upload History lists every file sent to the CDHS. It shows each upload's status, how many rows have been processed, and the errors for any upload that stalled or failed.

You want to see Completed, with a count that matches the rows in your file, for example 60/60.

If it shows Stuck, wait a few minutes and refresh. The count goes up every five rows, so a large file can look stalled when it's still moving. If the count hasn't changed after you refresh, the upload has likely crashed or timed out. Don't upload the file again, because every lead will be duplicated. Take a screenshot and ask for help.

If it finished with fewer rows than your file, click View to see which rows failed and why. The usual causes are a missing or misspelled email, or a renamed column.

1. Upload History (CDHS)

20 2. Routing Runs (CDHS)

Search for the lead's email. You want to see "ROUTED", a rep's name, and Zoho Created? = Lead Created. A DISQUALIFIED status comes with a reason in the Reason column. Marketing Engaged and Active customer are both normal and need no action. If no rep was assigned, or the wrong rep was, check that row's Org Type and Country for typos or blanks. Fix the file and upload that one contact again. Zoho Created? always starts at No, so give it a few minutes and refresh. To check a whole upload at once, filter Routing Runs by Zoho Created? = No.
2. Routing Runs (CDHS)

21 3. Zoho

Search for the email in Leads, Contacts, and Opportunities. If the person was already a contact, or was added to an open opportunity, the import worked as it should. If the owner doesn't match what the CDHS shows, check the record's Created Time. Records that existed before your upload keep their original owner. A brand-new record with the wrong owner needs a help request. A lead flagged Missing Company Name still went through, so just add the company name in Zoho.
3. Zoho

22 4. HubSpot

Search HubSpot Leads for the Contacts email. You want the contact linked to the event. If it's missing from the Leads board, check its Lifecycle Stage. Contacts set to Marketing Engaged stay in HubSpot on purpose. Being excluded from sync is also normal, because the CDHS now sends leads to Zoho. Still stuck? Send the event name, the upload time, a screenshot of what you saw, and 1 or 2 affected email addresses.
4. HubSpot
This SOP covered the main lead sources and detailed the import process for exhibition, webinar, and publisher content leads. We explored the CDHS Decisions Admin portal, including the import interface, template usage, and the dry-run option, and concluded with how to monitor import success and lead-routing outcomes through the Upload History and Routing Runs pages.
All Rights Reserved ©  | QDFs SOP Guide Solution Powered By Fruition RevOps

Schedule a Time with our Expert!

— Fill out the Form and let's meet —

Fill out the form below to book your meeting to get your HubSpot Audit Report.

Schedule a meeting
Your HubSpot Onboarding Plan.

** Schedule to have you High level plan for free.

Funnel Types List

Register and Get the Funnel List type

Provide you with a complete overview of the type of funnel and how to manage it. 

JOIN OUR LIVE EVENT!

Wednesday, October 18th
10AM (PST)

Webinar Topic: Fix the Leak with Streamline Your Revenue Path with RevOps Funnels. 
How to seamlessly guide prospects through your company’s journey,

  1. Utilize the Funnels in Revenue Operations
  2. How to Prevent Bleeding Prospects and Customers in Your Company’s Journey
  3. How to Automate the Process for Enhanced Efficiency

RevOps Knowledge Sharing!

Fill out the form below, and blogs, videos and content will come directly to your inbox.