宿泊実績分析【日別】の見方

宿泊実績分析【日別】の見方

（１）このレポートでわかること。

宿泊実績について、指定した1ヶ月間の推移を表、及びグラフで表示する。
宿泊日ベースで集計した結果を表示する。（チェックアウト日ベースではない）
なお、精算請求が発生している場合は反映した値を表示する。

平均利用人数、平均泊数、宿泊件数、キャンセル件数、ノーショウ件数についてこの項目についてはチェックイン日ベースで集計した結果を表示する。

宿泊延人数については内訳として男女別の人数を表示する。
合計には該当月の合計値を表示する。

最大で過去13ヶ月分の表示が可能です。

（２）出力イメージ

（３）出力項目の詳細

各日別ごとに出力します。

表に出力される項目

項目名	出力単位
宿泊延室数	「部屋数」
宿泊延人数（人泊数）	「大人人数」
宿泊延人数_大人_男性	「大人人数（男性）」
宿泊延人数_大人_女性	「大人人数（女性）」
宿泊売上	「宿泊売上」
宿泊平均室売上	「宿泊売上」 ÷ 「宿泊延室数」（小数点以下は四捨五入）
宿泊1人あたり売上	「宿泊売上」 ÷ 「宿泊延人数」（小数点以下は四捨五入）
平均利用人数	「「大人人数（チェクイン日ベース）」 ÷ 「宿泊件数（チェックイン日ベース）」 （小数点以下は四捨五入）
平均泊数	「泊数合計（チェックイン日ベース）」 ÷ 「宿泊件数（チェックイン日ベース）」 （小数点以下は四捨五入）
宿泊件数	「宿泊件数（チェックイン日ベース）」
キャンセル件数	「キャンセル件数（チェックイン日ベース）」
ノーショウ件数	「ノーショウ件数（チェックイン日ベース）」

グラフに出力される項目

項目名	出力単位
日付	「チェックアウト日」
宿泊売上	「宿泊売上
宿泊平均室売上	「宿泊売上」 ÷ 「部屋数」 （小数点以下は四捨五入）
宿泊１人あたり売上	「宿泊売上」 ÷ 「大人人数」 （小数点以下は四捨五入）

ダウンロードデータの形式

ダウンロードすると、csv形式で出力されます。出力結果は下記のような順番で出力されています。エクセルで開くことも可能です。

"月間日別売上動向分析","","","","","","","","","","","",""
"","宿泊延室数","宿泊延人数（人泊数）","宿泊延男性人数","宿泊延女性人数","宿泊売上（円）","宿泊平均室売上（円）","宿泊1人あたり売上（円）","平均利用人数","平均泊数","宿泊件数","キャンセル件数","ノーショウ件数"
"8月1日","250","500","300","200","3500000","12000","11666","2","2","300","15","1"
"8月2日","1000","1200","1000","200","9400500","9400","20890","2","2","450","1","0"
"8月3日","0","0","300","200","0","0","0","0","0","0","0","0"
"8月4日","250","500","0","0","3500000","12000","11666","2","2","300","15","1"
"8月5日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月6日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月7日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月8日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月9日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月10日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月11日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月12日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月13日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月14日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月15日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月16日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月17日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月18日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月19日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月20日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月21日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月22日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月23日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月24日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月25日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月26日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月27日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月28日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月29日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月30日","0","0","0","0","0","0","0","0","0","0","0","0"
"8月31日","0","0","0","0","0","0","0","0","0","0","0","0"
"合計","1500","2200","1600","600","16400500","33400","44222","6","6","1050","31","2"