Salesforce Pipeline Analysis SpotApp

SpotApps are ThoughtSpot’s out-of-the-box solution templates built for specific use cases and data sources. They are built on ThoughtSpot Modeling Language (TML) Blocks, which are pre-built pieces of code that are easy to download and implement directly from the product.

The Salesforce Pipeline Analysis SpotApp mimics the Salesforce data model. When you deploy it, ThoughtSpot creates several worksheets, answers, and Liveboards, based on your Salesforce data in your cloud data warehouse.

This is a sample Liveboard, created after you deploy the Salesforce Pipeline Analysis SpotApp:

Salesforce SpotApp Liveboard

Use the Salesforce Pipeline Analysis SpotApp to track how prospects progress closer to closed deals.

Prerequisites

Before you can deploy the Salesforce Pipeline Analysis SpotApp, you must complete the following prerequisites:

Run SQL commands

Run the following SQL commands on your cloud data warehouse instance. The commands create 5 views in your cloud data warehouse schema. Create the views in one common database. Replace any parts of the script that say database_name with your specific database name, and replace schema_name with your specific schema name.

The following SQL example is for the Snowflake cloud data warehouse. You may need to modify the code for the SQL requirements of your specific cloud data warehouse.

SQL commands:

Click on the dropdown to view the SQL commands.
create or replace view database_name.schema_name.ACCOUNT
as
select * from database_name.schema_name."ACCOUNT";

create or replace view database_name.schema_name.OPPORTUNITY
as
select * from database_name.schema_name."OPPORTUNITY";

create or replace view database_name.schema_name.OPPORTUNITY_HISTORY
as
select * from database_name.schema_name."OPPORTUNITY_HISTORY";

create or replace view database_name.schema_name.OPPORTUNITY_STAGE
as
select * from database_name.schema_name."OPPORTUNITY_STAGE";

create or replace view database_name.schema_name.USER
as
select * from database_name.schema_name."USER";

create or replace view database_name.schema_name.CURRENCY_TYPE
as
select * from database_name.schema_name."CURRENCY_TYPE";

Deploy the Salesforce Pipeline Analysis SpotApp

After you complete the prerequisites, you are ready to deploy the Salesforce Pipeline Analysis SpotApp and begin leveraging its pre-built content.

To deploy the Salesforce Pipeline Analysis SpotApp, refer to Deploying SpotApps.

Salesforce Pipeline Analysis SpotApp schema

The following table describes the schema for the Salesforce Pipeline Analysis SpotApp.

Table Column Column type Required column

ACCOUNT

ID

VARCHAR

N

ACCOUNT

IS_DELETED

BOOL

N

ACCOUNT

NAME

VARCHAR

Y

ACCOUNT

TYPE

VARCHAR

N

ACCOUNT

INDUSTRY

VARCHAR

N

ACCOUNT

ANNUAL_REVENUE

INT64

N

ACCOUNT

NUMBER_OF_EMPLOYEES

INT64

N

ACCOUNT

REGION

VARCHAR

N

CURRENCY_TYPE

ISO_CODE

VARCHAR

Y

CURRENCY_TYPE

CONVERSION_RATE

DOUBLE

Y

OPPORTUNITY

STAGE_NAME

VARCHAR

Y

OPPORTUNITY

ACCOUNT_ID

VARCHAR

Y

OPPORTUNITY

NAME

VARCHAR

Y

OPPORTUNITY

AMOUNT

DOUBLE

Y

OPPORTUNITY

EXPECTED_REVENUE

DOUBLE

N

OPPORTUNITY

TOTAL_OPPORTUNITY_QUANTITY

DOUBLE

N

OPPORTUNITY

CLOSE_DATE

DATE

Y

OPPORTUNITY

TYPE

VARCHAR

Y

OPPORTUNITY

CAMPAIGN_ID

VARCHAR

N

OPPORTUNITY

CREATED_DATE

DATE_TIME

Y

OPPORTUNITY

FORECAST_CATEGORY

VARCHAR

N

OPPORTUNITY

ID

VARCHAR

Y

OPPORTUNITY

OWNER_ID

VARCHAR

Y

OPPORTUNITY

LEAD_SOURCE

VARCHAR

N

OPPORTUNITY_HISTORY

FORECAST_CATEGORY

VARCHAR

N

OPPORTUNITY_HISTORY

OPPORTUNITY_ID

VARCHAR

Y

OPPORTUNITY_HISTORY

STAGE_NAME

VARCHAR

Y

OPPORTUNITY_STAGE

IS_ACTIVE

BOOL

Y

OPPORTUNITY_STAGE

IS_CLOSED

BOOL

Y

OPPORTUNITY_STAGE

API_NAME

VARCHAR

Y

OPPORTUNITY_STAGE

IS_WON

BOOL

Y

USER

NAME

VARCHAR

Y

USER

COMPANY_NAME

VARCHAR

N

USER

ID

VARCHAR

Y