Get Review and Rating Over Time

Track review volume and average rating across time buckets.

get_review_and_rating_over_time

Description

Returns review count and average rating as a time series. Use it to identify rating trends, review-volume changes, seasonality, and spikes.

Parameters

Parameter	Type	Required	Default	Description
startDate	string	No	—	Start date in MM/DD/YYYY format
endDate	string	No	—	End date in MM/DD/YYYY format
days	integer	No	—	Relative window in days
months	integer	No	12 months when no period is requested	Relative window in months
sourceAliases	list[string]	No	All sources	Sources such as "google", "yelp", "facebook", or "birdeye"
businessNumbers	list[integer]	No	All locations	Location IDs to include
sortBy	string	No	"count"	Sort by "review-count", "avg-rating", or "time"
sortOrder	integer	No	1	0 for ascending or 1 for descending

Example Usage

Which month had the most reviews during the last year?

Example Response

[
  { "rating": 4.6, "count": 132, "milestone": "Jan 2026" },
  { "rating": 4.5, "count": 118, "milestone": "Feb 2026" },
  { "rating": 4.7, "count": 145, "milestone": "Mar 2026" }
]

Response Fields

Each time bucket contains milestone for the bucket date (formatted like "Feb 2026", not MM/YYYY), count for review volume, and rating for average rating.

Notes

• A rating of 0.0 with count: 0 means the bucket has no reviews; it is not a zero-star average.
• The array is not guaranteed to be in chronological order — sort dataPoints by milestone client-side if a strict timeline is needed, rather than assuming array order.
• Use get_review_and_rating_by_location for location comparisons.