In this article:
- Decide 3rd-party fields
- Decide data types
- Reverse syncing
- Custom business logic
- How often data is updated
- How to maintain data cleanness
Freshsuccess supports syncing of custom fields from your third party systems to your Freshsuccess instance for both accounts and users, provided that account/user mapping is defined. Custom fields enrich your customer data in Freshsuccess and allow for more flexible segmentation and in-depth analysis.
Decide 3rd-party fields
The first step is to decide which 3rd-party fields you'd like to sync to Freshsuccess to complement your account/user data. Upon request, we can generate a pre-populated spreadsheet of all possible fields from your choice of 3rd-party system, so you can pick the ones you'd like to sync.
Alternatively, you can send us a list of fields with underlying names (NOT the display names) to be synced to Freshsuccess. Note that your plan tier decides how many 3rd-party fields are allowed to be synced to Freshsuccess.
Decide data types
The next step is to decide which type(s) of data those fields should be synced to Freshsuccess so you can manipulate the way you want for charting, alerting, health scoring and segmentation etc..
Freshsuccess supports the following data types for syncing custom fields:
1. Account custom dimensions
3rd-party account fields can be synced as account custom dimensions. Freshsuccess will not track historical value for custom dimensions so you'll get a snapshot view of the latest value for each dimension synced across your accounts. Freshsuccess currently supports textual, numeric and date/event dimensions.
2. Account custom metrics
Freshsuccess also supports syncing 3rd-party fields as account custom metrics. In which case, Freshsuccess will track the historical value of the fields synced (on a daily basis) so you can use that to plot a chart to view trends. This is only applicable to numeric fields.
3. User custom dimensions
Freshsuccess supports syncing 3rd-party fields as user-level dimensions for textual, numeric and date/event values. Like account dimensions, Freshsuccess will not track historical value for user custom dimensions.
Note that Freshsuccess does not support 3rd-party fields syncing for user custom metrics, it should be sent to Freshsuccess via the JS library or Event API.
Freshsuccess supports reverse syncing of certain native account & user dimensions and metrics back to your 3rd-party system (e.g. account health score, user activity rank, etc.). We don't have a predefined list of them, the feasibility of a particular field will be investigated upon request.
Please specify the object under which your 3rd-party field is located for us to reverse sync the value from Freshsuccess.
Custom business logic
Freshsuccess can utilize internal triggers if you need to use complex rules to set account field values beyond simple field mapping. For example, a trigger could automatically churn any accounts that no longer have revenue and active subscriptions.
How often data is updated
Freshsuccess runs 3rd-party connectors on a nightly basis so any update to the synced fields in your 3rd-party system will be reflected within the next 24 hours.
Freshsuccess alert rules and workflow auto-deployment rules typically run every three hours, and data in the custom dashboard are automatically refreshed every six hours. Freshsuccess runs account health score calculations on a nightly basis, but users can manually run the current health score configuration via the UI at any time.
Internal triggers are maintained by Freshsuccess and typically run every six hours.
How to maintain data cleanness
The main focus should be on maintaining a clear account id across systems so that data from all sources can be properly mapped to the accounts in Freshsuccess. That's said, reducing the dependencies across multiple systems is recommended and will allow troubleshooting easier if there is a data discrepancy in Freshsuccess.
Make sure you are only capturing the information you care about in your 3rd-party systems. Or filters should be defined clearly to allow Freshsuccess to sync a subset of your data and leave the "garbage" out.