Market Position Board

Understand where your offer sits against comparable offers, for the dates and vehicle classes that matter.

Version

0.1 draft

Maintainer

RH-maintained

Sample data

Sample data planned

Support status

To be defined

Licence status

To be defined

Inputs

What data is required?

Your own rates by pickup location, dropoff location, pickup date, return date and vehicle class
Comparable offers for the same pickup and return pair, the same rental duration and the same vehicle class
A vehicle class mapping table, because the same car is not called the same thing everywhere
Currency, taxes and fees so that what you compare is actually comparable

Outputs

What does it calculate, display or help you decide?

Your position against comparable offers for each date and class, with the comparison basis stated
The gap expressed in both currency and percentage terms
A view of which comparisons were excluded and why

Build prompt

Select the prompt below and paste it into your AI-assisted editor as a starting point, then change the field names so they match your own export.

Build a board that compares my car rental rates against comparable offers. Inputs are two CSVs: my_rates and market_rates, both with pickup_location, dropoff_location, pickup_date, return_date, vehicle_class, currency, base_rate, taxes, fees, observed_at. A third CSV, class_map, maps each competitor vehicle_class to my own class. Only compare offers that share the same pickup and dropoff location, the same pickup and return date, the same mapped vehicle class and the same currency. Show for every comparable pair: my rate, the lowest comparable rate, the median comparable rate, my gap in currency and percent, and how many comparable offers were found. Let me choose whether to compare on base rate or on total including taxes and fees, and show the choice on screen. List every row that could not be compared with the reason. Never fill a missing comparison with an estimate.

Sample data

Use synthetic market data or data you are authorised to use. Comparable offers should carry the timestamp they were collected so the board can show how current the comparison is.

Setup

Start with one pickup location, one vehicle class and a two week date range.
Build the class mapping table first and check it by hand.
Generate the board and confirm the comparison count for a date you know well.
Add the base rate against total comparison switch.
Widen to more locations only once a single location reads correctly.

Dependencies

A CSV parser and a charting library you are comfortable maintaining
A vehicle class mapping you control and can edit
No connection to RateHighway services is required for the first version

Tests

Remove a comparable offer and confirm the comparison count falls by one for that date.
Change one competitor class mapping and confirm the affected comparisons move.
Switch from base rate to total and confirm every gap recalculates.
Introduce a row in a different currency and confirm it is excluded rather than converted silently.
Check one date by hand against the source file.

Operating complication

The part that catches people out

Vehicle class normalisation. The same physical car is described differently by every supplier. Comparing a rate labelled Compact against a rate labelled Economy can make a sound price look wrong, and a wrong price look sound.

Comparability is a decision, not a fact. A pickup date, a return date, the rental duration, the pickup and dropoff locations, the vehicle class, the currency and whether taxes and fees are included all have to match before a comparison means anything. Write the mapping down, show it on screen and let it be edited, rather than burying it in code.

Optional

Optional RME connection

RateMonitor Elite already handles rate shopping and comparison at an operational scale. A tool like this is useful for learning the mechanics and for building a view specific to your operation. Where an approved interface exists in future, a custom board could read authorised observations rather than manual exports. Nothing about that access is approved today.

Any connection to RateHighway services would require approved interfaces, authorisation, tenant isolation and verified data rights. Nothing about access or availability is approved.

Build it, then check it by hand

Run the prompt, point it at sample data, and verify one row or one date against the source before you trust the whole file.

Open the Playbook All modules