Field reference: Dealer Tech Vendor Reports & Data
Column-by-column description of the Dealer Tech Vendor Reports & Data CSV.
The file has one row per dealer website × vendor detected. A dealer running a website provider, a digital retailer, and a chat tool appears on three rows.
| Column | Description |
|---|---|
| Date Observed | The date the vendor was observed on the site, formatted like February 14, 2026. |
| Dealer Name | Dealer name as shown on the website. |
| Address, City, State, Zip | Physical dealership address. |
| Website | Primary dealer website URL. |
| Category | Franchise or Independent. |
| Makes | Comma-separated list of brands sold, e.g. Chrysler, Dodge, Jeep, Ram. |
| Latitude, Longitude | Geocoded location, formatted like 36.698° N / 82.007° W. |
| Vendor Unique ID | Stable identifier for the vendor, e.g. w_dealeron. Use this for joins; vendor names occasionally change. |
| Vendor Name | Display name of the vendor. |
| Vendor Type | Category of product: website, digital retail, chat, trade-in, service scheduling, and others. |
Tips
- Join key. Use
Website(normalized to lower case, no trailing slash) to join across months and to our US Franchise Dealer Group Mapping file. - Market share. Count distinct
Websitevalues grouped byVendor Namewithin aVendor Type. - Switching. Compare this month’s file to last month’s for the same
WebsiteandVendor Type; a changedVendor Unique IDis a switch. - Column headers. Headers in the raw export are prefixed with their source table (
Dealers → Dealer Name). Most tools accept them as-is; strip the prefix if yours doesn’t.
Download the Virginia sample to see the layout.
