Normalize the assigned account list
20 min
20 min
Start by exporting newly assigned accounts from HubSpot, folk, Airtable, or your territory spreadsheet into one working table. Create fields for account name, domain, owner, territory, segment, industry, employee_count, region, current_status, existing_contacts, last_activity_date, source, and research status. Deduplicate by domain, normalize company names, and remove students, agencies, vendors, competitors, existing customers, and accounts with an active owner conflict. Add a notes field for missing data so the rep does not confuse an incomplete record with a weak account. QA check: every account must have a domain, owner, segment, and keep/remove decision before research begins.
A deduped, research-ready account table with owner, segment, domain, and status fields.
Do not start researching before normalizing company names and domains. Bad source data creates duplicate work and misleading AI summaries.
Create a clean research-ready account table from this account list.
Raw account list:
{{raw_account_list}}
Required fields:
- account_name
- domain
- owner
- territory
- segment
- industry
- employee_count
- region
- current_status
- existing_contacts
- last_activity_date
- source
- research_status
Output a cleaned table and flag duplicates, missing domains, unclear owners, obvious non-fits, and accounts that need manual review.