Reporting

Google reviews reputation scorecard for the last 90 days

A management scorecard per location from Google Business Profile reviews: volume, period vs overall rating, star mix, unanswered share and median reply time, plus praise and complaint themes and a reply queue for low-star reviews.

When to use it

When you need to report on your Google review reputation across locations and spot which ones need attention.

What you get

A per-location scorecard with At risk flags, top praise and complaint themes with quotes, and a list of unanswered 1 to 3 star reviews for the team to reply to.

Does it change anything in my account?

No. The assistant only reads your data and reports back.

Works with

Business Profile

Use my Opus Growth connection for this. If you cannot see the tool you need, search among the Opus Growth tools (with search_tools if it is in your list); if you cannot reach the tools at all, do not guess, tell me. Build a reputation scorecard from our Google reviews for management, covering all locations and the last 90 days. This is a reporting task only. 1. List the locations. For each one, pull the overall average rating and total review count, then page through the reviews with offset and limit until you have every review created in the last 90 days. The list is ordered by last update and a reply counts as an update, so do not stop at the first older review; keep paging until the update dates are older than 90 days as well. If a location's list comes back truncated, say so on its row. 2. For each location, report: - number of new reviews in the period, - average rating of the period versus the overall average, - star distribution (1 to 5) for the period, - unanswered reviews in the period, as a count and a share, - median days between a review and our reply, using the review date and the reply date, for the period's answered reviews. 3. Mark a location as **At risk** if any of these applies: - the period rating is at least 0.3 below its overall average, - more than 20% of the period's reviews are unanswered, - the median reply time is over 3 days. If a location has fewer than 5 reviews in the period, show the figures but note that the sample is small. 4. Across all locations, identify the top 3 praise themes and the top 3 complaint themes from the review text. Back each theme with one short quote and the number of reviews that mention it. 5. Pull the unanswered reviews per location and list every one rated 1 to 3 stars, oldest first, with location, date and text, so the team can respond. Do not post or edit any replies.

Related searches

These prompts work best when your AI assistant is connected to your accounts with Opus Growth.

Connect your accounts free

More prompts

ReportingRead-only

Build a monthly scorecard of your brand's visibility in AI answers and compare it with last month

Measures the same question set in ChatGPT, Perplexity and Gemini every month, checks whether you are cited in Google's AI answers, and combines this with AI referrals in GA4 and brand searches in Search Console. States measurement noise and tool limits openly.

When to use itYou want to track your visibility in AI search every month on the same yardstick, not just once, and see whether your work is paying off.

SEO Intelligence, GA4, Search Console
ReportingRead-only

Measure conversion lag before you judge the last few days

Works out, per campaign, how many days after the click conversions are recorded, estimates how incomplete the last few days still are and says whether a bidding decision should wait.

When to use itWhen conversions look down over the last few days and you want to know whether late-arriving conversions explain it before you touch bids or budgets.

Google Ads
ReportingChanges after your approval

Monthly paid channel efficiency ranking with a budget split proposal

A ranking of every paid channel by cost per conversion, with spend share vs conversion share and a proposed budget split for next month.

When to use itWhen a new month is starting and you need to decide which paid channels deserve more or less budget.

Google Ads, Meta Ads, TikTok Ads
ReportingChanges after your approval

Monthly Google Ads client report with a shareable white-label link

Builds a one-page, jargon-free monthly report for a client with exact calendar-month figures versus the previous month, explains every big KPI move from campaign data and creates the white-label link only after you approve the draft.

When to use itWhen you have to send a client their monthly Google Ads results in plain language and explain what moved and why.

Google Ads