↖︎ Vishal Singh

Advertising market dashboard

Industry Ad Spend Explorer

A 2018-2022 view of monthly advertising spend by industry, advertiser, and media group. The page is built to ask what changed through the Covid shock and how budgets reallocated afterward.

Source-backed DuckDB over Tigris parquet

Monitor

Monthly spend by media group

Players

Top advertisers

Click a row to update the advertiser trend.

Advertiser detail

Advertiser trend

Covid lens

Advertiser movers

Dollar change from 2019 to 2020; advertisers with at least $1M in one compared year.

Lookup

Advertiser table

Aggregated across product rows. Brand examples show the largest brands for the selected advertiser.

Advertiser Spend Share 2020 vs 2019 Digital Brands
Source and caveat. Data is read from https://vishal.t3.tigrisfiles.io/sqlroom/Ad_data.parquet and aggregated with DuckDB. The dashboard excludes Jan-Jun 2023 so the default comparison ends at the last complete calendar year, Dec 2022. Rows are closer to month + product + media group than month + advertiser + media group, so advertiser views sum across product-level rows.