Book at end of Nov 6
1,118 customers
1,155 open deals · 300 open tasks · Shawna Smith

Revenue performance
Everything a rep who left owned on their last day — customers and open deals — and who owns it now.
Book at end of Nov 6
1,118 customers
1,155 open deals · 300 open tasks · Shawna Smith
Customers re-assigned
89.80%
1,004 of 1,118 · 114 still with Shawna Smith
Deals re-assigned
87.19%
1,007 of 1,155 · 148 still with Shawna Smith
Tasks re-assigned
14.67%
44 of 300 · 256 still with Shawna Smith
Deals won since
21
$31,379 won · 8 lost · 1,126 still open
Tasks done since
88
212 still open · 188 overdue
The book is everything Shawna Smith owned at the end of Nov 6 (Eastern): every customer (contact), leads included, every deal that was still open, and every task that was not yet completed. It was frozen once from HubSpot's owner history, so it stays the same however the hand-off goes — each snapshot re-reads those same records and shows who owns them now.
On the deals table, Won and Lost mean the deal reached its pipeline's Closed Won or Closed Lost stage since then (for Team Store, Won means Store Closed); everything else is still open. Unlike the Conversion tab, this includes every pipeline. The Deal type filter splits the deals table by HubSpot's Deal Type: New Business or Existing Business. Revenue on the customers table is the Retention tab's, as of its 2026-11-14 snapshot; customers that snapshot doesn't list (no status, or owned by someone outside the tracked reps) have no figure.
125 more open tasks have been created for Shawna Smith since then — workflows and sequences keep adding follow-ups for their customers. They aren't in the book, but they need an owner too, and more will come until the customers are re-assigned.
Click a number to see the deals behind it, or a column header to sort. Every deal was open when the book was frozen; Won and Lost happened since.
| Owner now⇅ | Deals⇅ | Still Open⇅ | Won⇅ | Lost⇅ | Conversion %⇅ | Deal Amount⇅ | Won Amount⇅ | Lost %⇅ |
|---|---|---|---|---|---|---|---|---|
| Report Total | 1,155 | 1,126 | 21 | 8 | 1.82% | $1,742,236 | $31,379 | 0.69% |
| Shawna Smith — not yet re-assigned | 148 | 140 | 1 | 7 | 0.68% | $65,379 | $2,584 | 4.73% |
| Crystal Gordon | 81 | 80 | 1 | 0 | 1.23% | $67,911 | $1,194 | 0.00% |
| Dan Girard | 131 | 122 | 9 | 0 | 6.87% | $693,653 | $14,180 | 0.00% |
| Elando (Allan) Tomlin | 79 | 75 | 4 | 0 | 5.06% | $132,477 | $7,241 | 0.00% |
| Jada Dehaney | 68 | 68 | 0 | 0 | 0.00% | $50,747 | $0 | 0.00% |
| Lydia Seivwright | 1 | 1 | 0 | 0 | 0.00% | $5,000 | $0 | 0.00% |
| Petagaye clarke | 71 | 69 | 2 | 0 | 2.82% | $66,459 | $979 | 0.00% |
| Rockel Royal | 55 | 52 | 3 | 0 | 5.45% | $32,409 | $3,179 | 0.00% |
| Sean Bailey | 115 | 114 | 1 | 0 | 0.87% | $130,864 | $2,022 | 0.00% |
| Shadane Butler | 112 | 112 | 0 | 0 | 0.00% | $141,014 | $0 | 0.00% |
| Simone Brown | 71 | 70 | 0 | 1 | 0.00% | $57,390 | $0 | 1.41% |
| Tami Parton | 59 | 59 | 0 | 0 | 0.00% | $171,667 | $0 | 0.00% |
| Terry Ann Green | 56 | 56 | 0 | 0 | 0.00% | $27,016 | $0 | 0.00% |
| Verrona Lamoth | 108 | 108 | 0 | 0 | 0.00% | $100,249 | $0 | 0.00% |
Click a number to see the customers, or a column header to sort. Retention % is Retained ÷ (Retained + Unretained), as on the Retention tab.
| Owner now⇅ | Customers⇅ | First Year⇅ | Retained⇅ | Unretained⇅ | Dead⇅ | No Status⇅ | Retention %⇅ | Revenue, Last 365 Days⇅ | Prior-Year Revenue (Unretained + Dead)⇅ |
|---|---|---|---|---|---|---|---|---|---|
| Report Total | 1,118 | 94 | 326 | 162 | 122 | 414 | 66.80% | $1,262,703 | $458,952 |
| Shawna Smith — not yet re-assigned | 114 | 0 | 0 | 0 | 114 | 0 | 0.00% | $0 | $0 |
| Crystal Gordon | 66 | 8 | 23 | 29 | 0 | 6 | 44.23% | $52,231 | $44,037 |
| Dan Girard | 55 | 1 | 51 | 2 | 1 | 0 | 96.23% | $609,835 | $133,716 |
| Elando (Allan) Tomlin | 52 | 8 | 43 | 0 | 0 | 1 | 100.00% | $141,211 | $0 |
| Jada Dehaney | 90 | 8 | 18 | 8 | 4 | 52 | 69.23% | $25,731 | $21,269 |
| Petagaye clarke | 112 | 4 | 29 | 20 | 0 | 59 | 59.18% | $42,318 | $53,151 |
| Rockel Royal | 106 | 6 | 18 | 6 | 0 | 76 | 75.00% | $20,271 | $14,586 |
| Sean Bailey | 110 | 20 | 25 | 22 | 0 | 43 | 53.19% | $92,359 | $54,078 |
| Shadane Butler | 115 | 9 | 27 | 6 | 0 | 73 | 81.82% | $47,237 | $9,984 |
| Simone Brown | 109 | 7 | 17 | 23 | 0 | 62 | 42.50% | $26,340 | $52,446 |
| Tami Parton | 31 | 2 | 28 | 0 | 0 | 1 | 100.00% | $118,463 | $0 |
| Terry Ann Green | 76 | 12 | 10 | 15 | 0 | 39 | 40.00% | $9,247 | $17,953 |
| Verrona Lamoth | 81 | 8 | 37 | 31 | 3 | 2 | 54.41% | $77,459 | $57,732 |
| No owner | 1 | 1 | 0 | 0 | 0 | 0 | 0.00% | $0 | $0 |
Click a number to see the tasks, or a column header to sort. Every task was still open when the book was frozen; Done Since was completed after that. Overdue and Due Next 7 Days count open tasks as of the snapshot.
| Owner now⇅ | Tasks⇅ | Still Open⇅ | Done Since⇅ | Overdue⇅ | Due Next 7 Days⇅ |
|---|---|---|---|---|---|
| Report Total | 300 | 212 | 88 | 188 | 8 |
| Shawna Smith — not yet re-assigned | 256 | 197 | 59 | 183 | 0 |
| Crystal Gordon | 2 | 0 | 2 | 0 | 0 |
| Dan Girard | 7 | 6 | 1 | 0 | 5 |
| Elando (Allan) Tomlin | 4 | 4 | 0 | 0 | 3 |
| Jada Dehaney | 2 | 0 | 2 | 0 | 0 |
| Petagaye clarke | 3 | 0 | 3 | 0 | 0 |
| Rockel Royal | 8 | 0 | 8 | 0 | 0 |
| Sean Bailey | 3 | 0 | 3 | 0 | 0 |
| Shadane Butler | 3 | 1 | 2 | 1 | 0 |
| Simone Brown | 1 | 0 | 1 | 0 | 0 |
| Tami Parton | 4 | 2 | 2 | 2 | 0 |
| Terry Ann Green | 4 | 0 | 4 | 0 | 0 |
| Verrona Lamoth | 3 | 2 | 1 | 2 | 0 |
Full lists for Excel: every customer · every deal · every task — with who owns each now.