予約状況分析【年間】の見方
(1)このレポートでわかること。
宿泊予定について、当月から最大24ヶ月(最短で当月を含む過去13か月分)の推移を表示します。
月ごとに入った予約の状況を、昨年の同月と比較しながら確認できます。また、エクセルでの出力も可能です。
(2)出力イメージ

(3)出力項目の詳細
※ その月に、何件の予約が入ったかを集計しています。
例えば、4月に4月宿泊の予約が何件入ったかだけではなく、5月や6月など未来宿泊の予約が何件入ったかも含めて集計しています。
※ なお、その月に変更された予約件数については含めておりません。
※ 集計は、毎日深夜に行っているため、本日予約された件数はカウントされていません。
| 項目名 | 出力単位 |
| 予約延室数 | 「予約延室数」 - 「キャンセル延室数」 |
| 予約延人数(人泊数) | 「予約延人数」 - 「キャンセル延人数」※延人数には子供も含まれます。 |
| 予約売上 | 「予約売上」 - 「キャンセル売上」 |
| 予約平均室売上 | 「予約売上」 ÷ 「予約延室数」(小数点以下は四捨五入) |
| 予約1人あたり売上 | 「予約売上」 ÷ 「予約延人数」(小数点以下は四捨五入) |
| 予約件数 | 「予約件数」 |
| キャンセル件数 | 「キャンセル件数」 |
| PV数 | 「施設詳細表示回数」 + 「プラン一覧表示回数」 +「プラン詳細表示回数」 |
ダウンロードデータの形式
| ダウンロードすると、csv形式で出力されます。出力結果は下記のような順番で出力されています。エクセルで開くことも可能です。 |
| "予約状況年間分析","","","","","","","","","" "月","年","予約延人数(人泊数)","予約延室数","予約売上(円)","予約平均室売上(円)","予約1人あたり売上(円)","予約件数","キャンセル件数","PV数" "9月","2005年","100","200","3000","400000","250000","500","50","3500" "9月","2004年","0","0","0","0","0","0","0","0" "10月","2005年","100","200","3000","400000","250000","500","50","3500" "10月","2004年","0","0","0","0","0","0","0","0" "11月","2005年","100","200","3000","400000","250000","500","50","3500" "11月","2004年","200","400","6000","80000","500000","1000","100","7000" "12月","2005年","100","200","3000","400000","250000","500","50","3500" "12月","2004年","200","400","6000","80000","500000","1000","100","7000" "1月","2006年","100","200","3000","400000","250000","500","50","3500" "1月","2005年","200","400","6000","80000","500000","1000","100","7000" "2月","2006年","100","200","3000","400000","250000","500","50","3500" "2月","2005年","200","400","6000","80000","500000","1000","100","7000" "3月","2006年","100","200","3000","400000","250000","500","50","3500" "3月","2005年","200","400","6000","80000","500000","1000","100","7000" "4月","2006年","100","200","3000","400000","250000","500","50","3500","","" "4月","2005年","200","400","6000","80000","500000","1000","100","7000","","" "5月","2006年","100","200","3000","400000","250000","500","50","3500","","" "5月","2005年","200","400","6000","80000","500000","1000","100","7000","","" "6月","2006年","100","200","3000","400000","250000","500","50","3500","","" "6月","2005年","200","400","6000","80000","500000","1000","100","7000","","" "7月","2006年","100","200","3000","400000","250000","500","50","3500","","" "7月","2005年","200","400","6000","80000","500000","1000","100","7000","","" "8月","2006年","0","0","0","0","0","0","0","0","","" "8月","2005年","200","400","6000","80000","500000","1000","100","7000","","" |