STR connector

Use your STR data for reporting, automation and AI.

Data Panda brings your STR benchmarks together with the data from the rest of your hotel operation. From one place, we turn occupancy, ADR and RevPAR indices into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
STR logo
About STR

The benchmark the hotel industry runs on.

STR was started in 1985 by Randell and Carolyn Smith and grew into the global benchmark provider for the hotel industry. The company joined CoStar Group in October 2019 and now operates as part of CoStar's hospitality analytics line. STR aggregates anonymised performance data from tens of thousands of properties in over 180 countries and feeds it back as STAR Reports, Forward STAR pace, Pipeline and Trend data.

Owners, brands and revenue managers use STR to answer one question: are we winning or losing share against the hotels we compete with. Once those benchmarks sit in your warehouse next to your PMS revenue, channel mix and labour cost, the index drift stops being a number on a PDF and becomes a signal you can act on.

What your STR data is for

What you get once STR is connected.

Reporting & dashboards

Your competitive-set indices, segment performance and forward pace in one place, aligned with your own PMS revenue.

  • MPI, ARI and RGI per property and per comp set
  • Segment mix versus market versus comp set
  • Forward STAR pace versus same-time-last-year

Process automation

Use the index drift to drive pricing, distribution and ownership reporting without re-keying numbers from a PDF.

  • Pace alerts when RGI drops two weeks in a row
  • Owner reports rebuilt from PMS plus STR every month
  • Comp-set changes synced into BI dimensions

AI workflows

Put STR pace and index history behind AI that knows your market and your comp set.

  • Demand forecasts trained on STR pace plus your bookings
  • Anomaly detection on segment-level RGI
  • Auto-drafted owner commentary on the variance story

Custom apps on your data

Internal tools that read STR data alongside PMS and channel feeds without bouncing between portals.

  • Revenue daily-stand-up dashboards per property
  • Owner portals showing benchmark plus actuals
  • Pricing what-if tools grounded in market pace
Use cases

Use cases we deliver with STR data.

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

Comp-set RGI trackingWeekly RGI per property versus the comp set you compete with.
Market index driftMPI versus market submarket, flagged when the gap widens.
Forward pace deviationOn-the-books pace next 90 days versus same-time-last-year.
Segment performanceTransient versus group versus contract, against the comp set.
ADR ceiling testWhere rate moves in the comp set leave room you are not taking.
Brand-tier penetrationIndex drift by brand tier inside your portfolio.
Owner monthly reportPMS actuals plus STR benchmark on one page, ready to send.
Pipeline supply watchRooms entering your market in the next 24 months.
Trend variance commentaryAuto-drafted explanation of why the index moved this period.
Channel mix versus marketDirect, OTA and group share alongside market mix benchmarks.
Multi-property roll-upPortfolio-level index, weighted by available room nights.
Budget reset supportLast year actual plus STR forecast as the starting point.
Real business questions

Answers you will finally get.

Are we winning or losing share against our comp set?

MPI, ARI and RGI per property over the rolling twelve months, with the four-week trend marked. Drops are split by segment and day of week so the conversation goes to the right room type and the right channel mix.

Where is forward pace soft?

Forward STAR on-the-books versus same-time-last-year, broken down by arrival week and segment. The weeks where pace lags by more than the threshold you set get flagged before pricing and distribution decisions are due.

Is new supply going to hit us?

STR Pipeline data filtered to your market and brand tier, with expected opening dates plotted against your forward bookings. The view shows the months where added rooms will compress occupancy if no countermove is made.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Owner reports that reconcile PMS revenue with STR benchmarks. Stop sending two PDFs and explaining why the indices in one do not match the actuals in the other.

For sales leaders

Corporate sales walks into rate negotiations with the same comp-set view ownership reads. You see whether the share you lost is going to direct competitors or to a softer market overall, and price the next group block accordingly.

For operations

Revenue management with comp-set context next to PMS pace, channel mix and labour cost. The pricing call has the same numbers the GM and the owner are reading.

Ideas

What you can automate with STR.

Pair with Exact Online

Reconcile PMS revenue with STR benchmark in the books

Monthly STR indices land in the warehouse next to the revenue posted in Exact Online. Owner reports show RGI, ARI and MPI per property alongside invoiced revenue and operating result, so the variance story is built once and not retyped from a PDF.

Pair with Slack

Push pace and index alerts into the revenue channel

When RGI for a property drops two weeks in a row, or when Forward STAR pace lags same-time-last-year by more than the threshold you set, a message lands in the revenue channel with the property, the segment and the suggested next look. The morning stand-up starts with the alert, not with the report.

Pair with monday.com

Turn benchmark misses into revenue actions

Each weekly STR drop creates an action item on a monday.com board with the affected property, the responsible revenue manager and the deadline before the next weekly report. The board closes the loop between the benchmark moving and someone doing something about it.

Pair with HubSpot

Feed market context into corporate-sales outreach

Comp-set occupancy and segment indices flow into HubSpot as company properties on your corporate-account records. The sales team sees which markets are running soft when they negotiate group and contract rates, and pace data tells them where they have room to push.

Pair with Mailchimp

Time leisure campaigns to weak forward pace

Forward STAR pace per arrival week feeds Mailchimp segments. When the next 30 to 60 days look soft for a property, the leisure list for that catchment area gets a campaign with the right offer, instead of a generic blast on the calendar.

Pair with Klaviyo

Trigger guest-segment journeys on segment-mix shifts

Klaviyo flows for repeat guests fire on the segments where STR shows you are losing share. Transient leisure flows activate when transient RGI drops, group flows when group pace softens, so the right audience hears from you when the index says they should.

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 STR data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From STR to answers in three steps.

01

Connect securely

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

02

Land in your warehouse

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

03

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.

  • STR 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.

How do we get our STR data into the warehouse?

STR delivers data through scheduled report exports and the CoStar STR Benchmark portal. We pick up the files or the feed your subscription supports, parse the indices and segments, and load them into the warehouse on the same cadence you receive them. The historical archive is loaded once at the start.

What if our comp set changes?

Comp-set definitions move when the portfolio or the market moves. We treat the comp-set membership as a slowly changing dimension so historical indices stay correct against the comp set that was in force at the time, and current dashboards run against the new one.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

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