From a merchant list to a sales opportunity
Portfolios and targets lived in spreadsheets, campaign preparation happened in a separate tool, and weekly reviews meant reconciling what reps submitted with official sales figures. I built the Hub’s portfolio views around the question I faced as an account manager. Which merchant has a reason to hear from me today?
The work varies by line of business. An account manager can filter for promotion opportunities and draft personalized outreach for the stores they select. Early merchant support uses menu and promotion data to find gaps at new restaurants. Retention reps follow inactive stores through reactivation.
One store, different owners
In the Hub’s multi-tenant data model, each store has a separate assignment for each line of business that works with it. When a portfolio changes hands, dated assignments preserve who was responsible for the store before and after the transfer.
I built the portfolio filters and saved views in React so reps could keep the spreadsheet workflow they knew. Azure Functions and PostgreSQL enforce access by role, team and assignment. That gives a lead a view across their team’s accounts while each rep works their own portfolio.
Managing the sales floor before month-end
Team leads can see whether each rep is on pace for the month, which stores still need outreach and who is on shift to cover them. They can coach a rep on their next promotion or direct outreach toward an overlooked group of merchants.
The sales claims pilot also distinguishes work awaiting review from approved wins. For pricing work, the Hub tracks whether a merchant’s lower menu markup held for 30 days. That gives a lead a basis for coaching on the outcome of the offer as well as the initial sale.
Sales figures leadership can explain
In the weekly account management review, analysts can compare approved sales claims with official results by product, then examine each team’s figures. Reporting leads publish the current week’s figures straight to the Google Sheets workbook leadership already uses. That removes the step of copying totals by hand.
We also separated who owns an account today from who earned a sale. If a rep moves teams on Friday, Tuesday’s sale still counts for the team that earned it.