Create intermediate Works with: Any AI

HubSpot Contact Properties and Data Model Plan

Table output Has example

Design properties that are clear and reportable.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Rate this prompt

Loading ratings…

Plan custom properties in HubSpot. Information we need to collect about contacts, companies and deals: [DATA_NEEDS]. Reports we need: [REPORTS]. Existing properties: [EXISTING_PROPERTIES].

Present a table. For each new property give the object, name, internal name, type (single-line text, dropdown, checkbox, date, number), allowed values with a definition and example for each dropdown, who fills it, required or not, and the question it answers in a report or workflow; drop it if there is none. Prefer dropdowns to free text for anything you will report on, and add an Other value only with a monthly review of what goes into it. Convention: lower case and underscores, such as lead_source_detail, with property groups and a rule for adding new properties. Identify existing properties that overlap or should be retired.

Migration: map old free-text values to the new dropdown with a mapping table for ten sample values, apply it, and test the result. Show a sample record. Collect only what you need and record the source of consent [VERIFY].

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

See an example result (fictional data)
Invented new properties. Lead source detail: dropdown, 14 values, set by forms and imports, used in the source report. Preferred language: dropdown (English, Spanish, French), used for email segments. Product interest: multiple checkbox, 5 values. Retire: 'Notes 2' (3 percent filled, no use).
Naming: snake case with a group prefix, for example marketing_lead_source_detail. Migration: map 41 old text spellings of industry to 18 dropdown values; check counts before and after add to 20,000 contacts. Rule: a new property needs a report or workflow that uses it.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts