Outreach sequence performance
Outreach sequence performance stats joined with Salesforce data
Use case
Sales
Apps
Outreach
Created by
Canvas
This table provides information on how well an Outreach sequence is performing. Sequences' metrics not just include the interactions with a sequence but also the number of opportunities (from both Outreach & Salesforce datasource) associated with a certain sequence
Model columns
| Column | Description |
|---|---|
| id | unique ID, which is the combination of sequence_id & account_id |
| account_id | Global account id, synthesized by salesforce & outreach account_id. |
| sequence_id | Outreach sequence id. |
| sequence_name | Outreach sequence name. |
| created_at | Timestamp of when a record was first created. |
| updated_at | The date and time the sequence state for a specific account was last updated. |
| total_deliver | The total count of delivered mailings from this sequence. |
| total_failure | The total count of failed mailings from this sequence. |
| total_bounce | The total count of bounced mailings during this sequence. |
| total_click | The total count of clicked mailings from this sequence. |
| total_open | The total count of opened mailings from this sequence. |
| total_negative_reply | The total count of negative reply mailings from this sequence. |
| total_neutral_reply | The total count of neutral reply mailings from this sequence. |
| total_opt_out | The total count of opted out mailings from this sequence. |
| total_positive_reply | The total count of positive reply mailings from this sequence. |
| total_reply | The total count of replied mailings from this sequence. |
| total_schedule | The total count of scheduled mailings from this sequence. |
| total_deals | Total opportunities recorded in both SF & Outreach and associated with a sequenced account |
| total_won_deals | Total won opportunities recorded in both SF & Outreach and associated with a sequenced account |
| total_lost_deals | Total lost opportunities recorded in both SF & Outreach and associated with a sequenced account |
| total_opportunity_amount | Total opportunities amount recorded in both SF & Outreach and associated with a sequenced account |
| total_won_deals_amount | Total won opportunities amount recorded in both SF & Outreach and associated with a sequenced account |
| total_lost_deals_amount | Total lost opportunities amount recorded in both SF & Outreach and associated with a sequenced account |
| has_delivered | booleans type, a true value indicates that an account was successfully delivered the email in the sequence |
| has_opened | booleans type, a true value indicates that an account opened the email in the sequence |
| has_clicked | booleans type, a true value indicates that an account clicked the email in the sequence |
| has_scheduled | booleans type, a true value indicates that an account scheduled after receiving emails in the sequence |
| has_opened_deals | booleans type, a true value indicates that an account opened at least one deal after receiving emails in the sequence |
| has_won_deals | booleans type, a true value indicates that an account signed at least one deal after receiving emails in the sequence |
