Import or Reimport Account or Opportunity Data from a CSV File

  • Updated

Context

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):

  1. CRM data
  2. CSV data
  3. Demandbase data

Important: 

  • The account you're importing must exist in your CRM or the Demandbase database. 
  • Demandbase ignores CSV data if there is no matched account or if the data already exists in your CRM or Demandbase.
  • Accounts are matched against your CRM and the Demandbase database using the account domain, account name, or external account 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.

Account Fields

Required account fields:

  • Account Domain or Account Name

Optional account fields:

  • External Account ID - Highly recommended. Using unique account IDs increases match rates for future CSV uploads.
  • Owner (Email or Name) - Highly recommend using email address. Having your 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.
  • Phone Number
  • Employees
  • Annual Revenue
  • Industry
  • Custom Fields

Opportunity Fields

Required opportunity fields:

  • Opportunity ID 
  • Opportunity Name
  • Account Name
  • Account Domain
  • Owner (Assigned Email or Name of opportunity) - Highly recommend using email address. 
  • Type
  • Created Date (Format: month/day/year)

Optional opportunity fields:

  • External Account ID - Highly recommended. Using unique account IDs increases match rates for future CSV uploads.
  • Stage (Current for Opportunity)
  • Probability
  • Close Date (Format: month/day/year)
  • Is Closed
  • Is Won
  • Amount

Steps

  1. From the left navigation bar, go to Database_N.png Database and select Accounts > Data Import or Opportunities > Data Import.
  2. Click Import Data.
    Import_Data.png
  3. 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.
    Import_Data_Window.png

Tip: To update imported data, go to Database > Accounts > Data Import or Database > Opportunities > Data Import, click on the account list, and click Re-import Data. Demandbase updates the fields that have changed according to the same prioritization as the original import: CRM Data, CSV Data, Demandbase Data.

Outcome

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_N.png Database > Accounts > Account Lists or Database_N.png Database > Opportunities > Opportunity List
  • Drop-down for selecting accounts and lists in Analytics2.png Analytics.

To see the resulting field data, from the left navigation bar, go to Settings_N.png Settings > Analytics > Fields.

Data will be processed and available in the customer database according to the schedules described in Understanding Demandbase Data Availability

Next Steps

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 imported CSV file.

Important: The process to access and view the Audit Report is different for account and opportunity imports.

Account Import Audit Report

The Data Import Audit Report in Demandbase shows the processing results for each row included in the imported CSV file and identifies accounts that require review or could not be matched.

To access the Data Import Audit Report, from the left navigation bar, go to Database_N.png Database > Accounts > Data Import and click the name of a data import.

The Report tab opens for the data import with the following sections.

Overview Cards

The three overview cards show the number and percentage of matched accounts, matched accounts needing review, and invalid accounts.

Accounts Table

The accounts table shows the match results for each row in the imported file and includes the following columns.

  • Account Name: The account name from the CSV file.
  • Account Domain: The account domain from the CSV file.
  • Match Result: The match results status and any applicable errors. The available statuses include:
    • Matched Account (Valid): Indicates a matching account was found in Demandbase. The account will be added or updated in the database.
    • Matched Account Needing Review: Indicated a matching account was found in Demandbase, but the account was not added or updated in the database. Refer to the error message for more information. 
    • Invalid Account: Indicates a matching account was not found in Demandbase and the account will not be added to the database. Refer to the error message for more information.
  • Matched Name: The name of the account matched in Demandbase.
  • Matched Domain: The domain of the account matched in Demandbase.

Tips:

  • Hover over entries in the Match Result column for accounts needing review or invalid accounts to see more details.
  • To help with the review, sort the Match Result column to quickly group matching and non-matching results.

Account_Audit_Report.png

From the Report tab, you can do the following:

  • Click View Audit CSV to export the report as a CSV file.
  • Click View as Account List to view the matched accounts as an account list.
  • Select the Data tab to see the account name and website for each matched account.
  • Select the Detail tab to review information about the data import and to access the source CSV file imported.

Opportunity Import Audit Report

You can download and view the Audit Report for opportunity imports in CSV format. To download the file, select the List tab for a data import and click View Audit Report.

Audit_Report_Opp.png

The Audit Report file includes the following columns:

  • Account Name: The account name from the CSV file.
  • Account Domain: The account domain from the CSV file.
  • Match Result:
    • True: Indicates a matching opportunity was found in Demandbase. The opportunity will be added or updated (if existing) in the database.
    • False: Indicates a matching opportunity was not found in Demandbase and the opportunity will not be added to the database.
  • Match Reason:
    • New Opportunity (True): A new opportunity will be added to the database.
    • Existing Opportunity (True): An existing opportunity will be updated in the database.
    • Duplicate (False): The opportunity already exists in the CSV file and will not be added to the database.
    • Invalid (False): A matching opportunity was not found in Demandbase and will not be added to the database. 

Was this article helpful?

3 out of 6 found this helpful