Data dictionary
Every lead Mosaic delivers carries the fields below. This page says what each one holds, when it is blank, and what it does not mean.
When a lead is delivered into a CRM, each field is a custom field whose name begins with “Mosaic”, so they group together in the field list. Every contact carries the tag Mosaic and one lane tag. A delivery can also add an owner tag for the person the contact is assigned to. The lane tags are:
preprobate: a death has been recorded and the property has not yet entered probate.probate: the estate has been filed with the court.
Do-not-call contacts also carry dnc-mail-only (see below).
Before anyone dials: the two contact types
Each contact is one of two kinds. The field Mosaic DNC Status tells you which, and so does the dnc-mail-only tag.
Callable: clean
- Screened against the Do Not Call registry and clear.
- Carries a phone number and/or an email.
- Call, text or email as you normally would.
- Individual numbers that came back suppressed were stripped before we sent the record.
On the registry: on_list
- At least one of this person’s numbers is on the Do Not Call registry. Do not call and do not text these contacts unless you have screened them yourself or have a legal basis to.
- These contacts carry their phone number, and their email when we found one, so you have the full record. The protection is the flag, not the absence of the number: filter on
Mosaic DNC Status = on_listor on thednc-mail-onlytag and keep those out of any dialer or text campaign. - Check that your dialer or text tool excludes the
dnc-mail-onlytag before you load a list that includes these contacts. A phone number sitting in a contact can be dialed by an automation that does not look at the flag. - Reach them by mail, or by a channel your own compliance process clears.
The screen is a point in time. Each contact’s DNC status reflects a screen we ran before sending it. If that was a while ago and you are about to start a calling campaign, ask us to re-screen the batch first.
Addresses: which field to mail to
Two addresses on every contact answer different questions: Address 1 (the CRM’s built-in address) is where we mail the contact, and Mosaic Property Address is the estate property.
Mail to Address 1. Evaluate on Mosaic Property Address. Never put Mosaic Property Address on an envelope expecting to reach the person. For a do-not-call contact it may not be where they live; their verified mailing address is in Address 1.
Address 1 is built differently per type, and the separate City, State and Postal Code fields are only populated for one of them.
| Contact type | Address 1 holds | City / State / Postal Code |
|---|---|---|
on_list do-not-call | That person’s own verified mailing address, street line only | Populated. A complete, true mailing address. |
clean callable | The subject property, packed into that one line | Empty. We hold no separate residence for these people. |
To carry the full address for every contact, merge all four fields: Address 1, City, State and ZIP. Do not build the block from Address 1 alone. That drops the City, State and ZIP for the do-not-call contacts, whose Address 1 is only the street line. To format each group its own way instead, run two segments off the dnc-mail-only tag.
Some do-not-call contacts have no mailing address on file; their Address 1 is empty and they are reachable only by the phone or email we sent. For a callable contact, mailing Address 1 means mailing the estate property itself, not a verified personal mailbox, which is not the same as reaching that person at their own home.
The field dictionary
36 fields per contact. The type on some fields reads “MONETORY” in GoHighLevel’s field settings; that is GoHighLevel’s own spelling of monetary.
The property
| Field | Meaning |
|---|---|
Mosaic Property Address | The subject (estate) property. The deal. Never a person’s mailbox. |
Mosaic Beds | Bedrooms. |
Mosaic Baths | Bathrooms. |
Mosaic SqFt | Square footage. |
Mosaic Year Built | Year built. |
Mosaic Title Owners | Owner(s) of record per the county assessor, as the assessor writes it. |
Mosaic Ownership Type | How title is held. A trust is labeled as a trust (including a joint revocable trust). Otherwise: Individual for one person; Joint Owners (unspecified) for two or more people with no legal marker; Multiple Owners (ETAL) where the assessor writes “et al”, which means more than one owner without saying how many; or the legal form where the assessor states one, for example Husband/Wife, JTWROS or Tenants by Entirety. |
What it is worth
| Field | Meaning |
|---|---|
Mosaic AVM Value Estimate | A model-generated value estimate for the property, produced without an interior inspection. A directional figure, not an appraisal. |
Mosaic Retail Value Est. | Our own estimate of retail-market value. Worth comparing to the AVM rather than reading in isolation. |
Mosaic Investor Entry Low | 25th percentile of what entity buyers actually paid for comparable homes. |
Mosaic Investor Entry High | 75th percentile of the same set. Low and High together are a band of observed behavior, not a recommended offer. |
Mosaic Investor Entry Basis | Sample size, area and window behind that band. Read before leaning on the band. |
Mosaic Rent Estimate | Our in-house rent model, anchored on market value. |
Mosaic Assessed Value | County assessed figure converted to estimated market value (St. Louis County assesses residential at roughly 19% of market, so we apply the county ratio). |
Assessed Value and the AVM are two independent estimates and can differ; neither checks the other, and neither is an appraisal.
These valuation fields, and the bedroom, bathroom, square-footage and year-built fields above, are filled only for properties where the county lists exactly two owners. For a property titled to one owner or to several, they are blank. That is the scope we have set for them, not a gap in a particular record. The owner fields (Mosaic Title Owners, Mosaic Ownership Type) are filled for every property we send.
The person
| Field | Meaning |
|---|---|
Mosaic DNC Status | clean = screened and clear to call. on_list = on the DNC registry. The phone and email are in the record, but do not call or text. |
Mosaic Contact Rank | Where this person sits among the reachable people found for that property. 1 is who we would approach first. |
Mosaic Relationship | Their relationship to the deceased owner, for example Child, Spouse, Sibling, Parent, In-law, or Other Relative. |
Mosaic Deceased Name | The deceased owner this lead descends from, written as First Last (middle names and initials dropped). When an obituary names two people, only the first is shown. We fill it in a separate pass after a contact is created, so a contact that has just arrived can show it blank until that pass runs. |
Dates
| Field | Meaning |
|---|---|
Mosaic Date of Death | Date of death from the published obituary. Pre-probate contacts only; blank on probate contacts. |
Mosaic Date Filed | Date the estate was filed with the court. Probate contacts only; blank on pre-probate contacts. Each lane carries only its own date; we never fill one from the other. |
How fast the estate was filed (probate contacts only)
These five fields describe one thing: how long after the death the estate was filed. They are filled for probate contacts once their record has been graded, and blank for pre-probate contacts (no estate has been filed yet, so there is nothing to grade). A probate record whose death date or filing date is missing is graded Flagged, with its days field left blank. They describe the record’s filing timing. They are not a prediction for the property, and no percentage appears anywhere in them.
| Field | Meaning |
|---|---|
Mosaic Odds Grade | Fast filing (filed within 3 months of the death), Standard (3 to 12 months), or Flagged (more than 12 months, or the timing could not be measured). |
Mosaic Days Death to Filing | Whole days from the date of death to the date filed. Blank when either date is missing. |
Mosaic Grade Reason | One sentence saying why the record got its grade, for example “The estate was filed between 3 and 12 months after the death.” |
Mosaic Grade Explanation | The same short paragraph on every record, explaining the three grades and their cut-offs. |
Mosaic Odds Version | Which version of the grading standard produced the grade, and its date. If we ever change the cut-offs, this changes with it, so you can tell old grades from new. The odds behind each grade come from the history we have so far, and we recalculate them as it grows. |
The Flagged grade covers two different situations, and Mosaic Grade Reason tells them apart: an estate filed more than a year after the death, and a record where we could not measure the filing time at all. Read the reason before treating every flagged record the same way.
The rate on every contact
Every contact carries its odds as one number. A probate contact carries the calibrated odds for its grade in its county. A pre-probate contact has no filed estate, so it has no grade; it carries the provisional group rate for its county instead. A second field describes what the number measures.
| Field | Meaning |
|---|---|
Mosaic Odds | The odds as a decimal number: for example, 0.25 would mean 25 in 100. It is a number, never a sentence, so you can sort and filter on it. The figure comes from our published ledger of fact-checked rates, so it matches the same rate on our website. |
Mosaic Odds Description | What the odds measure, in one sentence: the county, how many cases or homes were counted, the range around the rate, and the date it will be measured again. |
- It is filled for every contact, in both St. Louis County and St. Charles County. A contact we cannot give a rate to is not sent.
- It is a rate for a group, not a promise about one property. Every contact in the same grade and county carries the same number.
- A probate rate is the share of cases in that grade that sold within six months of filing. A pre-probate rate is provisional, and the two counties measure different things: in St. Louis County it counts a change of owner on the county’s owner records, and in St. Charles County it counts a recorded sale. We never add them together or compare them.
- When a pre-probate contact’s estate is filed and graded, Mosaic Odds changes to the probate rate in the same update. It is never blank in between.
- The date at the end of the description is when the rate will be measured again. If the rate changes, the number and the description change together.
Identity and lifecycle
| Field | Meaning |
|---|---|
Mosaic UID | Our identity key. Do not edit. It is how our updates find this contact again. |
Mosaic Lane | preprobate (a death is recorded, no estate filed yet) or probate (the estate has been filed with the court). |
Mosaic Created Date | Date we first sent this contact. |
Mosaic Last Updated | Date of our most recent sync to this contact. Set on every contact we send, new or updated. |
Mosaic Home Sold | Blank until we detect the property sold; then Yes. |
Mosaic Sale Date | Date of the recorded sale, once there is one. |
Mosaic Sale Price | Recorded sale price, once there is one. |
Mosaic Title Change | Blank unless the county owner record shows the property retitled to a surviving family member (the deceased owner is off the title) and it was not a sale. Then it reads Retitled to survivor. The contact stays on your list. |
Mosaic Property State | Machine-readable record of every property mapped to this person and its status. Reference data; read the individual fields instead. |
Which properties we send
We send a property when the county’s title names one owner, two owners, or several owners. The county writes more than one owner in several ways, for example names joined with & or *, or followed by “et al”.
We never send a property whose owner name contains the word LLC, Inc, Corp or Ltd, and we never send a property for which the county shows no owner at all. A property held in a family trust is sent, and Mosaic Ownership Type says so. Mosaic Title Owners shows the owner names exactly as the assessor writes them.
Within each property we send every reachable relative we found, including a surviving spouse; Mosaic Relationship and Mosaic Contact Rank tell you who each person is and who to approach first. We send a contact only after its Do Not Call screen has run: a person we have not been able to screen is held back, not sent with the status left blank.