How-to / Using the data

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 (or SuperGroupName for consolidated holdings).
  • Buy/sell activity. Compare Website → GroupName between this month’s and last month’s files. A rooftop whose group changed was sold; a new Website is an acquisition or new point.
  • Enriching your CRM. Match on Website or on address, then write GroupName to the account record so reps know who makes the decision.

Download the Georgia sample to see the layout.

Last updated October 27, 2026