Context
You can import CSV files to add and update database records for accounts, opportunities, people, or activities.
For each field in a merged record (a record with multiple sources), Demandbase prioritizes the data sources in the following order:
- CRM data
- Marketing Automation System data
- CSV data
- Demandbase data
Important:
Accounts, opportunities, people, and activities are matched in Demandbase using the following rules:
- Accounts are matched against your CRM or Demandbase database using the account domain, account name, or external account ID.
- Opportunities are matched against accounts using the account domain, account name, or external account ID.
- People are matched against accounts using the person’s email domain, account name, or external account ID. See Understanding Lead to Account Matching.
- Activities are matched against accounts or people using the account domain, external account ID, or person ID.
To watch a video about importing accounts, see Importing an Account List from a CSV File (Video).
Prerequisites/Preparation
You must have Administrative privileges to import CSV data.
See CSV Import Examples for formatting guidelines and data examples.
Account Fields
Required account fields:
- Account Name or Account Domain
Optional account fields:
- External Account ID
Tip: Highly recommend including External Account ID. Using unique IDs prevents duplicate entries and increases match rates for future CSV uploads. - Owner (Email or Name)
Tip: Highly recommend including email address. Having account domain increases match rates. It also makes the owner eligible for Snapshot Subscriptions on the Auto-Create Account Lists settings page. See Configure Auto-Create Account Lists. - Phone Number
- Employees
- Annual Revenue
- Industry
- Custom Fields
Opportunity Fields
Required opportunity fields:
- Opportunity ID
- Opportunity Name
- Account Name
- Account Domain
- Owner (Email or Name)
Tip: Highly recommend including email address. Having account domain increases match rates. - Type
- Created Date
Optional opportunity fields:
- External Account ID
Tip: Highly recommend including External Account ID. Using unique IDs prevents duplicate entries and increases match rates for future CSV uploads. - Stage
- Probability
- Close Date
- Is Closed
- Is Won
- Amount
People Fields
Required people fields:
- Person ID
Tip: You can also use the person's email as the ID. - First Name
- Last Name
Optional people fields:
- Person Type (Lead or Contact)
- External Account ID
Tip: Highly recommend including External Account ID. Using unique IDs prevents duplicate entries and increases match rates for future CSV uploads. - Title
- Role
- Company
- Website
- Country
- State
- City
- Postal code
- Custom fields
Activity Fields
You can import call, meeting, and email activity types.
Calls
Required call fields:
- Activity Date
- Caller
- TimeStamp
- Title
- Person ID
- External Activity ID
Optional call fields:
- Duration
- Description
- Recording URL
- Callee
- Direction
Meetings
Required meeting fields:
- Start Time
- Title
- Activity Date
- Owner Id
- End Time
- Person ID
- External Activity ID
Optional meeting fields:
- Body
- External URL
- Location
- Outcome
Emails
Required email fields:
- TimeStamp
- Subject
- Activity Date
- From Email
- To Email
- Person ID
- External Activity ID
Optional email fields:
- Open Sales Email
- Attachment IDs
- Sender First Name
- Sender Last Name
- Click Sales Email
- Recipient First Name
- Recipient Last Name
- Marketing Email Open
- Status
- Click Email
- Body
Steps: Import Data
- From the left navigation bar, go to Database and select Accounts > Data Import, Opportunities > Data Import, People > Data Import, or Activities > Data Import.
- Click Import Data.
- In the Import Data window, enter a Data Import Name.
- (Optional) If importing activities, choose Call, Meeting, or Email activity type.
-
Click Browse to select the CSV file to upload, and click Import Data.
Tip: Click Download .csv template to download a file with the required columns.
Steps: Update Data
- From the left navigation bar, go to Database and select Accounts > Data Import, Opportunities > Data Import, People > Data Import, or Activities > Data Import.
- Click the name of an account, opportunity, people, or activity data import.
- Click the Report tab.
- (Optional) To add or remove accounts from the account list based on the accounts from the CSV file, click Automatically update existing account list with these accounts.
- Click Re-import Data.
- Upload a CSV file that includes the following required fields:
- Account: External Account ID or Account Name AND Account Domain
- Opportunity: Opportunity ID
- Person: Person ID
- Activity: Person ID and External Activity ID.
- Click Re-import Data.
Important: Demandbase updates fields using the same prioritization as the original import: CRM > CSV > Demandbase Data.
Outcome
Data is processed and available according to the schedules described in Understanding Demandbase Data Availability.
After Demandbase processes the CSV file, click View Audit CSV to see the matched accounts, opportunities, or people. See Understanding CSV Data Import Results.
To see the field data, from the left navigation bar, go to Settings > Analytics > Fields.