CSV Record Matching And Data Mapping

Record Matching

CSV data is matched against records in Demandbase using the following rules:

Accounts are matched against data from your CRM or Demandbase using the following prioritization:

  • External account ID (if provided)
  • Account domain + account name

Opportunities are matched against accounts using

  • account domain
  • account name
  • or external account ID.

People are matched against accounts using

  • external account ID
  • account domain
  • or account name.

Important: Importing people records only makes the data available for advertising campaigns.

To see individual activity at the person level, an integration with a CRM or Marketing Automation System is required.

Activities are matched against accounts or people using the external person ID.

Important: If the external person ID is related to an account, then the activity is matched against both the account and the person. If the external person ID is not related to an account, then the activity is matched against the person only.

CSV Headers

  • Account

    Field NameRequiredMaps to Demandbase fieldCreates New Demandbase Field?
    Account NameYesNo
    Account DomainYesNo
    Owner (email or name)No
    Phone NumberNo
    EmployeesNo
    Annual RevenueNo
    IndustryNo
    External Account IDNocrmId___eNo
    Custom FieldsNosupplied field name is created/mapped in DemandbaseYes

For more information, please refer to this document: What to know when importing data from a CSV file