| name | review-recency-insights |
|---|
| description | Analyze a G2 product's Review Recency Score (part of the Pulse Engagement Score) using live Looker data. Use whenever a user asks about "review recency", "recency score", "pulse score", "review target", "how many reviews does [product] need", "review history", or asks to diagnose or improve a product's/vendor's review collection health — even if they only give a product ID or vendor name and a short prompt like "check recency for product 12345" or "why is X's recency score low". Always trigger for any question mixing a G2 product/vendor identifier with recency, pulse score, review targets, or CSM coaching on review collection, regardless of how casually it's phrased. |
|---|
Review Recency Insights (Looker edition)
Diagnoses a G2 product's Review Recency Score end-to-end: current state, why it is what it is, monthly history, and — the most useful part for CSMs — exactly how many more months of hitting target would move the score up a tier.
All queries use the Looker MCP (looker_mcp:* tools). This skill does not depend on Snowflake — the Looker semantic layer is the single source of truth so numbers always match what the CSM sees in the Adoption Tracking dashboard.
Model / explore used throughout:
- Model:
global_adoption_tracking
- Explore:
adoption_tracking_master
Step 0 — Resolve the product (if only a name was given)
If the user gave a PRODUCT_ID, skip this and use it directly. If they gave a vendor or product name, resolve it with a fields-only lookup:
looker_mcp query
model: global_adoption_tracking
explore: adoption_tracking_master
fields: [product_vendor_info.product_id, product_vendor_info.product_name, product_vendor_info.vendor_name]
filters: {product_vendor_info.vendor_name: "%<name>%"} # or product_vendor_info.product_name
limit: 20
If multiple products come back, show the list and ask which product_id they mean before continuing. If exactly one, proceed silently.
Step 1 — Current pulse & recency snapshot
Pull the most recent monthly row for this product:
looker_mcp query
model: global_adoption_tracking
explore: adoption_tracking_master
fields:
- product_vendor_info.product_id
