Field reference: US Franchise Dealer Group Mapping
Column-by-column description of the US Franchise Dealer Group Mapping CSV.
The file has one row per group-owned rooftop.
| Column | Description |
|---|---|
| DealerName | Rooftop name. |
| Address, City, State, Zip | Physical dealership address. |
| Website | Primary dealer website URL. |
| Makes | Comma-separated brands sold at this rooftop. |
| GroupName | The dealer group that owns the rooftop. |
| SuperGroupName | The parent group, where the owning group is itself part of a larger holding. Blank otherwise. |
Tips
- Group size. Count rows per
GroupName(orSuperGroupNamefor consolidated holdings). - Buy/sell activity. Compare
Website→GroupNamebetween this month’s and last month’s files. A rooftop whose group changed was sold; a newWebsiteis an acquisition or new point. - Enriching your CRM. Match on
Websiteor on address, then writeGroupNameto the account record so reps know who makes the decision.
Download the Georgia sample to see the layout.
