Digital Ad Impression Counts
This dataset provides granular counts of digital ad impressions across multiple channels, campaigns, and placements, with additional context such as device type and geographic location. It enables marketers and analysts to optimize ad spend, measure reach, and compare performance across platforms and regions. The structured format supports robust reporting, attribution modeling, and campaign effectiveness analysis.
Sample rows
preview · 8 of 82 rows · all 11 columns| impression_idstring | device_typestring | impression_countinteger | campaign_idstring | ad_idstring | channelstring | placementstring | impression_datedate | countrystring | regionstring | citystring |
|---|---|---|---|---|---|---|---|---|---|---|
| a7F9cG2v-12Bd | Mobile | 543 | CMP202402 | AD1001 | Feed | 2024-04-07 | US | CA | Los Angeles | |
| R8xR2t7s-6QWk | Mobile | 210 | CMP202402 | AD1002 | Stories | 2024-04-08 | US | NY | New York | |
| Q2k9h3Zc-4Ln6 | Desktop | 325 | CMP202405 | AD1003 | Search Results | 2024-04-09 | GB | ENG | London | |
| B7z1Q8jD-1xVw | Desktop | 89 | CMP202403 | AD1004 | Sidebar | 2024-04-07 | CA | ON | Toronto | |
| Jk3M1z2P-8HsW | Tablet | 134 | CMP202405 | AD1005 | Website | Banner | 2024-04-10 | AU | NSW | Sydney |
| Zx91hL8b-5nQy | Mobile | 67 | CMP202406 | AD1006 | Feed | 2024-04-11 | US | TX | Houston | |
| V7b2N8sP-3qWz | Mobile | 156 | CMP202403 | AD1001 | Stories | 2024-04-10 | FR | IDF | Paris | |
| M2p9K4aV-6wTy | Desktop | 412 | CMP202404 | AD1007 | YouTube | In-Stream | 2024-04-08 | IN | MH | Mumbai |
| L8q7T3fU-1zXm | Mobile | 237 | CMP202404 | AD1008 | Feed | 2024-04-07 | US | FL | Miami | |
| P4d6E2cS-9vLk | Desktop | 93 | CMP202407 | AD1009 | Other | News Portal | 2024-04-09 | DE | BE | Berlin |
| T1f8G5yJ-7cPz | Tablet | 301 | CMP202402 | AD1002 | Display Network | 2024-04-11 | US | CA | San Francisco | |
| S6r2X1uD-4aQb | Mobile | 481 | CMP202404 | AD1010 | Feed | 2024-04-10 | ZA | GP | Johannesburg | |
| Y9h6M7pR-5tLc | Desktop | 77 | CMP202406 | AD1011 | Website | Sidebar | 2024-04-08 | JP | 13 | Tokyo |
| W8e3H2kN-2vSc | Mobile | 54 | CMP202405 | AD1003 | Feed | 2024-04-11 | BR | SP | São Paulo | |
| F5b7J3qR-8zMw | Desktop | 98 | CMP202407 | AD1009 | Feed | 2024-04-09 | US | IL | Chicago | |
| U1m6D5xZ-3wQk | Desktop | 405 | CMP202403 | AD1012 | Search Results | 2024-04-10 | US | MA | Boston | |
| N6k9Q2lV-7zHd | Mobile | 191 | CMP202404 | AD1013 | Stories | 2024-04-08 | IT | LAZ | Rome | |
| K3r7C8wS-9xLj | Desktop | 49 | CMP202405 | AD1007 | Sidebar | 2024-04-07 | DE | BW | Stuttgart | |
| C8t4A5gP-2qNd | Mobile | 367 | CMP202406 | AD1011 | YouTube | In-Stream | 2024-04-09 | US | WA | Seattle |
| D9y2U3oF-1pWb | Tablet | 141 | CMP202407 | AD1008 | Website | Banner | 2024-04-07 | GB | SCT | Glasgow |
What the 82 rows show
from the 82-row sample- 90.5median impression_
count - 8channels
- 18countries
- 21placements
Median 90.5, from 19 to 543.
- string 9
- integer 1
- date 1
Columns
11 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
impression_id | string | Unique identifier for each ad impression recordunique | a7F9cG2v-12Bd |
campaign_id | string | Identifier for the advertising campaign associated with the impression | CMP202402 |
ad_id | string | Unique identifier for the specific ad creative shown | AD1001 |
channel | string | The digital channel where the impression occurred (e.g., Facebook, Google, Instagram, Website)8 values | |
placement | string | Specific ad placement within the channel (e.g., Feed, Sidebar, Stories, Search Results)optional | Feed |
device_type | string | Type of device on which the ad was displayed (e.g., Mobile, Desktop, Tablet)Mobile · Desktop · Tablet · Other · optional | Mobile |
country | string | Country where the impression was served (ISO 3166-1 alpha-2 code)optional | US |
region | string | Region or state within the country where the impression was servedoptional | CA |
city | string | City where the impression was servedoptional | Los Angeles |
| Numbers 1 column | |||
impression_count | integer | Number of impressions recorded for this ad in the given context1 or more | 543 |
| Dates and times 1 column | |||
impression_date | date | Date when the impressions were recorded | 2024-04-07 |
Use it for
A marketing dashboard
Impression_
count by device_ type and a breakdown of campaign_ id. Excel, Power BI or Tableau. What pattern can you find in 82 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 82 rows.
- Impressions82a7F9cG2v-12Bd543MobileR8xR2t7s-6QWk210MobileQ2k9h3Zc-4Ln6325Desktop
A software demo
Believable impressions with campaign_
id, ad_ id and channel to fill a screen in front of a buyer.
blueprint · digital-ad-impression-counts
Behind this dataset
Same schema. As many rows as you need.
These 82 rows came out of a blueprint — 11 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Log impression count per channel daily
- Aggregate by campaign and ad format
- Flag impressions below target thresholds
- Calculate cost per thousand impressions (CPM)
- Summarize weekly totals
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- digital-ad-impression-counts