HubSpot lists from RealGreen data: segmentation that sells programs

What HubSpot lists should a RealGreen company build first? We will give you our exact starting ten, because lists are where a RealGreen-HubSpot sync starts paying rent. Once program status, balances, and visit history live on every contact as properties, you can slice your base into audiences that map directly to revenue plays: actives without aeration, cancels from last season, prepay-eligible customers, quotes that never closed. This post gives you the ten lists to build first, in order, plus the suppression lists that keep the whole machine from embarrassing you. One assumption up front: your synced fields are trustworthy. Lists built on stale or missing properties do not fail loudly; they just quietly mail the wrong people. The order below matters: the first five power urgent money and safety, and the back five compound over a season. Everything here works on Marketing Hub's lower tiers too; list tools are one of the few places where HubSpot is generous early. And none of it requires exotic plumbing: we can connect RealGreen to pretty much any platform with an API, a Zapier connection, or a native connection, and lists are the first thing the connection pays for.

Active or static: which kind of list?

HubSpot gives you two types and the choice matters. Active lists re-evaluate continuously: when the nightly sync flips a customer's status, they enter or leave the list by morning, no human involved. Every ongoing audience: actives, past-due, white-space segments, should be active. Static lists are snapshots: the 412 people you mailed the March prepay letter, frozen forever. Use them for campaign send records and one-off experiments, because being able to answer "who exactly got this" six months later is worth more than it sounds. The default habit: build active, snapshot to static at the moment of each major send. List type is also a permissions story: static snapshots protect your campaign history from a well-meaning teammate editing an active list's filters a week after the send.

The ten lists to build first

1. Active customers. rg_customer_status is active. The mother list every other audience derives from, and the exclusion behind every acquisition campaign: never pay to advertise to people already on your routes.
2. Past-due suppression. rg_days_past_due over 30. This list exists to be excluded from everything promotional. Selling aeration to someone you are dunning is how you lose both conversations.
3. Actives without aeration. Status active, rg_programs does not contain aeration. Your fall campaign audience, built in ten seconds instead of a two-hour export. The campaign itself is covered in our aeration playbook.
4. Actives without perimeter pest. The same shape, different program: usually the biggest white-space audience in the base. Bundle the pricing with the lawn program and the offer gets easier to say yes to than to ignore.
5. Canceled 12-24 months. Old enough that the cancellation sting has faded, recent enough that the lawn remembers you. Prime win-back territory.
6. Canceled under 12 months, price reason. Cancel reason matters: price cancels get a different offer than service-complaint cancels, and service cancels within 90 days should be suppressed from cheery marketing entirely.
7. Prepay-eligible. Active, autopay or good payment history, no prepay recorded this season. The audience for prepay season, refreshed nightly as payments land so nobody gets asked twice.
8. Quoted, unsold, last 90 days. Money already priced, sitting in a drawer. Feed this to a follow-up workflow and it becomes the highest-ROI list in the portal. Pair it with a task queue for office call-backs: texts revive quotes, calls close them.
9. New customers, first 90 days. Enrollment audience for onboarding touches, and an exclusion for upsell campaigns; let people settle in before you sell them more. Ninety days is also the window when a happy customer's referral comes most naturally.
10. Engaged non-customers. Prospects opening email or revisiting the site without buying. Small, but it is the audience your neighborhood offers and seasonal urgency sends convert best against.

Worked math on just one of these, illustrative as always: an actives-without-aeration list of 780 households, emailed and texted in a September sequence with an 11% take rate at $320 per job, is roughly $27,400 of found fall revenue from an audience that cost nothing to build. Plug in your own numbers; the shape holds across every white-space list.

Suppression lists are the safety net

Every promotional send should exclude, at minimum: past-due accounts, open service complaints, employees, commercial decision-makers who should not get residential blasts, and anyone in an active sales sequence, so automation and salespeople never talk over each other. Build these as active lists once, then make exclusion a checklist habit on every campaign. This is the unglamorous half of segmentation, and it is what separates shops whose automation feels personal from shops whose automation generates apology calls. When in doubt, suppress; nobody ever canceled because you skipped emailing them for a week. The strategy layer of who should receive what, independent of any tool, is laid out in the nine customer segments every automation stack needs; the lists above are that thinking rendered in HubSpot mechanics.

Where do lists go wrong?

Three failure modes account for most of the mess. Stale properties: the sync breaks quietly and lists drift from reality, so put a freshness check on your dashboard: count of contacts updated in the last 48 hours. List sprawl: a portal with 300 lists nobody can name; fight it with a naming convention (audience_purpose_owner) and a quarterly delete pass. And segment overlap without priority: the same household qualifying for aeration, perimeter pest, and win-back messaging in the same week. The fix is sequencing rules, one promotional conversation per household at a time, which is really an email and SMS program design question wearing a list problem's clothes. A quarterly thirty-minute audit catches all three: pick five lists, open ten members of each, and check them against RealGreen before your customers do it for you.

The takeaway: lists are the cheapest asset in your whole marketing stack. Ten active lists on trustworthy synced fields turn your RealGreen base into named, refreshed, revenue-shaped audiences, and the suppression lists keep the machine polite. Build them once; the nightly sync does the maintenance forever.

Build the first five today

1. Create actives, past-due suppression, and quoted-unsold; those three power everything urgent.
2. Add your two biggest white-space lists based on actual program penetration, not guesses.
3. Write the naming convention down and rename anything that predates it.
4. Add the sync-freshness count to a dashboard so a silent sync failure cannot hide.
5. Make campaign snapshots a rule: every major send gets a static copy for the record.