Integrate Third Party Systems With Natero

Natero supports a variety of third-party system integrations to provide a 360 degree view of your customers. In this article, we explore how accounts are synchronized between third-party systems.

Our complete list of supported integrations can be found here.

Requests for new integrations can be sent to support@natero.com.

MUST READ: Choosing an effective account_id

All objects synchronized with Natero require an account_id, so they can be successfully tied to an account upon insertion.

Create programmatically

Avoid manually created account_ids at all costs because they invariably lead to mismatches. An account_id must be an exact (case sensitive) match across multiple systems. Whenever possible, create account_id through a consistent, automated, programmatic approach.

Numbers are better

If manual entry is your only option, account_id containing only numbers and no spaces are best, because they are not case sensitive.

Store it as text

Natero processes all account_id as String/Text.

It is important to store all account_id as either String/Text (preferred) or Integer/Long (acceptable).

Problems can arise if account_ids are stored as Decimals/Float (e.g. “12345.0” will not match “12345”).

Is it accessible in your product?

  • Product usage events and metadata must contain user_ids, and optionally account_ids.
  • If account_ids are not present in product usage events, a mapping table must exist in Natero containing the association between user_ids and account_ids.
  • Using an account_id that is already present in your product will help reduce engineering effort.

Propagate new account_ids automatically

  • New account_ids will need to be propagated across all of your systems.
  • Ensure that new account creation can be fully automated across all systems, as it will help reduce operational costs, and also make new accounts appear in Natero without delay.

MUST READ: Choosing the Accounts System of Record

In order for any object other than an account to be successfully inserted into Natero, the supplied account_id must exist in Natero, otherwise that object is rejected.

The first step for data integration consists of "loading" your accounts into Natero.

To automate the loading of accounts into Natero, we ask that one system become your “System of Record” (SOR) which contains the complete list of your accounts.  Automating this step via a Natero integration is important, so that new accounts are loaded without delay in the future.

Will it include all of your accounts?

Pick a SOR that includes all of your accounts, and will stay up-to-date in the future.

Does it include mandatory fields?

Natero accounts require 3 fields:

  • account_id: as discussed in the previous section, the SOR must include the account_id you have chosen
  • Name: The SOR must include account names as you want them to appear in Natero. Think about how you reference your customers internally, you should be able to search for these same names within Natero.
  • Join Date: this is the date Natero uses to start looking for account activity and revenue.

Can it be filtered?

You will likely want to filter the accounts so that only revenue generating and/or active accounts appear in Natero.

To do this, the SOR must include a way for Natero to filter your accounts, usually by checking the value of a field. The SOR must either include this field, or a path must exist from the SOR to the system that has the field.

For example, you could choose Salesforce as your SOR and only import Salesforce Accounts that also exist in Zuora. In this case, a mapping between Zuora and Salesforce account_id’s must exist in either system.

MUST READ: Where to store the account_id?

  BEST CHOICE ACCEPTABLE CHOICE
CRM
Salesforce

Custom field in Account Object

A custom field value, typically from your product.

Store it as Text.

Account.Id or Opportunity.Id

Choosing a native Salesforce ID as account_id mandates that the Salesforce ID is propagated to your other systems, or vice versa.

Infusionsoft

CompanyID field in Company Object

CompanyID is typically sent from your product.

ContactID field in Contact Object

This approach may lead to problems as multiple contacts could match the same company, it's best when only one object maps to an account.

Capsule

Custom field in Party/Organisation Object

Typically sent from your product.

Contacts.website.webaddress field in Organisation Object

This is a manually entered field.

CUSTOMER SUPPORT
Freshdesk

Custom field in Companies Object

Typically sent from your product.

Email field in Contacts Object

If all emails exist under Natero account users or contacts, it can potentially be used to map support tickets to an account.

Note that this is a manually entered field.

Desk (legacy)

Custom field in Companies Object

Typically sent from your product.

Email in Customers object, Domain in Companies object

If all emails exist under Natero account users or contacts, it can potentially be used to map support tickets to an account.

Note that this is a manually entered field.

If using Domain, a mapping to account_id must exist somewhere else.

Zendesk

External_id field in Organizations Object

Typically sent from your product.

Email field in Users Object

If all emails exist under Natero account users or contacts, it can potentially be used to map support tickets to an account.

Note that this is a manually entered field.

JIRA

Custom field in Issues Object

Typically sent from your product

Store existing Id field in Jira Issues as account_support_id in Natero Accounts

If Jira Issues object has an Id referring to an account, you can add that Id within Natero Accounts as account_support_id and we can use that field to link support tickets to your accounts.

FINANCIAL
Recurly

Store and map Recurly Account.account_code into an external system.

Recurly support for custom fields is non existent.

Best practice is to create your new accounts in your SOR then create Recurly accounts automatically, and store the Recurly account_code in your SOR.

Email field in Account Object

If all emails exist under Natero account users or contacts, it can potentially be used to map Recurly accounts to Natero accounts.

Note that this is a manually entered field.

Zuora

Custom field in Account Object

Typically sent from your product.

Store and Map Zuora Account.Id into an external system

For example using the Zuora plug-in for Salesforce.

Chargebee

Custom field/metadata in Customers Object

Typically sent from your product.

ID field in Customers Object

Choosing a native Chargebee ID as account_id mandates that this ID is propagated to your other systems.

Chargify

Reference field in Customers Object

Typically sent from your product.

Email field in Customers Object

If all emails exist under Natero account users or contacts, it can potentially be used to map Chargify accounts to Natero accounts.

Note that this is a manually entered field.

Braintree

Custom field in Customer Object

Typically sent from your product.

Email field in Customer Object

If all emails exist under Natero account users or contacts, it can potentially be used to map Braintree accounts to Natero accounts.

Note that this is a manually entered field.

Stripe

Custom field/Meta Data in Customers Object

Typically sent from your product.

Email field in Customers Object

If all emails exist under Natero account users or contacts, it can potentially be used to map Stripe accounts to Natero accounts.

Note that this is a manually entered field.

Xero

AccountNumber field in Contacts object

Populate it with your own product account ID.

Email field in Contacts Object

If all emails exist under Natero account users or contacts, it can potentially be used to map Xero accounts to Natero accounts.

Note that this is a manually entered field.

INTERACTIONS
Intercom

Company_id field in Companies Object

Typically sent from your product.

Custom_attributes field in users Object

Typically sent from your product.

NPS
Delighted  

Person.email field in SurveyResponse Object

If all emails exist under Natero account users or contacts, it can potentially be used to map Delighted contacts to Natero accounts.

Note that this is a manually entered field.

Have more questions? Submit a request