Site selection·Google Ads + 2024 Census

I checked 'coffee shop near me' across 1,000 US cities. Here's where demand outpaces supply.

Starbucks has proprietary site-selection models. A small operator does not. So I asked a narrower question with a cheaper input: where is local coffee demand already visible in Google searches, but still light enough on shop count to look interesting? The result is a 1,000-city screening model built from live Google Ads volume and 2024 Census population.

Per-capita demand falls out cleanly once you divide raw search volume by population. The cities that surprised me most were not the obvious foodie towns — they were mid-sized markets where the per-capita rate beats every major metro but the shop count hasn't caught up yet.

DV

Founder, Sextaris · I build keyword-research tools for non-US markets. · Published April 10, 2026 · 12 min read

Back to research

Four numbers that frame the screening model

Pulled directly from the 1,000-city dataset below.

Demand Scale

4.7M

Combined monthly searches across the 1,000 matched cities. This is not a category estimate. It is a location-screening signal for one high-intent query.

NYC Benchmark

97

Major cities with population above 100,000 that beat New York’s 3,550.3 searches per 100K residents.

Median Density

2,156.5

Median monthly searches per 100K across the full 1,000-city set. The real action starts well above that line.

Leading Overlap

2

Markets that rank on both the underserved list and the strongest 12-month trend list. Those are the places we would screen first.

“Coffee shop near me” is one of the cleanest local-intent terms in search. Nobody types it for entertainment. They type it because they want coffee, nearby, soon. That makes it useful as a demand-density proxy. Not a guarantee of store success. Not a substitute for rent, traffic, co-tenancy, or unit economics. But a very efficient early filter.

To build that filter, we pulled live Google Ads historical metrics for 1,000 US cities matched to Google Ads city geo targets, then normalized the monthly volume using the latest available 2024 Census place populations. The result surfaces a pattern that raw volume alone would miss: some markets are huge because they are huge, while others are genuinely overperforming relative to their size.

New York still leads the country on raw volume at 301,000 monthly searches. But the more revealing metric is intensity. New York posts 3,550.3 searches per 100K residents. That is strong, but far from unbeatable. 97 major cities in this study clear that bar.

The US map

Each point below is one of the 1,000 matched cities. Dot size reflects raw monthly search volume. Color reflects volume per 100K residents. The broad pattern is clear: Sunbelt and western metros show up repeatedly, but so do selective legacy and college-driven markets. The most interesting story is not simply “big cities search more.” It is that mid-size cities like Denver, Seattle, Austin, and Orlando generate much denser local coffee intent than New York on a per-capita basis.

Coffee demand map

Hover points for city-level volume, CPC, and demand density.

Lower density
Higher density

Raw volume leader

New York, NY

301,000/mo

Per-capita leader

Orange, CA

65,607.8 per 100K

Large-city standouts

Atlanta, GA

11,633 per 100K

Dataset retrieval

April 10, 2026

Google Ads live pull + Census Vintage 2024

Top 50 cities by monthly volume

Raw volume matters because it points to absolute demand. But the highlighted column here is Volume per 100K residents. That is the bridge from “big city, big number” to “market where search demand looks unusually concentrated.”

RankCityMonthly VolumePopulationVolume per 100KCPCComp. Index12-Month Trend
1
New York, NY
301,0008,478,0723,550.3$12.5921
+31.4%
2
Los Angeles, CA
135,0003,878,7043,480.5$18.1013
+82.3%
3
Chicago, IL
135,0002,721,3084,960.8$16.3120
+22.0%
4
Houston, TX
110,0002,390,1254,602.3$17.2517
+95.9%
5
Austin, TX
90,500993,5889,108.4$15.8917
+82.4%
6
Orange, CA
90,500137,94165,607.8$19.0615
+71.1%
7
San Diego, CA
74,0001,404,4525,269$16.5318
+60.6%
8
San Francisco, CA
74,000827,5268,942.3$15.7414
+71.7%
9
Seattle, WA
74,000780,9959,475.1$11.4314
+60.6%
10
Denver, CO
74,000729,01910,150.6$13.2516
+60.6%
11
Dallas, TX
60,5001,326,0874,562.3$16.1317
+60.5%
12
Atlanta, GA
60,500520,07011,633$20.1418
+70.9%
13
Philadelphia, PA
49,5001,573,9163,145$26.5816
+39.8%
14
San Antonio, TX
49,5001,526,6563,242.4$27.9721
+96.2%
15
Portland, OR
49,500635,7497,786.1$15.3914
+71.7%
16
Minneapolis, MN
49,500428,57911,549.8$20.7516
+60.6%
17
Phoenix, AZ
40,5001,673,1642,420.6$19.3520
+96.2%
18
Charlotte, NC
40,500943,4764,292.6$19.3518
+60.5%
19
Las Vegas, NV
40,500678,9225,965.3$19.8519
+82.6%
20
Boston, MA
40,500673,4586,013.7$18.1915
+42.3%
21
Orlando, FL
33,100334,8549,884.9$23.4520
+140.3%
22
Fort Worth, TX
27,1001,008,1062,688.2$16.7017
+60.8%
23
San Jose, CA
27,100997,3682,717.2$18.2216
+110.1%
24
Columbus, OH
27,100933,2632,903.8$19.0519
+60.8%
25
Raleigh, NC
27,100499,8255,421.9$28.3415
+85.7%
26
Miami, FL
27,100487,0145,564.5$25.7522
+108.0%
27
St. Paul, MN
27,100307,4658,814$21.7018
+60.8%
28
Jacksonville, FL
22,2001,009,8332,198.4$21.7418
+127.0%
29
Baltimore, MD
22,200568,2713,906.6$19.7713
+71.5%
30
Kansas City, MO
22,200516,0324,302.1$21.5016
+61.0%
31
Tampa, FL
22,200414,5475,355.2$27.5721
+96.6%
32
Cleveland, OH
22,200365,3796,075.9$28.4815
+42.7%
33
New Orleans, LA
22,200362,7016,120.7$13.4416
+83.1%
34
Pittsburgh, PA
22,200307,6687,215.6$15.7917
+49.9%
35
St. Louis, MO
22,200279,6957,937.2$20.9717
+42.7%
36
Detroit, MI
18,100645,7052,803.1$26.3520
+51.9%
37
Milwaukee, WI
18,100563,5313,211.9$25.7617
+60.9%
38
Sacramento, CA
18,100535,7983,378.1$14.8715
+83.5%
39
Colorado Springs, CO
18,100493,5543,667.3$21.6619
+60.9%
40
Oakland, CA
18,100443,5544,080.7$15.3913
+110.4%
41
Cincinnati, OH
18,100314,9155,747.6$17.1515
+49.7%
42
Scottsdale, AZ
18,100246,1707,352.6$28.0024
+137.5%
43
Salt Lake City, UT
18,100217,7838,311$14.9218
+71.5%
44
Oklahoma City, OK
14,800712,9192,076$12.4015
+60.6%
45
Albuquerque, NM
14,800560,3262,641.3$31.3716
+85.5%
46
Tucson, AZ
14,800554,0132,671.4$13.9816
+155.2%
47
Long Beach, CA
14,800450,9013,282.3$14.6111
+96.3%
48
Durham, NC
14,800301,8704,902.8$40.2614
+85.5%
49
Plano, TX
14,800293,2865,046.3$23.8522
+60.6%
50
Madison, WI
14,800285,3005,187.5$16.4114
+51.5%

The overserved and the underserved

The most useful ranking in this study is not raw volume. It is the blend of per-capita demand, lower advertiser competition, and positive 12-month momentum. That is the closest we can get, from search data alone, to a screening list of markets where demand may be arriving faster than supply.

Top 10 underserved proxy markets

High density, lighter competition, rising trend

1. Orlando, FL

33,100/mo · 9,884.9 per 100K · comp 20

12M trend

+140.3%

2. Tacoma, WA

12,100/mo · 5,302.3 per 100K · comp 13

12M trend

+97.0%

3. Knoxville, TN

12,100/mo · 6,088.9 per 100K · comp 13

12M trend

+85.2%

4. Scottsdale, AZ

18,100/mo · 7,352.6 per 100K · comp 24

12M trend

+137.5%

5. Lakewood, CO

12,100/mo · 7,713.5 per 100K · comp 15

12M trend

+83.1%

6. Bellevue, WA

9,900/mo · 6,412.9 per 100K · comp 15

12M trend

+83.3%

7. Fort Lauderdale, FL

12,100/mo · 6,347 per 100K · comp 25

12M trend

+123.9%

8. Oakland, CA

18,100/mo · 4,080.7 per 100K · comp 13

12M trend

+110.4%

9. Raleigh, NC

27,100/mo · 5,421.9 per 100K · comp 15

12M trend

+85.7%

10. Miami, FL

27,100/mo · 5,564.5 per 100K · comp 22

12M trend

+108.0%

Top 10 overserved proxy markets

Large populations, weaker density, tougher competition

1. Wichita, KS

400,991 residents · 6,600/mo · 1,645.9 per 100K

Comp. index

40

2. Mesa, AZ

517,151 residents · 9,900/mo · 1,914.3 per 100K

Comp. index

22

3. Henderson, NV

350,039 residents · 5,400/mo · 1,542.7 per 100K

Comp. index

21

4. Port St. Lucie, FL

258,575 residents · 2,900/mo · 1,121.5 per 100K

Comp. index

20

5. North Las Vegas, NV

294,034 residents · 2,400/mo · 816.2 per 100K

Comp. index

18

6. Cape Coral, FL

233,025 residents · 2,900/mo · 1,244.5 per 100K

Comp. index

23

7. Gilbert, AZ

288,790 residents · 5,400/mo · 1,869.9 per 100K

Comp. index

27

8. Toledo, OH

265,638 residents · 3,600/mo · 1,355.2 per 100K

Comp. index

20

9. Phoenix, AZ

1,673,164 residents · 40,500/mo · 2,420.6 per 100K

Comp. index

20

10. Jacksonville, FL

1,009,833 residents · 22,200/mo · 2,198.4 per 100K

Comp. index

18

The underserved list should be read as an expansion screen, not a verdict. Orlando, Tacoma, Knoxville, Scottsdale, and Raleigh all combine strong demand density with positive trend signals. The overserved list tells a different story: large population alone is not enough. Markets like Wichita, Mesa, Henderson, and Port St. Lucie show materially lower search intensity relative to their size, which means a coffee operator would want stronger proof from rent, traffic, trade-area, or household-spend data before assuming easy demand.

The college town effect

College towns are where this dataset becomes unexpectedly fun. Franchise models often overweight population, household income, and daytime employment. Search behavior adds a different layer: student-heavy markets can punch above their weight because they generate repeat, high-frequency local intent.

The pattern is clear in the numbers. Charlottesville posts 12,062.5 searches per 100K, Boulder sits at 9,269.4, and even larger campus cities like Madison, Tempe, and Ann Arbor clear the national median by a wide margin.

University of Virginia

Charlottesville, VA

Monthly volume

5,400

Per 100K

12,062.5

Trend

+62.4%

Comp. index

13

University of Colorado Boulder

Boulder, CO

Monthly volume

9,900

Per 100K

9,269.4

Trend

+39.4%

Comp. index

17

University of North Carolina

Chapel Hill, NC

Monthly volume

5,400

Per 100K

8,433.8

Trend

+85.1%

Comp. index

12

UC Berkeley

Berkeley, CA

Monthly volume

9,900

Per 100K

8,131.5

Trend

+71.5%

Comp. index

16

University of Michigan

Ann Arbor, MI

Monthly volume

8,100

Per 100K

6,589.4

Trend

+83.3%

Comp. index

23

Arizona State University

Tempe, AZ

Monthly volume

9,900

Per 100K

5,207.4

Trend

+94.0%

Comp. index

26

University of Wisconsin-Madison

Madison, WI

Monthly volume

14,800

Per 100K

5,187.5

Trend

+51.5%

Comp. index

14

None of this proves “open beside campus and print money.” It does suggest that college towns deserve a dedicated branch in any coffee-site screening model. Their customer base resets every few years, but their habit loops do not.

DMA view: the bigger picture

City-level data is best for pinpointing where a local operator might scout next. DMA-level data is better for understanding how entire metro systems compare. New York and Los Angeles still dominate on raw metro demand, but the rank gaps are where the insight lives: Phoenix, Austin, Denver, Dallas-Fort Worth, and Seattle-Tacoma all outperform their DMA size rank.

Vol. RankDMAMonthly VolumeDMA Size RankRank DeltaAvg CPC
1New York, NY550,00010$15.67
2Los Angeles, CA450,00020$17.96
3San Francisco-Oakland-San Jose, CA301,0005+2$16.47
4Chicago, IL246,0003-1$16.62
5Dallas-Fort Worth, TX246,0008+3$18.06
6Boston, MA201,00060$17.88
7Washington, DC201,00070$19.12
8Houston, TX201,00010+2$17.10
9Seattle-Tacoma, WA201,00012+3$14.28
10Denver, CO201,00016+6$17.05
11Philadelphia, PA165,0004-7$22.22
12Atlanta, GA165,0009-3$20.56
13Minneapolis-St. Paul, MN135,00014+1$21.39
14Austin, TX135,00029+15$15.72
15Phoenix, AZ135,00050+35$21.20
16Tampa-St. Petersburg, FL110,00013-3$24.63
17Orlando-Daytona Beach, FL110,000170$21.32
18Portland, OR110,00020+2$16.77
19Detroit, MI90,50011-8$22.45
20Miami-Fort Lauderdale, FL90,50015-5$28.61

Punching above weight

Phoenix, AZ

Size rank 50, volume rank 15, delta +35

135,000/mo · +125.9% trend · $21.20 CPC

Austin, TX

Size rank 29, volume rank 14, delta +15

135,000/mo · +82.4% trend · $15.72 CPC

Denver, CO

Size rank 16, volume rank 10, delta +6

201,000/mo · +70.5% trend · $17.05 CPC

Dallas-Fort Worth, TX

Size rank 8, volume rank 5, delta +3

246,000/mo · +82.3% trend · $18.06 CPC

Seattle-Tacoma, WA

Size rank 12, volume rank 9, delta +3

201,000/mo · +70.5% trend · $14.28 CPC

San Francisco-Oakland-San Jose, CA

Size rank 5, volume rank 3, delta +2

301,000/mo · +96.0% trend · $16.47 CPC

What this means

Search demand is not the final answer. It is the cheapest useful first question.

That is the real takeaway from this project. Search volume cannot tell you rent, labor pressure, parking, drive-thru viability, or whether a neighborhood is already saturated with great independents. It can tell you where people are actively raising their hands.

If you are screening expansion markets, that matters. Large chains pay for location intelligence because intent usually shows up before revenue does. We collected this dataset with Sextaris, which lets you check a keyword across Google Ads geographic units without stitching dozens or hundreds of manual lookups together.

Questions I get about this dataset

Real questions from coffee operators, retail site-selection teams, and local-business researchers.

Why measure "coffee shop near me" instead of asking people directly?+

Survey data is sticky and slow. "Coffee shop near me" is what people type when they actually want coffee right now — Google Ads search volume per market is a direct read of that intent. We measured it across 1,000 US cities so per-capita demand falls out cleanly.

How did you normalize for population?+

Each city volume is divided by 2024 Census population estimates, expressed as searches per 100,000 residents. That removes "Houston is just bigger than Asheville" from the comparison and surfaces actual demand intensity.

What does "demand outpaces supply" actually mean here?+

A city qualifies as underserved when per-capita "coffee shop near me" volume sits well above its DMA median while total establishment count (from Census CBP) sits below. That gap signals an opportunity to open or expand, not just a thirsty population.

Why college towns dominate the leaderboards?+

Students search differently from commuters. College towns concentrate young, mobile-first, third-place-seeking populations — and they tend to have smaller resident bases, which inflates per-capita numbers. Both real and structural; we flag them separately so you can filter.

How current is the volume data?+

Google Ads monthly search volume is pulled in the month before publication. Census population estimates are the latest annual release. Both refresh on different cadences; the article footer records the exact data dates.

Can I get the per-city data?+

The table above lists all 1,000 cities with volume, per-capita rate, DMA, and establishment count. A downloadable CSV is on the roadmap; until then the section is screen-scrape-friendly into Sheets.

Run your own 1,000-city demand map — on your keyword

This workflow was built in Sextaris: one keyword, every US city geo target, population-normalized, in a single pass. One credit, one minute.

Share this research

Methodology and limitations

We used the keyword “coffee shop near me” and queried live Google Ads historical metrics across 1,000 US cities matched to Google Ads city geo targets. Population denominators come from the U.S. Census Bureau City and Town Population Totals: 2020-2024 dataset, and map coordinates come from the U.S. Census Gazetteer Files 2024. The working pull for this article was generated on April 10, 2026.

“Volume per 100K” is the central normalization. It converts raw demand into a city-size-adjusted signal. Competition index is an advertiser metric from Google Ads. It is useful, but it is not a direct measure of how many physical coffee shops already exist in a market.

That means this article should be read as a screening tool, not a full market study. It identifies places worth researching further. It does not recommend guaranteed winners, and it absolutely does not replace lease underwriting, trade-area analysis, or local due diligence.

One more caveat: municipal boundaries can distort per-capita readings for cities with unusually small or unusually commercialized boundaries. That is why we include both city-level and DMA-level views. The city cut is ideal for finding spikes. The DMA cut helps put those spikes back into metro context.