Aggregation and Collection
Accounts CSV Upload
How to import and update contact accounts via CSV upload
Navigation
Access at: https://app.monterey.ai/w/default/feedback/contacts/accounts
Or follow these steps:
- Log into the Monterey.ai dashboard
- Navigate to Contacts -> Accounts tab
- Click the ”+ Account” button in the top right corner
You must have the appropriate permissions to access the accounts import feature. Contact your workspace administrator if you cannot access this section.
CSV Format
Your CSV file should contain the following columns:
name
- The account/company namedomain
- The company’s domain (e.g., “example.com”)contractValue
- The account’s contract value (numeric)- Additional columns - Any other columns will be stored as metadata on the account
Example CSV
How Accounts Are Matched
When importing accounts, the system attempts to match each row with existing accounts using the following logic:
- First, looks for an existing account with matching
domain
in your workspace. - If no match by domain, looks for an existing account with matching
name
in your workspace. - If a match is found:
- Updates the account with new data while preserving existing data.
- Merges any new metadata fields with existing metadata.
- If no match is found and either
name
ordomain
is provided:- Creates a new account with the provided data.
Required Fields
You must provide at least one of:
name
domain
Rows missing both fields are invalid and will be skipped during import.
Data Validation
name
anddomain
are validated as strings.contractValue
is converted to a number if valid, otherwise ignored.- All other columns are stored as metadata on the account.
Best Practices
- Include domain when possible - this provides the most reliable account matching.
- Use consistent naming - accounts are matched exactly on name.
- Include any additional fields you want to track as metadata columns.
- Review your CSV data before upload to ensure accuracy.
What Happens During Import
- System validates all rows in your CSV.
- For each valid row:
- Attempts to match existing accounts.
- Updates matched accounts or creates new ones.
- Preserves existing data while adding new data.
Supported File Types
The account import accepts the .csv
and .xlsx
files