Phase 2Executive Readout — findings, recommendations and roadmapLive · Read now
American Retirement Association

Indigo Trigger

Strategic Consulting Services

Special Report · Phase 2 Executive ReadoutSeptember 30, 2026 · On-site

Readout:
Lead-to-Cash Assessment
Revenue & Sales Operations

Prepared by Indigo Trigger for the American Retirement Association

By Christopher Prinos · NAPA · ASPPA · PSCA · NTSA

← Back to Assessment Hub

Executive Summary

This assessment looked at how a deal moves through ARA today, from the first inquiry through proposal, signature, fulfillment, invoicing and renewal. It covered advertising, sponsorships, events, education and the new Ask ERISA subscription product. The commercial engine works because a small, experienced team holds it together by hand. The same deal is typed into a Word insertion order, Salesforce, Fonteva and ClickUp, then checked again at month-end. Pipeline lives in personal spreadsheets and in conversations. Leadership finds out about most revenue when a contract comes back signed.

ARA does not need new systems. Salesforce and Fonteva are already in place, and the March Fonteva go-live has made Salesforce the logical front door for every sale. The work ahead is to make the seller's entry the single source of truth and let it flow downstream to the sales order, the fulfillment board and the invoice. Reporting comes out of that for free. Getting every seller working in Salesforce is the table stake. The fastest way there is to give reps something they want from it, such as pacing to goal and commission visibility, before asking for compliance.

4×times one deal is keyed: IO, opportunity, pro forma, ClickUp
~100media partners a year; 80–90% also buy events or education
~15media campaigns managed per month
30M+emails sent a year across disconnected platforms
100–150Kcontacts in Salesforce, with others in separate email tools
~20events a year, three or four of them flagship conferences
10–15%of media revenue that is net-new year over year
2–25multi-line pro formas decremented by hand each month

Figures are estimates given by ARA staff during the sessions, not system reports.

Key Challenges

Key findings — click to expand

1One deal, keyed four times+

Media sells on a Word insertion order sent as a PDF, or on the agency's own IO. For agency IOs the team also writes an internal plan document so accounting can read it. Stacia then re-keys every line into a Fonteva pro forma. Ad ops rebuilds the same placements in ClickUp each month. At month-end Stacia compares the pro forma, ClickUp and the inventory calendar to see what actually ran. Where an opportunity exists, Ashley often created it on the rep's behalf. Mid-run date changes travel by email to the whole media team plus accounting, and one missed email is enough to put the systems out of step.

Accounting estimates that flowing the opportunity straight into the Fonteva sales order would cut Stacia's order-entry time by more than half and end disagreement about what was sold.

Sources AM 0:38:20AM 0:41:45PM 1:22:46PM 1:27:45
2Salesforce is in place but not consistently used+

Salesforce has been at ARA for about 12 years and was, in the team's words, implemented "just okay." Media has never used it. Tashawna runs the book from a long-standing Excel workbook with year-over-year, budget-by-association and prospect tabs. Education and events reps use it partly: conferences fairly consistently, Ask ERISA inconsistently. One rep is new to Salesforce entirely. The advertising pipeline exists only as an unused placeholder. Opportunities are often entered and closed the same day, so the pipeline shows what has already happened. The conference commitments report deliberately leaves out prospecting so the events team doesn't treat it as confirmed.

Leadership "finds out when the contract is signed." Without rep-entered opportunities, none of the downstream automation or reporting has anything to run on.

Sources AM 0:19:47AM 0:27:07AM 2:06:03AM 2:09:13PM · reporting session
3Leads arrive by email and are not systematically tracked+

Web forms for advertising, education, events and Ask ERISA each send an email to a different inbox. The Salesforce lead object is not in active use. A web-to-lead prototype has been proven but is not live. If someone is out, or loses mailbox access, leads sit unanswered, and nobody can confirm that every inquiry got a follow-up. New business is a small share of media revenue (about 10–15%), and purchased lists have yielded less than benchmark. The exception is Ask ERISA. It reaches new segments such as law firms, it sells both self-service and enterprise, and the large NAPA firm deals have a 6–12 month cycle. That makes it the product where lead capture, qualification and nurture matter most.

The product with the most new-business upside is also the one with the least pipeline visibility.

Sources AM 0:30:36AM 1:04:53AM 1:06:52AM 1:08:39
4Finance runs through one person and around Fonteva's limits+

Stacia creates every Fonteva sales order as a pro forma. At month-end she pulls the ClickUp export, chases "did this run?" questions, decrements multi-line pro formas and creates active invoices. That is anywhere from 2 to 25 invoices depending on the season, and each is sent one click at a time. Fonteva allows one revenue code per item, so package deals are invoiced by hand-editing component lines into a single package price. Packages are usually billed only after the last component delivers, which delays cash. The opportunity-to-sales-order flow supports only one billing contact, so co-sponsored education programs can't be split. Commissions are calculated by hand from Fonteva data. The weekly sales report is a Power BI extract, and the person who built its back end has left.

Billing accuracy and timing depend on one person's month-end reconciliation, and the main sales report has a knowledge gap behind it.

5Fulfillment runs on spreadsheets and institutional knowledge+

Inventory is an Excel calendar for each association, with one tab per month and one row per day. Holds are typed in by the seller and removed by hand once a deal signs. Tashawna also keeps a separate banner-inventory file to protect first right of refusal. After signature, ad ops sets up each month's placements in ClickUp manually, having tried Zapier and dropped it. A custom Excel spec sheet is built for every client, and creative reminders are sent by hand against a 7–10 business-day deadline. Webinars and custom content pull in education, content and design staff, so clients can end up dealing with many contacts. Performance reporting is a monthly Excel send, plus PowerPoint year-end wrap-ups for partners spending over $100K.

ClickUp is the record of what actually ran, which is what billing depends on. Today it isn't linked to the deal it came from.

Sources AM 0:39:48AM 2:32:15AM 2:38:48PM · ad ops session
6Reporting is assembled by hand+

No single view shows booked revenue against budget, the same period last year, and the pipeline needed to close the gap. Pacing arrives through Brian Short's monthly emails, ad hoc CFO course corrections tied to board meetings, and a mid-year sales review described as "a massive exercise in handwork." Matt gets his most detailed update from regular conversations with Tashawna. The closed-lost reason field exists but isn't used. Marketing conversion rates are calculated by hand. GAM pacing is checked manually. Ask ERISA self-service has good daily dashboards; its B2B pipeline does not.

Leadership is steering on conversations and email, and the reps are the only ones who can fix the inputs.

Sources AM 0:28:26AM 2:30:24PM · reporting session
7Contracts and renewals follow a different path for every line+

Media uses a Word IO whose terms have built up over time. Agency IOs can run to 20 pages, mostly IAB terms. Events just rolled out a one-time MSA plus a short order form through DocuSign, and it is going well. Education has no contracting at all, and that push has repeatedly failed. Flagship-event recommitments run through Smartsheet. Sponsored-education requests go from a Smartsheet form to an Excel file to Stacia. Renewals are mostly manual: 2026 sponsors are being re-entered by hand as 2027 opportunities. Fonteva subscriptions (Ask ERISA, EOB multi-user, webcast packages) generate their own renewal sales orders, so any Salesforce renewal automation has to link to them rather than duplicate them. Some renewals also need a contract re-signed before they can close.

Renewal revenue, the bulk of ARA's business, is the least automated part of the pipeline.

Sources AM 0:44:26AM 2:17:13AM 2:23:33AM 2:25:56AM 2:34:07
8Email volume is outrunning the data behind it+

ARA sends more than 30 million emails a year through several platforms (HubSpot, Klaviyo and ActiveCampaign were named) that aren't connected to the 100–150K contacts in Salesforce. Segmentation and suppression are manual. Bounces are left to each platform to handle. One newly signed partner received about 15 emails in a week and asked ARA to stop. The team linked the volume to declining list quality, spam-filter risk at large firms, and lower value for media buyers. A consolidation initiative is planned for next year. Membership list validation (sending firms a list of members to confirm) is also a manual report-and-email cycle.

The list is both a marketing channel and a media product, so its quality affects ad revenue too.

Sources AM 1:17:32AM 1:19:02AM 1:20:47AM 1:11:40

Recommended Leadership Takeaways

The day points to five areas of improvement, in this order of dependency:

  1. Make Salesforce the front door for every deal and all teams.

    Bring media into Salesforce, and build pipelines that move from association to product family to placement, so reps can enter a $50K placeholder early and add detail at 75%.

  2. Let the opportunity create the Fonteva sales order.

    Replace the Word IO with a Salesforce quote and e-signature so closed-won produces the pro forma with no re-keying.

  3. Tie fulfillment to billing.

    Link ClickUp work to opportunity lines so what actually ran drives the month-end decrement and invoice automatically.

  4. Give leadership one pacing view, and give reps a reason to keep it current.

    Booked vs. budget vs. prior year vs. pipeline, plus rep-to-goal and commission visibility as the incentive.

  5. Route every lead and renewal into the system with an owner.

    Web forms to Salesforce leads, rule-based next-year opportunities, and Fonteva renewals linked rather than duplicated.

Immediate Action Items & Recommendations

  • Activate and require the closed-lost reason field with a standard picklist (budget, timing, competitor, strategy change).Sales Ops · days
  • Build a flow that auto-closes opportunities whose close date is 30+ days past with no activity in 30 days.Business Systems
  • Send reps an automated weekly "closing soon" and "trial expiring" email so Ashley no longer summarizes dashboards by hand.Sales Ops · Business Systems
  • Re-enable Tashawna's Salesforce access and load her account and contact tab from Excel with an import template.Business Systems · Media Sales
  • Fix task assignment in Salesforce for Outlook, then confirm the Teams, Microsoft Bookings and LinkedIn Sales Navigator integrations.Business Systems
  • Launch the web-to-lead prototype for the advertising, education, events and Ask ERISA forms, with a lead source picklist and auto-assignment.Business Systems · Digital Marketing
  • Stand up the media pipeline (10 / 50 / 75 / Closed) with early-stage planning products by association and product family.Sales Ops · Media Sales
  • Define the leadership KPI set and the pacing report layout.Matt Scanlon
  • Add a Salesforce opportunity link field to ClickUp campaign entries.Ad Ops
  • Schedule day-in-the-life sessions with Trevor, Rich and Diane (education and events sales), plus membership and events operations.Sales Ops · Indigo Trigger

Some Strategic Recommendations

  • Replace the Word IO with a Salesforce quote template that carries product-level terms (a linked IAB standard for media, MSA references for events). DocuSign completion should set closed-won and create the Fonteva sales order.
  • Extend the opportunity-to-sales-order integration to multi-line media orders and to multiple billing contacts for co-sponsored education.
  • Connect ClickUp and Salesforce so each fulfilled placement updates its opportunity line. Use that to automate the month-end pro forma decrement and flag items that didn't run.
  • Move the inventory calendar into Salesforce in a layout that matches today's by-day view, with holds tied to open opportunities. Keep the seller's quick-look experience.
  • Write renewal rules by line: auto-create next-year sponsor opportunities after each event; link Fonteva subscription renewals to an opportunity that can't close until a contract or MSA is re-signed where one is required.
  • Build CRM Analytics dashboards for pacing to budget and prior year, pipeline coverage, rep-to-goal, close rate and time to close. Add a commission estimate for each rep as the adoption incentive.
  • Document and take ownership of the Power BI sales report before it needs to change, or rebuild it in CRM Analytics.
  • Choose a primary email platform, sync it to Salesforce contacts, and add list hygiene (for example ZeroBounce), segmentation and frequency caps.
  • Evaluate batch invoice delivery and card surcharging in Fonteva (noted as future functionality).
  • Capture competitor placement history as account fields, from MediaRadar or internal tracking, so reps can target advertisers running elsewhere.
  • Pilot agent-assisted work where the rules are clear: pre-call account briefs, renewal follow-up drafts, creative-reminder drafts for ops to approve, and month-end "did this run?" reconciliation.
  • Run Salesforce training in ARA's own environment, with twice-monthly lunch-and-learns recorded into an SOP knowledge base.

Phased Direction

Phase 1

Foundation

First 30 days
  • Closed-lost reasons, auto-close and weekly rep reminders
  • Media onboarded with contacts imported
  • Media pipeline stages and planning products
  • Outlook task fix; Teams, Bookings and Navigator
  • Web-to-lead live for all forms
  • KPI definitions and day-in-the-life sessions
Phase 2

Integration

Days 30–60
  • Salesforce quote and e-signature replace the Word IO
  • Opportunity to Fonteva sales order for multi-line orders
  • ClickUp linked to opportunity lines
  • Next-year event sponsor opportunities by rule
  • Pacing and rep-to-goal dashboards
Phase 3

Automation

Days 60–90 and beyond
  • Automated month-end reconciliation and decrement
  • Inventory calendar and holds in Salesforce
  • Fonteva renewal sync with contract gates
  • Commission reporting
  • Email platform consolidation
  • Agent-assisted pilots

Planned & Completed Follow-Ups

TaskTeamStatus
Re-enable Tashawna's Salesforce accountARA Business SystemsDone
Extract and rationalize the product catalog (Fonteva and Salesforce)Indigo Trigger, ARA Business SystemsOpen
Share a sample agency insertion orderARA Media SalesOpen
Dashboard working sessionARA, Indigo TriggerScheduled
Define leadership KPIs and pacing reportARA LeadershipOpen
Day-in-the-life with Trevor, Rich and DianeARA Sales Ops, Indigo TriggerTo schedule
Membership and events operations sessionARA, Indigo TriggerTo schedule
Finance sidebar on the accounting sales reportARA Finance, Indigo TriggerOpen

Execution Approaches

Option 1

Train the Trainer

Indigo Trigger works with ARA's business systems and sales ops team so they can carry out the recommendations themselves, with guidance and review at each phase.

Option 2

We Do It For You

Indigo Trigger implements recommendations by priority, either project by project or as a budget-based managed service.

Open Items

  • The 2:55 automation and agentic sponsor breakout is not in either recording. Agentic items above come from session notes and need confirming.
  • Education, events and membership have not been walked through in depth. Trevor, Rich and Diane were remote and did not join.
  • Standard agreements for education: leadership needs to decide whether to pursue them, given past resistance.
  • Which auto-renewing subscriptions also need a pipeline opportunity for upsell and check-in.
  • Commission structures differ by team (draw-based, paid annually). Confirm the basis before building commission reporting.
  • Ownership and timing of next year's email consolidation initiative.

Appendix

Who We Heard From

Matt ScanlonCOO; Ask ERISA product owner; conferences and IT
Tashawna RodwellMedia sales across all associations
Ashley GeogheganSr. Director, Sales Operations
Joey Santos-JonesSr. Director, Digital Marketing; email and ad production
Halimat OduyeDirector, Digital Ad Operations; ClickUp and trafficking
Stacia McCaulBilling, invoicing and month-end reconciliation
Philip HarverSr. Business Systems Analyst; Salesforce and Fonteva
Darren BaileyBusiness systems leader; Fonteva implementation
StevenClient success coordinator for media programs
Trevor, Rich, DianeEducation and events sales (not present)
Indigo Trigger · Lead-to-Cash Assessment · American Retirement Association · Draft prepared October 2026