Shiji ReviewPro connector

Use your Shiji ReviewPro data for reporting, automation and AI.

Data Panda brings your Shiji ReviewPro data together with the data from the rest of your hotel group. From one place, we turn it into dashboards, automations, AI workflows and custom apps your operations, guest-experience and revenue teams use every day.

About Shiji ReviewPro

The reputation platform behind the Global Review Index.

ReviewPro was founded in Barcelona in 2008 to give hotels a single view of what guests were saying about them across booking sites and review platforms. Shiji Group acquired a majority stake in January 2017 for around 26 million euro, and the product has been part of the Chinese hospitality-tech group ever since. Today the platform reports more than 60,000 establishments using ReviewPro across 150-plus countries.

For operations, guest-experience and revenue leaders, ReviewPro is the system of record for everything that happens after a guest checks in and decides to talk about it: reviews aggregated from over 140 OTAs and review sites in 45-plus languages, the proprietary Global Review Index that weights more recent reviews more heavily, sentiment analysis across hundreds of concepts, post-stay surveys sent over email, SMS or WhatsApp, case management for issue follow-up, and AI-assisted response drafting. The dashboards in the product cover the daily reputation view well. The harder questions, like which OTA channel your GRI is drifting on, whether a recurring complaint theme lines up with an operational fix the property already made, or how response-time SLAs correlate with the next month's GRI, sit between ReviewPro and the PMS, channel manager and CRM around it. Pulling ReviewPro into a warehouse is how those questions stop being a screenshot in a Monday morning meeting.

What your Shiji ReviewPro data is for

What you get once Shiji ReviewPro is connected.

Reputation reporting

GRI, sentiment and survey scores in one place, split by source, language and property.

Group GRI with drift per OTA and review site
Sentiment by concept across rooms, F&B, front desk and cleanliness
Survey NPS and CSAT next to the same property's GRI

Process automation

Turn review and survey events into the follow-up your guest-experience desk would otherwise do by hand.

Open a case in ReviewPro when a survey response drops below a CSAT threshold
Push low-rated reviews into the on-call ops channel within minutes
Roll up monthly GRI per property into the group reporting pack automatically

AI workflows

Use review and survey history to spot patterns and sharpen response.

Recurring complaint themes per property and per shift, scored by frequency
Predicted GRI impact of a fix, based on the concept and the channel mix
Draft review responses in the property's tone, ready for a manager to approve

Custom apps on your data

Small guest-experience and ops tools that run on ReviewPro data instead of yet another tab.

Reputation cockpit per general manager with their property's GRI, cases and survey delta
Response-SLA tracker that flags reviews older than the team's own target
Concept-to-fix board that ties recurring themes back to the work order that closed them

Use cases

Use cases we deliver with Shiji ReviewPro data.

A list of concrete reports, automations and AI features we have built on Shiji ReviewPro data. Pick the one that matches your situation.

GRI per OTA channelGroup GRI broken out per source, with drift over time.

Sentiment by conceptRooms, F&B, front desk, cleanliness, value, scored over time.

Survey versus publicPost-stay survey CSAT next to the same period's public GRI.

Response-time SLAMedian time to first response per property, channel and shift.

Case follow-up rateCases opened, resolved and reopened per property and team.

Recurring complaintsTop themes per property over rolling 30, 60 and 90 days.

Review volume vs occupancyVolume of reviews and surveys per occupied room night.

Language and source mixReview distribution per language and per booking site.

Competitor set driftGRI versus competitor set over time per property.

Multi-property viewGroup reputation KPIs with per-property drill-down.

Survey funnelSurveys sent, opened and completed per channel and template.

Star-rating distribution1 to 5 star spread per source and per property over time.

Real business questions

Answers you will finally get.

Where is our GRI quietly drifting, by OTA channel?

Group GRI broken out per source (Booking.com, Tripadvisor, Google, Expedia and the rest), tracked week over week. Reputation desks see the channel where the score is dropping in time to look at the underlying reviews, instead of finding out at the next quarterly benchmark when one channel has dragged the group GRI down half a point.

Do our recurring complaint themes line up with anything operations fixed?

Sentiment by concept (cleanliness, breakfast, check-in wait, A/C noise, shower) is joined to the work orders or PMS notes that should have closed them. Themes that keep showing up after a fix get flagged so the next round goes back to root cause instead of being closed again on the same comment.

Are we hitting our own review response-time SLA across the group?

Median time to first response per property, per source and per shift, against whatever target the group has set. The properties that miss the SLA on the channels guests book through most become a manageable list rather than an aggregate the group average hides.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

GRI per property next to ADR, occupancy and OTA commission, so a half-point GRI move can be read against the rate decisions and the channel mix it followed. The reputation cost of a recurring complaint becomes visible in the same view as the cost of the fix.

For sales leaders

Group reputation by source ready for the OTA review meeting, so the conversation with a Booking.com or Expedia account manager runs on your numbers. Corporate-account satisfaction trends are there when a procurement team asks for them at renewal.

For operations

Recurring themes per property and per shift, with cases and response-time SLA next to them. The general manager opens one cockpit instead of jumping between ReviewPro tabs, the PMS and a separate work-order tool.

Ideas

What you can automate with Shiji ReviewPro.

Pair with Mews

Attach ReviewPro reviews and surveys to the Mews guest record

Reviews and post-stay survey responses from ReviewPro are matched back to the Mews stay and guest profile they came from, with the OTA channel, the rate plan and the room number kept on the row. Returning guests with a low score on a previous stay are visible to the front desk before check-in, and recurring themes can be sliced by room type or floor instead of being one anonymous group score.

Pair with Lighthouse Channel Manager (Cubilis)

Feed GRI per OTA channel back into your distribution view

GRI drift per source from ReviewPro is joined to the channel mix and commission per OTA from Cubilis, so the channels you depend on most for distribution are also the ones whose review trend you watch first. A drop on Booking.com lands next to the share of stays Booking.com drove that month, and the trade-off is visible in one row instead of two screenshots.

Pair with HubSpot

Sync corporate and group account satisfaction into HubSpot

Survey and review scores from ReviewPro that can be tied to a corporate account or group block flow into HubSpot as timeline activity on the company record. Sales walks into a renewal meeting with the actual stay-level satisfaction trend of the buyer's travellers next to the rate they pay, instead of a generic group GRI that says nothing about that one account.

Pair with Hello Customer

Combine ReviewPro public reviews with Hello Customer survey themes

Public reviews and post-stay surveys from ReviewPro are joined with Hello Customer's broader CX survey themes on the same guest segment, so a Belgian or European hotel group sees the same complaint pattern from two angles. The themes that show up in both are the ones operations starts with, and the gaps between the two sources flag where one channel is hiding what the other already shows.

Data model

Tables we make available.

These are the 2 tables we currently pull from Shiji ReviewPro into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

Available Groups
Available Hotels

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Shiji ReviewPro data lives.

Power BI Microsoft

Fabric Microsoft

Snowflake Data warehouse

BigQuery Google

Tableau Visualisation

Excel Sheets & pivots

Three steps

From Shiji ReviewPro to answers in three steps.

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

Shiji ReviewPro connector configured and running
Warehouse set up in your cloud account
Clean access for your Power BI, Fabric or Tableau team
Documentation on what's in the data model
Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

Everything in Self-serve
Dashboards built to the questions your team actually asks
Automations between your systems
AI workflows scoped to real tasks your team runs
Custom apps where a dashboard does not cut it
Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Which OTAs and review sites does ReviewPro cover?

ReviewPro aggregates reviews from over 140 OTAs and review platforms in 45-plus languages, with the major sources being Booking.com, Tripadvisor, Google, Expedia and the regional booking sites. In the warehouse each source becomes its own dimension on review and rating tables, so GRI per channel and group-level reputation mix are both first-class queries instead of a column extracted from a source-name string.

How does GRI weight recent reviews, and can we replicate it in the warehouse?

GRI is ReviewPro's proprietary score and weights more recent reviews more heavily than older ones, so a single bad month moves the score faster than a quiet quarter erodes it. We expose the underlying review and rating data in the warehouse so you can either trust the GRI ReviewPro publishes or build your own time-weighted score for internal benchmarking, depending on what your reputation desk prefers.

Do post-stay surveys and public reviews land in the same model?

Yes. ReviewPro surveys (sent over email, SMS or WhatsApp) and public reviews land as separate sources but on a shared guest and stay key wherever the data allows it. That makes the standard sanity check easy: where a property's survey CSAT is healthy and the public GRI is lower, the gap usually points at a channel or a recurring complaint that the surveys are not sampling.

GDPR-compliant

Data stays in the EU

You own the warehouse

A first deliverable live in four to six weeks.

We review your Shiji ReviewPro setup and the systems around it. Together we pick the first thing worth building.

Book a call See our other connectors