M-Marketing · YouTube Performance

McNeill Stores — YouTube, 13 Markets

← Portfolio overview

2026-07-28 to 2026-08-28 · 30 days · Google Ads account 480-063-0074. Built directly from BigQuery on 2026-08-31; no manual export in the loop.

Investment
$51,452
$1,715/day average
Impressions
5.02M
$10.24 CPM
Completed views
4.35M
86.54% watched to the end
Cost / 1k completed
$11.83
the portfolio benchmark
Clicks
2,183
0.043% CTR
Markets
13
over 30 days

01Market performance

The fair way to compare 13 markets running the same creative on the same bid strategy is cost per 1,000 completed views — it folds CPM and completion rate into one number, so a market that buys cheap impressions people abandon gets no credit for it. Portfolio average is $11.83; Lexington is the most efficient, Gainesville the least, a 28% spread.

portfolio avg $11.83Lexington$10.06Louisville$10.40Columbus$10.87Detroit$11.47Fort Wayne$11.48Evansville$11.78Bowling Green$11.97Tallahassee$12.09South Bend$12.55Grand Rapids$12.67Toledo$12.75Lansing$12.80Gainesville$12.83
MarketBudget/daySpend Impr.CPMCompl. CompletedCost/1k compl.Index
Lexington$50.00$1,660190,413$8.7286.67%165,030$10.0685
Louisville$100.00$3,320368,468$9.0186.61%319,112$10.4088
Columbus$150.00$4,980518,394$9.6188.40%458,274$10.8792
Detroit$300.00$9,960985,833$10.1088.08%868,274$11.4797
Fort Wayne$75.00$2,490257,471$9.6784.22%216,836$11.4897
Evansville$75.00$2,490251,691$9.8983.98%211,365$11.78100
Bowling Green$50.00$1,660161,316$10.2985.98%138,704$11.97101
Tallahassee$75.00$2,490239,990$10.3885.81%205,924$12.09102
South Bend$125.00$4,150389,912$10.6484.79%330,608$12.55106
Grand Rapids$250.00$8,296755,058$10.9986.72%654,807$12.67107
Toledo$150.00$4,978455,044$10.9485.81%390,481$12.75108
Lansing$100.00$3,318297,762$11.1487.07%259,270$12.80108
Gainesville$50.00$1,660152,990$10.8584.54%129,335$12.83108

02When the ads ran

No ad schedule is set on any campaign, so delivery follows raw YouTube supply. The overnight block runs 17.0% of impressions for 15.7% of spend — 4,458,894 impressions costing $21,464, in the hours when a connected TV screen is most likely to be running unattended.

036912151821MonMonday 00:00 — 5,110 impressions/dayMonday 01:00 — 4,599 impressions/dayMonday 02:00 — 3,709 impressions/dayMonday 03:00 — 4,219 impressions/dayMonday 04:00 — 2,407 impressions/dayMonday 05:00 — 1,625 impressions/dayMonday 06:00 — 1,412 impressions/dayMonday 07:00 — 1,426 impressions/dayMonday 08:00 — 1,529 impressions/dayMonday 09:00 — 1,596 impressions/dayMonday 10:00 — 1,651 impressions/dayMonday 11:00 — 1,936 impressions/dayMonday 12:00 — 2,365 impressions/dayMonday 13:00 — 2,949 impressions/dayMonday 14:00 — 3,770 impressions/dayMonday 15:00 — 4,117 impressions/dayMonday 16:00 — 5,317 impressions/dayMonday 17:00 — 7,120 impressions/dayMonday 18:00 — 9,668 impressions/dayMonday 19:00 — 12,003 impressions/dayMonday 20:00 — 14,633 impressions/dayMonday 21:00 — 12,469 impressions/dayMonday 22:00 — 14,893 impressions/dayMonday 23:00 — 7,679 impressions/dayTueTuesday 00:00 — 4,200 impressions/dayTuesday 01:00 — 3,686 impressions/dayTuesday 02:00 — 5,139 impressions/dayTuesday 03:00 — 4,801 impressions/dayTuesday 04:00 — 3,476 impressions/dayTuesday 05:00 — 2,130 impressions/dayTuesday 06:00 — 1,273 impressions/dayTuesday 07:00 — 1,433 impressions/dayTuesday 08:00 — 1,294 impressions/dayTuesday 09:00 — 1,372 impressions/dayTuesday 10:00 — 1,492 impressions/dayTuesday 11:00 — 1,777 impressions/dayTuesday 12:00 — 2,162 impressions/dayTuesday 13:00 — 2,554 impressions/dayTuesday 14:00 — 2,832 impressions/dayTuesday 15:00 — 3,187 impressions/dayTuesday 16:00 — 3,730 impressions/dayTuesday 17:00 — 4,684 impressions/dayTuesday 18:00 — 7,470 impressions/dayTuesday 19:00 — 8,006 impressions/dayTuesday 20:00 — 8,708 impressions/dayTuesday 21:00 — 9,471 impressions/dayTuesday 22:00 — 9,589 impressions/dayTuesday 23:00 — 5,794 impressions/dayWedWednesday 00:00 — 6,691 impressions/dayWednesday 01:00 — 4,790 impressions/dayWednesday 02:00 — 5,808 impressions/dayWednesday 03:00 — 4,609 impressions/dayWednesday 04:00 — 2,474 impressions/dayWednesday 05:00 — 1,673 impressions/dayWednesday 06:00 — 1,341 impressions/dayWednesday 07:00 — 1,345 impressions/dayWednesday 08:00 — 1,271 impressions/dayWednesday 09:00 — 1,285 impressions/dayWednesday 10:00 — 1,469 impressions/dayWednesday 11:00 — 1,700 impressions/dayWednesday 12:00 — 2,143 impressions/dayWednesday 13:00 — 2,915 impressions/dayWednesday 14:00 — 3,150 impressions/dayWednesday 15:00 — 3,698 impressions/dayWednesday 16:00 — 3,936 impressions/dayWednesday 17:00 — 4,655 impressions/dayWednesday 18:00 — 7,370 impressions/dayWednesday 19:00 — 6,810 impressions/dayWednesday 20:00 — 8,056 impressions/dayWednesday 21:00 — 9,576 impressions/dayWednesday 22:00 — 9,503 impressions/dayWednesday 23:00 — 4,630 impressions/dayThuThursday 00:00 — 5,406 impressions/dayThursday 01:00 — 4,913 impressions/dayThursday 02:00 — 6,239 impressions/dayThursday 03:00 — 6,056 impressions/dayThursday 04:00 — 2,960 impressions/dayThursday 05:00 — 2,137 impressions/dayThursday 06:00 — 1,978 impressions/dayThursday 07:00 — 1,664 impressions/dayThursday 08:00 — 1,604 impressions/dayThursday 09:00 — 1,666 impressions/dayThursday 10:00 — 1,726 impressions/dayThursday 11:00 — 2,001 impressions/dayThursday 12:00 — 2,411 impressions/dayThursday 13:00 — 2,803 impressions/dayThursday 14:00 — 2,577 impressions/dayThursday 15:00 — 3,085 impressions/dayThursday 16:00 — 4,380 impressions/dayThursday 17:00 — 5,248 impressions/dayThursday 18:00 — 6,992 impressions/dayThursday 19:00 — 7,130 impressions/dayThursday 20:00 — 8,020 impressions/dayThursday 21:00 — 7,572 impressions/dayThursday 22:00 — 8,398 impressions/dayThursday 23:00 — 4,863 impressions/dayFriFriday 00:00 — 5,512 impressions/dayFriday 01:00 — 6,767 impressions/dayFriday 02:00 — 4,820 impressions/dayFriday 03:00 — 3,772 impressions/dayFriday 04:00 — 3,186 impressions/dayFriday 05:00 — 1,840 impressions/dayFriday 06:00 — 1,636 impressions/dayFriday 07:00 — 1,794 impressions/dayFriday 08:00 — 1,736 impressions/dayFriday 09:00 — 1,793 impressions/dayFriday 10:00 — 2,058 impressions/dayFriday 11:00 — 2,912 impressions/dayFriday 12:00 — 2,560 impressions/dayFriday 13:00 — 2,728 impressions/dayFriday 14:00 — 2,897 impressions/dayFriday 15:00 — 3,168 impressions/dayFriday 16:00 — 3,579 impressions/dayFriday 17:00 — 4,193 impressions/dayFriday 18:00 — 5,497 impressions/dayFriday 19:00 — 7,358 impressions/dayFriday 20:00 — 9,390 impressions/dayFriday 21:00 — 9,756 impressions/dayFriday 22:00 — 10,108 impressions/dayFriday 23:00 — 4,546 impressions/daySatSaturday 00:00 — 5,999 impressions/daySaturday 01:00 — 4,323 impressions/daySaturday 02:00 — 3,984 impressions/daySaturday 03:00 — 3,631 impressions/daySaturday 04:00 — 4,459 impressions/daySaturday 05:00 — 2,771 impressions/daySaturday 06:00 — 1,927 impressions/daySaturday 07:00 — 1,845 impressions/daySaturday 08:00 — 1,822 impressions/daySaturday 09:00 — 1,950 impressions/daySaturday 10:00 — 1,845 impressions/daySaturday 11:00 — 2,078 impressions/daySaturday 12:00 — 2,247 impressions/daySaturday 13:00 — 2,395 impressions/daySaturday 14:00 — 2,502 impressions/daySaturday 15:00 — 2,902 impressions/daySaturday 16:00 — 2,960 impressions/daySaturday 17:00 — 3,223 impressions/daySaturday 18:00 — 3,653 impressions/daySaturday 19:00 — 3,830 impressions/daySaturday 20:00 — 4,082 impressions/daySaturday 21:00 — 4,413 impressions/daySaturday 22:00 — 4,752 impressions/daySaturday 23:00 — 3,392 impressions/daySunSunday 00:00 — 4,722 impressions/daySunday 01:00 — 4,008 impressions/daySunday 02:00 — 5,150 impressions/daySunday 03:00 — 3,640 impressions/daySunday 04:00 — 3,542 impressions/daySunday 05:00 — 3,339 impressions/daySunday 06:00 — 2,136 impressions/daySunday 07:00 — 2,138 impressions/daySunday 08:00 — 1,934 impressions/daySunday 09:00 — 2,034 impressions/daySunday 10:00 — 2,126 impressions/daySunday 11:00 — 2,196 impressions/daySunday 12:00 — 2,242 impressions/daySunday 13:00 — 2,448 impressions/daySunday 14:00 — 2,490 impressions/daySunday 15:00 — 2,773 impressions/daySunday 16:00 — 3,287 impressions/daySunday 17:00 — 3,367 impressions/daySunday 18:00 — 3,704 impressions/daySunday 19:00 — 4,012 impressions/daySunday 20:00 — 4,000 impressions/daySunday 21:00 — 4,084 impressions/daySunday 22:00 — 4,106 impressions/daySunday 23:00 — 3,296 impressions/dayorange = midnight to 6am

03Screens and formats

Creative length is derived from the video duration on each asset. The two cuts buy materially different inventory at materially different prices.

FormatCreativesImpressions SpendCPMShare of spend
15-second269,556,242$87,246$9.13169.6%
30-second393,322,580$48,763$14.6894.8%

04What this report does not cover

Three things in the original July report have no BigQuery source. They are omitted rather than estimated:

  • Reach, frequency, co-viewed impressions. The transfer carries no reach metrics of any kind. These were Google modelled estimates in the original report and have no BigQuery equivalent.
  • Channel-level placements. Every Placement table in the dataset is empty. The transfer exposes only managed placements; automatic YouTube placements are not included at any setting.
  • Change history. Budget edits and pause events come from the Ads API change_event resource, which the transfer does not replicate. Daily budget levels below are inferred from the campaign snapshots instead.