New Report on SA Gambling Impact
Check It Out
<-Back

3 Countries, 1 Live Dashboard: How Ipsos Retired the Monthly Excel Pivot

How Ipsos South Africa turned WhatsApp photos of menu boards into a live price tracker across Kenya, Ghana and Zambia for a global quick-service restaurant brand.

Ipsos x Yazi case study card: 3 Countries, 1 Live Dashboard, How Ipsos Retired the Monthly Excel Pivot
Yazi case study · Market research

How Ipsos South Africa turned WhatsApp photos of menu boards into a live price tracker across Kenya, Ghana and Zambia for a global quick-service restaurant brand.

3
Countries tracked every month: Kenya, Ghana and Zambia
Year 2
The end client renewed the tracker for 2026
1
Live dashboard in place of monthly Excel pivots
Client
Ipsos South Africa
Industry
Market research
Markets
Kenya, Ghana, Zambia
Timeline
Since Jan 2025

In short

Ipsos South Africa tracks menu prices every month for a global quick-service restaurant brand in Kenya, Ghana and Zambia. Photos of menu boards are sent on WhatsApp, Yazi's AI reads every item and price, and Ipsos analysts check only what the system flags. The end client renewed the tracker for 2026, with a live dashboard in place of monthly Excel pivots.

  • 3 countries tracked every month since January 2025
  • The next two countries took less time than the first was to capture by hand
  • Renewed for a second year, with a live dashboard added
01The brief

A monthly price tracker built on photos of menu boards

Ipsos South Africa tracks menu prices for a global quick-service restaurant brand in three African markets. Each month, people in the field visit the brand's restaurants and its competitors, photograph the menu boards and send the photos in. The prices on those boards become the tracker: what each item costs, what changed, and which promotions are running.

Ipsos runs the programme with a fieldwork partner on the ground, and brought in Yazi to collect the photos on WhatsApp and turn them into data. In 2025 the photos came from a consumer panel. For 2026 the tracker moved to dedicated field auditors and a live dashboard.

02The challenge

Every price on every board had to be read by hand

Photos in, prices typed out

Every item on every menu board had to be read and captured. The first country alone took hours.

Monthly spreadsheets

The end client received the tracker as Excel pivot tables, once a month.

Checking every photo

Blurry, partial or wrong photos had to be caught one submission at a time.

Three markets, one standard

Menus differ by country, with combos and specials that don't map neatly to a product list.

Before the dashboard, analysts processed each month's photos and the end client saw the results as Excel pivots once a month.
03The approach

WhatsApp for the field, AI for the reading, a dashboard for the client

Field auditors send menu-board photos to Yazi on WhatsApp, up to ten photos per restaurant visit in one session. Yazi's AI reads each photo and turns it into line items, capturing combos and time-limited specials as items of their own. Ipsos analysts review anything the system can't match in an admin view, and the results flow into a live dashboard for the end client.

How the monthly cycle changed from 2025 to 2026

2025
Panellists send photos on WhatsApp›AI reads the photos›Analysts process the month›Excel pivot for the client
2026
Auditors send up to 10 photos per visit›AI reads every item on arrival›Analysts check flagged items›Live dashboard

One restaurant visit, start to finish

Each visit is a short WhatsApp session, checked as it arrives.

1
Visit. Field auditors photograph the full menu board at each restaurant.
2
Send. Up to ten photos go to Yazi on WhatsApp, with each visit's timing checked.
3
Read. AI extracts every item and price, including specials.
4
Check. Ipsos analysts match any new items to the standard product list.
5
Report. Prices update in the live dashboard.
WhatsApp photo uploadAI image readingAnalyst QC viewLive dashboard3 markets

Illustrative screen showing the field auditor flow. Not real menu data.

04Results

A tracker that reads its own photos

The difference showed in the first months. Ipsos's account lead at the time captured the first country's menu photos by hand, which took two to three hours. For the next two countries, with Yazi reading the photos, he set up the full report and analysis in less time than that first capture took.

Accuracy held up under Ipsos's own checks. After QC on a month of Zambia data, the Ipsos analyst reported a low error rate. In 2026 the fieldwork partner tested deliberately poor photos and found the system still read them.

DashboardMenu itemsPrice changesQCKenya · Ghana · Zambia
Menu itemPriceStatus
Matched
Matched
Special
New item
Matched

The QC view: analysts only review items the system flags, such as new items and specials. Illustrative layout, no client data shown.

A second year, with a live dashboard added

For 2026 the end client renewed the tracker for a second year, with a live dashboard and WhatsApp quality checks added. Ipsos's QC team has since signed off the August and September 2026 data.

Two years of the tracker

Jan to Feb 2025
Set-up
Panellists onboarded on WhatsApp in Kenya, Ghana and Zambia.
Mar 2025
First reports
AI reading of menu photos cuts the time to report.
Sep 2025
QC review
A low error rate after QC on a month of Zambia data.
Nov 2025
Dashboard agreed
Ipsos and Yazi plan a live dashboard to replace the Excel pivots.
Jan 2026
Renewed for 2026
The end client renews, with field auditors, the dashboard and quality checks.
Mar to Apr 2026
Dashboard and QC view
Analysts match new items, and edits flow straight to the dashboard.
Aug to Sep 2026
Signed off
Ipsos's QC team signs off two more months of tracker data.

“Comparing it to what we were doing before, this is far better.”

Charles Gayi, Ipsos, April 2026

“Images I thought weren't zoomed in or close enough, the whole thing picked up perfectly.”

Field manager, Ipsos's fieldwork partner
05Year one and year two

What changed in the monthly cycle

Tracker in 2025Tracker in 2026
Photo collectionA consumer panel on WhatsAppField auditors, up to ten photos per visit
Reading pricesRead by AI, processed by analysts each monthRead by AI as the photos arrive
Specials and combosHandled case by caseCaptured as their own line items
Quality checksReviewed at month endAnalysts review only flagged items
Client reportingMonthly Excel pivotsA live dashboard
06Impact

Less analyst time, a better product for the client

For Ipsos

A tracker that takes less analyst time each month, catches problems at the point of upload, and was renewed for a second year with a live dashboard added.

For the end client

Menu prices for its own restaurants and its competitors in three markets, in a live dashboard instead of a monthly spreadsheet.

“

It will make it a lot easier for everyone. We don't have to do manual dashboard updates every morning, send feedback, check for the photos. It will just make it so much smoother.

Lauren Van Der Rheede, Ipsos South Africa, when the 2026 dashboard was agreed
07Conclusion

The slowest step in price tracking was reading the photos

The fieldwork in a price tracker was never the hard part. Reading thousands of menu photos was. With collection on WhatsApp and the reading done by Yazi's AI, Ipsos turned a monthly manual job into a live tracker, and kept its analysts for the judgement calls.

08FAQ

Frequently asked questions

How does AI read menu prices from photos?

Field auditors send up to ten photos per restaurant visit on WhatsApp. Yazi's AI reads each photo and turns it into line items with prices, capturing combos and specials as items of their own. Ipsos analysts review only the items the system flags, such as new items.

Which markets does the tracker cover?

Kenya, Ghana and Zambia, every month, for a global quick-service restaurant brand and its competitors.

What changed in the second year?

For 2026 the photos moved from a consumer panel to dedicated field auditors, WhatsApp quality checks were added, and a live dashboard replaced the monthly Excel pivots the end client used to receive.

Turning photos into data by hand?

Book a 30-minute demo →