Moravio
Our work

Business intelligence for Asahi

After a wave of changes, Asahi Beer USA was losing store accounts it could not see in its sales reports. We turned years of distributor sales data into one ready list per distributor, and the marketing team now works with the data on its own.

Client context

Asahi Beer USA is the US business of Asahi Group. Its brands reach stores through independent distributors, and in the independent trade every store account has to be reached on its own. The US team is lean.

Like almost every company that sells beer, spirits or wine in the US, Asahi Beer USA sees its sales through VIP (Vermont Information Processing), the standard software of the US beverage industry for suppliers and distributors. Distributors report what each store buys, and suppliers read it in VIP's reporting tool iDIG.

The real problem

Between 2024 and 2026 a lot changed at the same time. One of the company's brands was renamed and repackaged several times, products got new item codes, some distributors changed, and two sales databases that had been kept separately were merged into one. In the client's words, these were many changes at one moment that are hard to match with each other.

In the reports, the same physical product now showed up as several items, one for each name and code, and there was no simple way to bring them together. Stores that had stopped ordering after a distributor change or a rename were hard to find. As the client explained: "We have lost a lot of accounts because, as we are distributed in independent trade, where you really need to communicate with each individual account, few accounts may not be aware of this change, therefore we may lose them."

The team had started to put the report exports together by hand, and every export stopped at a row limit.

Where we started

What the team needed was clear: "We just need the list of the accounts, ideally with address, and the comparison of what was sold in the past and now, to understand that they've dropped. Because we're going to come with this list to our distributors."

We started in August 2026 with a brief of two to three hours, and the team did not have to explain the whole business first. In a screen-share session, the national marketing manager walked us through how the reports are read today.

Two limits shaped the work. Company computers are locked, and any software install goes through IT in Europe. The only AI tool the company allows is Microsoft Copilot. The team also asked for something it could run without us: "we don't want to be reliant on you all the time." Everything we delivered works with what the team already had: Excel, Copilot and a web browser.

What we built

  • One row per store, across the years. Sales are matched store by store on the VIP outlet ID, so each store's purchases from 2023 to 2026 can be compared side by side.

  • Win-back lists by state. The first version, in October 2026, covered four US states in the South and on the West Coast. Each workbook shows the stores to call now, the stores to win back, the top stores that are shrinking, a view by chain and all stores.

  • One ready list per distributor. The second version came two weeks later. Each list can go straight to the distributor: account, address, ZIP code, chain, store type, cases bought per year, the last month of purchase and what the store used to buy. A column estimates the potential in US dollars, and stores that have closed are left out.

  • Copilot prompts. A sheet of ready-made prompts lets the team ask its own questions of the files in Copilot.

  • A tool that runs in the browser. The team adds new report exports to the master file in a web page that runs only in their own browser. Nothing is uploaded to our servers.

The browser tool went through three iterations. After the team had worked with the files for a while, we met again to check and improve the whole setup. We worked under a confidentiality agreement, so the figures on this page stay general.

The results

  • The marketing team works with the data on its own. "That was actually the file which I can use as a, you know, basic user … So I could create dropped accounts because of distributor change or drop accounts from 2023 and I had the list and the size of opportunity and everything."

  • Store visits planned from the data. With one state's file in Copilot, the client asked for crew drives within a 30-mile radius based on lost volume and got a list of crew drives covering hundreds of cases.

  • Lists ready to hand over. Each distributor gets its own list of stores to win back, with the potential in US dollars.

What we learned

The data the team needed was already in the reports. What was missing was a way to read it across several years of renames and distributor changes, in tools the company allows. We kept to Excel, Copilot and the browser, so a lean team can keep the lists up to date without us.

What the client says

  • We had a global problem that my team or I would have spent hours on, and the Moravio team solved it from a brief of two or three hours. I got a tool I can use on my own, and I am not dependent on them.

    Zuzana DudováMarketing Director, USA, Asahi Beer USAUnited States

More context helps

Describe the situation

A few useful details help us prepare: who is affected, how the work happens today, what has already been tried, and why this matters now.

Sounds like your situation?