Published
How a 25-Person Hospitality Studio Replaced Its Spreadsheet Pipeline With .STUDIO in One Week
Case study: Ambient Form Design Studio migrated 18 active opportunities from Excel to .STUDIO over one weekend. By Week 2, the team was logging activities daily. By Month 3, they couldn’t imagine going back.

Author:
Ben D'Souza
Estimated reading time: 9 minutes
Studio: Ambient Form Design Studio (name changed for confidentiality)
Location: Dubai, UAE
Team size: 25 people
Specialisation: Hospitality and F&B design
Pre-.STUDIO setup: Shared Google Sheet for pipeline, email for relationship management, separate PM tool for projects
The Problem
By early 2025, Ambient Form had outgrown their spreadsheet. The pipeline held 18 active opportunities worth approximately £4.2M. Two BD people managed relationships independently. Pipeline updates were sporadic - the spreadsheet was always 3–5 days out of date. Leadership couldn't answer "what's realistically closing this quarter?" without an hour of manual analysis.
Deals were slipping through the cracks. A strong hospitality opportunity went cold for three weeks because one of the members fell ill and there was no documentation anywhere - the spreadsheet had no column for last feedback. Another proposal was late because the submission deadline wasn't in anyone's calendar.
The studio director decided: the spreadsheet had to go. The question was how to switch without losing active deals during the transition.
The Migration Timeline
Day | Activity |
|---|---|
Monday Week 0 | Decision made: switch to .STUDIO. Cutover date set for Friday → Monday (5 days away). |
Tuesday–Wednesday | .STUDIO setup: user accounts, pipeline stages, BD team roles configured. |
Thursday | Final spreadsheet update. All BD people ensured their opportunities were current. |
Friday | Spreadsheet frozen EOD. Active opportunities exported into .STUDIO helper format. Data imported into .STUDIO Friday evening. Spreadsheet marked read-only. |
Monday Week 1 | Go-live. Team logs in, reviews opportunities, logs first activities. Daily check-ins for questions. |
Week 2 | Normal operations in .STUDIO. Team logging activities consistently. No parallel tracking. |
Week 4 | Full adoption. Team can't remember how they managed pipeline in the spreadsheet. |
Month 3 | Operational maturity. System is the default. Historical data backfilled. Reporting in use. |
Total implementation time: 5 days from decision to go-live. Full adoption in 4 weeks.
"We thought it would take months. It took a weekend."
— Studio Director, Ambient Form
Week 0: The Decision and Setup (Monday–Thursday)
Monday: The Breaking Point
The decision to switch came after a specific incident: a £75k office fit-out opportunity went cold because nobody followed up for 12 days. The lead had been warm - client was ready to move. The studio just didn't see it. By the time someone remembered to check in, the client had moved forward with a competitor.
The studio director called a meeting: "We're switching to a real system. This happens in the next two weeks, not 'someday.'"
The team chose .STUDIO after reviewing three options (HubSpot, Programa, .STUDIO). HubSpot felt over-engineered for their workflow. Programa was great but lacked the business operations layer they needed. .STUDIO connected sales directly to their project management and specifications - the single system solution was the deciding factor. Cutover date set: Friday → Monday, 5 days away.
Tuesday–Wednesday: System Setup
.STUDIO's onboarding team set up the system in a 90 minute meeting: 25 user accounts created with roles assigned (2 BD leads, 5 senior designers with opportunity visibility, 18 team members with project-only access), pipeline stages configured (Leads → RFP Received → RFP Submitted → Expected → Won/Lost), project types (Hospitality, F&B, Residential), and service types (Design Only, Design + Supervision). No historical data migrated yet. No extensive training. Just enough structure to support active operations.
Thursday: Final Spreadsheet Update
All BD people updated their opportunities one last time: current stage, estimated value, last contact date, notes on where each deal stood. This became the migration source file.
Friday: The Cutover
Spreadsheet exported to CSV Friday afternoon. Data imported into .STUDIO with stage mapping ("Proposal Sent" → "RFP Submitted", etc.). 18 opportunities imported. Each BD person reviewed their opportunities in .STUDIO, confirmed completeness. Spreadsheet renamed "Pipeline Archive — Frozen [Date]", moved to archive folder, editing access removed permanently.
Studios using CRM for interior design studios report clean cutover (hard Friday → Monday switch) works better than gradual transition: using both systems for weeks creates data divergence and confusion.
Week 1: Go-Live and Initial Adoption
Monday Morning: First Login
9AM: Team meeting. 25-minute .STUDIO walkthrough covering three things: how to view and search though your opportunities, key dashboard widgets, how to log an activity (email, call, meeting), and how to update a stage. That's it. No exhaustive feature training. 9:30AM: Everyone logs in, reviews their opportunities, adds missing details. 10AM: Everyone logs their first activity. By Friday Week 1, the team had logged 73 activities across 18 opportunities.
The Adoption Tipping Point
Wednesday Week 1: A manager asked in the team chat: "Did anyone follow up with the Marina Bay Hotel client?" The BD lead responded: "Yes - check .STUDIO. I called them Tuesday. Notes are logged. Here is the link from .STUDIO" The manager clicked the link, opened .STUDIO, reviewed the follow up notes, got the info he was looking for in 30 seconds without having to ask anyone anything further.
That moment crystallised the value: information accessible to everyone who needs it, without asking anyone.
Studios running on project management software for interior designers report this as the adoption breakthrough: when team members self-serve context instead of asking for updates, the system proves its value viscerally.
Week 2–4: Building Operational Muscle
Week 2: The Resistance Fades
One BD person kept trying to update the old spreadsheet out of habit. Found it locked. Complained briefly. By Wednesday, they stopped complaining. They realised .STUDIO was faster: logging an activity took 20 seconds vs 45 seconds in the spreadsheet, plus avoiding the potential of overwriting someone else's data from simultaneous editing. The resistance wasn't ideological. It was muscle memory. Muscle memory fades in 3–5 days when the new behavior is easier.
Week 3: Enriching Data
By Week 3, the team wasn't just using .STUDIO - they were improving their version of it. Stakeholder maps added per opportunity. Client communication preferences documented. Three RFP deadlines added to opportunity records and visible in the shared RFP calendar, not scattered across individual Google Calendars. None of this was mandated. Teams enrich data when they see the value.
Week 4: Full Adoption
By Week 4, .STUDIO was the default. Nobody referred to the old spreadsheet. The studio director reviewed adoption metrics: 18 opportunities all current, 187 activities logged (average 10 per opportunity), 100% of opportunities updated in past 7 days, zero deals marked stale or forgotten.
Month 2–3: Operational Maturity and Results
What Changed Operationally
Follow-up consistency improved. Before .STUDIO: deals went cold because follow-up was manual. After: Clear dashboard charts surfaced overdue opportunities. If a deal sat in "RFP Submitted" for 2 weeks with no activity, the process flagged it because the data was visible.
Pipeline visibility became real-time. Before: 30 minutes to compile a pipeline update. After: leadership opened the dashboard and saw total pipeline value (£4.2M), weighted forecast (£2.1M realistic), stage distribution, aging deals. No manual reporting required.
Proposal development accelerated. Before: fee estimates built in separate spreadsheets, disconnected from the opportunity record. After: resource-based estimates built inside each opportunity. Margin visible before proposal went out.
Sales-to-delivery handoff became seamless. Before: when a deal was won, someone emailed the project manager with the brief. After: when a deal was marked Won, it became an active project automatically. No re-entry. No lost context.
Studios using interior design management software report handoff improvement as the highest-value outcome: projects starting with full context instead of partial information.
Quantified Outcomes (Month 3)
Metric | Before .STUDIO | After .STUDIO | Change |
|---|---|---|---|
Opportunities going cold unnoticed | 1–2 per quarter | 0 in 3 months | Eliminated |
Time to compile pipeline report | 30–45 minutes | 2 minutes (live dashboard) | 93% reduction |
Margin visibility timing | Post-delivery | Pre-proposal | Proactive |
Sales-to-delivery handoff | Manual, 2–3 hours | Automatic, 0 hours | 100% elimination |
Leadership confidence in forecast | Low (gut feel) | High (weighted data) | Qualitative improvement |
Won deals (first 3 months): 3 opportunities, £98k total value, average 38% gross margin (visible before contracts signed).
Key insight from lost opportunity tracking: 3 of the 4 losses were small F&B projects (<£15k). Pattern identified: stop pursuing small F&B, focus BD effort on larger hospitality (>£50k) where win rates are higher.
The 90-Day Retrospective
What worked: Hard cutover (Friday → Monday). Minimum viable migration. Daily check-ins Week 1. Forcing adoption by removing spreadsheet access.
What was harder than expected: Changing habits. First week felt awkward. By Week 2, natural. Resisting the urge to keep the spreadsheet "just in case" required discipline.
Would they go back to spreadsheets? "Absolutely not. I can't imagine running the studio without real-time visibility now."
The Lessons Other Studios Can Apply
1. Set a Hard Cutover Date (Not "Someday") |
|---|
Ambient Form set the date Monday of Week 0: "We go live Friday → Monday." No ambiguity. A date five days away created urgency and forced decisions. Studios that say "we'll migrate when we're ready" never migrate. Ready never comes. |
2. Migrate Minimum Viable Data |
|---|
Ambient Form didn't migrate historical deals. Didn't migrate full conversation history. They migrated active opportunities with just enough data to keep deals moving: client name, contact, stage, value, owner, brief notes. Perfection delays launch. Minimum viability enables launch. Enrichment happens through use. |
3. Kill the Old System Completely |
|---|
Ambient Form made the spreadsheet read-only. Removed editing access. No escape hatch. Studios that keep the old system "just in case" end up using both systems. Data diverges. Confusion multiplies. Clean death of the old system prevents this. |
4. Train Just-in-Time, Not Exhaustively |
|---|
Ambient Form's training: 15 minutes. "Here's how to view opportunities, log activities, update stages." They didn't train on reports, advanced workflows, or edge cases. Training happened as needs emerged. Week 3: someone asked about RFP deadlines. Trained on that feature then - not Day 1 when it wasn't relevant yet. |
5. Expect Resistance; Persist Anyway |
|---|
One BD person resisted Week 1. By Week 2, they adapted. By Week 3, they were advocating for the system. Resistance is normal. Studios that accommodate resistance by allowing parallel tracking fail. Studios that persist through discomfort succeed. |
Stop Waiting for Perfect Conditions
Ambient Form didn't wait for slow season. Didn't wait for clean data. Didn't wait for full team availability. They set a cutover date during normal operations, migrated over a weekend, went live Monday.
Was it perfect? No. Were there questions Week 1? Yes. Did anyone lose a deal during the transition? No.
By Month 3, the system was operationally superior to the spreadsheet - not because it was perfect, but because it was connected, automated, and designed for the workflows design studios actually run. The studios that switch successfully don't wait for perfect conditions. They accept imperfection, migrate fast, and improve iteratively.
If your studio has been "planning to switch" for months, stop planning. Set a date. Two weeks from now. Migrate minimum viable data that weekend. Go live Monday.
Ready to make the switch? Book a free 30-minute implementation planning session and we'll map your exact migration timeline — what to migrate, when to cut over, and how to get live in one week.


