Stays overlapping a month (pro-rata)
stays_in_monthCalculate pro-rated nights and revenue for bookings overlapping a month, totalled per property, portal and entity to verify Smoobu Analytics data.
Instructions
Every booking overlapping the month with nights inside the month and pro-rated revenue, totalled per property, per portal and per entity. Reproduces Smoobu Analytics' convention so the extraction can be verified without reading the screen.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| month | Yes | Calendar month, YYYY-MM. | |
| entity | No | Restrict to one EOM entity (KALAWALA, NAMAITAMI, RIBHOLDING, DELFINES, PERLA). | |
| company | No | Restrict to one fiscal company / bsides account (AO_DIMME, XELION, PERLA). | |
| include_rows | No | Return the per-booking rows in addition to the per-property / per-portal totals. |