Travel Site Dashboard v1 (3)
3
Sample Travel Site Dashboard Choose Mo KPI Room Night GOR A&P Spent A&P !e need " RN per da# to hit T 120 $31,200 $5,350 17% Sales 40% Up from previous month Let's Cele "C# " L& &# (") a* +oo* erfe t RN 120 272 2- 42. /5-% $%$$$$$$$$$$$ Sales Trend Moment m 13 3 )oom i hts er a "u /10 Sep/10 t/10 2 0 2 4 0 Destination '((e)tiveness "6 Cost ) Cost ) % Sort 1 2 3 4 Sort r*er 8 9"L"&S:";< 0 0 0 0% S: +" )=;< 0 0 0 0% "US#)"L:" 32 0 72 45 17% C>: " 32 0 72 45 17% ?" " 32 0 72 45 17% >:LL: : =S 32 1 45 17% #":@" 32 1 45 17% (:=# "9 32 1 45 17% 9"C"U 553 12 45 17% > + A + -42 14 45 17% 9"L"&S:" -42 14 45 17% #>":L" .03 1. 45 17% S: +" )= 1070 24 45 17% : =S:" 1-05 3- 45 17% Note* #he Cost ) en hmarB is 10 =*u ate* 6 :nspire* http han*oo or Last Up*ate* as o Apr-10 Jul-10 Oct-10 Jan-11 - 10.00 20.00 30.00 40.00 50.00 60.00 70.00 80.00 Aug-10 Sep-10 Oct-10 - 2.0 4.0 6.0 Apr-10 Jun-10 Aug-10 Oct-10 Dec-10 Feb-11 0 500 1,000 Ggle !a" F# Onl$ne Ot"% &e'%paper Fa$r O($ne Ot"% 3000 450 1600 300 Ggle !a" F# Onl$ne Ot"% &e'%paper Fa$r O($ne Ot"% 3)434 4800 13806 3240 5000 15000 Apr-10 Jun-10 Aug-10 Oct-10 Dec-10 0 100 200 300 400 500 600 700 800 )00 1,000 +& A * Apr-10 Jun-10 Aug-10 Oct-10 Dec- 0 20 40 60 80 100 120 140 160 180 Total A&P Spending +# Media A&P Anal#sis Cost , RN Trend Sele)t * Moment m (or Past - Months Room Nights .S A&P o( GOR Cost Per Room Night Trend Per(orman)e AUSTRALIA
-
Upload
eblebleblebl-ebl-ebl-ble -
Category
Documents
-
view
219 -
download
0
description
Travel Site Dashboard v1
Transcript of Travel Site Dashboard v1 (3)
DashBoardSample Travel Site DashboardBased on BudgetdNormalized1234567891011121314151617181920RNActualBudgetedLast YearYTDBadOkLast YearRNTotalBadOkChoose MonthApr-102550312525401210201016000000000May-10375029622540121520101600000KPIRoom NightGORA&P SpentA&P %We need 6 RN per day to hit TargetJun-10684821302438128201016120$31,200$5,35017%Sales 40% Up from previous monthLet's Celebrate !!!Jul-103299416250791620101600000000000000Aug-106013920222701113132010160000000Sep-10861945308971551132010160000000Oct-10120272264281362182132010160000000ACTABPLYYTDVARBadGoodPerfectNov-1035065853778329526217201016000RN12027226428-56%000000Dec-10900704261,67835256318201016000000000000Jan-11790684272,4683425471620101600000000000000Sales TrendFeb-11678931193,146466745- 0620101600000000000000Mar-119001,081304,046541865152010160000000000000004,0467ActualBudgetedLast YearYTDBadOkLast YearRNTotalBadOkOct-1012027226428136218213201016Momentum24.0Room Nights Per DayA&P SpendAug-10Sep-10Oct-10Total2.02.94.0OnlineOfflineGoogleYahooFBOthersTotalNewspaperFairOthersTotalGrand TotalDestination EffectivenessApr-1036612002004,061- 04,061A&P CostRNCost/RN%May-104,9281202005,248- 05,248Sort By1234Jun-102,6363003722003,50810001,0004,508Sort Order000Jul-101,8092002342402,48310001,0003,483MALAYSIA_FB0000%Aug-102,50030013003004,400- 04,400SINGAPORE_FB0000%Sep-102,70050015003005,000- 05,000AUSTRALIA320.724517%Oct-103,00045016003005,350- 05,350CHINA320.724517%Nov-103,40050016503005,85030003,0008,850JAPAN320.724517%Dec-103,00060017003005,6001500015,00020,600PHILLIPINES3214517%Jan-113,50047017503006,020- 06,020TAIWAN3214517%Feb-114,00056018003006,660- 06,660VIETNAM3214517%Mar-114,30060019003007,100- 07,100MACAU553124517%39,4344,80013,8063,24061,2805,00015,000- 020,00081,280HONG KONG642144517%MALAYSIA642144517%To show pieTHAILAND803184517%GoogleYahooFBOnline OthsNewspaperFairOffline OthsSINGAPORE1070244517%Oct-103,0004501,600300- 0- 0- 0INDONESIA1605364517%Note:The Cost/RN benchmark is 10Educated & Inspired by http://chandoo.orgLast Updated as of :5/8/2010 5:24To show YTDCreated By Francis ChinGoogleYahooFBOnline OthsNewspaperFairOffline Othsemail: [email protected],4344,80013,8063,2405,00015,000- 0To show A&P% TrendRNGORA&PA&P%Cost/RNDiff fr pr mApr-102565004,06162%162May-103796205,24855%14248%Jun-1068176804,50825%6684%Jul-103283203,48342%109-53%Aug-1060156004,40028%7388%Sep-1086223605,00022%5843%Oct-10120312005,35017%4540%Nov-10350910008,85010%25192%Dec-1090023400020,6009%23157%Jan-117902054006,0203%8-12%Feb-116781762806,6604%10-14%Mar-119002340007,1003%833%For top message, Sales is XX up or down from previous monthOct-1040%Destination Effectiveness - Cost (RM)AUSTRALIACHINAHONG KONGINDONESIAJAPANMACAUMALAYSIAPHILLIPINESSINGAPORETAIWANTHAILANDVIETNAMMALAYSIA_FBSINGAPORE_FBTotalApr-10- 0112211- 020166554- 01,02414937203,301May-10- 0195211741195207598- 01,671254146724,928Jun-10- 0274997170594- 01,2504475512,636Jul-10- 003021142541- 08751308- 04417863,037Aug-1026265281,320264555282688026660264,530Sep-1030306001,50030517600301,00030750305,147Oct-1032326421,60532553642321,07032803325,508Nov-1053531,0622,655539161,062531,770531,328539,111Dec-101241242,4726,1801242,1312,4721244,1201243,09012421,207Jan-1136367221,80636623722361,20436903366,197Feb-1140407991,99840689799401,33240999406,856Mar-1143438522,13043734852431,420431,065437,309Total3847188,17919,9466167,2039,96438417,61641511,2861,82779,766Room Nights By Destination0.60%0.60%12%30%0.60%10%12%0.60%20%0.60%15%0.60%AUSTRALIACHINAHONG KONGINDONESIAJAPANMACAUMALAYSIAPHILLIPINESSINGAPORETAIWANTHAILANDVIETNAMMALAYSIA_FBSINGAPORE_FBTotalApr-10000132130600025May-100364021101100037Jun-10000001210170171268Jul-10000032402300032Aug-100071806701209062Sep-101110261910117113189Oct-10111436112141241181124Nov-102242105236422702532360Dec-1055108270593108518051355927Jan-11559523758295515851195813Feb-11448120347081413641024698Mar-1155108270593108518051355927Total23264721170294095152383423600354160To draw chartOct-10A&P CostRNCost/RN%1AUSTRALIA320.724517.1%2CHINA320.724517.1%3HONG KONG64214.44517.1%4INDONESIA1,605364517.1%5JAPAN320.724517.1%6MACAU55312.41379310344517.1%7MALAYSIA64214.44517.1%8PHILLIPINES320.724517.1%9SINGAPORE1,070244517.1%10TAIWAN320.724517.1%11THAILAND803184517.1%12VIETNAM320.724517.1%13MALAYSIA_FB- 014SINGAPORE_FB- 0Total5,5081244517.1%Sort by2Sort Order2SortedDestinationSort KPIUniqueSortedPositionDestinationA&P CostRNCost/RN%1AUSTRALIA11013MALAYSIA_FB0000%2CHINA11014SINGAPORE_FB0000%3HONG KONG141411AUSTRALIA3214517%4INDONESIA363612CHINA3214517%5JAPAN1115JAPAN3214517%6MACAU121218PHILLIPINES3214517%7MALAYSIA1414110TAIWAN3214517%8PHILLIPINES11112VIETNAM3214517%9SINGAPORE2424126MACAU553124517%10TAIWAN11143HONG KONG642144517%11THAILAND1818147MALAYSIA642144517%12VIETNAM111811THAILAND803184517%13MALAYSIA_FB00249SINGAPORE1070244517%14SINGAPORE_FB00364INDONESIA1605364517%Cost / RN Bench mark10Country Selected1Cost / RN Trend Master ChartAUSTRALIACHINAHONG KONGINDONESIAJAPANMACAUMALAYSIAPHILLIPINESSINGAPORETAIWANTHAILANDVIETNAMTotalApr-100000783430171000May-10065351850103540152000Jun-1000000170280740284Jul-100000421135038000Aug-10737373737373737373737373Sep-10585858585858585858585858Oct-10454545454545454545454545Nov-10252525252525252525252525Dec-10232323232323232323232323Jan-11888888888888Feb-11101010101010101010101010Mar-11888888888888Cost / RN Trend for this monthAUSTRALIAApr-10- 0May-10- 0Jun-10- 0Jul-10- 0Aug-1073.33Sep-1058.14Oct-1044.58Nov-1025.29Dec-1022.89Jan-117.62Feb-119.82Mar-117.89
DashBoard
AUSTRALIA
parameters
Actual
Oct-10
Total
RNA&P%
Cost/RN
Site :Sample Travel SiteData TableMonth :1. Daily A&P spend table including Google, Yahoo, FB, Ads, others BY DestinationAvg Rate2602. Daily RN by Destination3. Daily TrafficsBad50%Ok80%Cost/RN Benchmark10If the Cost per room night is higher this number, the city is highlightedAUSTRALIACHINAHONG KONGINDONESIAJAPANMACAUMALAYSIAPHILLIPINESSINGAPORETAIWANTHAILANDVIETNAM
Total A&P Spending By MediaA&P AnalysisCost / RN TrendSelect :Momentum for Past 3 MonthsRoom Nights VS A&P% of GORCost Per Room Night TrendPerformance
