Table: salesforce_opportunity_contact_role - Query Salesforce Opportunity Contact Roles using SQL

Opportunity Contact Role in Salesforce is a junction object that links Contacts to Opportunities, showing the role that the contact plays in the specific opportunity. This role could be a decision maker, influencer, etc. It provides a way to specify the individuals who are involved in the business deal.

Table Usage Guide

The salesforce_opportunity_contact_role table provides insights into the roles that contacts play in specific opportunities within Salesforce. As a sales manager or business analyst, you can explore details about these roles through this table, including the contact's involvement in the opportunity, their influence level, and other associated metadata. Utilize it to uncover information about the relationships between contacts and opportunities, such as who are the main decision makers or influencers in a particular deal.

Important Notes

If the naming_convention configuration argument is set to api_native, please see API Native Examples.

Examples

Basic info

Explore which roles are associated with different opportunities in Salesforce to better understand the distribution of responsibilities within your organization. This can help to identify any gaps or overlaps in roles assigned to specific opportunities.

select
  id,
  contact_id,
  is_primary,
  opportunity_id,
  stage_name,
  role
from
  salesforce_opportunity_contact_role;

select
  id,
  contact_id,
  is_primary,
  opportunity_id,
  stage_name,
  role
from
  salesforce_opportunity_contact_role;

List primary opportunity contact roles

Determine the primary roles within your opportunities to better understand your salesforce interactions. This can help identify key contacts and their respective roles, helping to streamline communication and improve sales strategies.

select
  id,
  opportunity_id,
  contact_id,
  is_primary
from
  salesforce_opportunity_contact_role
where
  is_primary;

select
  id,
  opportunity_id,
  contact_id,
  is_primary
from
  salesforce_opportunity_contact_role
where
  is_primary;

API Native Examples

If the naming_convention config argument is set to api_native, the table and column names will match Salesforce naming conventions.

Basic info (with API Native naming convention)

Explore the primary contacts associated with specific business opportunities. This can help you understand the key individuals involved in each opportunity and their respective roles.

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName"
from
  "OpportunityContactRole";

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName"
from
  "OpportunityContactRole";

List primary opportunity contact roles (with API Native naming convention)

Identify the primary roles within opportunities to understand their significance and influence within your organization's operations.

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName"
from
  "OpportunityContactRole"
where
  "IsPrimary";

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName"
from
  "OpportunityContactRole"
where
  "IsPrimary";

Show opportunity contact roles created in last 30 days

Discover the roles of contacts associated with opportunities that were created in the past month. This could be useful for assessing recent changes in contact roles and understanding their involvement in new opportunities.

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName",
  "Role"
from
  "OpportunityContactRole"
where
  "CreatedDate" <= now() - interval '30' day;

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName",
  "Role"
from
  "OpportunityContactRole"
where
  "CreatedDate" <= datetime('now', '-30 day');

Show decision maker opportunity contact roles

Explore which roles in an opportunity are designated as 'Decision Makers'. This can be useful in identifying key individuals within a business opportunity.

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName",
  "Role"
from
  "OpportunityContactRole"
where
  "Role" = 'Decision Maker';

select
  "ID",
  "ContactID",
  "IsPrimary",
  "OpportunityID",
  "StageName",
  "Role"
from
  "OpportunityContactRole"
where
  "Role" = 'Decision Maker';

Schema for salesforce_opportunity_contact_role

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form.
contact_id	text	ID of an associated Contact.
created_by_id	text	Id of the user who created contact role record.
created_date	timestamp with time zone	Date and time of the creation of the contact role record.
id	text	Unique identifier of the opportunity contact role in Salesforce.
is_primary	boolean	Indicates whether the associated Contact plays the primary role on the Opportunity (true) or not (false).
last_modified_by_id	text	Id of the user who most recently changed the contact role record.
last_modified_date	timestamp with time zone	Date of most recent change in the contact role record.
opportunity_id	text	Required. ID of an associated Opportunity.
role	text	Name of the role played by the associated Contact on the Opportunity, such as Business User or Decision Maker.
sp_connection_name	text	Steampipe connection name.
sp_ctx	jsonb	Steampipe context in JSON form.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- salesforce

You can pass the configuration to the command with the --config argument:

steampipe_export_salesforce --config '<your_config>' salesforce_opportunity_contact_role