BattleBridge The AI StudioSample engagement · what we build Sample · Client details anonymized
Document I·AI Opportunity Evaluation

AI Opportunity Evaluation

A six-week, evidence-based evaluation of where artificial intelligence genuinely benefits the business - and where it should not be applied - across Finance, Event Operations, Booking, Ticketing, and Marketing.

Prepared for the leadership of a live-entertainment group · 1,000+ shows a year · three divisions · ~160 people
15+ hrs
of recorded interviews plus executive working sessions
57
documented, evidence-backed opportunities
6
core workflows drawn end to end for the first time
Jump to a section
  1. 01About this document
  2. 02Executive summary
  3. 03Method & who we interviewed
  4. 04Operating principles
  5. 05Systems & data map
  6. 06How the work flows today
  7. 07Findings by area
  8. 08Observations & exposure
  9. 09What we measured
  10. 10The 57 opportunities
  11. 11Opportunity roadmap
  12. 12Architecture & governance
  13. 13Closing
What you are reading. This is the evaluation we delivered to a live-entertainment group - the readout, the current-state maps, and the opportunity inventory - with the client’s name, its people, and its confidential financial figures removed. Everything else is as delivered. The companion Proposal and Statement of Work were built directly from it.
00·Orientation

About this document

The front section is designed to be read in about fifteen minutes. The material behind it is supporting reference.

You engaged us to provide a candid, evidence-based evaluation of where artificial intelligence can genuinely benefit the business. This document presents that evaluation. It opens with the executive summary, then the method, the systems and workflow maps we drew, the findings for each operating area in order of interview depth, the baseline measures, the full 57-item opportunity inventory, and a recommended implementation sequence. The evidence was gathered directly from your people, and the findings follow from that evidence.

01·Executive summary

Summary of findings

Over six weeks we interviewed fifteen people across your divisions and mapped where AI can deliver genuine value to the business - and where it should not be applied. Three principal findings emerged.

Finding one · The opportunity is real and specific

Not “AI could help someday.” 57 concrete, named opportunities, several already carrying figures your own team provided: five to seven hours every Monday on subsidiary settlements; one to three hours a day re-keying box-office data; a full admin-day each month coding ad invoices; two temporary hires already working in accounts payable whose work better tooling makes unnecessary. Every recommendation ties back to a verifiable figure.

Finding two · Proven value exists today, but stays confined to individuals

Your own staff have already shown what these tools can do. The CFO connected a model to the ERP himself, built a multi-market demand model in a weekend, and caught a genuine posting-date error in the year-over-year numbers. A marketing lead cut a two-hour task to fifteen minutes with a spreadsheet of his own design. What is missing is shared infrastructure: systems whose work persists, that connect to where the data lives, and that turn a proven individual solution into a durable tool for the whole team.

Finding three · The design principles originated with your own team

Every interview independently drew the same boundaries: augment judgment rather than replace it; keep a human in the loop on anything that moves money; build systems that retain context; and give every workflow a named owner. Because they came from your people, we present them as findings in their own right rather than as our caveats.

The through-line

“I don’t want dashboards. I want to ask the question and have it figure out the answer.”

A finance leader, in his own words - the single request that resolves nearly every area of need

Reporting that can be queried conversationally, memory that persists, and a small number of connectors to the systems that hold the data. The remainder of the findings follow from that foundation.

The gap your teams found for us

Nobody systematically compares what an offer projected against what the show actually settled for. Four interviews across three divisions surfaced this independently - booking wants it, finance attempted it by hand and couldn’t keep up, operations checks it by eye, and ticketing’s profitability view cannot see ancillary revenue at all. We recommend scoping this once, as shared reconciliation infrastructure, rather than four partial versions.

What we are not recommending

Offer automation stays transparent - no black boxes over the bookers’ sheets. Tool changes happen with teams, not to them. No autonomous money movement. No AI in the relationship layer. No AI-generated creative on artist campaigns. And nothing that duplicates what your own builders already have in flight - the in-house work under way in the Touring division was reviewed together, and the roadmap coordinates with it rather than rebuilding it.

02·Method

How we did the work, and who we talked to

We interviewed people across Finance, Event Operations, Booking, Ticketing, and Marketing; mapped the systems each division operates and how they connect; documented the core workflows end to end; and captured the baseline figures each team already tracks. Every opportunity was then evaluated against a single test: how defensible is the return before any investment is made in building it.

15+ hrs
of interviews and working sessions
3
divisions covered end to end
5
operating areas
6
core workflows drawn
~6 wks
of discovery
Figure 1 · Who we interviewed
EXECUTIVE TIER · 5 conversationsChief Executive OfficerChief Operating OfficerChief Financial Officer(named finance poweruser)SVP Operations(final settlementcheck)SVP Global Touring(offer sign-off)TOURING DIVISION · 7Head of talent buying + bookingTalent buyers (5) · booking team (7)Event operations lead + event managersProduced-events lead (3-person team)Marketing planning leadMarketing execution lead (~8)Settlement / accounting leadCONCERTS DIVISION · 3VP of Booking (35 yrs)Ticketing lead (5-person team)Data owner / analyst (the SQL spine)TICKETING SUBSIDIARY + FINANCE · 3Subsidiary leadership + compliance(PCI)Controller (cash forecast, close)Accounts-payable process owners15 people · 3 divisions · 5 operating areas · executive and operator tiers both interviewed - what the business is trying to become, and what the work actually costs
Two tiers, both necessary: executive interviews establish what the business is trying to become; operator interviews establish what the work actually costs.
A scope note we state rather than bury

Marketing findings are execution-side; the strategy and budget-rationale layer sits with the planning team and was out of scope for this pass. Per-task time baselines for Touring settlement, advancing, and contracting were not captured in this window; where a number wasn’t stated by someone who would know, we left it to be quantified rather than estimate it.

03·Design principles, drawn from the interviews

Operating principles for anything built here

These recurred consistently across the interviews. They are your own standards, and every recommendation in this evaluation assumes them.

Augment, never replace

Your bookers carry twenty-year track records. AI proposes and flags; a human decides. A demand model that works against the people who know the markets is an obstacle, not a solution.

Human in the loop on money

Anything that touches the books remains under human confirmation or override. Reporting is sequenced first precisely because it is read-only: straightforward to verify, minimal risk.

Memory that persists

The single reason proven individual solutions have not reached production is that they retain nothing between sessions. Systems that carry context forward convert a proven one-off into a durable tool.

One owner per workflow

A process without an owner is not a process that can be automated. Every recommendation assumes a named owner on your side.

Keep the workflow, change where it lives

The objective is not to move anyone onto unfamiliar tools. Where a change is warranted, the replacement operates the way people already work - the change happens in the plumbing, not the process.

Earn autonomy in sequence

Work begins where results are verifiable and risk is low. Broader, money-adjacent automation is extended only after the pattern has demonstrated reliability.

Two permanent scope boundaries - not phase-1 limitations

Capture, don’t migrate. Automation observes and normalizes existing workflows - talent buyers keep their working sheets; working them is how buyers learn deal structure. Admin layer, never the relationship layer. Roughly 90% of one division’s shows are booked with relationship-driven venue partners, and the value is in that relationship. Nothing we recommend inserts a tool between your people and a venue partner, an artist, or an agent.

04·Current state · Systems & data map

Every system, drawn on one page

The whole operating estate on a single diagram - booking and offers, operations and settlement, ticketing and counts, the data spine, finance, and the ticketing subsidiary. The color of each connection tells you its health at a glance.

Figure 2 · The unified systems & data map
BOOKING / OFFERSOPS / SETTLEMENT (TOURING)TICKETING / COUNTSFINANCETICKETING SUBSIDIARY · PCI TIER 1THE DATA SPINEGoogle Sheets(Touring offers)Operations DB(Concerts offers ·merge in progress)Industry database(venue contacts)Automation hub(fan-out onconfirmation)manual re-key: offer → every downstreamdepartmentShow folders(shared-drivefolder trees)Settlement sheets(per tour,interlocking)Confirmed-showtimeline(600+ graphics pershow)Slack(per-tourchannels)ERP → spend platform: auto-populatesfrom confirmationPrimary ticketingvendor(~80% ofconversions)CRM feed →operations DB(API auto-import)Daily-count platform(Concerts live ·Touring not adopted)Non-vendor venues(~20%)manual PDF auditsSecondary-marketreports: PDFs, atface valueERP(single source offinancial truth)Spend platform(cards + AP)↔ live 2-way syncPlanning & budgeting module · load-bearingcalculations still in spreadsheetsBox office(proprietary)Legacy database+ BI reportsdaily CSV download / upload - 1–3 hrsper day, MANUALCloud SQL warehouse60M+ rows · 2 yrs ·nightly batch · 24 hrlagBI layer(storedprocedures)Fragmented spreadsheets OUTSIDE the spine(consistency risk)posts to spend / ERPnightly batchNO CONNECTIONNO CONNECTION · offers ↔ daily countsAutomated / connectedManual bridge (a person moves the data)Named disconnectIsland / blind spotSystem of record
Green = automated and connected · amber = a person moves the data by hand · red = a named disconnect or island. Every connection state was named by the people we spoke with; nothing is inferred.

What connects - the working plumbing to build on

A great deal already works well. These are the connections that are healthy today - the foundation any future automation should extend rather than replace.

ConnectionMechanismHealth
Spend platform ↔ ERPLive two-way syncSolid - most expenses auto-ingest coded to show
Ticketing vendor → CRM feed → operations DBAPI auto-importSolid - covers ~80% of Concerts shows
Ticketing vendor → SQL warehouseNightly batch (60M+ rows, 24 hr lag)Stable - occasional dev fixes, no monitoring today
SQL warehouse → BIStored proceduresWorking - the thin analytical layer
Operations DB → automation hub → downstream (show confirmation)Fan-out: folders, contract, master sheets, ERP, industry database, timeline, SlackBest automation in the company - venue-fee field + two-eyes check deliberately manual
Box-office audits → daily-count platform (Concerts)Email forwarding + AI parse (~98–99%)Solid - absorbed a full-time person’s worth of work

What doesn’t connect - the manual bridges, each one a person

Where two systems don’t talk, a person moves the data by hand. Each row is a recurring labor cost, and each has a clear path to being closed.

BridgeCost todayWhat addresses it
Subsidiary box office → legacy database1–3 hrs/day manual CSVThe subsidiary box-office integration (PCI-scoped)
Subsidiary box office → BIDaily CSV via a manual scriptRides on the same integration
Operations DB → daily-count platformTemplate / manual entry per show or tourConnecting counts to offers
Non-vendor venues → sold-map visibilityManual PDF requests (~20% of Concerts shows)The non-vendor venue-visibility opportunity
Offer sheet → downstream departments (both divisions)Manual re-keying per departmentLetting the offer feed downstream instead of being re-keyed
Ad-platform invoices → spend classes~1 admin-day / month manual codingThe invoice-categorization opportunity
Venue ticket audits → Touring count sheetsWeekly manual pulls, difficult formatsThe ticket-audit parsing opportunity
Touring daily counts (no counts platform)Fully manual, 2×/wk (hourly during on-sales)A change-management conversation on tool adoption

Seven gaps worth naming plainly

These are the structural gaps that shape everything else. They are not failures of any team - they are the natural seams between systems that grew up independently. Each is addressable.

  1. The daily-count layer and the SQL warehouse have no connection at allThe counts layer is forward-only; the two-year, 60M-row history that would make pacing and pricing intelligent sits unreachable right next to it. Addressed by the connector work.
  2. The warehouse is reachable by no analytical AI todayThe vendor API can’t query deep history, and consumer AI tools can’t reach the database - the barrier the CFO described hitting himself. The connector addresses several gaps at once.
  3. Ancillary revenue lives outside every profitability surfaceShows can look unprofitable in the counts platform while actually being viable. The fix must respect a hard confidentiality boundary - external agencies have direct counts access.
  4. Secondary-market sales are recorded at face valueResale reports arrive as PDFs and aren’t integrated, systematically distorting per-show revenue reads.
  5. Fragmented spreadsheets sit outside the spineThey undermine trust in anything automated on top of it. The design rule is flag, don’t absorb - surface the inconsistency, never silently overwrite working files.
  6. No offer-to-settlement reconciliation path exists in any systemProjections never systematically meet actuals anywhere. Surfaced in four interviews across three teams, unprompted.
  7. Venue and deal knowledge has no system at allIt lives in inboxes and heads - the reason two leaves in three months meant months of retraining. The existing venue hub is built but not adopted; seed what exists rather than build new.
05·Current state · How the work flows today

Six core workflows, drawn end to end for the first time

Where the work starts, how it moves, and what each map makes possible next. Every node traces to something a member of your team told us in an interview; nothing here is an assumed process.

Figure 3 · Map 1 · Touring booking

Tour offer → venue booking → confirmation

This is how a tour becomes a confirmed set of dates - from a talent buyer sourcing a deal, through leadership sign-off, into a heavy stretch of venue outreach, and out to the departments that execute it. It’s a well-drilled relay; the map shows exactly where the hand-offs and the manual duplication happen.

Talent buyer sources thedeal(agent + managementrelationships)Offer template built onestimates(expenses, capacity,walkout)CEO + SVP sign-off(1–2 wks; 1 day ifpriority)Hand-off to booking(routing + targetmarkets set)Slack channel +outreach sheet +tour worksheetVenue outreach across 5regional territories50+ contacts per show ·600–700 emails per30-date tourVenue confirms →event-offer tab builtoff the tour offer(manual duplication)Proof → talent buyer→ agent → approvalOps runs theautomatedconfirmation formFan-out to ~7sheets: marketing ·ticketing · events ·settlementDay sheet + hand-offcall → eventmanagersOpportunity:templated outreach +follow-up assistOpportunity: offer feedsdownstream instead ofbeing re-keyedMissing edge: no arrowreturns from settlementto the next offerStepAutomatedManual bridgeDeliberate human gateOpportunity
What this makes possible

The two heaviest steps - 600–700 outreach emails per tour and rebuilding the event offer off the tour offer - are exactly the kind of high-volume, template-driven work where assistance pays off fastest, without touching the relationships or the sign-off that make the deal.

The missing edge

Look at what isn’t on this map: no arrow returns from settlement back to the offer. The feedback loop that would let actuals sharpen the next estimate simply doesn’t exist yet - the most consequential missing connection this diagram points to is one it can’t draw.

Figure 4 · Map 2 · Touring operations

Show confirmation → settlement

Once a show is confirmed, one action “kicks the snowball off the mountain”: an automation fans a single confirmation out to folders, contracts, master sheets, the ERP, the graphics timeline, and Slack - then weekly counts flow into the settlement sheet, and nothing leaves without two sets of eyes. This is the strongest existing automation in the company, and it already knows where to stop.

Tour confirmation(talent buyer) →operations databaseformShow confirmation(Operations)“kicks the snowballoff the mountain”Automation generates:venue folder ·contract · venue email· invoice templateVenue-fee fieldstays MANUAL(live negotiation)Auto-populates: mastersettlement sheet · masterlist · industry database· ERP → spend · graphicstimeline (600+ per show)· SlackWeekly (Mon): ticketcounts pulled fromticketing + venueaudits vs projectionsPer-tour settlementsheet (template SOP)red = estimate · black =checked · bold = ≥2 eyesSVP Operations finalcheck“nothing leaves withouttwo sets of eyes”→ Finance: accountingsettlement(recognition +accruals)Opportunity:ticket-audit parsing(“brutal” venueformats)Opportunity:venue-expensecategorization(confirm/override)StepAutomatedManual bridgeDeliberate human gateOpportunity
The deliberate human gates

The purple steps - the live venue-fee negotiation and the SVP’s final two-eyes check - are deliberate human checkpoints, not gaps to be closed. This is the core principle in one picture: automation fills in everything around the checks, and never runs through them.

What this makes possible

The two weakest links are input-quality problems, not decision problems: parsing difficult venue-audit formats and categorizing venue expenses. Raising the quality of what reaches the settlement sheet makes the reviewer’s job easier while leaving the two-eyes gate exactly where it is.

Figure 5 · Map 3 · Event operations

The advancing lifecycle

Advancing is the weeks-out choreography that turns a confirmed show into a smooth day-of: the event manager works the venue through riders, questionnaires, production, and a week-of sweep, staying the relationship holder the whole way. Each EM runs it with their own preferred tools - a strength worth preserving, not standardizing away.

Booking confirmsshowEmail fan-out(all stakeholderscc’d)4–6 wks out: eventmanager contacts thevenueRider walkthrough(buses, dressing rooms,catering, concourse)Follow-upquestionnaire(open items)Production secondaryadvance(EM stays therelationship holder)Week-of confirmationsweep(volunteers, load-in /load-out)On site: EM owns theticketing /settlement liaisonPost-event survey1–2 wks after - IFthe EM remembersEach EM uses their OWNtool (Wrike / Notion /Calendly / sheets) →capture, don’t migrateVenue hub exists butis underused → seedit, don’t rebuildOpportunity: surveyautomation (theteam’s own pick)Relationship layer stays outof scope by rule - nothingbetween an EM and a venuepartnerStepAutomatedManual bridgeDeliberate human gateOpportunity
A relationship-first constraint we honor by rule

Every automation on this map stays in the admin layer - questionnaires, sweeps, the post-event survey that today depends on someone remembering. The relationship edges are out of scope by design.

What this makes possible

Two easy wins sit in plain sight: making the post-event survey automatic instead of memory-dependent, and seeding the venue hub that already exists rather than building anything new - capturing what each EM already does in their own tool, not forcing a migration.

Figure 6 · Map 4 · Touring marketing

The marketing campaign lifecycle

From the confirmed-show timeline, the planning leads set the plan and budget split, hand off per tour in Slack, and an execution team of about eight runs a campaign per city - six figures a month in paid social - through pre-sale, on-sale, and a “finish strong” final month. It’s a high-tempo machine that rarely gets a moment to look back.

“Confirmed showtimeline” sheetlandsPlanning leads setmarketing plan, budgets,launch timing (4 tourleads set the split)Per-tour Slackhand-off“$10K digital, $10Kradio…”Execution team (~8):campaign-per-city ·4–5 ad sets · lifetimebudgets · six-figuremonthly paid social~1 wk pre-sale blast→ 2–4 wk on-salepushMaintenance →“finish strong”final monthNEXT TOUR - noend-of-tourreconciliation (“onto the next”)Opportunity:end-of-tour rollup - alearning loop across~1,000 shows a yearPixel / conversionaccuracy: “dangerous,not pixel experts” →one conversion sourceof truthAd invoices: ~1admin-day / month ofmanual class-coding →invoiceauto-categorizationSearch + SEO channel:effectively untouched→ managed search +SEOStepAutomatedManual bridgeDeliberate human gateOpportunity
What this makes possible

Three high-leverage openings, all additive to a team that already runs at scale: capturing end-of-tour spend lessons that are currently lost on the way to the next tour, tightening conversion-tracking accuracy so the KPIs stand on firmer ground, and reclaiming the admin-day a month spent hand-coding ad invoices.

Figure 7 · Map 5 · Concerts booking

Booking origination → offer → confirmation

The Concerts division originates offers three ways - agent-led, as exclusive booker, or direct with unrepresented artists - then runs intake and risk analysis, builds the offer in the operations database, and routes the geographic puzzle to confirmation. The whole flow hinges on one manual step: looking up venue expenses by hand.

Agent brings a tour(dictates cities /venues / pricing)Division is exclusivebooker(sets city / venue /routing)Unrepresented artist(direct negotiation)Intake / risk analysisindustry database,prior sales, social,calls to club ownersOffer creation in theoperations database~20 min per offerMANUAL venue-expenselookup: settlementfolders, pre-2024spreadsheets = the #1bottleneckOffers PDF’d → agent +manager → artistapproval (negotiatescaling / price / VIP)Routing: venueavails, thegeographic puzzleConfirm → ONE massemail to everydepartmentEach departmentworks from sharedshow foldersOpportunity:auto-populate venueexpenses from history (VPof Booking: “agame-changer”) +auto-filled scaling tiersOpportunity: theoffer feedsdownstream instead ofbeing re-keyedStepAutomatedManual bridgeDeliberate human gateOpportunity
A benchmark from inside the room

A well-known industry system once let anyone crank out 30–60 offers a day on auto-populated venue expenses - and one of your own executives helped build it. That is the target state for the one manual step above. The division’s stated goal of growing from ~400 to 550 shows a year rides directly on relieving this exact bottleneck.

What this makes possible

Auto-populating venue expenses at the offer step turns a ~20-minute manual lookup into a fast, repeatable action - and because that same offer can then feed downstream instead of being re-keyed into every department’s folder, one fix pays off twice.

Figure 8 · Map 6 · The ticketing data spine

Two layers that don’t talk

The ticketing data lives in two worlds. The operational layer - daily counts - is fast and accurate. The analytical layer - two years and 60M+ rows of purchaser-level history in a cloud SQL warehouse - is deep but reachable only through BI. The two sit side by side and never connect.

LAYER 1 · DAILY COUNTS (OPERATIONAL) - fast and accurateLAYER 2 · HISTORY + TRANSACTIONS (ANALYTICAL) - deep, but reachable only through BIVenue box offices(emailed PDFaudits)Daily-count platformAI parse ~98–99%(Concerts, since Jan)Auto-distributed dailypacing reports(stakeholders + artists /agents)Touring counts: fullyMANUAL - 2×/wk; hourlyduring on-salesTicketing vendor(nightly batch · 24hr lag)Cloud SQL warehouse60M+ rows · 2 years ·purchaser-level detailStored procedures → BIreports (the thinanalytical layer)Fragmented spreadsheetsOUTSIDE the spineNO CONNECTIONVendor API cannot query deep historyDaily counts are forward-only; the history sits next to them, unreachableThe connector: the missing prerequisiteBuild one connection and today’s daily counts finally have two years of history behind them.
The connector gap

Because the vendor API can’t reach the deep history, a purpose-built connector is the only path in - and closing that gap is a prerequisite for most of the other analytical opportunities in this evaluation. Build that one connection and today’s daily counts finally have two years of history behind them.

06·Findings by area

Findings, division by division

Areas are presented in order of interview depth: Finance and Event Operations first, then Booking, Ticketing, and Marketing. Summaries appear here; the complete detail for each area is in the addendum.

1. Finance 13 opportunities

Finance is the most rigorously organized area of the business, and the one with the clearest and most defensible opportunities. The ERP is the source of truth; the spend platform handles expenses and bill pay; the load-bearing calculations still live in spreadsheets that, in the team’s own words, “people break.” The finance leader already operates a read-only model against the ERP but cannot keep it in production, for two structural reasons: it has no memory, so every session starts over; and no cached schema, so it re-pulls everything to answer a simple question. Both are platform problems, not model problems.

Documented painWhat it costs today
AP field-coding is wrong, forcing two temporary staff to re-code centrallyTwo temps at roughly $40–45/hr loaded - on the order of $170–185K a year at those loaded rates - and the leader notes it grows with volume, not shrinks
Settlement accounting spikes sharply after shows playThree people on one high-volume pillar; “once we hit October they’ll be drowning”
Cash forecasting done weekly, by many hands, and not trustedOne to two people per unit for half a day to a day, plus a day to consolidate centrally
Reporting is laborious to build and run in the ERP“I don’t want dashboards, I want to ask the question.” The stated first task to hand off

Principal opportunities: natural-language reporting (read-only, the appropriate first build, and the foundation subsequent work reuses); the pre-coding agent, which displaces the temporary staffing and scales where hiring does not; settlement accrual preparation delivered as a reviewable journal-entry file the leader uploads himself; and cash-forecast consolidation.

2. Event Operations 8 opportunities

Event Operations is the seam where a confirmed offer becomes a contract, a settlement, and cash. Today that hand-off is manual: dates and amounts are re-keyed, the estimate-versus-invoice gap is tracked by hand, and the settlement pack is rebuilt from scratch for each show. It is also the area where the Touring division is already building its own modules; our recommendations are reconciled against that work rather than duplicating it. The ticketing subsidiary carries its own settlement seam: 30 to 40 settlements processed by hand every Monday - five to seven hours a week of bounded, recurring, already-quantified work.

Principal opportunities: show-settlement assembly (drawing expenses, revenue, ticketing, and the original deal terms into one reconciled pack with receipts matched); ad-pack and advancing-pack auto-assembly; production-template reuse; and contractor-agreement plus 1099 document generation - the produced-events components scoped in coordination with the in-flight internal build, which already covers the pay-calculation logic.

3. Booking 12 opportunities

Booking is the area where your professional judgment is strongest and your tooling least developed. One division runs booking on an operations database with a genuine financial model embedded; the other still books from spreadsheets and copy-paste. A demand model exists but resides on a single machine, and the bookers do not yet trust it because no feedback loop exists to teach it what they know. As one put it: “a lot of times we’re running so fast that it’s just get the offer out.” No systematic double-check exists today.

Principal opportunities: venue-expense auto-population at offer creation, with anomaly flagging immediately behind it (this serves the growth goal directly and augments the booker without overriding); an offer-vetting check that compares each new offer against history; an ancillary-revenue model to strengthen rebate terms, where much of the real margin resides; and productionizing the demand model with a feedback loop under the bookers’ control.

4. Ticketing 10 opportunities

Three systems carry ticketing, and they exchange very little. A new daily-count layer ingests box-office audits but begins from a blank slate with no history. A cloud SQL warehouse holds roughly 60 to 65 million records spanning two years of ticketing history, and today it goes almost entirely unused because the people who want answers from it cannot reach it. The daily feed that fills it fails periodically, and a developer must notice and repair it by hand.

A significant dormant asset

Between the ticketing transactional set and your own first-party buyer database, the business holds audience data most promoters would work hard to acquire - and almost none of it is being modeled today. Making it reachable is the largest dormant asset identified in this evaluation.

Principal opportunities: a feed watchdog that detects a broken or shifted feed the moment it occurs; a daily-count assembler that formats counts and flags pacing; a connector that makes the two-year dataset answerable in plain English; and per-artist segmentation that converts dormant transactional data into stronger audience seeds.

5. Marketing 9 opportunities

Marketing is the most manual and least measured of the five areas, and the one where your own people have already begun solving their problems individually. The media buying itself is well executed. The friction sits in four seams around it: coding spend back to shows, producing the artist ad-packs, measuring whether the spend performed, and the search and SEO channel, which is effectively unaddressed today. Across roughly a thousand shows a year, the institutional learning captured is close to zero - in the team’s words, “we’re moving so fast that we’re on to the next tour.”

Principal opportunities: the spend-to-show coding agent (the same coding problem identified in Finance - a single build serving both areas); an ad-pack finisher that extends a spreadsheet the team has already built; spend-to-sales reconciliation; and establishing the search and SEO channel, which the team identified as its single largest untapped opportunity. Marketing is the thinnest area by interview count, and the findings are presented with that limitation stated rather than overstated.

07·Current-state observations & exposure

Where the business is carrying avoidable cost, risk, or blind spots today

Every observation is drawn directly from interviews with your team. Where we characterize how much exposure something carries, that is our read as assessors - a starting point for discussion, not a rating you have signed off on. This is meant as a plan, not a complaint list.

ObservationExposureEvidenceWhat addresses it
Venue and deal knowledge lives in inboxes and heads, and leaves when people doHIGHER always onTwo leaves in three months meant months of retraining (Touring booking)A shared venue-knowledge repository that captures existing workflows rather than replacing them
The data plumbing rests heavily on one personHIGHER always onA single owner handles feed fix-ups, the test parser, the settlement stopgap, and the database mergeFeed monitoring plus a data connector - repeatable rather than person-dependent
No offer-to-settlement reconciliation loop exists anywhereHIGHER always onRaised in four interviews across three teams, unprompted; one team tried it manually and “couldn’t keep up”The offer-to-settlement reconciliation build
The 60M-row, two-year dataset is unreachable for analysisHIGHER always onThe vendor API can’t query deep history; consumer AI tools can’t reach the databaseThe data connector
Ancillary revenue is invisible to every profitability surfaceHIGHER decision qualityShows can be misread as unprofitable (Concerts ticketing)The profitability-visibility build, with a hard access-control boundary
A financial-write automation error would be high-cost and hard to catchHIGHER on buildThe CFO’s rationale for keeping a human in the loopThe settled file-generation-for-review rule - AI drafts, a person enters
Every ticketing-subsidiary integration carries PCI Tier-1 scopeHIGHER on build“A pretty heavy lift because of the compliance”PCI-scoped gating on each subsidiary integration
End-of-tour marketing reconciliation is skipped entirelyMODERATE always on“On to the next” - spend lessons never captured across ~1,000 shows a yearAn end-of-tour reconciliation step
Settlement quality depends on one final reviewerMODERATE always onThe SVP of Operations is the last external check on everythingPre-fill that raises input quality - the two-eyes gate itself stays by design
Secondary-market sales are recorded at face valueMODERATE always onResale reports aren’t integratedCorrecting how secondary-market sales are recorded
Senior staff resist any mandated standard toolMODERATE on rollout“Everybody has their best method”A capture-don’t-migrate posture - meet people in the tools they already use
In-house AI development is already under way in one divisionPRIORITY · nowModule inventory reviewed togetherA scope-reconciliation step so you fund one coordinated effort rather than parallel builds
Data lag is 24 hours - fine for history, wrong for any real-time ambitionLOWER always onNightly batchA scope note on real-time use cases
08·Baselines · What we measured

The numbers behind this evaluation

Every figure was stated by a member of your team on a dated call - nothing modeled, nothing inferred. These are the measured facts any future work should hold itself against.

5–7 hrs/wk
subsidiary settlements - 10 min each, 30–40 every Monday
1–3 hrs/day
subsidiary box-office → database transfer, daily
~1 day/mo
ad-invoice class-coding, per admin
2 hrs → 15 min
ad-pack build time - already proven by a team member’s own spreadsheet
~20 min
per offer in the operations database (vs ~15 min old spreadsheet muscle memory)
$170–185K/yr
AP re-coding staffing displaced - two temps at ~$40–45/hr loaded, growing with volume
60–65M
ticketing records unreachable today · 2 years · 24 hr lag
AreaWhat we measuredThe figure
TouringShow volume~900–950 shows/yr in settlement · ~90–100 tours · 50–60 artists; the booking team runs ~1,000 booked shows/yr, growing ~200/yr
TouringTeam shape5 talent buyers (~200 shows each) · 7-person booking team · ~10 event managers + up to 7 seasonal contractors · 70–80 shows per EM
TouringProduced events~40 tours / ~530 shows · 3-person team · 70–80% of division revenue
ConcertsOffer volume vs the growth goal~400 offers/yr today, targeting 550
ConcertsTicketing team5 people; daily-count platform live since January at ~98–99% parse accuracy
MarketingPaid socialSix figures a month across two ad accounts · campaign-per-city · ~80% of conversions via the primary vendor · working KPI thresholds CPC $0.30 standard / $0.10 hot, CTR 1–3%
MarketingSearch / SEO baselineEffectively zero - ~$500 spent of a $10K example budget
Ticketing subsidiaryScale20-person company · 530+ events on sale · 550–650 partners/yr · PCI Tier 1
Data spineThe dataset60M+ rows · 2 years · purchaser-level detail · nightly batch, 24 hr lag · drop counts 85–90% average
Why these numbers matter: the before / after contract

Baselines are only half of measurement. Their real value is as the fixed line every future phase measures itself against. If work proceeds, each figure gets re-measured on the same terms - baseline → 90-day → steady-state - so improvement is demonstrated, not asserted.

09·The full inventory

The 57 opportunities

Every opportunity from the interviews, force-ranked and sequenced into waves. Where a per-task time baseline was not captured, the inventory gives the volume and a confidence rating instead of an invented number - so the ranking stands on volume denominators plus qualitative confidence.

HS hard savingsRU revenue upliftSC strategic capabilityConfidence: H owned process + deterministic + data reachable · M needs a connection or some judgment · L compound dependency, heavy judgment, or hire-out

Finance 13

IDOpportunityTierConfidenceSizing (interview-stated)
F1AP pre-coding agent (plus mis-code flagging) - first instance of the categorization coreHSHTwo AP temps already hired at ~$40–45/hr loaded → ~$170–185K/yr, a derived estimate; grows with volume
F2Ad-spend allocation agent (200-line invoices)HSMSix-figure monthly paid-social spend; budget rationale sits with the planning team
F3Natural-language finance query layer (the CFO = named power user)SCMManual-pull count not quantified
F4Forecast-variance flaggingSCMNot quantified
F5Accounting-settlement automation - file-generation-for-review, NOT autonomous postingHS SCLDepends on EO2
F6Income-recognition + accruals agent - file-generation-for-reviewHSHClose frequency not quantified
F7Cash-forecast auto-population (the controller’s #1)HS SCM1–2 people per unit, half a day to a day weekly, plus a consolidation day
F8Working-capital forecasting by artistSCLNot quantified
F9Audit-support assembly (external auditors)HSMNot quantified
F10Settlement three-way variance compare - cross-departmentalSCL→MNumber of shows un-analyzed not quantified
F11Margin-anomaly explainer - reads variance directly from the ERPSCMNot quantified
F12ZBA daily transfer automationHSHPosting volume not quantified
F13New-vendor completeness checkHSHPercent incomplete not quantified

Ticketing 10

IDOpportunityTierConfidenceSizing (interview-stated)
T1Feed watchdog agent - “generally stable, occasional dev fixes”HSMBreak frequency + dev hours not quantified
T2Daily-count platform historical backfill (a ~90% in-house test parser = head start)HS SCMVendor-tier cost not quantified
T3SQL warehouse connector - feasibility confirmed; the only path to the two-year recordSCH60M+ rows · 2 yrs · nightly batch · 24 hr lag
T4Dynamic price-recommendation engine (genre + city/region; feeds the existing approval step)RULDepends on T3
T5Daily-count dashboard + historical-pacing flagsSC HSMDistribution effort not quantified
T6Kill manual daily-count entry (operations-DB auto-pull)HSHSetup time per tour not quantified
T7Email management assistant (a ticketing lead’s stated #1)HSMVolume not quantified
T8Internal profitability dashboard incl. ancillary “secret money” - hard access-control constraintRU SCMCost of misreads not quantified
T9Sold-map visibility for non-vendor venues (~20% of Concerts shows)SCM20% share known
T10Historical feedback loop (tour-over-tour) - vendor upload stopgap vs T2 pipelineSCMVendor tier cost not quantified

Marketing 9

IDOpportunityTierConfidenceSizing (interview-stated)
Mk1Single source of truth for conversion data (~80% via primary vendor)SCMEnabler
Mk2AI budget management + dayparting (lifetime budgets conflict with standard settings)HS RUMBudget-rationale layer sits with the planning team
Mk3Actionable-flag + visibility dashboard (CPC / CTR thresholds already in use)SC HSMThresholds known
Mk4Audience building / lookalikes from ticket-buyer historyRUMQualitative
Mk5Ad-invoice auto-class-coding - categorization core instanceHSH~1 admin-day / month
Mk6End-of-tour reconciliation / “what worked” rollup - skipped entirely todayHS SCHBaseline = zero; value = learning loop × ~1,000 shows/yr
Mk7Search ads + SEO channel - owner-endorsed; a service engagement, not a platform buildRUMNear-zero baseline
M1Customer segmentation + lookalikes on the SQL warehouseRULDepends on T3
M2Ticket velocity / efficient-frontier modelingRU HSLDepends on T3

Booking 12

IDOpportunityTierConfidenceSizing (interview-stated)
B1Auto-populate venue expenses + historicals at offer creation (VP of Booking: “a game-changer”)HSH need / M build~400 offers/yr → 550 target; ~20 min per offer today
B2Centralized venue / deal-knowledge base - ONE shared build with EO1 / EO5HS SCMKnowledge-loss case: two leaves in three months → months of retraining
B3Automated offer-sheet / tour-offer → event-offer templatingHSH15–16-city tours, ~8 wks, concurrent
B4Auto-populate scaling tiersHSHCompounds B1
B5Routing base + availability / conflict integration (+ cannibalization gap)SC RUM50+ outreaches per show; 600–700 emails per tour
B6Anomaly / risk flagging on offers (rent, taxes, fees, stagehands, break-even)SCMSwing scale: “tens of thousands” on rent
B7Venue rebate / ancillary optimizer - single-source, directional until validatedRUL→MRebate delta not quantified
B8Competitive-analysis + routing-optimization bolt-on (phase 2, after B5)RUL -
B9Artist evaluation / underwriting demand model - no reliable streaming → sales correlationSCLNot quantified
B10Financial vs demand model + Monte Carlo productionizationSCLNot quantified
B11Offer → settlement reconciliation loop - cross-division shared build (4 interviews, unprompted)SC HSMNeeds structured settlement data first
B12Intuition ↔ data bridge (judgment-vs-outcome calibration; piggybacks B11)SCL -

Event Operations 8 incl. 3 at the ticketing subsidiary

IDOpportunityTierConfidenceSizing (interview-stated)
EO1Show-advancing repository + pack assembly (capture-don’t-migrate; post-event survey = embedded quick win)HS SCM~700–800+ shows/yr, ~10 EMs + ≤7 contractors
EO2Show-settlement assembly agent (absorbs ticket-audit parsing + venue-expense categorization; populate-never-bypass)HSM~900–950 shows/yr, ~90–100 tours
EO3Production template-reuse + routed review - assist-onlySC HSLMethod not yet documented
EO4Contractor agreement + 1099 automation (“the single biggest sideways-energy drain”)HSM~40 tours/yr, 3-person team, 70–80% of division revenue
EO5Venue-data hub (produced events) + mileage-grid automation - coordinate with the in-house buildHSM~40 tours/yr
iEO1Ticketing-subsidiary settlement automationHSH30–40 × 10 min = 5–7 hrs every Monday (PCI scope)
iEO2Ticketing-subsidiary AI-assisted customer service (deflect-and-escalate)HS SCMCS volume not quantified
iEO3Ticketing-subsidiary PCI-compliant phone card captureHSLQSA / vendor scope

Workflow Automation 5 cross-cutting

IDOpportunityTierConfidenceSizing (interview-stated)
WA1Ad-pack auto-assembly - 2 hrs → 15 min per pack already proven by the team’s own spreadsheetHSH~87% already banked by the DIY version
WA2Email / attachment intake agentHS SCMDoc volume not quantified
WA3Cross-system re-keying elimination - 3 instances (subsidiary box office ↔ database 1–3 hrs/day; offer → downstream; offer → contract → settlement)HSM–H1–3 hrs/day on instance (a)
WA4Ticketing-subsidiary event-build automationHSLPCI scope
WA7Expense / document-categorization shared core - ONE build, three deployments; confirm-or-override, never auto-postHSH~1 admin-day/mo (ad invoices) + AP + venue expenses
57 opportunities total. Hard numbers held: iEO1 (5–7 hrs every Monday), WA3-a (1–3 hrs/day), Mk5 (~1 admin-day/mo), F1 (two temps at ~$40–45/hr → ~$170–185K/yr, derived), plus volume denominators across Booking, Event Ops, and Marketing.

The cross-bucket dependency map

Build order is set by dependencies, not by enthusiasm. One connector gates a dozen items; one categorization engine deploys three times; one knowledge base was asked for by three teams independently.

Figure 9 · Dependencies that determine build order
Governance tiering3–5 power users · read-onlydefault · file-gen-for-reviewNatural-language reporting(read-only · the firstbuild)Warehouse connectorthe most leveraged singledependencyCategorization coreone engine → AP · adinvoices · venue expensesShow-settlement assemblypopulate, never bypass thetwo-eyes gateVenue / deal knowledge baseONE build - asked for bythree teamsDaily-count dashboard +pacing flagsDynamic pricerecommendationsSegmentation · velocity ·audiencesAccounting settlement +income recognition(file-gen)Venue-expenseauto-populate + offerflagsProfitability view incl.ancillary revenue(access-controlled)Demand modelproductionizationOffer → settlementreconciliation loop(cross-division)Cash-forecastauto-populationFoundation (Platform)The gate that unlocks the restDownstream (Full Studio)Cross-division shared buildGovernance
The categorization core → instantiates → three deployments

AP pre-coding (F1) → ad-invoice coding (Mk5) → venue-expense mapping (the settlement slice). Build once; the second and third deployments are near-free.

The connector → gates → T2, T4, T5, T10, M1, M2, F7, B9/B10

The most leveraged single dependency in the map, now de-risked (feasibility confirmed with your data owner). A design constraint travels with it: flag-don’t-black-box the spreadsheets, and remember the ~24-hour lag - this data is analytical, not real-time.

10·Opportunity roadmap

Recommended starting sequence

The sequence is designed to establish momentum through early, verifiable results before advancing to more ambitious work. Reporting leads because it is read-only, verifiable, and the foundation subsequent builds reuse.

  1. Natural-language finance reporting F3

    A finance question asked in plain English returns its answer directly, with no manual report construction. Read-only by design, so it cannot touch the books - and it is the shared foundation every later finance agent reuses.

    Safe on-ramp · foundation for the rest
  2. Categorization and pre-coding agent F1 + WA7 + Mk5

    Reads the invoice, prefills the coding, and asks only when genuinely uncertain. This displaces the two AP temporary staff - roughly $170–185K a year in loaded staffing cost that grows with volume - and the same engine codes marketing spend and venue expenses: one build serving three functions.

    Cleanest hard-dollar win · cross-bucket
  3. Ticketing-subsidiary settlement automation iEO1

    Automates the 30 to 40 settlements currently processed by hand every Monday, returning roughly five to seven hours a week on a recurring, measurable task. Scoped with the PCI review.

    Bounded · recurring · quantified
  4. SQL warehouse connector T3

    Makes the two-year, 60-million-row dataset queryable by the people who need answers from it. Significant in its own right, and the gateway to several revenue-side opportunities.

    Makes the largest dormant asset reachable
  5. Venue-expense auto-populate, with offer anomaly flagging B1 + B6

    Populates venue expenses at offer creation and flags any offer that runs off pattern. This serves the booking growth goal directly, and it augments the booker’s judgment rather than overriding it.

    Revenue-side · augments the booker
Quick wins - run in parallel with the first builds

Deterministic, fast, visible: ZBA transfer automation · new-vendor completeness checks · income-recognition file generation (for review) · the end-of-tour marketing rollup · offer-sheet templating · the post-event survey slice. Each sits on an owned process with reachable data, and each is consistent with the reporting-first trust logic.

The 12–16 month view

PhaseMonthsWhat happensGates & dependencies
Foundation1–3Governance tiering stood up · natural-language reporting live · the categorization core’s first deployment (AP pre-coding) · quick-win cluster under way · subsidiary settlement scoped with the PCI reviewAccess-tier setup; PCI scope conversation
Data spine2–4Warehouse connector built and validated (nightly-batch data, ~24-hour lag - analytical, not real-time) · feed watchdog · categorization core deployments 2–3 (ad invoices, venue expenses)Database access; data-owner partnership
Revenue tier4–9Venue-expense auto-populate + offer flagging · profitability dashboard (with the access-control layer) · segmentation and pacing work on the connected spine · venue-knowledge base, coordinated with the in-flight internal workConnector live; legacy offer-data seeding; access-control design
Strategic tier9–16The offer → settlement reconciliation build (scoped once, cross-division) · cash-forecast auto-population · demand-model productionization (with the honest caution that streaming numbers don’t reliably predict ticket sales) · remaining document-assembly familyStructured settlement data from earlier phases; confidence earned in production
Sequencing honesty

The strongest story items - the reconciliation loop and the ancillary-revenue profitability view - sit later in the build order because they depend on structured data the earlier phases create. We’d rather sequence honestly than promise them early.

11·Architecture & governance

From ad-hoc sessions to owned infrastructure

Your AI use today runs through consumer tools with no shared memory, no audit trail, and no way to reach the company’s own systems - the CFO’s own description of hitting a wall trying to connect an AI model to the warehouse is the clearest example. The recommended posture inverts that.

Two tiers, settled with you

A small group of 3–5 power users who can write and build agents and automations, and standard users who get read-only, natural-language access. The CFO is the named power user for Finance; other divisions name their own as the model extends. Shared skills self-populate from patterns that repeat across users; an individual’s personal corrections live in a separate per-user profile layer.

Four rules every build honors

Gate 01 · Human-in-the-loop on financial writes

AI generates the file - for example, an ERP journal entry - and a person reviews and enters it. Direct AI writes into the ERP are explicitly out of scope until sustained confidence is established.

Gate 02 · Confirm-or-override on categorization

Anywhere AI maps messy input to a category - vendor coding, invoice class-coding, ticket-count ingestion - a person confirms or corrects before it’s final. The pattern already proven in the working ticket-count parser.

Gate 03 · Undo, fallback, and governance before autonomy

Any agent proposed for the data spine must have undo and fallback options and governance controls in place before it’s trusted to act. Trust is earned incrementally, not assumed at launch.

Gate 04 · Two-eyes and role boundaries, never bypassed

The existing settlement sign-off convention and division-scoped data access stay intact. Ancillary “secret money” and other division-specific figures never leak to surfaces outside their intended audience.

Rollout order - sequenced for trust, not just payback
  1. Reporting and natural-language query first. Low-risk, verifiable, and it builds organizational trust before anything is automated.
  2. Deterministic hard-savings automations on owned processes where the work is countable and the output is checkable.
  3. Money-adjacent file generation - still human-reviewed; AI drafts, a person enters.
  4. Graduated write access, only after sustained confidence has been demonstrated.
Open governance risks - kept honest, on purpose

Gatekeeping at scale. The 3–5 power-user model works at small scale; whether it holds org-wide without an equivalent structure is your CFO’s own good question, carried forward to revisit post-rollout. Sprawl risk. Several leaders are already building point solutions to problems this evaluation identifies. That energy is a real asset; without a shared foundation it becomes several uncoordinated builds rather than one governed platform.

12·Closing

Concluding observations

Whatever course you choose from here, the evidence points in one consistent direction: genuine value that your own people already create, constrained by the absence of shared infrastructure to sustain it.

The findings, the figures, and the roadmap are yours to act on. We have sequenced the work in the order we believe compounds fastest - reporting is the foundation the rest reuses - but each division’s figures stand on their own should leadership prefer to begin elsewhere. When you are ready to discuss where to start, we are prepared to help scope it.

Independent of any implementation decision, this evaluation gives you a documented map of how your divisions actually operate today, drawn from direct conversations rather than assumption. That map has standing value on its own. The remainder is a question of sequence.

What sits behind this readout

The full delivery package: the systems & data map, the six workflow maps, the current-state observations, the executive summary, findings by area, the opportunity roadmap, the architecture & governance outline, the baseline-metrics sheet, and an addendum carrying every interview, every system mapped end to end, and the derivation of every figure - 135 pages, each document self-contained and bookmarked.