予約状況分析【年間】の見方

予約状況分析【年間】の見方

(1)このレポートでわかること。

宿泊予定について、当月から最大24ヶ月(最短で当月を含む過去13か月分)の推移を表示します。
月ごとに入った予約の状況を、昨年の同月と比較しながら確認できます。また、エクセルでの出力も可能です。

(2)出力イメージ

img1.gif

(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","",""
↑Pagetop