- Getting started
- Account management
- Security
- Destinations
- Integrations
- SaaS
- Overview
- 3PL Central
- ActiveCampaign
- AdRoll
- Amplitude
- AppsFlyer
- Asana
- Autopilot
- BigCommerce
- Braintree
- Bronto
- Campaign Manager
- Campaign Monitor
- Chargebee
- Chargify
- CircleCI
- Close.io
- Club Speed
- Codat
- COVID-19 Public Data
- Crossbeam
- Darksky
- Deputy
- Desk
- Dixa
- Doorbell.io
- eBay
- Eloqua
- Facebook Ads
- Freshdesk
- Front
- FullStory
- GitHub
- GitLab
- Google Ads
- Google Ads (AdWords)
- Google Analytics
- Google Analytics (AdWords)
- Google Analytics 360
- Google Analytics 4
- Google ECommerce
- Google Search Console
- Google Sheets
- Harvest
- Harvest Forecast
- Heap
- Help Scout
- HubSpot
- iLEVEL
- Impact
- Intacct
- Intercom
- Invoiced
- Iterable
- JIRA
- Klaviyo
- Kustomer
- Lever
- LinkedIn Ads
- Listrak
- LivePerson
- Looker
- LookML
- MailChimp
- Mailshake
- Mambu
- Marketo
- Microsoft Advertising
- Microsoft Teams
- Mixpanel
- NetSuite
- NetSuite Suite Analytics
- Onfleet
- Outbrain
- Outreach
- Pardot
- Pendo
- Pepperjam
- Pipedrive
- Quick Base
- QuickBooks
- Recharge
- Recurly
- Referral SaaSquatch
- Revinate
- RingCentral
- SaaSOptics
- Sailthru
- Salesforce
- Salesforce Marketing Cloud
- Selligent
- SendGrid Core
- ShipHero
- Shippo
- Shopify
- Slack
- Snapchat Ads
- Square
- Stripe
- SurveyMonkey
- Taboola
- TikTok Ads
- Toggl
- Trello
- Twilio
- Twitter Ads
- Typeform
- UJET
- Urban Airship
- UserVoice
- Wootric
- Workday RaaS
- Xero
- Yotpo
- Zendesk Chat
- Zendesk Support
- Zoom
- Zuora
- Databases
- Overview
- Amazon Aurora MySQL RDS
- Amazon Aurora PostgreSQL RDS
- Amazon DynamoDB
- Amazon Microsoft SQL Server RDS
- Amazon MySQL RDS
- Amazon Oracle RDS
- Amazon PostgreSQL RDS
- Amazon S3 CSV
- Google CloudSQL MySQL
- Google CloudSQL PostgreSQL
- Heroku
- Magento
- MariaDB
- Microsoft Azure MySQL
- Microsoft Azure SQL Database
- Microsoft SQL Server
- MongoDB
- MongoDB Atlas
- MySQL
- Oracle
- PostgreSQL
- Responsys
- SFTP
- Webhooks
- All integrations
- Connection cloning
- Connect other data sources
- SaaS
- Extracting data
- Loading data
- Analysis tools
- Troubleshooting
- Developers
- Changelog
Get started with a free trial today
Already have an account? Sign in
Outreach (v1)
This integration is powered bySinger's Outreach tap and certified by Stitch.Check out and contribute to the repo on GitHub.
For support, contactSupport.
Outreach integration summary
Stitch’s Outreach integration replicates data using theOutreach REST API. Refer to theSchema section for a list of objects available for replication.
Outreach feature snapshot
A high-level look at Stitch's Outreach (v1) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status | Released on April 20, 2020 | Supported by | |
| Stitch plan | Standard | API availability | Available |
| Singer GitHub repository | |||
| REPLICATION SETTINGS | |||
| Anchor Scheduling | Supported | Advanced Scheduling | Supported |
| Table-level reset | Unsupported | Configurable Replication Methods | Unsupported |
| DATA SELECTION | |||
| Table selection | Supported | Column selection | Supported |
| Select all | Supported | ||
| TRANSPARENCY | |||
| Extraction Logs | Supported | Loading Reports | Supported |
Connecting Outreach
Step 1: Add Outreach as a Stitch data source
- In theQuota Limit field, define the percentage of your standard Outreach API quota Stitch is allowed to use. This is an optional field. Before you define the limit, refer to theOutreach API documentation to learn about your Outreach rate limit.
Step 2: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Outreach integration. This means that dataequal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond Outreach’s default setting of1 year. For a detailed look at historical replication jobs, check out theSyncing Historical SaaS Data guide.
Step 3: Create a replication schedule
In theReplication Frequency section, you’ll create the integration’sreplication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Outreach integrations support the following replication scheduling methods:
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See theUnderstanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 4: Set objects to replicate
The last step is to select the tables and columns you want to replicate.Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For Outreach integrations, you can select:
Individual tables and columns
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’sTables to Replicate tab, locate a table you want to replicate.
To track a table, click thecheckbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click thecheckbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click theFinalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
Click theTables to Replicate tab.
- In the list of tables, click the box next to theTable Names column.
In the menu that displays, clickTrack all Tables and Fields:
- Click theFinalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up Outreach, itsSync Status may show asPending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, aPending status indicates that Stitch is in the process of scheduling the initial replication job for the integration.This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to theAnchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Outreach table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is forversion 1 of this integration.
This is the latest version of the Outreach integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs >customers), while case is maintained in PostgreSQL destinations (CusTomERs >CusTomERs). Refer to theLoading Guide for your destination for more info.
accounts
Theaccounts table contains information about prospective clients in Outreach.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join accounts with | on |
|---|---|
| opportunities | accounts.id = opportunities.id accounts.creatorId = opportunities.creatorId accounts.ownerId = opportunities.creatorId accounts.updaterId = opportunities.creatorId accounts.creatorId = opportunities.ownerId accounts.ownerId = opportunities.ownerId accounts.updaterId = opportunities.ownerId |
| prospects | accounts.id = prospects.id accounts.creatorId = prospects.creatorId accounts.ownerId = prospects.creatorId accounts.updaterId = prospects.creatorId accounts.creatorId = prospects.updaterId accounts.ownerId = prospects.updaterId accounts.updaterId = prospects.updaterId |
| sequence_states | accounts.id = sequence_states.id accounts.creatorId = sequence_states.creatorId accounts.ownerId = sequence_states.creatorId accounts.updaterId = sequence_states.creatorId |
| tasks | accounts.id = tasks.id accounts.creatorId = tasks.creatorId accounts.ownerId = tasks.creatorId accounts.updaterId = tasks.creatorId accounts.creatorId = tasks.completerId accounts.ownerId = tasks.completerId accounts.updaterId = tasks.completerId |
| call_dispositions | accounts.creatorId = call_dispositions.creatorId accounts.ownerId = call_dispositions.creatorId accounts.updaterId = call_dispositions.creatorId |
| call_purposes | accounts.creatorId = call_purposes.creatorId accounts.ownerId = call_purposes.creatorId accounts.updaterId = call_purposes.creatorId |
| calls | accounts.creatorId = calls.userId accounts.ownerId = calls.userId accounts.updaterId = calls.userId |
| content_categories | accounts.creatorId = content_categories.creatorId accounts.ownerId = content_categories.creatorId accounts.updaterId = content_categories.creatorId |
| mailboxes | accounts.creatorId = mailboxes.creatorId accounts.ownerId = mailboxes.creatorId accounts.updaterId = mailboxes.creatorId accounts.creatorId = mailboxes.updaterId accounts.ownerId = mailboxes.updaterId accounts.updaterId = mailboxes.updaterId accounts.creatorId = mailboxes.userId accounts.ownerId = mailboxes.userId accounts.updaterId = mailboxes.userId |
| sequence_steps | accounts.creatorId = sequence_steps.creatorId accounts.ownerId = sequence_steps.creatorId accounts.updaterId = sequence_steps.creatorId accounts.creatorId = sequence_steps.updaterId accounts.ownerId = sequence_steps.updaterId accounts.updaterId = sequence_steps.updaterId |
| sequence_templates | accounts.creatorId = sequence_templates.creatorId accounts.ownerId = sequence_templates.creatorId accounts.updaterId = sequence_templates.creatorId accounts.creatorId = sequence_templates.updaterId accounts.ownerId = sequence_templates.updaterId accounts.updaterId = sequence_templates.updaterId |
| sequences | accounts.creatorId = sequences.creatorId accounts.ownerId = sequences.creatorId accounts.updaterId = sequences.creatorId accounts.creatorId = sequences.ownerId accounts.ownerId = sequences.ownerId accounts.updaterId = sequences.ownerId accounts.creatorId = sequences.updaterId accounts.ownerId = sequences.updaterId accounts.updaterId = sequences.updaterId |
| stages | accounts.creatorId = stages.creatorId accounts.ownerId = stages.creatorId accounts.updaterId = stages.creatorId accounts.creatorId = stages.updaterId accounts.ownerId = stages.updaterId accounts.updaterId = stages.updaterId |
| users | accounts.creatorId = users.creatorId accounts.ownerId = users.creatorId accounts.updaterId = users.creatorId accounts.creatorId = users.id accounts.ownerId = users.id accounts.updaterId = users.id accounts.creatorId = users.updaterId accounts.ownerId = users.updaterId accounts.updaterId = users.updaterId |
buyerIntentScore NUMBER |
companyType STRING |
createdAt DATE-TIME |
creatorId INTEGER |
custom1 STRING |
custom10 STRING |
custom100 STRING |
custom101 STRING |
custom102 STRING |
custom103 STRING |
custom104 STRING |
custom105 STRING |
custom106 STRING |
custom107 STRING |
custom108 STRING |
custom109 STRING |
custom11 STRING |
custom110 STRING |
custom111 STRING |
custom112 STRING |
custom113 STRING |
custom114 STRING |
custom115 STRING |
custom116 STRING |
custom117 STRING |
custom118 STRING |
custom119 STRING |
custom12 STRING |
custom120 STRING |
custom121 STRING |
custom122 STRING |
custom123 STRING |
custom124 STRING |
custom125 STRING |
custom126 STRING |
custom127 STRING |
custom128 STRING |
custom129 STRING |
custom13 STRING |
custom130 STRING |
custom131 STRING |
custom132 STRING |
custom133 STRING |
custom134 STRING |
custom135 STRING |
custom136 STRING |
custom137 STRING |
custom138 STRING |
custom139 STRING |
custom14 STRING |
custom140 STRING |
custom141 STRING |
custom142 STRING |
custom143 STRING |
custom144 STRING |
custom145 STRING |
custom146 STRING |
custom147 STRING |
custom148 STRING |
custom149 STRING |
custom15 STRING |
custom150 STRING |
custom16 STRING |
custom17 STRING |
custom18 STRING |
custom19 STRING |
custom2 STRING |
custom20 STRING |
custom21 STRING |
custom22 STRING |
custom23 STRING |
custom24 STRING |
custom25 STRING |
custom26 STRING |
custom27 STRING |
custom28 STRING |
custom29 STRING |
custom3 STRING |
custom30 STRING |
custom31 STRING |
custom32 STRING |
custom33 STRING |
custom34 STRING |
custom35 STRING |
custom36 STRING |
custom37 STRING |
custom38 STRING |
custom39 STRING |
custom4 STRING |
custom40 STRING |
custom41 STRING |
custom42 STRING |
custom43 STRING |
custom44 STRING |
custom45 STRING |
custom46 STRING |
custom47 STRING |
custom48 STRING |
custom49 STRING |
custom5 STRING |
custom50 STRING |
custom51 STRING |
custom52 STRING |
custom53 STRING |
custom54 STRING |
custom55 STRING |
custom56 STRING |
custom57 STRING |
custom58 STRING |
custom59 STRING |
custom6 STRING |
custom60 STRING |
custom61 STRING |
custom62 STRING |
custom63 STRING |
custom64 STRING |
custom65 STRING |
custom66 STRING |
custom67 STRING |
custom68 STRING |
custom69 STRING |
custom7 STRING |
custom70 STRING |
custom71 STRING |
custom72 STRING |
custom73 STRING |
custom74 STRING |
custom75 STRING |
custom76 STRING |
custom77 STRING |
custom78 STRING |
custom79 STRING |
custom8 STRING |
custom80 STRING |
custom81 STRING |
custom82 STRING |
custom83 STRING |
custom84 STRING |
custom85 STRING |
custom86 STRING |
custom87 STRING |
custom88 STRING |
custom89 STRING |
custom9 STRING |
custom90 STRING |
custom91 STRING |
custom92 STRING |
custom93 STRING |
custom94 STRING |
custom95 STRING |
custom96 STRING |
custom97 STRING |
custom98 STRING |
custom99 STRING |
customId STRING |
description STRING |
domain STRING |
externalSource STRING |
followers INTEGER |
foundedAt DATE-TIME |
id INTEGER |
industry STRING |
linkedInEmployees INTEGER |
linkedInUrl STRING |
locality STRING |
name STRING |
named BOOLEAN |
naturalName STRING |
numberOfEmployees INTEGER |
ownerId INTEGER |
sharingTeamId STRING |
tags ARRAY |
touchedAt DATE-TIME |
updatedAt DATE-TIME |
updaterId INTEGER |
websiteUrl STRING |
call_dispositions
Thecall_dispositions table contains information about call dispositions from your call log in Outreach.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join call_dispositions with | on |
|---|---|
| calls | call_dispositions.id = calls.callDispositionId call_dispositions.creatorId = calls.userId |
| accounts | call_dispositions.creatorId = accounts.creatorId call_dispositions.creatorId = accounts.ownerId call_dispositions.creatorId = accounts.updaterId |
| call_purposes | call_dispositions.creatorId = call_purposes.creatorId |
| content_categories | call_dispositions.creatorId = content_categories.creatorId |
| mailboxes | call_dispositions.creatorId = mailboxes.creatorId call_dispositions.creatorId = mailboxes.updaterId call_dispositions.creatorId = mailboxes.userId |
| opportunities | call_dispositions.creatorId = opportunities.creatorId call_dispositions.creatorId = opportunities.ownerId |
| prospects | call_dispositions.creatorId = prospects.creatorId call_dispositions.creatorId = prospects.updaterId |
| sequence_states | call_dispositions.creatorId = sequence_states.creatorId |
| sequence_steps | call_dispositions.creatorId = sequence_steps.creatorId call_dispositions.creatorId = sequence_steps.updaterId |
| sequence_templates | call_dispositions.creatorId = sequence_templates.creatorId call_dispositions.creatorId = sequence_templates.updaterId |
| sequences | call_dispositions.creatorId = sequences.creatorId call_dispositions.creatorId = sequences.ownerId call_dispositions.creatorId = sequences.updaterId |
| stages | call_dispositions.creatorId = stages.creatorId call_dispositions.creatorId = stages.updaterId |
| tasks | call_dispositions.creatorId = tasks.creatorId call_dispositions.creatorId = tasks.completerId |
| users | call_dispositions.creatorId = users.creatorId call_dispositions.creatorId = users.id call_dispositions.creatorId = users.updaterId |
createdAt DATE-TIME |
creatorId INTEGER |
id INTEGER |
name STRING |
order INTEGER |
outcome STRING |
updatedAt DATE-TIME |
call_purposes
Thecall_purposes table contains information about the purpose of calls in your Outreach call logs.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join call_purposes with | on |
|---|---|
| calls | call_purposes.id = calls.callPurposeId call_purposes.creatorId = calls.userId |
| accounts | call_purposes.creatorId = accounts.creatorId call_purposes.creatorId = accounts.ownerId call_purposes.creatorId = accounts.updaterId |
| call_dispositions | call_purposes.creatorId = call_dispositions.creatorId |
| content_categories | call_purposes.creatorId = content_categories.creatorId |
| mailboxes | call_purposes.creatorId = mailboxes.creatorId call_purposes.creatorId = mailboxes.updaterId call_purposes.creatorId = mailboxes.userId |
| opportunities | call_purposes.creatorId = opportunities.creatorId call_purposes.creatorId = opportunities.ownerId |
| prospects | call_purposes.creatorId = prospects.creatorId call_purposes.creatorId = prospects.updaterId |
| sequence_states | call_purposes.creatorId = sequence_states.creatorId |
| sequence_steps | call_purposes.creatorId = sequence_steps.creatorId call_purposes.creatorId = sequence_steps.updaterId |
| sequence_templates | call_purposes.creatorId = sequence_templates.creatorId call_purposes.creatorId = sequence_templates.updaterId |
| sequences | call_purposes.creatorId = sequences.creatorId call_purposes.creatorId = sequences.ownerId call_purposes.creatorId = sequences.updaterId |
| stages | call_purposes.creatorId = stages.creatorId call_purposes.creatorId = stages.updaterId |
| tasks | call_purposes.creatorId = tasks.creatorId call_purposes.creatorId = tasks.completerId |
| users | call_purposes.creatorId = users.creatorId call_purposes.creatorId = users.id call_purposes.creatorId = users.updaterId |
createdAt DATE-TIME |
creatorId INTEGER |
id INTEGER |
name STRING |
order INTEGER |
updatedAt DATE-TIME |
calls
Thecalls table contains information about inbound and outbound calls in your Outreach call logs.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join calls with | on |
|---|---|
| call_dispositions | calls.callDispositionId = call_dispositions.id calls.userId = call_dispositions.creatorId |
| call_purposes | calls.callPurposeId = call_purposes.id calls.userId = call_purposes.creatorId |
| tasks | calls.id = tasks.callId calls.opportunityId = tasks.opportunityId calls.prospectId = tasks.prospectId calls.sequenceId = tasks.sequenceId calls.sequenceStateId = tasks.sequenceStateId calls.sequenceStepId = tasks.sequenceStepId calls.id = tasks.id calls.userId = tasks.creatorId calls.userId = tasks.completerId |
| mailings | calls.opportunityId = mailings.opportunityId calls.prospectId = mailings.prospectId calls.sequenceId = mailings.sequenceId calls.sequenceStateId = mailings.sequenceStateId calls.sequenceStepId = mailings.sequenceStepId calls.id = mailings.id |
| opportunities | calls.opportunityId = opportunities.id calls.userId = opportunities.creatorId calls.userId = opportunities.ownerId |
| events | calls.prospectId = events.prospectId |
| prospects | calls.prospectId = prospects.id calls.userId = prospects.creatorId calls.userId = prospects.updaterId |
| sequence_states | calls.prospectId = sequence_states.prospectId calls.sequenceId = sequence_states.sequenceId calls.sequenceStateId = sequence_states.id calls.userId = sequence_states.creatorId |
| sequence_steps | calls.sequenceId = sequence_steps.sequenceId calls.sequenceStepId = sequence_steps.id calls.userId = sequence_steps.creatorId calls.userId = sequence_steps.updaterId |
| accounts | calls.userId = accounts.creatorId calls.userId = accounts.ownerId calls.userId = accounts.updaterId |
| content_categories | calls.userId = content_categories.creatorId |
| mailboxes | calls.userId = mailboxes.creatorId calls.userId = mailboxes.updaterId calls.userId = mailboxes.userId |
| sequence_templates | calls.userId = sequence_templates.creatorId calls.userId = sequence_templates.updaterId |
| sequences | calls.userId = sequences.creatorId calls.userId = sequences.ownerId calls.userId = sequences.updaterId |
| stages | calls.userId = stages.creatorId calls.userId = stages.updaterId |
| users | calls.userId = users.creatorId calls.userId = users.id calls.userId = users.updaterId |
answeredAt DATE-TIME |
callDispositionId INTEGER |
callPurposeId INTEGER |
completedAt DATE-TIME |
createdAt DATE-TIME |
dialedAt DATE-TIME |
direction STRING |
externalVendor STRING |
from STRING |
id INTEGER |
note STRING |
opportunityId INTEGER |
outcome STRING |
phoneNumberId INTEGER |
prospectId INTEGER |
recordingUrl STRING |
returnedAt DATE-TIME |
sequenceAction STRING |
sequenceId INTEGER |
sequenceStateId INTEGER |
sequenceStepId INTEGER |
shouldRecordCall BOOLEAN |
state STRING |
stateChangedAt DATE-TIME |
tags ARRAY |
taskId INTEGER |
to STRING |
uid STRING |
updatedAt DATE-TIME |
userCallType STRING |
userId INTEGER |
vendorCallId STRING |
voicemailRecordingUrl STRING |
content_categories
Thecontent_categories table contains information about your content categories in Outreach.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join content_categories with | on |
|---|---|
| accounts | content_categories.creatorId = accounts.creatorId content_categories.creatorId = accounts.ownerId content_categories.creatorId = accounts.updaterId |
| call_dispositions | content_categories.creatorId = call_dispositions.creatorId |
| call_purposes | content_categories.creatorId = call_purposes.creatorId |
| calls | content_categories.creatorId = calls.userId |
| mailboxes | content_categories.creatorId = mailboxes.creatorId content_categories.creatorId = mailboxes.updaterId content_categories.creatorId = mailboxes.userId |
| opportunities | content_categories.creatorId = opportunities.creatorId content_categories.creatorId = opportunities.ownerId |
| prospects | content_categories.creatorId = prospects.creatorId content_categories.creatorId = prospects.updaterId |
| sequence_states | content_categories.creatorId = sequence_states.creatorId |
| sequence_steps | content_categories.creatorId = sequence_steps.creatorId content_categories.creatorId = sequence_steps.updaterId |
| sequence_templates | content_categories.creatorId = sequence_templates.creatorId content_categories.creatorId = sequence_templates.updaterId |
| sequences | content_categories.creatorId = sequences.creatorId content_categories.creatorId = sequences.ownerId content_categories.creatorId = sequences.updaterId |
| stages | content_categories.creatorId = stages.creatorId content_categories.creatorId = stages.updaterId |
| tasks | content_categories.creatorId = tasks.creatorId content_categories.creatorId = tasks.completerId |
| users | content_categories.creatorId = users.creatorId content_categories.creatorId = users.id content_categories.creatorId = users.updaterId |
allowSequences BOOLEAN |
allowSnippets BOOLEAN |
allowTemplates BOOLEAN |
color STRING |
createdAt DATE-TIME |
creatorId INTEGER |
id INTEGER |
name STRING |
updatedAt DATE-TIME |
duties
Theduties table contains Outreach-suggested job roles for users.
Full Table | |
Primary Key | id |
| Useful links |
| Join duties with | on |
|---|---|
| users | duties.id = users.duties.id |
dutyType STRING |
id INTEGER |
symbolicName STRING |
events
Theevents table contains information about application events in your Outreach account.
Key-based Incremental | |
Primary Key | id |
Replication Key | eventAt |
| Useful links |
| Join events with | on |
|---|---|
| mailings | events.mailingId = mailings.id events.prospectId = mailings.prospectId |
| tasks | events.mailingId = tasks.mailingId events.prospectId = tasks.prospectId |
| calls | events.prospectId = calls.prospectId |
| prospects | events.prospectId = prospects.id |
| sequence_states | events.prospectId = sequence_states.prospectId |
accountId INTEGER |
body STRING |
callId INTEGER |
createdAt DATE-TIME |
eventAt DATE-TIME |
externalUrl STRING |
id INTEGER |
mailingId INTEGER |
name STRING |
opportunityId INTEGER |
payload OBJECT |
prospectId INTEGER |
requestCity STRING |
requestDevice STRING |
requestHost STRING |
requestProxied BOOLEAN |
requestRegion BOOLEAN |
taskId INTEGER |
userId INTEGER |
mailboxes
Themailboxes table contains information about your Outreach email mailbox.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join mailboxes with | on |
|---|---|
| mailings | mailboxes.id = mailings.mailboxId |
| users | mailboxes.id = users.mailboxId mailboxes.creatorId = users.creatorId mailboxes.updaterId = users.creatorId mailboxes.userId = users.creatorId mailboxes.creatorId = users.id mailboxes.updaterId = users.id mailboxes.userId = users.id mailboxes.creatorId = users.updaterId mailboxes.updaterId = users.updaterId mailboxes.userId = users.updaterId |
| accounts | mailboxes.creatorId = accounts.creatorId mailboxes.updaterId = accounts.creatorId mailboxes.userId = accounts.creatorId mailboxes.creatorId = accounts.ownerId mailboxes.updaterId = accounts.ownerId mailboxes.userId = accounts.ownerId mailboxes.creatorId = accounts.updaterId mailboxes.updaterId = accounts.updaterId mailboxes.userId = accounts.updaterId |
| call_dispositions | mailboxes.creatorId = call_dispositions.creatorId mailboxes.updaterId = call_dispositions.creatorId mailboxes.userId = call_dispositions.creatorId |
| call_purposes | mailboxes.creatorId = call_purposes.creatorId mailboxes.updaterId = call_purposes.creatorId mailboxes.userId = call_purposes.creatorId |
| calls | mailboxes.creatorId = calls.userId mailboxes.updaterId = calls.userId mailboxes.userId = calls.userId |
| content_categories | mailboxes.creatorId = content_categories.creatorId mailboxes.updaterId = content_categories.creatorId mailboxes.userId = content_categories.creatorId |
| opportunities | mailboxes.creatorId = opportunities.creatorId mailboxes.updaterId = opportunities.creatorId mailboxes.userId = opportunities.creatorId mailboxes.creatorId = opportunities.ownerId mailboxes.updaterId = opportunities.ownerId mailboxes.userId = opportunities.ownerId |
| prospects | mailboxes.creatorId = prospects.creatorId mailboxes.updaterId = prospects.creatorId mailboxes.userId = prospects.creatorId mailboxes.creatorId = prospects.updaterId mailboxes.updaterId = prospects.updaterId mailboxes.userId = prospects.updaterId |
| sequence_states | mailboxes.creatorId = sequence_states.creatorId mailboxes.updaterId = sequence_states.creatorId mailboxes.userId = sequence_states.creatorId |
| sequence_steps | mailboxes.creatorId = sequence_steps.creatorId mailboxes.updaterId = sequence_steps.creatorId mailboxes.userId = sequence_steps.creatorId mailboxes.creatorId = sequence_steps.updaterId mailboxes.updaterId = sequence_steps.updaterId mailboxes.userId = sequence_steps.updaterId |
| sequence_templates | mailboxes.creatorId = sequence_templates.creatorId mailboxes.updaterId = sequence_templates.creatorId mailboxes.userId = sequence_templates.creatorId mailboxes.creatorId = sequence_templates.updaterId mailboxes.updaterId = sequence_templates.updaterId mailboxes.userId = sequence_templates.updaterId |
| sequences | mailboxes.creatorId = sequences.creatorId mailboxes.updaterId = sequences.creatorId mailboxes.userId = sequences.creatorId mailboxes.creatorId = sequences.ownerId mailboxes.updaterId = sequences.ownerId mailboxes.userId = sequences.ownerId mailboxes.creatorId = sequences.updaterId mailboxes.updaterId = sequences.updaterId mailboxes.userId = sequences.updaterId |
| stages | mailboxes.creatorId = stages.creatorId mailboxes.updaterId = stages.creatorId mailboxes.userId = stages.creatorId mailboxes.creatorId = stages.updaterId mailboxes.updaterId = stages.updaterId mailboxes.userId = stages.updaterId |
| tasks | mailboxes.creatorId = tasks.creatorId mailboxes.updaterId = tasks.creatorId mailboxes.userId = tasks.creatorId mailboxes.creatorId = tasks.completerId mailboxes.updaterId = tasks.completerId mailboxes.userId = tasks.completerId |
authId INTEGER |
createdAt DATE-TIME |
creatorId INTEGER |
editable BOOLEAN |
STRING |
emailHash STRING |
emailProvider STRING |
emailSignature STRING |
ewsEndpoint STRING |
ewsSslVerifyMode INTEGER |
exchangeVersion STRING |
id INTEGER |
imapHost STRING |
imapPort INTEGER |
imapSsl BOOLEAN |
maxEmailsPerDay INTEGER |
maxMailingsPerDay INTEGER |
maxMailingsPerWeek INTEGER |
optOutMessage STRING |
optOutSignature STRING |
prospectEmailExclusions STRING |
providerId INTEGER |
providerType STRING |
sendDisabled BOOLEAN |
sendErroredAt DATE-TIME |
sendMaxRetries INTEGER |
sendMethod STRING |
sendPeriod INTEGER |
sendRequiresSync BOOLEAN |
sendSuccessAt DATE-TIME |
sendThreshold INTEGER |
sendgridWebhookUrl STRING |
smtpHost STRING |
smtpPort INTEGER |
smtpSsl BOOLEAN |
smtpUsername STRING |
syncActiveFrequency INTEGER |
syncDisabled BOOLEAN |
syncErroredAt DATE-TIME |
syncFinishedAt DATE-TIME |
syncMethod STRING |
syncOutreachFolder BOOLEAN |
syncPassiveFrequency INTEGER |
syncSuccessAt DATE-TIME |
updatedAt DATE-TIME |
updaterId INTEGER |
userId INTEGER |
username STRING |
mailings
Themailings table is a representation of a platform-related email.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join mailings with | on |
|---|---|
| mailboxes | mailings.mailboxId = mailboxes.id |
| users | mailings.mailboxId = users.mailboxId |
| events | mailings.id = events.mailingId mailings.prospectId = events.prospectId |
| tasks | mailings.id = tasks.mailingId mailings.opportunityId = tasks.opportunityId mailings.prospectId = tasks.prospectId mailings.sequenceId = tasks.sequenceId mailings.sequenceStateId = tasks.sequenceStateId mailings.sequenceStepId = tasks.sequenceStepId mailings.id = tasks.id |
| calls | mailings.opportunityId = calls.opportunityId mailings.prospectId = calls.prospectId mailings.sequenceId = calls.sequenceId mailings.sequenceStateId = calls.sequenceStateId mailings.sequenceStepId = calls.sequenceStepId mailings.id = calls.id |
| opportunities | mailings.opportunityId = opportunities.id |
| prospects | mailings.prospectId = prospects.id |
| sequence_states | mailings.prospectId = sequence_states.prospectId mailings.sequenceId = sequence_states.sequenceId mailings.sequenceStateId = sequence_states.id |
| sequence_steps | mailings.sequenceId = sequence_steps.sequenceId mailings.sequenceStepId = sequence_steps.id |
bodyHtml STRING |
bodyText STRING |
bouncedAt DATE-TIME |
clickCount INTEGER |
clickedAt DATE-TIME |
createdAt DATE-TIME |
deliveredAt DATE-TIME |
errorBacktrace STRING |
errorReason STRING |
followUpSequenceId INTEGER |
followUpTaskScheduledAt DATE-TIME |
followUpTaskType STRING |
id INTEGER |
mailboxAddress STRING |
mailboxId INTEGER |
mailingType STRING |
markedAsSpamAt DATE-TIME |
messageId STRING |
notifyThreadCondition STRING |
notifyThreadScheduledAt DATE-TIME |
notifyThreadStatus STRING |
openCount INTEGER |
openedAt DATE-TIME |
opportunityId INTEGER |
overrideSafetySettings BOOLEAN |
prospectId INTEGER |
references ARRAY |
repliedAt DATE-TIME |
retryAt DATE-TIME |
retryCount INTEGER |
retryInterval INTEGER |
scheduledAt DATE-TIME |
sequenceId INTEGER |
sequenceStateId INTEGER |
sequenceStepId INTEGER |
state STRING |
stateChangedAt DATE-TIME |
subject STRING |
taskId INTEGER |
templateId INTEGER |
trackLinks BOOLEAN |
trackOpens BOOLEAN |
unsubscribedAt DATE-TIME |
updatedAt DATE-TIME |
userId INTEGER |
opportunities
Theopportunities table contains information about your pending deals and sales in Outreach.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join opportunities with | on |
|---|---|
| accounts | opportunities.id = accounts.id opportunities.creatorId = accounts.creatorId opportunities.ownerId = accounts.creatorId opportunities.creatorId = accounts.ownerId opportunities.ownerId = accounts.ownerId opportunities.creatorId = accounts.updaterId opportunities.ownerId = accounts.updaterId |
| prospects | opportunities.id = prospects.id opportunities.opportunityStageId = prospects.stageId opportunities.creatorId = prospects.creatorId opportunities.ownerId = prospects.creatorId opportunities.creatorId = prospects.updaterId opportunities.ownerId = prospects.updaterId |
| sequence_states | opportunities.id = sequence_states.id opportunities.creatorId = sequence_states.creatorId opportunities.ownerId = sequence_states.creatorId |
| tasks | opportunities.id = tasks.id opportunities.id = tasks.opportunityId opportunities.creatorId = tasks.creatorId opportunities.ownerId = tasks.creatorId opportunities.creatorId = tasks.completerId opportunities.ownerId = tasks.completerId |
| calls | opportunities.id = calls.opportunityId opportunities.creatorId = calls.userId opportunities.ownerId = calls.userId |
| mailings | opportunities.id = mailings.opportunityId |
| stages | opportunities.opportunityStageId = stages.id opportunities.creatorId = stages.creatorId opportunities.ownerId = stages.creatorId opportunities.creatorId = stages.updaterId opportunities.ownerId = stages.updaterId |
| call_dispositions | opportunities.creatorId = call_dispositions.creatorId opportunities.ownerId = call_dispositions.creatorId |
| call_purposes | opportunities.creatorId = call_purposes.creatorId opportunities.ownerId = call_purposes.creatorId |
| content_categories | opportunities.creatorId = content_categories.creatorId opportunities.ownerId = content_categories.creatorId |
| mailboxes | opportunities.creatorId = mailboxes.creatorId opportunities.ownerId = mailboxes.creatorId opportunities.creatorId = mailboxes.updaterId opportunities.ownerId = mailboxes.updaterId opportunities.creatorId = mailboxes.userId opportunities.ownerId = mailboxes.userId |
| sequence_steps | opportunities.creatorId = sequence_steps.creatorId opportunities.ownerId = sequence_steps.creatorId opportunities.creatorId = sequence_steps.updaterId opportunities.ownerId = sequence_steps.updaterId |
| sequence_templates | opportunities.creatorId = sequence_templates.creatorId opportunities.ownerId = sequence_templates.creatorId opportunities.creatorId = sequence_templates.updaterId opportunities.ownerId = sequence_templates.updaterId |
| sequences | opportunities.creatorId = sequences.creatorId opportunities.ownerId = sequences.creatorId opportunities.creatorId = sequences.ownerId opportunities.ownerId = sequences.ownerId opportunities.creatorId = sequences.updaterId opportunities.ownerId = sequences.updaterId |
| users | opportunities.creatorId = users.creatorId opportunities.ownerId = users.creatorId opportunities.creatorId = users.id opportunities.ownerId = users.id opportunities.creatorId = users.updaterId opportunities.ownerId = users.updaterId |
accountId INTEGER |
amount INTEGER |
closeDate DATE-TIME |
createdAt DATE-TIME |
creatorId INTEGER |
currencyType STRING |
custom1 STRING |
custom10 STRING |
custom100 STRING |
custom101 STRING |
custom102 STRING |
custom103 STRING |
custom104 STRING |
custom105 STRING |
custom106 STRING |
custom107 STRING |
custom108 STRING |
custom109 STRING |
custom11 STRING |
custom110 STRING |
custom111 STRING |
custom112 STRING |
custom113 STRING |
custom114 STRING |
custom115 STRING |
custom116 STRING |
custom117 STRING |
custom118 STRING |
custom119 STRING |
custom12 STRING |
custom120 STRING |
custom121 STRING |
custom122 STRING |
custom123 STRING |
custom124 STRING |
custom125 STRING |
custom126 STRING |
custom127 STRING |
custom128 STRING |
custom129 STRING |
custom13 STRING |
custom130 STRING |
custom131 STRING |
custom132 STRING |
custom133 STRING |
custom134 STRING |
custom135 STRING |
custom136 STRING |
custom137 STRING |
custom138 STRING |
custom139 STRING |
custom14 STRING |
custom140 STRING |
custom141 STRING |
custom142 STRING |
custom143 STRING |
custom144 STRING |
custom145 STRING |
custom146 STRING |
custom147 STRING |
custom148 STRING |
custom149 STRING |
custom15 STRING |
custom150 STRING |
custom16 STRING |
custom17 STRING |
custom18 STRING |
custom19 STRING |
custom2 STRING |
custom20 STRING |
custom21 STRING |
custom22 STRING |
custom23 STRING |
custom24 STRING |
custom25 STRING |
custom26 STRING |
custom27 STRING |
custom28 STRING |
custom29 STRING |
custom3 STRING |
custom30 STRING |
custom31 STRING |
custom32 STRING |
custom33 STRING |
custom34 STRING |
custom35 STRING |
custom36 STRING |
custom37 STRING |
custom38 STRING |
custom39 STRING |
custom4 STRING |
custom40 STRING |
custom41 STRING |
custom42 STRING |
custom43 STRING |
custom44 STRING |
custom45 STRING |
custom46 STRING |
custom47 STRING |
custom48 STRING |
custom49 STRING |
custom5 STRING |
custom50 STRING |
custom51 STRING |
custom52 STRING |
custom53 STRING |
custom54 STRING |
custom55 STRING |
custom56 STRING |
custom57 STRING |
custom58 STRING |
custom59 STRING |
custom6 STRING |
custom60 STRING |
custom61 STRING |
custom62 STRING |
custom63 STRING |
custom64 STRING |
custom65 STRING |
custom66 STRING |
custom67 STRING |
custom68 STRING |
custom69 STRING |
custom7 STRING |
custom70 STRING |
custom71 STRING |
custom72 STRING |
custom73 STRING |
custom74 STRING |
custom75 STRING |
custom76 STRING |
custom77 STRING |
custom78 STRING |
custom79 STRING |
custom8 STRING |
custom80 STRING |
custom81 STRING |
custom82 STRING |
custom83 STRING |
custom84 STRING |
custom85 STRING |
custom86 STRING |
custom87 STRING |
custom88 STRING |
custom89 STRING |
custom9 STRING |
custom90 STRING |
custom91 STRING |
custom92 STRING |
custom93 STRING |
custom94 STRING |
custom95 STRING |
custom96 STRING |
custom97 STRING |
custom98 STRING |
custom99 STRING |
description STRING |
externalCreatedAt DATE-TIME |
id INTEGER |
mapLink STRING |
mapNextSteps STRING |
mapStatus STRING |
name STRING |
nextStep STRING |
opportunityStageId INTEGER |
opportunityType STRING |
ownerId INTEGER |
probability INTEGER |
prospectingRepId STRING |
sharingTeamId STRING |
stageId INTEGER |
tags ARRAY |
touchedAt DATE-TIME |
updatedAt DATE-TIME |
updaterId INTEGER |
personas
Thepersonas table contains information about descriptions and types of people in Outreach.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join personas with | on |
|---|---|
| prospects | personas.id = prospects.personaId |
createdAt DATE-TIME |
description STRING |
id INTEGER |
name STRING |
updatedAt DATE-TIME |
prospects
Theprospects table contains information about your prospects.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join prospects with | on |
|---|---|
| accounts | prospects.id = accounts.id prospects.creatorId = accounts.creatorId prospects.updaterId = accounts.creatorId prospects.creatorId = accounts.ownerId prospects.updaterId = accounts.ownerId prospects.creatorId = accounts.updaterId prospects.updaterId = accounts.updaterId |
| opportunities | prospects.id = opportunities.id prospects.stageId = opportunities.opportunityStageId prospects.creatorId = opportunities.creatorId prospects.updaterId = opportunities.creatorId prospects.creatorId = opportunities.ownerId prospects.updaterId = opportunities.ownerId |
| sequence_states | prospects.id = sequence_states.id prospects.id = sequence_states.prospectId prospects.creatorId = sequence_states.creatorId prospects.updaterId = sequence_states.creatorId |
| tasks | prospects.id = tasks.id prospects.id = tasks.prospectId prospects.creatorId = tasks.creatorId prospects.updaterId = tasks.creatorId prospects.creatorId = tasks.completerId prospects.updaterId = tasks.completerId |
| personas | prospects.personaId = personas.id |
| calls | prospects.id = calls.prospectId prospects.creatorId = calls.userId prospects.updaterId = calls.userId |
| events | prospects.id = events.prospectId |
| mailings | prospects.id = mailings.prospectId |
| stages | prospects.stageId = stages.id prospects.creatorId = stages.creatorId prospects.updaterId = stages.creatorId prospects.creatorId = stages.updaterId prospects.updaterId = stages.updaterId |
| call_dispositions | prospects.creatorId = call_dispositions.creatorId prospects.updaterId = call_dispositions.creatorId |
| call_purposes | prospects.creatorId = call_purposes.creatorId prospects.updaterId = call_purposes.creatorId |
| content_categories | prospects.creatorId = content_categories.creatorId prospects.updaterId = content_categories.creatorId |
| mailboxes | prospects.creatorId = mailboxes.creatorId prospects.updaterId = mailboxes.creatorId prospects.creatorId = mailboxes.updaterId prospects.updaterId = mailboxes.updaterId prospects.creatorId = mailboxes.userId prospects.updaterId = mailboxes.userId |
| sequence_steps | prospects.creatorId = sequence_steps.creatorId prospects.updaterId = sequence_steps.creatorId prospects.creatorId = sequence_steps.updaterId prospects.updaterId = sequence_steps.updaterId |
| sequence_templates | prospects.creatorId = sequence_templates.creatorId prospects.updaterId = sequence_templates.creatorId prospects.creatorId = sequence_templates.updaterId prospects.updaterId = sequence_templates.updaterId |
| sequences | prospects.creatorId = sequences.creatorId prospects.updaterId = sequences.creatorId prospects.creatorId = sequences.ownerId prospects.updaterId = sequences.ownerId prospects.creatorId = sequences.updaterId prospects.updaterId = sequences.updaterId |
| users | prospects.creatorId = users.creatorId prospects.updaterId = users.creatorId prospects.creatorId = users.id prospects.updaterId = users.id prospects.creatorId = users.updaterId prospects.updaterId = users.updaterId |
accountId INTEGER |
addedAt DATE-TIME |
addressCity STRING |
addressCountry STRING |
addressState STRING |
addressStreet STRING |
addressStreet2 STRING |
addressZip STRING |
angelListUrl STRING |
availableAt DATE-TIME |
callOptedOut BOOLEAN |
callsOptStatus STRING |
callsOptedAt DATE-TIME |
campaignName STRING |
clickCount INTEGER |
company STRING |
contactHistogram ARRAY |
createdAt DATE-TIME |
creatorId INTEGER |
custom1 STRING |
custom10 STRING |
custom100 STRING |
custom101 STRING |
custom102 STRING |
custom103 STRING |
custom104 STRING |
custom105 STRING |
custom106 STRING |
custom107 STRING |
custom108 STRING |
custom109 STRING |
custom11 STRING |
custom110 STRING |
custom111 STRING |
custom112 STRING |
custom113 STRING |
custom114 STRING |
custom115 STRING |
custom116 STRING |
custom117 STRING |
custom118 STRING |
custom119 STRING |
custom12 STRING |
custom120 STRING |
custom121 STRING |
custom122 STRING |
custom123 STRING |
custom124 STRING |
custom125 STRING |
custom126 STRING |
custom127 STRING |
custom128 STRING |
custom129 STRING |
custom13 STRING |
custom130 STRING |
custom131 STRING |
custom132 STRING |
custom133 STRING |
custom134 STRING |
custom135 STRING |
custom136 STRING |
custom137 STRING |
custom138 STRING |
custom139 STRING |
custom14 STRING |
custom140 STRING |
custom141 STRING |
custom142 STRING |
custom143 STRING |
custom144 STRING |
custom145 STRING |
custom146 STRING |
custom147 STRING |
custom148 STRING |
custom149 STRING |
custom15 STRING |
custom150 STRING |
custom16 STRING |
custom17 STRING |
custom18 STRING |
custom19 STRING |
custom2 STRING |
custom20 STRING |
custom21 STRING |
custom22 STRING |
custom23 STRING |
custom24 STRING |
custom25 STRING |
custom26 STRING |
custom27 STRING |
custom28 STRING |
custom29 STRING |
custom3 STRING |
custom30 STRING |
custom31 STRING |
custom32 STRING |
custom33 STRING |
custom34 STRING |
custom35 STRING |
custom36 STRING |
custom37 STRING |
custom38 STRING |
custom39 STRING |
custom4 STRING |
custom40 STRING |
custom41 STRING |
custom42 STRING |
custom43 STRING |
custom44 STRING |
custom45 STRING |
custom46 STRING |
custom47 STRING |
custom48 STRING |
custom49 STRING |
custom5 STRING |
custom50 STRING |
custom51 STRING |
custom52 STRING |
custom53 STRING |
custom54 STRING |
custom55 STRING |
custom56 STRING |
custom57 STRING |
custom58 STRING |
custom59 STRING |
custom6 STRING |
custom60 STRING |
custom61 STRING |
custom62 STRING |
custom63 STRING |
custom64 STRING |
custom65 STRING |
custom66 STRING |
custom67 STRING |
custom68 STRING |
custom69 STRING |
custom7 STRING |
custom70 STRING |
custom71 STRING |
custom72 STRING |
custom73 STRING |
custom74 STRING |
custom75 STRING |
custom76 STRING |
custom77 STRING |
custom78 STRING |
custom79 STRING |
custom8 STRING |
custom80 STRING |
custom81 STRING |
custom82 STRING |
custom83 STRING |
custom84 STRING |
custom85 STRING |
custom86 STRING |
custom87 STRING |
custom88 STRING |
custom89 STRING |
custom9 STRING |
custom90 STRING |
custom91 STRING |
custom92 STRING |
custom93 STRING |
custom94 STRING |
custom95 STRING |
custom96 STRING |
custom97 STRING |
custom98 STRING |
custom99 STRING |
dateOfBirth DATE-TIME |
degree STRING |
emailOptedOut BOOLEAN |
emails ARRAY |
emailsOptStatus STRING |
emailsOptedAt DATE-TIME |
engagedAt DATE-TIME |
engagedScore NUMBER |
eventName STRING |
externalId STRING |
externalOwner STRING |
externalSource STRING |
facebookUrl STRING |
firstName STRING |
gender STRING |
githubUrl STRING |
githubUsername STRING |
googlePlusUrl STRING |
graduationDate DATE-TIME |
homePhones ARRAY |
id INTEGER |
jobStartDate DATE-TIME |
lastName STRING |
linkedInConnections INTEGER |
linkedInId STRING |
linkedInSlug STRING |
linkedInUrl STRING |
middleName STRING |
mobilePhones ARRAY |
name STRING |
nickname STRING |
occupation STRING |
openCount INTEGER |
optedOut BOOLEAN |
optedOutAt DATE-TIME |
otherPhones ARRAY |
ownerId INTEGER |
personaId INTEGER |
personalNote1 STRING |
personalNote2 STRING |
preferredContact STRING |
quoraUrl STRING |
region STRING |
replyCount INTEGER |
school STRING |
score NUMBER |
sharingTeamId STRING |
source STRING |
specialties STRING |
stackOverflowId STRING |
stackOverflowUrl STRING |
stageId INTEGER |
tags ARRAY |
timeZone STRING |
timeZoneIana STRING |
timeZoneInferred STRING |
title STRING |
touchedAt DATE-TIME |
trashedAt DATE-TIME |
twitterUrl STRING |
twitterUsername STRING |
updatedAt DATE-TIME |
updaterId INTEGER |
voipPhones ARRAY |
websiteUrl1 STRING |
websiteUrl2 STRING |
websiteUrl3 STRING |
workPhones ARRAY |
sequence_states
Thesequence_states table contains info about currently sequenced prospects.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join sequence_states with | on |
|---|---|
| accounts | sequence_states.id = accounts.id sequence_states.creatorId = accounts.creatorId sequence_states.creatorId = accounts.ownerId sequence_states.creatorId = accounts.updaterId |
| opportunities | sequence_states.id = opportunities.id sequence_states.creatorId = opportunities.creatorId sequence_states.creatorId = opportunities.ownerId |
| prospects | sequence_states.id = prospects.id sequence_states.prospectId = prospects.id sequence_states.creatorId = prospects.creatorId sequence_states.creatorId = prospects.updaterId |
| tasks | sequence_states.id = tasks.id sequence_states.prospectId = tasks.prospectId sequence_states.sequenceId = tasks.sequenceId sequence_states.id = tasks.sequenceStateId sequence_states.creatorId = tasks.creatorId sequence_states.creatorId = tasks.completerId |
| calls | sequence_states.prospectId = calls.prospectId sequence_states.sequenceId = calls.sequenceId sequence_states.id = calls.sequenceStateId sequence_states.creatorId = calls.userId |
| events | sequence_states.prospectId = events.prospectId |
| mailings | sequence_states.prospectId = mailings.prospectId sequence_states.sequenceId = mailings.sequenceId sequence_states.id = mailings.sequenceStateId |
| sequence_steps | sequence_states.sequenceId = sequence_steps.sequenceId sequence_states.creatorId = sequence_steps.creatorId sequence_states.creatorId = sequence_steps.updaterId |
| call_dispositions | sequence_states.creatorId = call_dispositions.creatorId |
| call_purposes | sequence_states.creatorId = call_purposes.creatorId |
| content_categories | sequence_states.creatorId = content_categories.creatorId |
| mailboxes | sequence_states.creatorId = mailboxes.creatorId sequence_states.creatorId = mailboxes.updaterId sequence_states.creatorId = mailboxes.userId |
| sequence_templates | sequence_states.creatorId = sequence_templates.creatorId sequence_states.creatorId = sequence_templates.updaterId |
| sequences | sequence_states.creatorId = sequences.creatorId sequence_states.creatorId = sequences.ownerId sequence_states.creatorId = sequences.updaterId |
| stages | sequence_states.creatorId = stages.creatorId sequence_states.creatorId = stages.updaterId |
| users | sequence_states.creatorId = users.creatorId sequence_states.creatorId = users.id sequence_states.creatorId = users.updaterId |
accountId INTEGER |
activeAt DATE-TIME |
bounceCount INTEGER |
callCompletedAt DATE-TIME |
clickCount INTEGER |
createdAt DATE-TIME |
creatorId INTEGER |
deliverCount INTEGER |
errorReason STRING |
failureCount INTEGER |
id INTEGER |
mailboxId INTEGER |
negativeReplyCount INTEGER |
neutralReplyCount INTEGER |
openCount INTEGER |
opportunityId INTEGER |
optOutCount INTEGER |
pauseReason STRING |
positiveReplyCount INTEGER |
prospectId INTEGER |
repliedAt DATE-TIME |
replyCount INTEGER |
scheduleCount INTEGER |
sequenceId INTEGER |
sequenceStepId INTEGER |
state STRING |
stateChangedAt DATE-TIME |
updatedAt DATE-TIME |
sequence_steps
Thesequence_steps table contains info about individual steps within automated sequences.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join sequence_steps with | on |
|---|---|
| calls | sequence_steps.sequenceId = calls.sequenceId sequence_steps.id = calls.sequenceStepId sequence_steps.creatorId = calls.userId sequence_steps.updaterId = calls.userId |
| mailings | sequence_steps.sequenceId = mailings.sequenceId sequence_steps.id = mailings.sequenceStepId |
| sequence_states | sequence_steps.sequenceId = sequence_states.sequenceId sequence_steps.creatorId = sequence_states.creatorId sequence_steps.updaterId = sequence_states.creatorId |
| tasks | sequence_steps.sequenceId = tasks.sequenceId sequence_steps.id = tasks.sequenceStepId sequence_steps.creatorId = tasks.creatorId sequence_steps.updaterId = tasks.creatorId sequence_steps.creatorId = tasks.completerId sequence_steps.updaterId = tasks.completerId |
| accounts | sequence_steps.creatorId = accounts.creatorId sequence_steps.updaterId = accounts.creatorId sequence_steps.creatorId = accounts.ownerId sequence_steps.updaterId = accounts.ownerId sequence_steps.creatorId = accounts.updaterId sequence_steps.updaterId = accounts.updaterId |
| call_dispositions | sequence_steps.creatorId = call_dispositions.creatorId sequence_steps.updaterId = call_dispositions.creatorId |
| call_purposes | sequence_steps.creatorId = call_purposes.creatorId sequence_steps.updaterId = call_purposes.creatorId |
| content_categories | sequence_steps.creatorId = content_categories.creatorId sequence_steps.updaterId = content_categories.creatorId |
| mailboxes | sequence_steps.creatorId = mailboxes.creatorId sequence_steps.updaterId = mailboxes.creatorId sequence_steps.creatorId = mailboxes.updaterId sequence_steps.updaterId = mailboxes.updaterId sequence_steps.creatorId = mailboxes.userId sequence_steps.updaterId = mailboxes.userId |
| opportunities | sequence_steps.creatorId = opportunities.creatorId sequence_steps.updaterId = opportunities.creatorId sequence_steps.creatorId = opportunities.ownerId sequence_steps.updaterId = opportunities.ownerId |
| prospects | sequence_steps.creatorId = prospects.creatorId sequence_steps.updaterId = prospects.creatorId sequence_steps.creatorId = prospects.updaterId sequence_steps.updaterId = prospects.updaterId |
| sequence_templates | sequence_steps.creatorId = sequence_templates.creatorId sequence_steps.updaterId = sequence_templates.creatorId sequence_steps.creatorId = sequence_templates.updaterId sequence_steps.updaterId = sequence_templates.updaterId |
| sequences | sequence_steps.creatorId = sequences.creatorId sequence_steps.updaterId = sequences.creatorId sequence_steps.creatorId = sequences.ownerId sequence_steps.updaterId = sequences.ownerId sequence_steps.creatorId = sequences.updaterId sequence_steps.updaterId = sequences.updaterId |
| stages | sequence_steps.creatorId = stages.creatorId sequence_steps.updaterId = stages.creatorId sequence_steps.creatorId = stages.updaterId sequence_steps.updaterId = stages.updaterId |
| users | sequence_steps.creatorId = users.creatorId sequence_steps.updaterId = users.creatorId sequence_steps.creatorId = users.id sequence_steps.updaterId = users.id sequence_steps.creatorId = users.updaterId sequence_steps.updaterId = users.updaterId |
bounceCount INTEGER |
callPurposeId INTEGER |
clickCount INTEGER |
createdAt DATE-TIME |
creatorId INTEGER |
date DATE-TIME |
deliverCount INTEGER |
displayName STRING |
failureCount INTEGER |
id INTEGER |
interval INTEGER |
negativeReplyCount INTEGER |
neutralReplyCount INTEGER |
openCount INTEGER |
optOutCount INTEGER |
order INTEGER |
positiveReplyCount INTEGER |
replyCount INTEGER |
scheduleCount INTEGER |
sequenceId INTEGER |
stepType STRING |
taskAutoskipDelay INTEGER |
taskNote STRING |
taskPriorityId INTEGER |
updatedAt DATE-TIME |
updaterId INTEGER |
sequence_templates
Thesequence_templates table contains info about templates used by sequence steps.
Full Table | |
Primary Key | id |
| Useful links |
| Join sequence_templates with | on |
|---|---|
| accounts | sequence_templates.creatorId = accounts.creatorId sequence_templates.updaterId = accounts.creatorId sequence_templates.creatorId = accounts.ownerId sequence_templates.updaterId = accounts.ownerId sequence_templates.creatorId = accounts.updaterId sequence_templates.updaterId = accounts.updaterId |
| call_dispositions | sequence_templates.creatorId = call_dispositions.creatorId sequence_templates.updaterId = call_dispositions.creatorId |
| call_purposes | sequence_templates.creatorId = call_purposes.creatorId sequence_templates.updaterId = call_purposes.creatorId |
| calls | sequence_templates.creatorId = calls.userId sequence_templates.updaterId = calls.userId |
| content_categories | sequence_templates.creatorId = content_categories.creatorId sequence_templates.updaterId = content_categories.creatorId |
| mailboxes | sequence_templates.creatorId = mailboxes.creatorId sequence_templates.updaterId = mailboxes.creatorId sequence_templates.creatorId = mailboxes.updaterId sequence_templates.updaterId = mailboxes.updaterId sequence_templates.creatorId = mailboxes.userId sequence_templates.updaterId = mailboxes.userId |
| opportunities | sequence_templates.creatorId = opportunities.creatorId sequence_templates.updaterId = opportunities.creatorId sequence_templates.creatorId = opportunities.ownerId sequence_templates.updaterId = opportunities.ownerId |
| prospects | sequence_templates.creatorId = prospects.creatorId sequence_templates.updaterId = prospects.creatorId sequence_templates.creatorId = prospects.updaterId sequence_templates.updaterId = prospects.updaterId |
| sequence_states | sequence_templates.creatorId = sequence_states.creatorId sequence_templates.updaterId = sequence_states.creatorId |
| sequence_steps | sequence_templates.creatorId = sequence_steps.creatorId sequence_templates.updaterId = sequence_steps.creatorId sequence_templates.creatorId = sequence_steps.updaterId sequence_templates.updaterId = sequence_steps.updaterId |
| sequences | sequence_templates.creatorId = sequences.creatorId sequence_templates.updaterId = sequences.creatorId sequence_templates.creatorId = sequences.ownerId sequence_templates.updaterId = sequences.ownerId sequence_templates.creatorId = sequences.updaterId sequence_templates.updaterId = sequences.updaterId |
| stages | sequence_templates.creatorId = stages.creatorId sequence_templates.updaterId = stages.creatorId sequence_templates.creatorId = stages.updaterId sequence_templates.updaterId = stages.updaterId |
| tasks | sequence_templates.creatorId = tasks.creatorId sequence_templates.updaterId = tasks.creatorId sequence_templates.creatorId = tasks.completerId sequence_templates.updaterId = tasks.completerId |
| users | sequence_templates.creatorId = users.creatorId sequence_templates.updaterId = users.creatorId sequence_templates.creatorId = users.id sequence_templates.updaterId = users.id sequence_templates.creatorId = users.updaterId sequence_templates.updaterId = users.updaterId |
bounceCount INTEGER |
clickCount INTEGER |
createdAt DATE-TIME |
creatorId INTEGER |
deliverCount INTEGER |
enabled BOOLEAN |
enabledAt DATE-TIME |
failureCount INTEGER |
id INTEGER |
isReply BOOLEAN |
negaitveReplyCount INTEGER |
neutralReplyCount INTEGER |
openCount INTEGER |
optOutCount INTEGER |
positiveReplyCount INTEGER |
replyCount INTEGER |
scheduleCount INTEGER |
sequenceStepId INTEGER |
templateId INTEGER |
updatedAt DATE-TIME |
updaterId INTEGER |
sequences
Thesequences table contains info about sequences.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join sequences with | on |
|---|---|
| accounts | sequences.creatorId = accounts.creatorId sequences.ownerId = accounts.creatorId sequences.updaterId = accounts.creatorId sequences.creatorId = accounts.ownerId sequences.ownerId = accounts.ownerId sequences.updaterId = accounts.ownerId sequences.creatorId = accounts.updaterId sequences.ownerId = accounts.updaterId sequences.updaterId = accounts.updaterId |
| call_dispositions | sequences.creatorId = call_dispositions.creatorId sequences.ownerId = call_dispositions.creatorId sequences.updaterId = call_dispositions.creatorId |
| call_purposes | sequences.creatorId = call_purposes.creatorId sequences.ownerId = call_purposes.creatorId sequences.updaterId = call_purposes.creatorId |
| calls | sequences.creatorId = calls.userId sequences.ownerId = calls.userId sequences.updaterId = calls.userId |
| content_categories | sequences.creatorId = content_categories.creatorId sequences.ownerId = content_categories.creatorId sequences.updaterId = content_categories.creatorId |
| mailboxes | sequences.creatorId = mailboxes.creatorId sequences.ownerId = mailboxes.creatorId sequences.updaterId = mailboxes.creatorId sequences.creatorId = mailboxes.updaterId sequences.ownerId = mailboxes.updaterId sequences.updaterId = mailboxes.updaterId sequences.creatorId = mailboxes.userId sequences.ownerId = mailboxes.userId sequences.updaterId = mailboxes.userId |
| opportunities | sequences.creatorId = opportunities.creatorId sequences.ownerId = opportunities.creatorId sequences.updaterId = opportunities.creatorId sequences.creatorId = opportunities.ownerId sequences.ownerId = opportunities.ownerId sequences.updaterId = opportunities.ownerId |
| prospects | sequences.creatorId = prospects.creatorId sequences.ownerId = prospects.creatorId sequences.updaterId = prospects.creatorId sequences.creatorId = prospects.updaterId sequences.ownerId = prospects.updaterId sequences.updaterId = prospects.updaterId |
| sequence_states | sequences.creatorId = sequence_states.creatorId sequences.ownerId = sequence_states.creatorId sequences.updaterId = sequence_states.creatorId |
| sequence_steps | sequences.creatorId = sequence_steps.creatorId sequences.ownerId = sequence_steps.creatorId sequences.updaterId = sequence_steps.creatorId sequences.creatorId = sequence_steps.updaterId sequences.ownerId = sequence_steps.updaterId sequences.updaterId = sequence_steps.updaterId |
| sequence_templates | sequences.creatorId = sequence_templates.creatorId sequences.ownerId = sequence_templates.creatorId sequences.updaterId = sequence_templates.creatorId sequences.creatorId = sequence_templates.updaterId sequences.ownerId = sequence_templates.updaterId sequences.updaterId = sequence_templates.updaterId |
| stages | sequences.creatorId = stages.creatorId sequences.ownerId = stages.creatorId sequences.updaterId = stages.creatorId sequences.creatorId = stages.updaterId sequences.ownerId = stages.updaterId sequences.updaterId = stages.updaterId |
| tasks | sequences.creatorId = tasks.creatorId sequences.ownerId = tasks.creatorId sequences.updaterId = tasks.creatorId sequences.creatorId = tasks.completerId sequences.ownerId = tasks.completerId sequences.updaterId = tasks.completerId |
| users | sequences.creatorId = users.creatorId sequences.ownerId = users.creatorId sequences.updaterId = users.creatorId sequences.creatorId = users.id sequences.ownerId = users.id sequences.updaterId = users.id sequences.creatorId = users.updaterId sequences.ownerId = users.updaterId sequences.updaterId = users.updaterId |
automationPercentage NUMBER |
bounceCount INTEGER |
clickCount INTEGER |
createdAt DATE-TIME |
creatorId INTEGER |
deliverCount INTEGER |
description STRING |
durationInDays INTEGER |
enabled BOOLEAN |
enabledAt DATE-TIME |
failureCount INTEGER |
finishOnReply BOOLEAN |
id INTEGER |
lastUsedAt DATE-TIME |
locked BOOLEAN |
lockedAt DATE-TIME |
maxActivations INTEGER |
name STRING |
negativeReplyCount INTEGER |
neutralReplyCount INTEGER |
numContactedProspects INTEGER |
numRepliedProspects INTEGER |
openCount INTEGER |
optOutCount INTEGER |
ownerId INTEGER |
positiveReplyCount INTEGER |
primaryReplyAction STRING |
primaryReplyPauseDuration INTEGER |
replyCount INTEGER |
rulesetId INTEGER |
scheduleCount INTEGER |
scheduleIntervalType STRING |
secondaryReplyAction STRING |
secondaryReplyPauseDuration INTEGER |
sequenceStepCount INTEGER |
sequenceType STRING |
shareType STRING |
tags ARRAY |
throttleCapacity INTEGER |
throttleMaxAddsPerDay INTEGER |
throttlePaused BOOLEAN |
throttlePausedAt DATE-TIME |
transactional BOOLEAN |
updatedAt DATE-TIME |
updaterId INTEGER |
stages
Thestages table contains information about different stages in a deal process.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join stages with | on |
|---|---|
| opportunities | stages.id = opportunities.opportunityStageId stages.creatorId = opportunities.creatorId stages.updaterId = opportunities.creatorId stages.creatorId = opportunities.ownerId stages.updaterId = opportunities.ownerId |
| prospects | stages.id = prospects.stageId stages.creatorId = prospects.creatorId stages.updaterId = prospects.creatorId stages.creatorId = prospects.updaterId stages.updaterId = prospects.updaterId |
| accounts | stages.creatorId = accounts.creatorId stages.updaterId = accounts.creatorId stages.creatorId = accounts.ownerId stages.updaterId = accounts.ownerId stages.creatorId = accounts.updaterId stages.updaterId = accounts.updaterId |
| call_dispositions | stages.creatorId = call_dispositions.creatorId stages.updaterId = call_dispositions.creatorId |
| call_purposes | stages.creatorId = call_purposes.creatorId stages.updaterId = call_purposes.creatorId |
| calls | stages.creatorId = calls.userId stages.updaterId = calls.userId |
| content_categories | stages.creatorId = content_categories.creatorId stages.updaterId = content_categories.creatorId |
| mailboxes | stages.creatorId = mailboxes.creatorId stages.updaterId = mailboxes.creatorId stages.creatorId = mailboxes.updaterId stages.updaterId = mailboxes.updaterId stages.creatorId = mailboxes.userId stages.updaterId = mailboxes.userId |
| sequence_states | stages.creatorId = sequence_states.creatorId stages.updaterId = sequence_states.creatorId |
| sequence_steps | stages.creatorId = sequence_steps.creatorId stages.updaterId = sequence_steps.creatorId stages.creatorId = sequence_steps.updaterId stages.updaterId = sequence_steps.updaterId |
| sequence_templates | stages.creatorId = sequence_templates.creatorId stages.updaterId = sequence_templates.creatorId stages.creatorId = sequence_templates.updaterId stages.updaterId = sequence_templates.updaterId |
| sequences | stages.creatorId = sequences.creatorId stages.updaterId = sequences.creatorId stages.creatorId = sequences.ownerId stages.updaterId = sequences.ownerId stages.creatorId = sequences.updaterId stages.updaterId = sequences.updaterId |
| tasks | stages.creatorId = tasks.creatorId stages.updaterId = tasks.creatorId stages.creatorId = tasks.completerId stages.updaterId = tasks.completerId |
| users | stages.creatorId = users.creatorId stages.updaterId = users.creatorId stages.creatorId = users.id stages.updaterId = users.id stages.creatorId = users.updaterId stages.updaterId = users.updaterId |
color STRING |
createdAt DATE-TIME |
creatorId INTEGER |
id INTEGER |
name STRING |
order INTEGER |
updatedAt DATE-TIME |
updaterId INTEGER |
tasks
Thetasks table contains information about items that require action in Outreach.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join tasks with | on |
|---|---|
| accounts | tasks.id = accounts.id tasks.creatorId = accounts.creatorId tasks.completerId = accounts.creatorId tasks.creatorId = accounts.ownerId tasks.completerId = accounts.ownerId tasks.creatorId = accounts.updaterId tasks.completerId = accounts.updaterId |
| opportunities | tasks.id = opportunities.id tasks.opportunityId = opportunities.id tasks.creatorId = opportunities.creatorId tasks.completerId = opportunities.creatorId tasks.creatorId = opportunities.ownerId tasks.completerId = opportunities.ownerId |
| prospects | tasks.id = prospects.id tasks.prospectId = prospects.id tasks.creatorId = prospects.creatorId tasks.completerId = prospects.creatorId tasks.creatorId = prospects.updaterId tasks.completerId = prospects.updaterId |
| sequence_states | tasks.id = sequence_states.id tasks.prospectId = sequence_states.prospectId tasks.sequenceId = sequence_states.sequenceId tasks.sequenceStateId = sequence_states.id tasks.creatorId = sequence_states.creatorId tasks.completerId = sequence_states.creatorId |
| calls | tasks.callId = calls.id tasks.opportunityId = calls.opportunityId tasks.prospectId = calls.prospectId tasks.sequenceId = calls.sequenceId tasks.sequenceStateId = calls.sequenceStateId tasks.sequenceStepId = calls.sequenceStepId tasks.id = calls.id tasks.creatorId = calls.userId tasks.completerId = calls.userId |
| events | tasks.mailingId = events.mailingId tasks.prospectId = events.prospectId |
| mailings | tasks.mailingId = mailings.id tasks.opportunityId = mailings.opportunityId tasks.prospectId = mailings.prospectId tasks.sequenceId = mailings.sequenceId tasks.sequenceStateId = mailings.sequenceStateId tasks.sequenceStepId = mailings.sequenceStepId tasks.id = mailings.id |
| sequence_steps | tasks.sequenceId = sequence_steps.sequenceId tasks.sequenceStepId = sequence_steps.id tasks.creatorId = sequence_steps.creatorId tasks.completerId = sequence_steps.creatorId tasks.creatorId = sequence_steps.updaterId tasks.completerId = sequence_steps.updaterId |
| call_dispositions | tasks.creatorId = call_dispositions.creatorId tasks.completerId = call_dispositions.creatorId |
| call_purposes | tasks.creatorId = call_purposes.creatorId tasks.completerId = call_purposes.creatorId |
| content_categories | tasks.creatorId = content_categories.creatorId tasks.completerId = content_categories.creatorId |
| mailboxes | tasks.creatorId = mailboxes.creatorId tasks.completerId = mailboxes.creatorId tasks.creatorId = mailboxes.updaterId tasks.completerId = mailboxes.updaterId tasks.creatorId = mailboxes.userId tasks.completerId = mailboxes.userId |
| sequence_templates | tasks.creatorId = sequence_templates.creatorId tasks.completerId = sequence_templates.creatorId tasks.creatorId = sequence_templates.updaterId tasks.completerId = sequence_templates.updaterId |
| sequences | tasks.creatorId = sequences.creatorId tasks.completerId = sequences.creatorId tasks.creatorId = sequences.ownerId tasks.completerId = sequences.ownerId tasks.creatorId = sequences.updaterId tasks.completerId = sequences.updaterId |
| stages | tasks.creatorId = stages.creatorId tasks.completerId = stages.creatorId tasks.creatorId = stages.updaterId tasks.completerId = stages.updaterId |
| users | tasks.creatorId = users.creatorId tasks.completerId = users.creatorId tasks.creatorId = users.id tasks.completerId = users.id tasks.creatorId = users.updaterId tasks.completerId = users.updaterId |
accountId INTEGER |
action STRING |
autoskipAt DATE-TIME |
callId INTEGER |
compiledSequenceTemplateHtml STRING |
completed BOOLEAN |
completedAt DATE-TIME |
completerId INTEGER |
createdAt DATE-TIME |
creatorId INTEGER |
dueAt DATE-TIME |
id INTEGER |
mailingId INTEGER |
note STRING |
opportunityAssociation STRING |
opportunityId INTEGER |
ownerId INTEGER |
prospectId INTEGER |
scheduledAt DATE-TIME |
sequenceId INTEGER |
sequenceStateId INTEGER |
sequenceStepId INTEGER |
sequenceTemplateId INTEGER |
state STRING |
stateChangedAt DATE-TIME |
subjectId INTEGER |
taskPriorityId INTEGER |
taskThemeId INTEGER |
taskType STRING |
templateId INTEGER |
updatedAt DATE-TIME |
teams
Theteams table contains information about groups of users in Outreach.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
color STRING |
createdAt DATE-TIME |
creatorId INTEGER |
id INTEGER |
name STRING |
scimExternalId STRING |
scimSource STRING |
updatedAt DATE-TIME |
updaterId INTEGER |
users
Theusers table contains information about individual users that use the Outreach app.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join users with | on |
|---|---|
| duties | users.duties.id = duties.id |
| mailboxes | users.mailboxId = mailboxes.id users.creatorId = mailboxes.creatorId users.id = mailboxes.creatorId users.updaterId = mailboxes.creatorId users.creatorId = mailboxes.updaterId users.id = mailboxes.updaterId users.updaterId = mailboxes.updaterId users.creatorId = mailboxes.userId users.id = mailboxes.userId users.updaterId = mailboxes.userId |
| mailings | users.mailboxId = mailings.mailboxId |
| accounts | users.creatorId = accounts.creatorId users.id = accounts.creatorId users.updaterId = accounts.creatorId users.creatorId = accounts.ownerId users.id = accounts.ownerId users.updaterId = accounts.ownerId users.creatorId = accounts.updaterId users.id = accounts.updaterId users.updaterId = accounts.updaterId |
| call_dispositions | users.creatorId = call_dispositions.creatorId users.id = call_dispositions.creatorId users.updaterId = call_dispositions.creatorId |
| call_purposes | users.creatorId = call_purposes.creatorId users.id = call_purposes.creatorId users.updaterId = call_purposes.creatorId |
| calls | users.creatorId = calls.userId users.id = calls.userId users.updaterId = calls.userId |
| content_categories | users.creatorId = content_categories.creatorId users.id = content_categories.creatorId users.updaterId = content_categories.creatorId |
| opportunities | users.creatorId = opportunities.creatorId users.id = opportunities.creatorId users.updaterId = opportunities.creatorId users.creatorId = opportunities.ownerId users.id = opportunities.ownerId users.updaterId = opportunities.ownerId |
| prospects | users.creatorId = prospects.creatorId users.id = prospects.creatorId users.updaterId = prospects.creatorId users.creatorId = prospects.updaterId users.id = prospects.updaterId users.updaterId = prospects.updaterId |
| sequence_states | users.creatorId = sequence_states.creatorId users.id = sequence_states.creatorId users.updaterId = sequence_states.creatorId |
| sequence_steps | users.creatorId = sequence_steps.creatorId users.id = sequence_steps.creatorId users.updaterId = sequence_steps.creatorId users.creatorId = sequence_steps.updaterId users.id = sequence_steps.updaterId users.updaterId = sequence_steps.updaterId |
| sequence_templates | users.creatorId = sequence_templates.creatorId users.id = sequence_templates.creatorId users.updaterId = sequence_templates.creatorId users.creatorId = sequence_templates.updaterId users.id = sequence_templates.updaterId users.updaterId = sequence_templates.updaterId |
| sequences | users.creatorId = sequences.creatorId users.id = sequences.creatorId users.updaterId = sequences.creatorId users.creatorId = sequences.ownerId users.id = sequences.ownerId users.updaterId = sequences.ownerId users.creatorId = sequences.updaterId users.id = sequences.updaterId users.updaterId = sequences.updaterId |
| stages | users.creatorId = stages.creatorId users.id = stages.creatorId users.updaterId = stages.creatorId users.creatorId = stages.updaterId users.id = stages.updaterId users.updaterId = stages.updaterId |
| tasks | users.creatorId = tasks.creatorId users.id = tasks.creatorId users.updaterId = tasks.creatorId users.creatorId = tasks.completerId users.id = tasks.completerId users.updaterId = tasks.completerId |
accountsViewId INTEGER | |||
activityNotificationsDisabled BOOLEAN | |||
bounceWarningEmailEnabled BOOLEAN | |||
bridgePhone STRING | |||
bridgePhoneExtension STRING | |||
callsViewId INTEGER | |||
controlledTabDefault STRING | |||
createdAt DATE-TIME | |||
creatorId INTEGER | |||
currentSignInAt DATE-TIME | |||
custom1 STRING | |||
custom2 STRING | |||
custom3 STRING | |||
custom4 STRING | |||
custom5 STRING | |||
dailyDigestEmailEnabled BOOLEAN | |||
duties ARRAY
| |||
STRING | |||
enableVoiceRecordings BOOLEAN | |||
engagementEmailsEnabled BOOLEAN | |||
firstName STRING | |||
id INTEGER | |||
inboundBridgePhone STRING | |||
inboundBridgePhoneExtension STRING | |||
inboundCallBehavior STRING | |||
inboundPhoneType STRING | |||
inboundVoicemailCustomMessageText STRING | |||
inboundVoicemailMessageTextVoice STRING | |||
inboundVoicemailPromptType STRING | |||
kaiaRecordingsViewId INTEGER | |||
keepBridgePhoneConnected BOOLEAN | |||
lastName STRING | |||
lastSignInAt DATE-TIME | |||
locked BOOLEAN | |||
mailboxErrorEmailEnabled BOOLEAN | |||
mailboxId INTEGER | |||
meetingEngagementNotificationEnabled BOOLEAN | |||
name STRING | |||
notificationsEnabled BOOLEAN | |||
oceClickToDialEverywhere BOOLEAN | |||
oceGmailToolbar BOOLEAN | |||
oceGmailTrackingState STRING | |||
oceSalesforceEmailDecorating BOOLEAN | |||
oceSalesforcePhoneDecorating BOOLEAN | |||
oceUniversalTaskFlow BOOLEAN | |||
oceWindowMode BOOLEAN | |||
opportunitiesViewId INTEGER | |||
passwordExpiresAt DATE-TIME | |||
phoneCountryCode STRING | |||
phoneNumber STRING | |||
phoneType STRING | |||
pluginAlertNotificationEnabled BOOLEAN | |||
preferredVoiceRegion STRING | |||
prefersLocalPresence BOOLEAN | |||
primaryTimezone STRING | |||
profileId INTEGER | |||
prospectsViewId INTEGER | |||
reportsTeamPerfViewId INTEGER | |||
reportsViewId INTEGER | |||
roleId INTEGER | |||
scimExternalId STRING | |||
scimSource STRING | |||
secondaryTimezone STRING | |||
senderNotificationsExcluded STRING | |||
tasksViewId INTEGER | |||
teamsViewId INTEGER | |||
tertiaryTimezone STRING | |||
textingEmailNotifications BOOLEAN | |||
title STRING | |||
unknownReplyEmailEnabled BOOLEAN | |||
updatedAt DATE-TIME | |||
updaterId INTEGER | |||
userGuid STRING | |||
username STRING | |||
usersViewId INTEGER | |||
voicemailNotificationEnabled BOOLEAN | |||
weeklyDigestEmailEnabled BOOLEAN |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.