Skip to content

Flag contacts with a high ticket reopen count for account review

One of 565 written HubSpot workflow specs, by a collective of independent HubSpot consultants.

Professional

Seat pricing: Professional edition. To build it, a GTM Seat or an Ops Seat (an Ops Seat cannot create marketing emails or sequences). Per-hub plans: Service Hub Professional.

Ticket3 stepsUpdated for HubSpot seat pricing
OutcomeA contact whose ticket keeps bouncing back open gets flagged at the account level, so a manager can look at the relationship as a whole instead of only ever seeing one reopened ticket at a time.
Workflow maptickets-sla-030
ticket_reopen_count >= 3 leads to Set contact_reopen_flag = true on associated contact. Set contact_reopen_flag = true on associated contact leads to Notify escalation contact. Notify escalation contact leads to Add contact to Accounts - review for reopen pattern list. Add contact to Accounts - review for reopen pattern list leads to Create account review task for escalation contact. ticket_reopen_count >= 3 Set contact_reopen_flag = true on associated contact Notify escalation contact Add contact to Accounts - review for reopen pattern list Create account review task for escalation contact
ticket_reopen_count >= 3 leads to Set contact_reopen_flag = true on associated contact. Set contact_reopen_flag = true on associated contact leads to Notify escalation contact. Notify escalation contact leads to Add contact to Accounts - review for reopen pattern list. Add contact to Accounts - review for reopen pattern list leads to Create account review task for escalation contact. ticket_reopen_count >= 3 Set contact_reopen_flag = true on associated contact Notify escalation contact Add contact to Accounts - review for reopen pattern list Create account review task for escalation contact

One of 565 written HubSpot workflow specs, by a collective of independent HubSpot consultants.

When to use it, when not to

Use it

  • Use it once tickets-sla-007 is live and already tracking ticket_reopen_count per ticket; this workflow is the account-level layer on top of that per-ticket counter.
  • Use it when repeated reopens on the same ticket are a signal worth a manager's attention beyond just another follow-up task for the rep, for example a recurring issue that never gets fully fixed, or a customer relationship at risk.
Read more on when to use itShow less

Skip it

  • Do not use it if reopens are rare in your data; a threshold-based flag on a rare event adds overhead without much payoff.
  • Do not use it as a substitute for tickets-sla-041's reopen-limit escalation, which acts on the same signal at the ticket level; this workflow's job is account visibility, not re-routing the ticket itself.
Read more on when to skip itShow less

The rest of this spec

Prerequisites · 4 items

Every property with its label, internal name, type and options, plus the assets the workflow needs.

Enrollment · 4 parts

The trigger, the criteria as ticked in the UI, the re-enrollment rule and the suppression list.

Steps · 3 numbered actions

Each action in order with its parameters, branches and delays.

Known pitfalls · 5

Traps seen in production, each with what breaks and what to do instead.

Test plan and UAT script · 2 cases, 3 variants

How to prove it works in a test portal, one case per branch, and a sign-off sheet.

Files · PDF, Markdown, JSON, CSV

The properties JSON creates the fields in one call. The workflow JSON documents the build.

Install · 1 click, switched off

The installer creates the properties and the workflow, switched off, then opens a task for what it cannot create. Nothing is deleted, enabled or enrolled.

Unlock all 565 specs, 149 EUR

One-time, excl. VAT. 30-day refund. Installs in 3 portals. Founding price until 30 November.

Read the free Tickets and SLA spec

Read 12 complete specs before you pay.

One per category, same format as the paid ones. Email only, no card.

We email the link, then a short note when specs change. Nothing else.

149 EUR199

Full library, 565 specs
Get the full library