Roadmap

Wishlist


Voters 3

  • Avatar
  • B
  • W

⚡️ by Upvoty

3

Extend Google Review Automation to Data Warehouse

Avatar
 Dale McGeorge

When creating a Data Warehouse any Google Reviews that are added to the profile are saved to BigQuery. If at a later stage, Google removes that review from the profile due to a policy violation, the review remains in BigQuery. This can cause reports to look outdated as they include reviews that are no longer public.

The Automation Job Google Review History https://www.jepto.com/help/google-review-change-history monitors your reviews to determine when a review is deleted, as there is currently no notification that Google sends when they take action against a review.

This Automation can be extended so that when it detects a deleted review, it will search through any active pipelines and mark the review in BigQuery with a new field (isDeleted) to true. This enables you to keep the review for historic purposes and a way to filter these reviews from any of your Looker Studio or SQL reports.

  • 2024-01-29 -
A