Use CSV files to add and update database records for accounts or opportunities.
For each field in a merged account record (a record with multiple sources), Demandbase prioritizes the data sources in the following order (depending on the data available):
- CRM data
- CSV data
- Demandbase data
CRM data overrides CSV and Demandbase data, and CSV data overrides Demandbase data.
You must have Administrative privileges to perform data imports.
For Accounts Imports
Your Accounts CSV file must have these fields:
- Account Domain or Account Name
These fields are optional for accounts:
- Owner (Email preferred or Name)
- Phone Number
- Annual Revenue
- Custom fields
Important: Owner fields are recommended and can have either a person's name or email address. Including an email address is preferred because having the account domain drastically increases match rates. It also makes the owner eligible for snapshot subscriptions that you can configure on the Auto-Create Account Lists settings page. See Set Up Auto-Create Account Lists.
For Opportunity Imports
Your Opportunities CSV file must have these fields:
- Opportunity ID (key)
- Opportunity Name
- Account Name
- Account Domain
- Created Date (Format: month-day-year)
- Owner (Assigned owner email of opportunity)
These fields are optional for opportunities:
- Stage (Current for Opportunity)
- CloseDate (Format: month-day-year)
- From the left navigation bar, go to Database and select Accounts > Data Import or Opportunities > Data Import.
- Click Import Data.
- In the Import Data window, enter a Data Import Name, 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.
Tip: If you need to update your imported data, go to Accounts > Data Import or Opportunities > Data Import, click on the data import, and click Re-import Data to add a new CSV file. Demandbase updates the fields that have changed according to the same prioritization as the original import: CRM Data, CSV Data, Demandbase Data.
After Demandbase processes the CSV file, click View as Account List or View as Opportunity List to see the matched accounts or opportunities. You can also access the account and opportunity lists in the the following areas:
- Database > Accounts > Account Lists or Opportunities > Opportunity List.
- Drop-down list for selecting accounts and lists in Analytics.
To see the resulting field data, from the left navigation bar, go to Settings > Analytics > Fields.
Review the Audit Report to find discrepancies in your list and errors in your upload. The report is available for every data import or the most recent reimport and provides the results of processing each row of the import CSV file.
To download and view the report in CSV format, click View Audit Report on the List tab.
Keep in mind that Demandbase ignores CSV data if an existing account can't be found or CRM or Demandbase data already exists.