CES 2026 Pre-Audit Report — Execution Roadmap (1-Pager)
Purpose
Build the CES 2026 – February Pre-Audit Report (and later the CES 2026 – Audit report) by creating each table/section as a discrete deliverable, using Maritz/CSI source logic and validating against pace and historical comparisons where applicable.
Approach: How to Build This Report
| Phase | Focus | Key Actions |
|---|---|---|
| 1. Foundation | Source alignment & core metrics | Map Maritz/CSI logic from report_config.csv to warehouse; build Total Attendance, Total Registration, Pre-show %, On-Site; validate with pace_report.csv (Pace → Pre-Audit deltas). |
| 2. Attendance breakdowns | Geography & segments | Build Attendance by Region, Top 20 Countries; then Product Categories, Industry Rankings (Fortune 500, Interbrand, Retail Focus). |
| 3. Industry profile | Demographics & behavior | Build Primary Business, Primary Business Other, Departments, Buying Influence, Customer Base, Company Revenue, Senior-Level Executive tables. |
| 4. Media | Media-specific tables | Build Media by Geography, Media by Function, Top Tier Outlets, Unveiled Vegas and Tech Trends to Watch event attendance. |
| 5. Exhibitor & membership | Exhibitor & CTA member | Build Footprint by Geography, Exhibitor by Contract Country, Unveiled LV Exhibitors, Exhibitor by Membership; then Member Company/Personnel, Executive Club, LIT. |
| 6. Conferences & products | Conferences & add-ons | Build Speakers, Conference Sessions, Trends Report Sold; run YoY and historical checks using report.csv where applicable. |
Data sources (from report_config.csv):
- Maritz and CSI logic define which registration types, codes, and attributes feed each metric (e.g. ATT, ATTO, MEDIA, EX, EP; Show Item Codes; PRIMFUNCTION; PRODCAT; INDJOB; MEDFUNC).
Rules: ExcludeINDJOB='ST01'; exclude cancelled records; unique exception for CES 2023–2025: include declined payment records verified onsite (including chargeback-verified).
Validation:
- Compare Pre-Audit to Pace using
pace_report.csv(International/Domestic/Total and deltas). - Compare to historical using
report.csv(CES 2015–2026 Pre-Audit results, percentage changes).
dbt Models to Build (1 model per set of tasks)
One model can serve multiple report tasks when they share the same grain and filters. Below: one row per dbt model, with the task numbers it feeds. Build these report models (and any staging they depend on) so each report table is either a direct query from the model or a simple aggregation/view on top of it.
| dbt Model | Serves Tasks | Grain / Purpose |
|---|---|---|
stg_ces_registration (or equivalent staging) | — | One row per registration/attendee; reg type (ATT, ATTO, MEDIA, EX, EP), geography, year, cancelled flag, INDJOB, on-site vs pre-show, etc. Base for all attendance/registration report models. Exclude INDJOB=‘ST01’, exclude cancelled; apply onsite exception for 2023–2025 where needed. |
rpt_ces_attendance_registration_overview | 1, 2, 3, 4 | By ces_year and registration_type (Industry / Exhibitor Personnel / Media): confirmed attendance counts (Task 1), completed registration counts (Task 2). Task 3 = calculated % from 1 & 2. Task 4 = same grain filtered to on-site only. One model with metrics (attendance_count, registration_count, is_onsite) supports all four. |
rpt_ces_attendance_by_geography | 5, 6 | By ces_year, region (and country for top 20): attendance counts, % of total, number of countries. Task 5 = region + domestic/international summary; Task 6 = top 20 countries ranked. |
rpt_ces_attendance_by_product_category | 7 | By ces_year, product_category: count of Media + Industry attendees, % of total. Supports “Media and Industry Attendance by Product Categories of Interest.” |
rpt_ces_industry_rankings | 8, 9, 10 | By ces_year and ranking_type (Fortune 500 / Interbrand / Retail Focus): distinct company count in attendance. One model with ranking_type + join to list seeds (or external list) can feed all three report tables. |
rpt_ces_industry_demographics | 11, 12, 13, 14, 15, 16, 17 | One row per industry attendee (or per attendee with reg type Industry) by ces_year, with attributes: primary_business, primary_business_other, department, buying_influence, customer_base, company_revenue_band, job_function (for senior-level). Single wide report model; report tables 11–17 are aggregations by the relevant dimension (e.g. group by primary_business for Task 11, by department for Task 13). Task 12 = filter to “Other” and group by primary_business_other label. |
rpt_ces_media | 18, 19, 20, 21, 22 | By ces_year, Media subset: geography (Task 18), media_function (Task 19), top_tier_outlet / top_tier_analyst flags (Task 20), event flags (Unveiled Vegas, Tech Trends to Watch) for Tasks 21–22. One report model with these attributes; each report table = aggregate by the right dimension or filter. |
rpt_ces_exhibitor | 23, 24, 25, 26 | By ces_year, exhibitor/company: footprint (SF), contract_country, country_hq, region, unveiled_lv (and main_floor / eureka_park if applicable), prior_year_membership_type. Tasks 23–26 = aggregates by geography, contract country, Unveiled LV by country, and membership type. |
rpt_ces_member_attendance | 27, 28, 29, 30 | By ces_year: member company (pre-show vs in-attendance, membership_type) and member personnel (count, registration_type). One model with company-level and personnel-level metrics (or two logical parts) for member company overview, by membership type, personnel overview, and personnel by reg type. |
rpt_ces_executive_club_lit | 31, 32 | By ces_year: Executive Club tier (Gold, Platinum, etc.) and LIT category (Ambassador, Senate, State, etc.). Counts per tier/category feed the two report tables. |
rpt_ces_conferences | 33, 34, 35 | By ces_year: speaker count (IsSpeaker=Y), conference session count, trends report units sold (Show Item logic; include verified declined/onsite for 2023–2025). One report model with these three metrics (or three clear columns/rows) feeds Speakers, Conference Sessions, and Trends Report Sold. |
Summary: 1 staging + 10 rpt_ models (or 11 models total) cover all 35 tasks. Report tables are either the rpt_ model itself aggregated in the BI layer or a thin aggregation (e.g. top 20 by country from rpt_ces_attendance_by_geography).
Task → Model quick reference:
| Tasks | dbt model |
|---|---|
| (base) | stg_ces_registration |
| 1, 2, 3, 4 | rpt_ces_attendance_registration_overview |
| 5, 6 | rpt_ces_attendance_by_geography |
| 7 | rpt_ces_attendance_by_product_category |
| 8, 9, 10 | rpt_ces_industry_rankings |
| 11–17 | rpt_ces_industry_demographics |
| 18–22 | rpt_ces_media |
| 23–26 | rpt_ces_exhibitor |
| 27–30 | rpt_ces_member_attendance |
| 31, 32 | rpt_ces_executive_club_lit |
| 33, 34, 35 | rpt_ces_conferences |
Task Table: All Report Tables/Tasks
| # | Task / Report Table | Location in Doc (section anchor) | Description | Data / Metrics | Source Logic (report_config / notes) |
|---|---|---|---|---|---|
| 1 | Total Attendance Overview – Confirmed Attendance in Las Vegas | #total-attendance-overview-–-confirmed-attendance-in-las-vegas (~line 89) | Confirmed attendance in Las Vegas by registration type. | Industry Attendees, Exhibitor Personnel, Media; Total Attendees; 2026, 2025, 2024. | Maritz: ATT, ATTO, MEDIA, EX, EP. CSI: same. |
| 2 | Total Registration Overview – Completed Registration | #total-registration-overview-–-completed-registration (~line 97) | Completed registrations (pre-show). | Same segments; Total Registrants; 2026, 2025, 2024. | Same reg types; completed registrations only. |
| 3 | Percentage of Pre-show Registration to Attendance (excludes on-site) | #percentage-of-pre-show-registration-to-attendance (~line 106) | Verified % of pre-show registration that attended. | Verified % by type; 2026, 2025, 2024. | Derived from Task 1 & 2; excludes on-site. |
| 4 | On-Site Registration Overview | #on-site-registration-overview (~line 116) | On-site registration counts by type. | Industry, Exhibitor, Media; Total; 2025, 2024 (2026 TBD). | On-site only; separate from pre-show. |
| 5 | Total Attendance by Region | #total-attendance-by-region (~line 125) | Domestic vs International; % of total; countries count; breakdown by region (Africa, Asia, Europe, North America, Oceania, South America). | Counts, %, number of countries; 2026, 2025, 2024. | From attendance base (Task 1) + geography. |
| 6 | Total Attendance by Top 20 Countries, Regions, and Territories | #total-attendance-by-top-20-countries (~line 149) | Ranked list of top 20 countries with attendance and % of total. | Ranking, Country, 2026 Total, 2026 %, 2025 %, 2024 %. | Same base + country/region; top 20. |
| 7 | Media and Industry Attendance by Product Categories of Interest | #media-and-industry-attendance-by-product-categories-of-interest (~line 175) | Product interest categories for Media + Industry. | Ranking, Product Category, Total, 2026/2025/2024 % of total. | Reg type ATT, ATTO (and possibly MEDIA); product category dimension. |
| 8 | Industry Rankings – Fortune 500 | #fortune-500 (~line 227) | Fortune 500 companies in attendance. | Number of Fortune 500 companies; 2026, 2025, 2024. | Subset of attendance (company list match). |
| 9 | Industry Rankings – Interbrand | #interbrand (~line 234) | Best Global Brands in attendance. | Number of Interbrand companies; 2025, 2024. | Subset of attendance (company list match). |
| 10 | Industry Rankings – Retail Focus | #retail-focus (~line 242) | Twice Top 50 Consumer Electronics Retailer count. | Number of retailers; 2025, 2024. | Subset of attendance (retail list match). |
| 11 | Industry Attendees by Primary Business | #industry-attendees-by-primary-business (~line 246) | Industry attendees by primary business. | Primary Business, 2026 Total, 2026 %, 2025 %, 2024 %. | report_config: PRIMFUNCTION (e.g. A01, A07 for Content & Advertising). |
| 12 | Primary Business Other | #primary-business-other (~line 281) | Free-text “Other” primary business; aggregated labels. | Primary Business Other, 2026 Count, 2025 Count. | Other primary business responses; grouped. |
| 13 | Industry Attendees by Departments | #industry-attendees-by-departments (~line 312) | Industry attendees by department (new question). | Department, 2026 Total, 2025 Total. | Department attribute. |
| 14 | Industry Attendees by Buying Influence | #industry-attendees-by-buying-influence (~line 341) | Buying influence (Final Decision Maker, Significant Influence, etc.). | Buying Influence, 2026 Total, 2026 %, 2025 %. | Survey/attribute. |
| 15 | Industry Attendees by Customer Base | #industry-attendees-by-customer-base (~line 351) | B2B, B2C, Both, Other. | Customer Base, 2026 Total, 2026 %, 2025 %. | Survey/attribute. |
| 16 | Industry Attendees by Company Revenue | #industry-attendees-by-company-revenue (~line 360) | Revenue bands (e.g. 100M–$1B, …); US/Canada C-Level/President/Founder. | Revenue Range, 2026 Total, 2026 %, 2025 %. | Job title + geography filter; revenue attribute. |
| 17 | Industry Attendees by Senior-Level Executive Attendance | #industry-attendees-by-senior-level-executive-attendance (~line 400) | Job function (Board, President/Founder, C-Level, VP, Director/Sr Mgr); attendance rate by job function. | Job Function counts and %; Job Function x Attendance Rate (Industry/Exhibitor/Total). | report_config: INDJOB=EX01,EX02,EX03,EX04,MA03; Reg type ATT,ATTO,EX,EXP. |
| 18 | Media by Geography | #media-by-geography (~line 432) | Domestic/International and region breakdown for Media. | 2026 Total Media, %; Region breakdown with %. | MEDIA reg type + geography. |
| 19 | Media by Function | #media-by-function (~line 453) | Media function (Print & Online, Digital Content Creator, Industry Analyst, etc.). | Media Function, 2026 Total, 2026 %, 2025 %, 2024 %. | report_config: MEDFUNC (e.g. A07=Industry Analyst, A14=Digital Content Creator). |
| 20 | Top Tier Media Outlets in Attendance | #top-tier-media-outlets-in-attendance (~line 477) | Top tier press outlets and analyst companies. | Number of Top Tier Press; Number of Top Tier Analyst; 2026, 2025, 2024. | Subset of media (outlet list match). |
| 21 | Media Event – Unveiled Vegas – Total Media Attendance | #media-event---unveiled-vegas (~line 490) | Media attendance at Unveiled Vegas. | Total Media Attendees; 2026, 2025, 2024. | Event-specific + MEDIA. |
| 22 | Media Event – Tech Trends to Watch – Total Attendance | #media-event-–-tech-trends-to-watch (~line 497) | Attendance at Tech Trends to Watch by type. | Industry, Exhibitor, Media, Total; 2026, 2025, 2024. | Event-specific + reg type. |
| 23 | Exhibitor – Footprint by Geography Comparison | #footprint-by-geography-comparison (~line 507) | Total SF, International/Domestic SF; by Region; by Country HQ with YoY change. | Total SF, International/Domestic; Region SF; Country HQ, 2026/2025/2024 SF, changes. | Exhibitor footprint/sales data; geography. |
| 24 | CES Exhibitor Company by Contract Country | #ces-exhibitor-company-by-contract-country (~line 546) | Exhibit companies by contract country. | Country, 2026 # companies, 2025 # companies. | Exhibitor contract country. |
| 25 | Unveiled Las Vegas Exhibitors by Country HQ | #unveiled-las-vegas-exhibitors-by-country-hq (~line 558) | Unveiled LV exhibitors; total and by country (Main Floor / Eureka Park). | Total exhibitors; Country, Total # companies, Main Floor, Eureka Park. | Unveiled LV exhibitor list + country HQ. |
| 26 | CES Exhibitor by 2025 Membership | #ces-exhibitor-by-2025-membership (~line 510) | Exhibit companies by prior-year membership. | 2025 Members, % of companies, % of space; Membership Type counts. | Exhibitor + membership type (Core, Industry Associate, Non-Profit). |
| 27 | Member Company Attendance Overview | #member-company-attendance-overview (~line 519) | CTA member companies pre-show vs in attendance; % in attendance. | Total member companies (pre-show); In attendance; % in attendance; 2026, 2025, 2024. | CTA member list + attendance. |
| 28 | Member Company by Projected 2026 Membership Type | #member-company-by-projected-2026-membership-type (~line 531) | By membership type: pre-show count, in attendance, % in attendance; 3-year. | Membership Type, Pre-show, In attendance, %; 2026, 2025, 2024. | Same + membership type. |
| 29 | Member Personnel Attendance Overview | #member-personnel-attendance-overview (~line 551) | CTA member personnel (including subsidiaries) in attendance. | CTA Member Personnel; 2026, 2025, 2024. | Member company personnel + attendance. |
| 30 | Member Personnel Attendance by Registration Type | #member-personnel-attendance-by-registration-type (~line 559) | Member personnel by Industry, Exhibitor, Media. | Registration Type, 2026, 2025, 2024. | Same + reg type. |
| 31 | Executive Club Attendance Overview | #executive-club-attendance-overview (~line 567) | Executive Club tiers (Gold, Platinum, Platinum Preferred Medical, Silver). | Tier, 2026, 2025, 2024. | Executive Club segment. |
| 32 | LIT Attendance Overview | #lit-attendance-overview (~line 575) | LIT categories (Ambassador, Senate, State, Staff House/Senate, Other/Agency, Members). | Category, 2026, 2025, 2024; Total. | LIT segment. |
| 33 | Speakers | #speakers (~line 587) | Number of speakers. | Number of Speakers; 2026, 2025. | report_config: IsSpeaker=Y. |
| 34 | Conference Sessions | #conference-sessions (~line 593) | Number of conference sessions. | Number of Conference Sessions; 2026, 2025. | Conference/session data. |
| 35 | Trends Report Sold through Maritz CES Registration | #trends-report-sold-through-maritz-ces-registration (~line 599) | Trends report units sold via Maritz registration. | 2026, 2025, 2024. | Show Item / product sale; *exception: include declined payment records verified onsite for 2023–2025. |
Reference: Where to Find What
| Need | Where |
|---|---|
| Full report structure & table layouts | CES 2026 Pre-Audit Report.md — Table of Contents (lines 12–87); each #section-anchor marks a table. |
| Metric definitions (Maritz vs CSI) | report_config.csv — column 1 = metric name, columns 2–3 = Maritz and CSI logic (reg types, codes, PRIMFUNCTION, PRODCAT, INDJOB, MEDFUNC, Show Item codes). |
| Pace → Pre-Audit comparison | pace_report.csv — International/Domestic/Total for 2026/2025/2024 Pace and “Change from Pace to Pre-Audit.” |
| Historical Pre-Audit & YoY % | report.csv — CES 2015–2026 Pre-Audit results; International/Domestic/Total and percentage change by year. |
| Global rules | report_config.csv bottom: exclude INDJOB=‘ST01’; exclude cancelled; CES 2023–2025 include declined payment records verified onsite (incl. chargebacks). |
Suggested Order of Implementation (by dependency)
- Core metrics (1–4) → needed for % and for pace/historical checks.
- Geography (5–6) → only need attendance + geography.
- Product categories & rankings (7–10) → need attendance + product/company lists.
- Industry demographics (11–17) → need industry subset + attributes.
- Media (18–22) → need MEDIA subset + event flags.
- Exhibitor & footprint (23–26) → need exhibitor/contract data.
- Membership (27–30) → need member company/personnel + attendance.
- Executive Club & LIT (31–32) → need segment flags.
- Conferences & products (33–35) → need speaker/session and show-item data.
This one-pager plus the task table give a single place to track “what to build,” “where it is in the doc,” “what data it uses,” and “where the logic lives.”