Transform Auto Repair Reviews into AggregateRating Schema
✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-05
Auto repair shops with customer review data need AggregateRating schema to display average star ratings in search results and business listings. Converting review statistics from spreadsheets into JSON-LD format enables search engines to show rating summaries, review counts, and best/worst rating ranges in local business profiles and knowledge panels.
The Problem
Auto repair businesses track customer satisfaction metrics across platforms without implementing AggregateRating schema markup, limiting star rating display in search results. Review statistics including average ratings, total review counts, and rating distributions require structured data for knowledge panel and local pack features. Manual calculation and schema creation for aggregate statistics across multiple review sources is time-consuming. AggregateRating - Schema.org
How to Fix It
1
Calculate Review Statistics
Compile review data from all sources (Google, Yelp, Facebook, website) into spreadsheet. Calculate average ratingValue (mean of all ratings), count ratingCount (total number of ratings submitted), and reviewCount (number of written reviews). Note bestRating (typically 5) and worstRating (typically 1).
2
Upload Rating Statistics
Import your auto repair rating summary data. The platform detects rating value formats (decimal averages), count columns for ratings and reviews, and scale ranges for best/worst possible ratings.
3
Map to AggregateRating Schema
Assign columns to AggregateRating properties: ratingValue (average rating), bestRating (maximum possible, usually 5), worstRating (minimum possible, usually 1), ratingCount (number of ratings), and reviewCount (number of reviews). Link to LocalBusiness or Product being rated.
4
Generate AggregateRating JSON-LD
Export validated AggregateRating schema for your repair shop. The system creates properly formatted rating object ready to embed in LocalBusiness, Product, or Service schema as aggregateRating property.
5
Embed in Business Schema
Add generated AggregateRating as property of your LocalBusiness, Product, or Service schema. Test complete markup with Google Rich Results Test to verify star rating display eligibility in search results and knowledge panels.
Frequently Asked Questions
What is the difference between ratingCount and reviewCount?
ratingCount is total number of ratings submitted (including star-only ratings without text). reviewCount is number of written reviews with text feedback. ratingCount is typically equal to or higher than reviewCount. Include both properties for complete statistics.
How do I aggregate reviews from multiple platforms?
Calculate combined statistics across all review sources. Add up total ratings (ratingCount), total reviews (reviewCount), and compute weighted average ratingValue based on all platform ratings. One AggregateRating represents combined statistics for the business entity.
Can I create AggregateRating without individual Review schemas?
Yes, AggregateRating can exist independently to show overall statistics. However, including individual Review schemas provides more credibility and enables display of specific customer feedback. Both together offer complete review representation: summary statistics plus detailed testimonials.
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.