✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-05
Automotive dealerships collect customer ratings for vehicles, service quality, and overall experience. AggregateRating schema displays average star ratings in Google Search results. Converting CSV review data to structured rating markup provides visual indicators of customer satisfaction for dealerships and vehicle models.
The Problem
Customer rating data in CSV format includes individual scores, rating counts, and review statistics without AggregateRating schema. Dealership reputation depends on visible star ratings in local search results. Manual calculation of average ratings and conversion to schema markup is necessary when aggregating reviews from multiple sources including DealerRater, Google Reviews, and internal feedback systems across hundreds of customer responses. Schema.org AggregateRating Specification
How to Fix It
1
Upload Review and Rating CSV
Import rating data including individual scores (1-5 stars), review counts, and subject (vehicle, dealership, service). System calculates aggregate statistics automatically.
2
Calculate Aggregate Statistics
Average rating, total review count, and rating distribution are computed. Values are validated against schema.org constraints (ratingValue between bestRating and worstRating).
3
Map to AggregateRating Properties
Link calculated statistics to AggregateRating fields. Rating value populates ratingValue, count populates ratingCount, and scale populates bestRating/worstRating.
4
Link to Rated Subject
Connect AggregateRating to the rated item (Vehicle Product, AutoDealer LocalBusiness, or Service). Use the aggregateRating property on the subject schema.
5
Export AggregateRating JSON-LD
Download JSON-LD markup for insertion into product or business pages. Schema displays star ratings in search results when implemented correctly.
Frequently Asked Questions
Can I combine ratings from multiple review platforms?
Yes, aggregate ratings from all sources (Google, DealerRater, internal surveys) into a single AggregateRating. Ensure you maintain the source data separately and update the aggregate when new reviews are added.
What rating scale should I use for automotive reviews?
Most automotive review platforms use a 5-star scale. Set bestRating to 5 and worstRating to 1 in the schema. The ratingValue should be the average of all reviews on this scale.
Do I need both Review and AggregateRating schema?
Use AggregateRating for the summary statistics displayed in search results. Optionally include individual Review schema entries for specific customer testimonials. The AggregateRating goes on the Product or LocalBusiness, while Review entries can be listed separately.
Example: Input → Output
name
email
phone
city
status
Alice Johnson
alice@example.com
+1-555-0101
New York
active
alice johnson
ALICE@EXAMPLE.COM
5550101
new york
Active
Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.