LO.ozdesign
Back to projects

Local market map

01 · The project

Local market map

AUTOMATION · PUBLIC DATA · SHEETS
02 · What I built

A demonstration automation: give it a category and an area, and the public listings become an ordered sheet. How many competitors per area, how they stand on reviews, who has a website and who does not.

03 · The result

Before opening or pushing into an area you already know how many there are, what they are worth, and where nobody is doing it well.

Pick a category and an area: see the sheet that comes out and what it tells you.

1 / 3
Category and areae.g. hairdressers, Cosenza
Collects the public listingsname, address, phone
Public directoriesmaps and listings
Drops duplicates and closed businessesonly the ones still trading stay
Cross-checks reviews against online presencewho has a site, who takes orders
Website checkdoes it exist, does it answer
Where is the biggest gap?
no websiteno ordersno hours
Sheet with the “no website” columnbest reviewed at the top
Sheet with the “online orders” columnbest reviewed at the top
Sheet with the “missing hours” columnbest reviewed at the top
01 · Source

Category and area

02 · Decision

Collects the public listings and orders them

Counts the businesses, cross-checks reviews and online presence.

On request
03 · Action

Sheet ready

31 of 47 have no website

Average rating 4.1

Thinnest area: Via Popilia

Sheet ready, 47 rows

Pick what to look for. Public business listings become an ordered sheet, and underneath are the three lines that make the sheet worth having.

1 / 3

Reads the public listings, drops the duplicates, cross-checks reviews against online presence.

The sheet that comes out

47 businesses
BusinessAreaReviewsSite
Salone AuroraCentre4.6 · 128yes
Hair LabVia Popilia4.2 · 41no
Studio KappaCentre4.8 · 203yes
Barber & CoRende south3.9 · 17no
Effetto ChiomaVia Popilia4.1 · 34no

What it tells you

  • 31 of 47 have no website
  • Average rating 4.1
  • Via Popilia is the thinnest area

Sample rows, not a market study anyone commissioned. On real data the sheet has the same shape and many more rows.

Need something similar?

Let's talk