Opportunities Prospect Roles
This table has 1 row per prospect role, per opportunity, per primary flag, and per org id.
Note: Because of the nature of contacts and leads in many objects, unusual prospect assignment may occur for multiple roles.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| CREATED_AT | Timestamp_NTZ | The date the prospect role was created in UTC datetime. | Can be used to dedupe rows for prospects with multiple roles to favor more recently created role mappings | |
| OPPORTUNITY_ID | Varchar | The associated opportunity for this prospect role. | Maps to the OPPORTUNITIES table | |
| PRIMARY | Boolean | A Boolean flag for "Is the prospect the primary contact?". | NULL can be assumed False | |
| PROSPECT_ID | Varchar | The associated prospect in Outreach. | Maps to the PROSPECTS table | |
| ROLE | Varchar | A categorical string for a role the prospect plays in the opportunity. | Buyer', 'Influencer', 'Champion' |