Check out our new Chrome Extension.

Salesforce Integration

Overview

Salesforce provides customer relationship management service and also sells a complementary suite of enterprise applications focused on customer service, marketing automation, analytics, and application development.

With the Salesforce integration enabled, accounts on all paid plans can manually create new Sales accounts from Store Leads domains. Existing Sales accounts can also be manually updated.

Accounts on the Pro or Elite plans can also:

  • Automatically update all existing Salesforce accounts and leads with the latest Store Leads data. This can be configured to happen automatically as soon as we refresh our data (weekly) or triggered manually.
  • Automatically update Salesforce accounts when they are manually created or modified within Salesforce.
  • Automatically update Salesforce leads when they are manually created or modified within Salesforce.
  • Automatically create new Salesforce accounts for any new stores on a list.
  • Export domains to a CSV file that is compatible with Salesforce CSV import. This is useful for initially creating accounts in Salesforce or for manual bulk updates.

Requirements

You will need the following to enable the Salesforce integration.

  • To connect to Salesforce with a user account that has permission to use the Salesforce API. You may wish to create a Salesforce API user for this purpose.
  • The Account object in Salesforce must have the following fields visible to the API user. You may need to set field-level permissions so that the fields are visible to the API user.
    • Website
    • IsDeleted

Enabling the Salesforce Integration

  1. To enable the Salesforce integration, visit the Integrations page in the Dashboard and click on Salesforce.

    Salesforce Integration Summary
    Salesforce Integration Summary.
  2. You'll see a page that summarizes the Salesforce integration. Click the enable button to proceed.

    Enable Salesforce Integration
    Enable Salesforce Integration.
  3. At this point, you may be asked to login to your Salesforce instance. You'll also be asked for permission to allow Store Leads to manage data in your Salesforce instance. You must approve this request in order to use the Salesforce integration.

    Once you approve the request, your Salesforce integration will be enabled. As soon as the integration is enabled, we scan your Salesforce instance to see if there is any overlap between accounts in Salesforce and domains in the Store Leads database.

    Note: When the Salesforce integration is first enabled, you will be establishing the "Organization Connection" between Salesforce and Store Leads. All automated enrichment performed by Store Leads will be done with the Salesforce account credentials that you use here. Often, it is best to use a dedicated API account to establish the Organization connection.

Connecting to Salesforce with Individual Accounts

When the Salesforce integration is enabled by the Store Leads account owner, it establishes an "Organization Connection" to Salesforce. This means that:

  • All automated actions that Store Leads performs in Salesforce will be done using the Salesforce credential supplied when establishing the organization connection.
  • If you have share access to your Store Leads account with other users, then any manual actions performed by those users will also default to using the Salesforce credentials of the organization connection. To fix this, each Store Leads user can also connect to Salesforce using their own Salesforce account credentials. Doing so ensures that accounts created manually by a user are attributed to the right person in Salesforce. Each account should visit the Integrations page, click on the "Salesforce" link and then click on the "Connect to Salesforce" button.
Enable Salesforce Integration
Enable Salesforce Integration.

Disabling the Salesforce Integration

If you wish to deactivate the integration, simply click the disable button.

Disable Salesforce Integration
Disable Salesforce Integration.

Account Enrichment

By default, Store Leads will automatically enrich Salesforce accounts every week when we publish our weekly data update. Salesforce accounts are also enriched shortly after they are created or changed. Salesforce accounts are only enriched if they have a Website that matches a store in our database that your plan can access.

Fields Mappings For Salesforce Accounts

Store Leads will not send any data to Salesforce until you configure field mappings. Field mappings determine which Store Leads data is written to specific fields in Salesforce Accounts.

To configure these field mappings, visit the Integrations page, click Salesforce and go to the Account Field Mappings section.

Salesforce Account Custom Fields
Salesforce Account Custom Fields.

You may need to create new Account fields within Salesforce Setup to accomodate Store Leads data. Be sure to configure field-level permissions so that the field is visible to the connected account.

The following fields can be sent to Salesforce.

Alexa Rank
  • The Alexa rank of the store's ecommerce website domain.
  • Suggested field type: Number
Aliases
  • A list of alternate domain names for the store's ecommerce website.
  • Suggested field type: Text (with max length 255)
Average Product Price
  • The average price of products sold in the store's ecommerce website. Names in the major unit of the store's currency (e.g., dollars of USD).
  • Suggested field type: Number
Categories
  • A list of the store's ecommerce website categories. Categories represent the store's industry vertical (e.g., "/Apparel" or "/Beauty & Fitness/Face & Body Care")"
  • Suggested field type: Multipicklist
City
  • The city of the merchant (if known)
  • Suggested field type: Text (with max length 64)
Country Code
  • The store's country code.
  • Suggested field type: Text (with max length 2)
Created At
  • The date at which the store's ecommerce website was created.
  • Suggested field type: Date
Currency Code
  • The 3-letter ISO currency code used on the store's ecommerce website.
  • Suggested field type: Text (with max length 3)
Description
  • A text description of the store's ecommerce website. Generally used to describe the goods and services provided by the merchant. Comes from the meta description tag on the stores's home page.
  • Suggested field type: TextArea (Long)
E-Commerce Plan
  • The name of the ecommerce platform's pricing plan that the merchant is using (if known). e.g. "Shopify Plus"
  • Suggested field type: Text (with max length 64)
Email addresses
  • The email address(es) listed on the company's ecommerce website
  • Suggested field type: Text (with max length 255)
Employees
  • The number of employees working at the company that runs the store (if known).
  • Suggested field type: Number
Estimated Monthly Sales
  • The store's estimated monthly sales (based on traffic estimates to the store's ecommerce website). Names in USD dollars.
  • Suggested field type: Number
Facebook Account
  • The name of the company's Facebook account.
  • Suggested field type: Text (with max length 64)
Facebook Account Followers
  • The number of Facebook account followers
  • Suggested field type: Number
Facebook Account Followers Delta 30-day
  • The change in the number of Facebook followers over the last 30 days.
  • Suggested field type: Number
Facebook Account URL
  • The URL of the company's Facebook account.
  • Suggested field type: Text (with max length 255)
Facebook Group
  • The name of the company's Facebook group.
  • Suggested field type: Text (with max length 128)
Facebook Group Followers
  • The number of Facebook group followers
  • Suggested field type: Number
Facebook Group Followers Delta 30-day
  • The change in the number of Facebook group followers over the last 30 days.
  • Suggested field type: Number
Facebook Group URL
  • The URL of the company's Facebook group.
  • Suggested field type: Text (with max length 255)
Features
  • A list of features enabled on the domain. e.g., "Shopify Pay"
  • Suggested field type: Text (with max length 255)
Full Address
  • The full address of the store (includes street address, city, state, country if known).
  • Suggested field type: Text (with max length 255)
Instagram Account
  • The name of the company's Instagram account.
  • Suggested field type: Text (with max length 64)
Instagram Followers
  • The number of Instagram followers
  • Suggested field type: Number
Instagram Followers Delta 30-day
  • The change in the number of Instagram followers over the last 30 days.
  • Suggested field type: Number
Instagram URL
  • The URL of the company's Instagram account.
  • Suggested field type: Text (with max length 255)
Last Crawled At
  • The date at which the store's website was last crawled.
  • Suggested field type: Date
Last Plan Change At
  • The date at which the store's ecommerce platform's pricing plan was last changed.
  • Suggested field type: Date
Last Platform
  • The ecommerce platform that the store previously used (if any), prior to switching to their current platform
  • Suggested field type: Picklist
Last Platform Change At
  • The date at which the store changed from their last ecommerce platform to their current ecommerce platform.
  • Suggested field type: Date
LinkedIn Company URL
  • The URL of the company's LinkedIn page.
  • Suggested field type: Text (with max length 255)
Magento Apps
  • A list of Magento apps installed on the store's ecommerce website
  • Suggested field type: TextArea (Long)
Merchant Name
  • The name of the merchant that is selling on the store's ecommerce store.
  • Suggested field type: Text (with max length 255)
Monthly E-Commerce App Spend (USD)
  • The estimated amount the store spends on ecommerce apps every month.
  • Suggested field type: Number
Phone number (1st)
  • The company's first phone number.
  • Suggested field type: Text (with max length 64)
Phone number (2nd)
  • The company's second phone number.
  • Suggested field type: Text (with max length 64)
Phone number (3rd)
  • The company's third phone number.
  • Suggested field type: Text (with max length 64)
Phone numbers
  • The phone number(s) listed on the company's ecommerce website
  • Suggested field type: Text (with max length 255)
Pinterest Account
  • The name of the company's Pinterest account.
  • Suggested field type: Text (with max length 64)
Pinterest Followers
  • The number of Pinterest followers
  • Suggested field type: Number
Pinterest Followers Delta 30-day
  • The change in the number of Pinterest followers over the last 30 days.
  • Suggested field type: Number
Pinterest URL
  • The URL of the company's Pinterest account.
  • Suggested field type: Text (with max length 255)
Platform
  • The ecommerce platform of the store's ecommerce website. (e.g., shopify or magento)
  • Suggested field type: Picklist
Platform Domain
  • The name of the store's "platform domain". Some ecommerce platforms provide a unique internal domain (e.g., merchant.myshopify.com) that is associated with each store. Merchants can use this domain for their store but most choose to purhcase and register a custom DNS domain.
  • Suggested field type: Text (with max length 128)
Platform Rank
  • The Store Leads platform rank for the domain - a measure of the store's popularity relative to all other stores on the same platform.
  • Suggested field type: Number
Product Variant Count
  • The number of product variants (aka SKUs) sold on the store's ecommerce website.
  • Suggested field type: Number
Products Sold
  • The number of products sold on the store's ecommerce website.
  • Suggested field type: Number
Rank
  • The Store Leads rank for the domain - a measure of the store's popularity relative to all other stores.
  • Suggested field type: Number
Record Source
  • The source of the record (always set to "Store Leads")
  • Suggested field type: Text (with max length 32)
Shopify Apps
  • A list of Shopify apps installed on the store's ecommerce website
  • Suggested field type: TextArea (Long)
State or Province
  • The state or province of the merchant (if known)
  • Suggested field type: Text (with max length 32)
State or Province Code
  • The 2-letter state or province code of the merchant (if known)
  • Suggested field type: Text (with max length 2)
Status
  • The store's status (e.g., active or inactive)
  • Suggested field type: Text (with max length 32)
Store Domain
  • The DNS domain name of the ecommerce store.
  • Suggested field type: Text (with max length 255)
Street Address
  • The street address of the store (if known).
  • Suggested field type: Text (with max length 255)
TLD+1
  • The "top-level domain plus one" for the domain. For a domain named www.merchant.com, the TLD+1 is merchant.com
  • Suggested field type: Text (with max length 64)
Technologies
  • A list of third-party technologies installed on the store's ecommerce website
  • Suggested field type: Multipicklist
TikTok Account
  • The name of the company's TitTok account.
  • Suggested field type: Text (with max length 255)
TikTok Followers
  • The number of TikTok followers
  • Suggested field type: Number
TikTok Followers Delta 30-day
  • The change in the number of TikTok followers over the last 30 days.
  • Suggested field type: Number
TikTok URL
  • The URL of the company's TikTok account.
  • Suggested field type: Text (with max length 255)
Title
  • The title tag on the store's ecommerce website home page
  • Suggested field type: Text (with max length 255)
Twitter Account
  • The name of the company's Twitter account.
  • Suggested field type: Text (with max length 255)
Twitter Followers
  • The number of Twitter followers
  • Suggested field type: Number
Twitter Followers Delta 30-day
  • The change in the number of Twitter followers over the last 30 days.
  • Suggested field type: Number
Twitter URL
  • The URL of the company's Twitter account.
  • Suggested field type: Text (with max length 255)
Vendor Count
  • The number of distinct vendors of products sold on the store's ecommerce website. (Only available for Shopify stores)
  • Suggested field type: Number
YouTube Account
  • The name of the company's YouTube account.
  • Suggested field type: Text (with max length 255)
YouTube Followers
  • The number of YouTube followers
  • Suggested field type: Number
YouTube Followers Delta 30-day
  • The change in the number of YouTube followers over the last 30 days.
  • Suggested field type: Number
YouTube URL
  • The URL of the company's YouTube account.
  • Suggested field type: Text (with max length 255)
ZIP or Postal Code
  • The zip or postal code of the merchant (if known)
  • Suggested field type: Text (with max length 32)

Manual Creation of Salesforce Accounts

The Salesforce integration allows you to manually create accounts in Salesforce from Store Leads domains. To do so, open the Salesforce integration menu by clicking on the Salesforce icon in the integration bar (which is in the top right corner of the page when you are looking at domain details in Store Leads).

Integration Bar
Integration Bar.

As long as the domain does not already exist in Salesforce, you'll be given the option to create a Salesforce Account for the domain.

Create Salesforce Account
Create Salesforce Account.

As soon as you click Create Salesforce Account, Store Leads will create a new Salesforce account for the domain and set all the standard and custom fields configured for the integration.

Manual Update of Salesforce Accounts

When you're looking at a domain in Store Leads that already exists as a Salesforce Account, the Salesforce integration menu allows you to Open in Salesforce (which opens the Salesforce Account in a new browser tab) and Update Salesforce Account. Clicking on the latter will immediately update the Salesforce Account with all standard and custom fields configured for the integration.

Update Salesforce Account
Update Salesforce Account.

Bulk Creation of Salesforce Accounts (via CSV Import)

To bulk create new Salesforce Accounts, use the Store Leads Export tool and select the Salesforce Account CSV format.

Salesforce Account CSV Export Format
Salesforce Account CSV Export Format.

If the export file contains less than 50,000 records, use the Salesforce Data Import Wizard.

If the export file contains more than 50,000 records, use the Salesforce Data Loader.

Automatic Enrichment of Salesforce Accounts

We can automatically keep the data you store in Salesforce in sync with the latest data on Store Leads. This feature is called automatic enrichment. When it is enabled, Salesforce accounts are enriched within 15 minutes of being created or updated in Salesforce and immediately after we do our weekly data updates. Accounts are matched to stores in our database using the "Website" field. Your paid plan must also have access to the store in question.

To enable automatic Salesforce account enrichment, visit the Salesforce section of the Integrations page and enable the following option.

Salesforce Account Enrichment
Salesforce Account Enrichment.

Note: this feature is only available to accounts on the Pro or Elite plans.

Automatic Salesforce Account Creation On New Store Leads Data

New Salesforce accounts can automatically be created during our weekly data updates for any new stores on a list.

To enable this functionality, go to any list and check the following option:

Create New in Salesforce
Create New in Salesforce.

Every week, as soon as we complete our data update, we'll find all lists that have this option enabled. We then find all stores on the list and a new Salesforce account will be created for all stores that do not already exist in Salesforce.

As an example, you can define a list as a saved search that contains all stores with at least 250,000 Instagram followers. By enabling this option on the list, you can ensure that your Salesforce instance will include all accounts that have at least 250,000 Instagram followers (both now and in the future).

Note: this feature is only available to accounts on the Pro or Elite plans.

Lead Enrichment

Store Leads can automatically enrich Salesforce leads every week when we publish our weekly data update. Salesforce leads can also be enriched shortly after they are created or changed.

Salesforce leads are only enriched if one of the following is true:

  • The lead has a Website that matches a store in our database that your plan can access. Website matching is fuzzy, so it doesn't matter if the Website starts with http:// or https:// or if it incluces www. at the beginning of the domain name.
  • The lead has an Email with a domain name that matches a store in our database that your plan can access. Email domain matching is also fuzzy.

To enable enrichment of Salesforce leads, check the "Enrich leads" option.

Salesforce Enrich Leads Option
Salesforce Enrich Leads Option.

Fields Mappings For Salesforce Leads

Store Leads will not send any data to Salesforce leads until you configure lead field mappings. Lead field mappings determine which Store Leads data is written to specific fields on Salesforce Leads.

To configure lead field mappings, visit the Integrations page, click Salesforce and go to the Lead Field Mappings section.

Automatic Enrichment of Salesforce Accounts

We can automatically keep the data you store in Salesforce in sync with the latest data on Store Leads. This feature is called automatic enrichment. When it is enabled, Salesforce leads are enriched within 15 minutes of being created or updated in Salesforce and immediately after we do our weekly data updates. Leads are matched to stores in our database using the "Email" and "Website" fields. Your paid plan must also have access to the store in question.

To enable automatic Salesforce lead enrichment, visit the Salesforce section of the Integrations page and enable the following option.

Salesforce Lead Enrichment
Salesforce Lead Enrichment.

Notes:

  • These search filters are currently only updated once every 24 hours. If you just enabled the HubSpot integration, the filters won't show up until tomorrow. This restriction will be removed soon.
  • These search filters are only available to accounts on the Pro or Elite plans.

Using Salesforce Data Within Store Leads

Your Salesforce data can also be used/displayed within Store Leads in a variety of ways, including search filtering and viewing Salesforce attributes for each store in the database.

Search Filter

With the Salesforce integration enabled, new search filters are available that can be used to show all stores in the database that also exist as accounts (or leads) in your Salesforce instance. This filter is also supported in Advanced Search, allowing you to filter out stores that already exist in Salesforce (a great way to look at new leads).

Salesforce search filter.

To filter out stores that already exist in Salesforce, run an Advanced Search, and create a filter on the "Integration Companies" field with Operation set to "Not Or".

Advanced search to filter out stores that already exist as Salesforce accounts.

Note: These search filters are currently only updated once every 24 hours. If you just enabled the Salesforce integration, the filters won't show up until tomorrow. This restriction will be removed soon.

Note: These search filters are only available to accounts on the Pro or Elite plans.

Search Results

Salesforce data can be displayed as a column in search results. To do so, customize the columns displayed in search results to include "Salesforce Account".

This provides a way to visually filter search results by showing the stores that already exist in Salesforce. You can also click on the "Salesforce Account" link to open the Salesforce Account page directly from search results.

Store Details

With the Salesforce integration enabled, a new "Salesforce" tab is available when viewing store details.

Store CRM details.

The list of fields to display for Salesforce Accounts, Contacts and Leads can be fully customized. Data display is fetched on demand from the Salesforce API and is never stored by Store Leads. For more details, read displaying Salesforce data within Store Leads.

Chrome Extension

It's also possible to display data for Salesforce Accounts, Contacts and Leads within the Store Leads Chrome Extension.

Best Practices

  • Connect your organization to Salesforce using a dedicated Salesforce API account. If you connect to Salesforce using an account linked to a person, the Store Leads integration with Salesforce will break if that person's account is disabled in Salesforce (which often happens when the person leaves the company).
  • Enable the "Use Salesforce Bulk API" option under "Salesforce Configuration Options". Using the Bulk API uses fewer Salesforce API calls and speeds up bulk enrichment. Note that this feature is only available on certain Salesforce plans and requires a specific account permission ("Manage Data Integrations"). Be sure to add that permission to the Salesforce account that you are using for your Organization connection.
  • Enable the "Daily Integration Error Email" option under "Salesforce Configuration Options". Store Leads is sometimes unable to enrich records in Salesforce due to validation checks and other configuration within Salesforce. For instance, we may try to write data to a field that no longer exists or has a restricted picklist that is not accepting the incoming value. When enabled, this email includes a summary of errors seen in the last 24 hours.
    Salesforce Integration Error Email option
    Salesforce Integration Error Email option.
  • Each person using Store Leads should also connect to Salesforce with their personal account. If they do not, then all Salesforce API calls made when using Store Leads are done with the organization connection. As a result, newly created accounts and leads will not be attributed to the right person.

Information Security Considerations

Since your Salesforce instance contains PII, it is natural to have concerns about information security when connecting a new app to Salesforce. Here is an overview of how Store Leads interacts with Salesforce.

After the Salesforce integration is enabled, Store Leads will query all Account records to determine which Accounts already exist in Salesforce. This is necessary so that:

  • the Store Leads web interface/chrome extension can tell whether a store already exists in your CRM, and
  • to enrich all your existing Account records on a weekly basis and
  • to prevent creating duplicate records

To accomplish this, each Account's Website and Id attribute are retrieved using the Salesforce API and stored in our database. These are the only attributes accessed at this time.

By default, only Account enrichment is enabled. If you choose to enable the "Enrich Leads" option in your integration), then we also need to pull and persist a lead identifier (which is the lead's email address and/or Website since leads don't always have an email) for the same reasons listed above. This data is never shared.

The only time that attributes other than Website and Id are retrieved for an Account record (or Email/Website/Id for Leads), is when a Store Leads user looks at the Salesforce data for Accounts, Leads or Contacts through the Store Leads website or Chrome extension. Both of those features allow each user to configure which attributes to pull from the CRM but these attributes are never stored. They are pulled from the Salesforce API live (to render the page) and never persisted. This data might include PII but since a) it is not persisted and b) it is configurable, it should hopefully be a minor concern.