Custom ETL

With Insycle, there are several ways you can standardize field data in your CRM. To analyze the variations in your database and make quick bulk changes, use the Cleanse Data module. The Transform Data module is perfect for standardizing data in bulk, one-time, or automatically on an ongoing basis. If you have data from an external source that you want to make consistent with your CRM while importing, use the Magical Import module.

To learn more, see:

• Standardize Job Titles, Industries, Location
• Standardize Job Title, Industry, State, Country, or Any Other Free-Text Field

When your data comes from many sources—website forms, internal data entry, integrations, and APIs—enforcing formats in specific fields is difficult. The inconsistent values make records difficult to segment and search for.

With Insycle, you can format any field in your database using pre-defined rulesets, and create templates to automate consistent field formatting. Existing data in any field can be formatted in bulk with the Transform Data module, or if you have an export from a third-party application or other data in a CSV, the new data can be formatted on import using the Magical Import module.

To learn more, see:

• Format Names, Phone Numbers, and Addresses
• Format Phone Numbers for Country Codes
• Populate Country Based on Domain

Ensuring that you have the correct data in the right field is important for keeping your data filterable and usable—both for your teams and for integrations. Doing this manually is a time-consuming process. 

For example, on contact records that have a value in the Mobile Phone Number field, but don't have a value in the Phone Number field, you'd like to move data from the Mobile Phone Number to the Phone Number field.

In the Transform Data module, you can use rule-based templates to quickly identify fields and automatically copy or move data between them.

To learn more, see:

• Copy or Move Values Between Fields
• Consolidate and Retire Legacy Fields

Ensuring that you have the correct data in the right field is important for keeping your data filterable and usable—both for your teams and for integrations. But sometimes, you need to fill in a field based on the values in another field. For example, when a contact's Job Title is "Chief Executive Officer," you may want to write "CEO Helena" into your Persona field. 

The Transform Data module lets you filter data, and use existing data in a field to specify what value should be copied to a new field.

To learn more, see:

• Map Values From One Field to Another
• Map Industry Values From External Data Sources

You need to make bulk updates to a field based on values that have been entered in another field. For example, when the State/Region value in a record is "Quebec," you want to set the Country field value to "Canada."

Insycle makes it easy to identify records that have a specific field value and update them based on your defined conditions. For straightforward, "If value=x, set it to=y," tasks, use the Bulk Operations module. For more complex tasks where you need to do multiple conditional bulk updates all in one template, the Transform Data module would be more appropriate.

To learn more, see the Conditional Bulk Update if Value=x Then Set It To=y article.