← Parker Ehret

Beacon Admin

Designing and building Beacon's custom internal software and intelligence engine.

UtilitiesDayMonthYear
12a6a12p6p
Pending
UtilitiesSyncing
Leak Alerts
BenchmarkingPendingPendingCompliantExempt
IntelligenceNew Utility Data
Energy StarPending
CustomerPending
Pending
New Utility Data
12/1/2026–1/1/2027New11,820
11/1/2026–12/1/2026New12,460
10/1/2026–11/1/2026New12,905
9/1/2026–10/1/2026New10,310
8/1/2026–9/1/2026New9,875
7/1/2026–8/1/2026New9,240
6/1/2026–7/1/2026New10,615
5/1/2026–6/1/2026New11,980
4/1/2026–5/1/2026New12,330
3/1/2026–4/1/2026New11,105
2/1/2026–3/1/2026New10,470
1/1/2026–2/1/2026New9,960

$586

Your savings in 2026

JanFebMarAprMayJunJulAugSepOctNovDec

Beacon is an agentic AI software platform for properties. It helps building owners and property managers monitor utility usage, maintain compliance, and uncover savings, without any hardware. Behind the product sits the tool our team uses to run the business, and at the foundation of everything we're building is our intelligence engine.

As we were bootstrapping, everything started as an Airtable base that I wired together myself. Eventually we needed to replace it with a custom Admin and CRM that I designed and helped build.

Everything started on Airtable

We needed to move fast, so we chose Airtable as our backend because the product was easy to use, the integrations were simple, and we didn't need to spend engineering time on something I could do myself.

I built the Beacon website and marketing site myself, and I built every Airtable integration that powered them. The contact form on the site, our intake forms, and the onboarding flow all wrote straight into Airtable. Every new lead and every new customer landed in one place.

Website01 / 05
full_nameJordan Lee
emailjordan.lee@example.com
companyNorthwind Properties
roleProperty manager
Submit
Airtable base
LeadWebsite
LeadMarketing site
LeadContact form
CustomerIntake forms
OnboardingOnboarding flow

Everything lived in Airtable. Our customers, their buildings, every status update, utility providers, Stripe integration, Energy Star integration, and countless automations.

CustomersBuildings
CompanyEmailFull NameStripeEnergy StarAccount
1Northwind Propertiesjordan.lee@example.comJordan LeeConnectedConnectedActive
2Harbor Point Realtyalex.morgan@example.comAlex MorganConnectedConnectedActive
3Maple Ridge Holdingstaylor.brooks@example.comTaylor BrooksConnectedConnectedActive

We even used Airtable for our sales funnel. People often started the intake form or onboarding and dropped off at some point. We didn't treat those as lost customers. Each incomplete intake or onboarding record showed exactly where someone dropped off, so we turned them into sales opportunities. Each person was given a priority and automatically assigned to someone on the team.

CustomersBuildingsSales
CompanyEmailFull NameStripeEnergy StarAccount
1Northwind Propertiesjordan.lee@example.comJordan LeeConnectedConnectedActive
2Harbor Point Realtyalex.morgan@example.comAlex MorganConnectedConnectedActive
3Cedar Park Groupcasey.nguyen@example.comCasey NguyenIncompleteIncompletePending

Where Airtable hit its limits

Airtable took us further than I expected. But as Beacon grew, what we were using wasn't able to scale as fast as our company was and it didn't have the features we needed.

Customers started getting bigger. They had multiple buildings, multiple utility providers, needed separate billing accounts, and required more detailed historical context. To scale properly, we needed to automate more and more, and Airtable's Automations were no longer capable or reliable.

Each workaround made the base harder to trust. We had started designing for what Airtable was capable of and not for what the ideal user experience was.

Customers
CompanyBuildings
1Customer 1Building A, Building B, Building C, Building D
2Customer 2Building E
3Customer 3Building F

We started designing our onboarding and user experience around what Airtable could do

Bigger customers outgrew one row

Building A
Building B
Building C
Building D
Run 1Done
Run 2Done
Run 3Done
Run 4Running

Airtable Automations were no longer reliable

Why we built our own Admin

Making Airtable do more was costing us more than it gave back. Our team actually needed a more bespoke internal tool to run Beacon as it scaled. We needed one place to run internal operations and manage every customer. Airtable had no way for us to see, compare, or improve what our intelligence engine was producing. We also wanted an Admin and CRM with far more depth than a spreadsheet database could offer.

I designed the entire Admin product from the ground up. I dissected every database in Airtable and reorganized everything around the customer. Data that used to be spread across numerous tables now lives in one view, and any detail is one click away. I mapped our entire workflow and how we interacted with customers. I created an entire library of reusable components to speed up development. And at every turn we optimized for speed.

Search
Harbor Point Realty
Harbor Point RealtyOverviewESPMBillingHistory
Customer Info
Customer StatusActive
Property managerAlex Morgan
Address1200 Harbor Blvd
Business TypeCommercial Real Estate
Buildings
Harbor Point PlazaActiveConnected20262027
Harbor Point TowerActiveConnected20262027
Harbor Point AnnexActiveConnected20262027
Harbor Point LoftsActiveConnected20262027
Harbor Point CommonsActiveConnected20262027
Energy Star Accounts
Harbor Point PlazaOverviewMeters
Building Info
Harbor Point Plaza20262027
Utility ProviderConnected
Address1200 Harbor Blvd
Year Built
Square Footage
Use TypeCommercial Real Estate
Construction StatusExisting
Notes

All forms, onboarding, and integrations now run on a scalable tech stack. I helped with every part of the migration and made sure that hundreds of fields and data types were mapped correctly to our new database tables and schemas.

SourcesWebsite & FormsOnboardingStripeEnergy StarAirtableMigratingMigration CompleteSupabase · PostgresIntelligence EngineAutonomous Building Intelligence®AdminCustomer DashboardUtility ProvidersAWS

A deeper dive into Admin

The Admin does three jobs together that Airtable never could: internal operations, customer management, and showing the output of our intelligence engine.

Internal operations

We could finally automate the entire building benchmarking and compliance process. Data was streaming into customer accounts from utility providers. The usage data was summed up at the end of every month, normalized, and prepped for upload to Energy Star Portfolio Manager. We could sync the data instantly and make sure our customers were compliant with AB 802. A customer with 10 buildings used to take almost a day to set up. Once the Admin had the automations we needed, we could get dozens of buildings compliant in minutes.

Search
Harbor Point Realty
Harbor Point RealtyOverviewESPMBillingHistory
Customer Info
Customer StatusActive
Property managerAlex Morgan
Address1200 Harbor Blvd
Business TypeCommercial Real Estate
Buildings
Harbor Point PlazaActiveConnected20262027
Harbor Point TowerActiveConnected20262027
Harbor Point AnnexActiveConnected20262027
Harbor Point LoftsActiveConnected20262027
Harbor Point CommonsActiveConnected20262027
Energy Star Accounts
Harbor Point PlazaOverviewMeters
Building InfoNew Meter DataSynced with ESPM
Harbor Point Plaza20262027PendingCompliantExempt
Utility ProviderConnected
Address1200 Harbor Blvd
Year Built
Square Footage
Use TypeCommercial Real Estate
Construction StatusExisting
Notes
Meter Usage DataSyncing with ESPM
12/1/2026–1/1/2027New11,820
11/1/2026–12/1/2026New12,460
10/1/2026–11/1/2026New12,905
9/1/2026–10/1/2026New10,310
8/1/2026–9/1/2026New9,875
7/1/2026–8/1/2026New9,240
6/1/2026–7/1/2026New10,615
5/1/2026–6/1/2026New11,980
4/1/2026–5/1/2026New12,330
3/1/2026–4/1/2026New11,105
2/1/2026–3/1/2026New10,470
1/1/2026–2/1/2026New9,960

Customer management

Every customer now lives in one place. We can view all of the buildings, information, statuses, and data for every customer. We automatically sync data to Energy Star Portfolio Manager, we can control Stripe accounts and subscriptions, and we even have a comprehensive history of every action performed on a customer's account, along with multiple email automations.

Search
Harbor Point Realty
Harbor Point RealtyOverviewESPMBillingHistory
Customer Info
Customer StatusActive
Property managerAlex Morgan
Address1200 Harbor Blvd
Business TypeCommercial Real Estate
Buildings
Harbor Point PlazaActiveConnected20262027
Harbor Point TowerActiveConnected20262027
Harbor Point AnnexActiveConnected20262027
Harbor Point LoftsActiveConnected20262027
Harbor Point CommonsActiveConnected20262027
Energy Star Accounts
Subscriptions
Harbor Point PlazaActive
Invoices
Receipts
Harbor Point TowerActive
Invoices
Receipts
History
Updated billing for Harbor Point Tower 1/14/2027BillingParker
Updated billing for Harbor Point Plaza 1/14/2027BillingParker
Invoice 1/1/2027Paid
Harbor Point Plaza 12/6/2026Connected
Invoice 12/1/2026Paid
Welcome Email 11/2/2026Delivered
Account Created 11/2/2026Active
Harbor Point PlazaOverviewMeters
Building Info
Harbor Point Plaza20262027
Utility ProviderConnected
Address1200 Harbor Blvd
Year Built
Square Footage
Use TypeCommercial Real Estate
Construction StatusExisting
Notes

Autonomous Building Intelligence®

Beacon's Autonomous Building Intelligence® is the intelligence engine at the heart of the product. This is what brings a building to life, creates alerts, finds savings, and generates recommendations. Being able to visualize the outputs in our Admin tool allows us to run different models, inspect prompts, and compare outputs. We run qualitative evals and give each output a score, which gives us fine-grained control over the rules and guardrails, and sets the foundation for us to constantly improve our product.

Harbor Point Realty · IntelligenceProcessing New Data
Tool Trace 0Checks 0Scores 0Findings 0
  1. Run
  2. Inspect
  3. Check
  4. Score
  5. Improve

Final thoughts

Airtable was the right call when we were small, bootstrapping and had no choice but to move fast. It let us ship fast without pulling engineers off the product, and every workaround we implemented showed us exactly what our team really needed. When it was time to build our own Admin, those workarounds became the blueprint.

Beacon's internal Admin software turned a spreadsheet our team had to babysit into a tool that puts everything we need in one system. Compliance runs on its own, every customer lives in one place, and we can see, score, and improve what our intelligence engine produces. We stopped designing around what a tool could do and started designing the best possible experience for our team and our customers.