How to maximize the value of your Salesforce data

Learn how Fivetran can help you get the most out of an extremely popular data source.
October 14, 2022

Salesforce is a cloud-based customer relationship management (CRM) tool that helps companies connect with customers, partners and potential customers.

Salesforce objects allow you to store data specific to your organization. Standard objects within Salesforce include account, contact, lead and opportunity. You can also create custom objects to store information specific to your business or industry. For instance, if you were an ice-cream business, you could have a custom object called "flavor" to keep track of your most popular ice-cream flavors per account or customer. Then you could make a calculation to determine your most popular flavor.

To get the most out of Salesforce, you will want to:

1. Analyze all of your Salesforce data

Fivetran pulls all the underlying data from Salesforce into a SQL-enabled environment. With access to the full data set, you will be able to transform and display the data, enabling you to deeply understand your CRM operations. Business intelligence (BI) tools such as Looker and Tableau make this easy. When you select fields such as opportunity start and end date, the BI tool performs transformations under the hood to make the data legible to you. You can also apply some logic to handle missing or incomplete data — using Fivetran Transformations, you can build a transformation that pulls start and end dates from the contract object (if available), and the CPQ quote object (if the contract has not been finalized yet).

Another reason to comprehensively replicate Salesforce data is that the data set provides calculated values in formula fields, but the underlying calculations are not carried over when you replicate the data, and the fields will not update to reflect changes to the underlying data. In order to faithfully recreate those formula fields, you should replicate the fields used to calculate the formula fields and recreate those calculations within your BI tool or using Fivetran Transformations.

2. Combine your Salesforce data with data from other sources

Data from Salesforce only represents part of your organization’s workflow. You can combine Salesforce data with other sources to build a comprehensive picture of how your customers interact with your products and services. For instance, you can blend Salesforce data with data from support desk software like Zendesk in order to see the most revenue-intensive support tickets and assign priorities to your engineers; and you can combine Salesforce data with event tracking data from apps like Mixpanel to identify the behaviors and customers that generate the most revenue. To measure the success of your digital advertising funnel, you can combine Salesforce data with advertising data from Facebook, Google, Bing and more.

Using Fivetran connectors, you can also link your Salesforce data with data from other sources under the broader Salesforce umbrella, including Salesforce Marketing Cloud, Salesforce Support Cloud and Pardot.

3. Increase reliability and ease of use with Fivetran

The Salesforce API is very complicated, with a huge range of tables with different update and delete mechanisms. Building and maintaining your own connector to integrate data from Salesforce and other sources is tricky and time-consuming. The Fivetran Salesforce connector is the first one we ever built, which means we’ve discovered and worked around every edge case across hundreds of customers. Moreover, it takes only a few minutes to set up, can replicate data on a continuous basis, and automatically migrates schema changes.

Other features Fivetran offers include control over individual tables and fields that are synced, column hashing for sensitive data, incremental updates that preserve your API call quota, and comprehensive logging of every API call and SQL transformation.

4. Transforming your Salesforce data

As we mentioned, you can use Fivetran Transformations for dbt Core™* to transform your Salesforce data into analytics-ready tables. We have now made this process even easier with our Quickstart data models for Salesforce. These all clicks approach to data transformations let you download, orchestrate, and manage data transformations in sequence with your Fivetran connector loads. This also works for Formula Fields you might build in Salesforce. Read more about Quickstart data models here.

Commencer gratuitement

Rejoignez les milliers d’entreprises qui utilisent Fivetran pour centraliser et transformer leur data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Product
Product

How to maximize the value of your Salesforce data

How to maximize the value of your Salesforce data

October 14, 2022
October 14, 2022
How to maximize the value of your Salesforce data
Learn how Fivetran can help you get the most out of an extremely popular data source.

Salesforce is a cloud-based customer relationship management (CRM) tool that helps companies connect with customers, partners and potential customers.

Salesforce objects allow you to store data specific to your organization. Standard objects within Salesforce include account, contact, lead and opportunity. You can also create custom objects to store information specific to your business or industry. For instance, if you were an ice-cream business, you could have a custom object called "flavor" to keep track of your most popular ice-cream flavors per account or customer. Then you could make a calculation to determine your most popular flavor.

To get the most out of Salesforce, you will want to:

1. Analyze all of your Salesforce data

Fivetran pulls all the underlying data from Salesforce into a SQL-enabled environment. With access to the full data set, you will be able to transform and display the data, enabling you to deeply understand your CRM operations. Business intelligence (BI) tools such as Looker and Tableau make this easy. When you select fields such as opportunity start and end date, the BI tool performs transformations under the hood to make the data legible to you. You can also apply some logic to handle missing or incomplete data — using Fivetran Transformations, you can build a transformation that pulls start and end dates from the contract object (if available), and the CPQ quote object (if the contract has not been finalized yet).

Another reason to comprehensively replicate Salesforce data is that the data set provides calculated values in formula fields, but the underlying calculations are not carried over when you replicate the data, and the fields will not update to reflect changes to the underlying data. In order to faithfully recreate those formula fields, you should replicate the fields used to calculate the formula fields and recreate those calculations within your BI tool or using Fivetran Transformations.

2. Combine your Salesforce data with data from other sources

Data from Salesforce only represents part of your organization’s workflow. You can combine Salesforce data with other sources to build a comprehensive picture of how your customers interact with your products and services. For instance, you can blend Salesforce data with data from support desk software like Zendesk in order to see the most revenue-intensive support tickets and assign priorities to your engineers; and you can combine Salesforce data with event tracking data from apps like Mixpanel to identify the behaviors and customers that generate the most revenue. To measure the success of your digital advertising funnel, you can combine Salesforce data with advertising data from Facebook, Google, Bing and more.

Using Fivetran connectors, you can also link your Salesforce data with data from other sources under the broader Salesforce umbrella, including Salesforce Marketing Cloud, Salesforce Support Cloud and Pardot.

3. Increase reliability and ease of use with Fivetran

The Salesforce API is very complicated, with a huge range of tables with different update and delete mechanisms. Building and maintaining your own connector to integrate data from Salesforce and other sources is tricky and time-consuming. The Fivetran Salesforce connector is the first one we ever built, which means we’ve discovered and worked around every edge case across hundreds of customers. Moreover, it takes only a few minutes to set up, can replicate data on a continuous basis, and automatically migrates schema changes.

Other features Fivetran offers include control over individual tables and fields that are synced, column hashing for sensitive data, incremental updates that preserve your API call quota, and comprehensive logging of every API call and SQL transformation.

4. Transforming your Salesforce data

As we mentioned, you can use Fivetran Transformations for dbt Core™* to transform your Salesforce data into analytics-ready tables. We have now made this process even easier with our Quickstart data models for Salesforce. These all clicks approach to data transformations let you download, orchestrate, and manage data transformations in sequence with your Fivetran connector loads. This also works for Formula Fields you might build in Salesforce. Read more about Quickstart data models here.

*dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

Topics
No items found.
Share

Articles associés

No items found.
No items found.
No items found.

Commencer gratuitement

Rejoignez les milliers d’entreprises qui utilisent Fivetran pour centraliser et transformer leur data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.