Opportunity Hub Data Model

Data Model Overview

🏗️ Primary Entities

Opportunities: One scored record per customer and vehicle, used to prioritize outreach

Signals: Recent activity measured per customer-vehicle pair (visits, invoices, reminders, declined services, bookings, messages)

Scores: A score part per signal, a total score, and priority buckets

🔗 Key Relationships

Many-to-One: Opportunity → Customer (join on STEER_CUSTOMER_ID to the Customer export)

Many-to-One: Opportunity → Vehicle (join on STEER_VEHICLE_ID to the Vehicle export)

Many-to-One: Opportunity → Shop / Tenant (the customer’s primary shop)

Tip

Customer and Vehicle Details: Names, contact details, and vehicle specifications are not repeated here. Join to the customer and vehicle exports by ID.

Note

Daily Recalculation: Scores are recalculated every day, so each snapshot reflects the scores as of its export date. Records carry no update timestamp: replace the tenant’s rows with each snapshot instead of filtering by STEER_UPDATED_AT.

Field Specifications

Opportunity Identification

The customer-vehicle pair the opportunity is scored for. STEER_CUSTOMER_ID together with STEER_VEHICLE_ID identifies a record. STEER_VEHICLE_ID is null for customers scored without a vehicle, so do not enforce NOT NULL on it and treat null as a key value.

Field Name	Data Type	Description	Required
STEER_TENANT_ID	String (UUID)	Unique tenant identifier (parent organization)	Yes
STEER_SHOP_ID	String (UUID)	The customer’s primary shop	Yes
STEER_CUSTOMER_ID	String (UUID)	Customer identifier	Yes
STEER_VEHICLE_ID	String	Vehicle identifier (null when the customer has no vehicle)	No

Activity Dates

Field Name	Data Type	Description	Required
OPPORTUNITY_LAST_VISIT_AT	Timestamp	Last visit of the customer with this vehicle	No
OPPORTUNITY_LAST_INVOICE_CREATED_AT	Timestamp	When the newest invoice for the customer and vehicle was written	No
OPPORTUNITY_MAINTENANCE_REMINDER_DUE_AT	Timestamp	Nearest maintenance reminder due date: overdue up to 180 days, or due within the next 60 days	No

Signals and Score Parts

Each signal comes as a pair: OPPORTUNITY_VAL_<SIGNAL> holds the measured value, and OPPORTUNITY_<SIGNAL> holds the score part calculated from it. Both are null when the signal does not apply to the pair.

Signal	Value field	Score field	Measures
PAC	OPPORTUNITY_VAL_PAC	OPPORTUNITY_PAC	Past appointments count, last 365 days
DSLA	OPPORTUNITY_VAL_DSLA	OPPORTUNITY_DSLA	Days since last appointment, last 365 days
ABC	OPPORTUNITY_VAL_ABC	OPPORTUNITY_ABC	Abandoned online bookings count, last 14 days
DSLAB	OPPORTUNITY_VAL_DSLAB	OPPORTUNITY_DSLAB	Days since last abandoned booking, last 14 days
DSMA	OPPORTUNITY_VAL_DSMA	OPPORTUNITY_DSMA	Days since a missed appointment not yet rebooked, last 45 days
DSGV	OPPORTUNITY_VAL_DSGV	OPPORTUNITY_DSGV	Days since the customer last opened their Digital Glovebox, last 30 days
DSWF	OPPORTUNITY_VAL_DSWF	OPPORTUNITY_DSWF	Days since the customer last submitted a web form, last 30 days
DSLPI	OPPORTUNITY_VAL_DSLPI	OPPORTUNITY_DSLPI	Days since last paid invoice, last 365 days
NMR	OPPORTUNITY_VAL_NMR	OPPORTUNITY_NMR	Number of maintenance reminders: overdue up to 180 days, plus due within the next 60 days
NDS	OPPORTUNITY_VAL_NDS	OPPORTUNITY_NDS	Number of declined services, last 180 days
DSDS	OPPORTUNITY_VAL_DSDS	OPPORTUNITY_DSDS	Days since last declined service, last 180 days
MRDI	OPPORTUNITY_VAL_MRDI	OPPORTUNITY_MRDI	Days until the maintenance reminder is due (negative = overdue): from 180 days overdue to 60 days ahead
DSLIM	OPPORTUNITY_VAL_DSLIM	OPPORTUNITY_DSLIM	Days since last incoming message, last 90 days
OQS	OPPORTUNITY_VAL_OQS	OPPORTUNITY_OQS	Number of opened quotes, last 180 days
PR	OPPORTUNITY_VAL_PR	OPPORTUNITY_PR	Whether the customer has provided a review

Total Score and Priority

Field Name	Data Type	Description	Required
OPPORTUNITY_TOTAL	Number	Total score: the sum of the signal score parts multiplied by OPPORTUNITY_OUTCOME_COEFFICIENT	Yes
OPPORTUNITY_OUTCOME_COEFFICIENT	Number	Multiplier from the latest Hub outcome: 1 (no outcome), 0.05 (Won), 0.01 (Lost)	Yes
OPPORTUNITY_STEER_NORMALIZED_VALUE	Number	Total score normalized against all customers in Steer (z-score)	No
OPPORTUNITY_TENANT_NORMALIZED_VALUE	Number	Total score normalized against the customers of the tenant (z-score)	No
OPPORTUNITY_SHOP_NORMALIZED_VALUE	Number	Total score normalized against the customers of the shop (z-score)	No
OPPORTUNITY_STEER_STANDARD_DIST_BUCKET	Number	Priority bucket (1–4) based on all customers in Steer	No
OPPORTUNITY_TENANT_STANDARD_DIST_BUCKET	Number	Priority bucket (1–4) based on the customers of the tenant	No
OPPORTUNITY_SHOP_STANDARD_DIST_BUCKET	Number	Priority bucket (1–4) based on the customers of the shop	No
OPPORTUNITY_CIT	Number	Number of customers in the tenant	No
OPPORTUNITY_CIS	Number	Number of customers in the shop	No

Field Enum Values

Priority Bucket

OPPORTUNITY_*_STANDARD_DIST_BUCKET ranks a pair against the chosen population:

• 4: Highest priority
• 3: High priority
• 2: Medium priority
• 1: Low priority. Also assigned for 7 days after a Won or Lost outcome is recorded in the Hub

Outcome Coefficient

OPPORTUNITY_OUTCOME_COEFFICIENT reflects the latest outcome recorded for the pair in the Opportunity Hub:

• 1: No outcome recorded
• 0.05: Won
• 0.01: Lost

Data Quality Notes

Null Values

Note

Expected Null Values

• STEER_VEHICLE_ID is null for customers scored without a vehicle
• OPPORTUNITY_VAL_* and the matching score fields are null when the signal does not apply to the pair, for example when there was no activity in the signal’s window
• OPPORTUNITY_MAINTENANCE_REMINDER_DUE_AT is null when the vehicle has no reminder in the window

Sample Record

One record from an opportunity_hub export file:

{
  "STEER_TENANT_ID": "ce96b905-5647-4901-8a83-8e7dbca90418",
  "STEER_SHOP_ID": "2dc598c3-1e9e-408e-82df-b8d7acff380b",
  "STEER_CUSTOMER_ID": "64e017ab-ead3-4149-8d4a-ec4598e33cd4",
  "STEER_VEHICLE_ID": "9a8b7c6d-5e4f-4a3b-8c2d-1e0f9a8b7c6d",
  "OPPORTUNITY_LAST_VISIT_AT": "2026-05-12 15:20:00.000",
  "OPPORTUNITY_LAST_INVOICE_CREATED_AT": "2026-05-12 16:45:10.000",
  "OPPORTUNITY_MAINTENANCE_REMINDER_DUE_AT": "2026-10-28 00:00:00.000",
  "OPPORTUNITY_VAL_PAC": 2,
  "OPPORTUNITY_PAC": 2,
  "OPPORTUNITY_VAL_DSLA": 160,
  "OPPORTUNITY_DSLA": 0.31,
  "OPPORTUNITY_VAL_NMR": 1,
  "OPPORTUNITY_NMR": 1,
  "OPPORTUNITY_VAL_MRDI": 8,
  "OPPORTUNITY_MRDI": 0.74,
  "OPPORTUNITY_VAL_PR": 1,
  "OPPORTUNITY_PR": 1,
  "OPPORTUNITY_CIT": 18240,
  "OPPORTUNITY_CIS": 6110,
  "OPPORTUNITY_OUTCOME_COEFFICIENT": 1,
  "OPPORTUNITY_TOTAL": 5.05,
  "OPPORTUNITY_STEER_NORMALIZED_VALUE": 1.12,
  "OPPORTUNITY_TENANT_NORMALIZED_VALUE": 1.31,
  "OPPORTUNITY_SHOP_NORMALIZED_VALUE": 1.27,
  "OPPORTUNITY_STEER_STANDARD_DIST_BUCKET": 3,
  "OPPORTUNITY_TENANT_STANDARD_DIST_BUCKET": 3,
  "OPPORTUNITY_SHOP_STANDARD_DIST_BUCKET": 3
}