ݺߣ

ݺߣShare a Scribd company logo


                                                                                                                    	
 
                                                                                                                      	
 
                                                                                                                    	
 
                                                                                                                    	
 
                                                                                                                    	
 
                                                                                                                    	
 
                          Data	
 Analytics	
 and	
 Reporting	
                                                  	
 
                      All	
 the	
 stuff	
 about	
 your	
 attendee	
 that	
 you	
 
                                                                                                                                                                                                                          June	
 2012	
 
                               never	
 knew	
 you	
 could	
 ask	
 for…	
 
This	
 LEMON	
 presentation	
 is	
 confidential	
 and	
 contains	
 proprietary	
 information.	
 	
 Neither	
 this	
 presentation	
 nor	
 any	
 of	
 the	
 information	
 contained	
 herein	
 may	
 be	
 
                                 disclosed	
 to	
 any	
 person	
 under	
 any	
 circumstance	
 without	
 prior	
 written	
 permission	
 of	
 LEMON	
 Mobile	
 LLC.	
 




                                                                                                                                                                                                                                             1
                                                                                                                                                                                                                                             	
 
                                                                              Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Data	
 Analytics	
 and	
 Reporting	
 

•  LEMON	
 will	
 supply	
 information	
 which	
 can	
 be	
 easily	
 digested	
 and	
 
   interpreted	
 by	
 the	
 client	
 and	
 is	
 delivered	
 in	
 standard	
 formats	
 and	
 
   visual	
 representations.	
 	
 
   	
 
•  Formats	
 include	
 (but	
 are	
 not	
 limited	
 to)	
 .csv,	
 Excel	
 charts,	
 heat	
 
   maps	
 and	
 Google	
 maps	
 showing	
 device	
 location	
 data	
 which	
 can	
 
   be	
 supplied	
 as	
 both	
 video	
 and	
 in	
 image	
 format	
 (.jpg,	
 .png).	
 	
 
   	
 
•  LEMON	
 will	
 work	
 close	
 with	
 the	
 client	
 to	
 further	
 customize	
 and	
 
   refine	
 current	
 standard	
 formats	
 to	
 best	
 answer	
 client	
 specific	
 
   questions	
 regarding	
 their	
 fans’	
 migratory	
 patterns.	
 Any	
 
   additional	
 costs	
 incurred	
 from	
 this	
 additional	
 service	
 will	
 be	
 pre-­‐
   agreed.	
 


                                                                                                                           2	
 
                                       Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Data	
 Analytics	
 and	
 Reporting	
 

Data	
 analyzed	
 and	
 made	
 available	
 to	
 client:	
 
	
 
     •    Device	
 universe	
 
     •    Device	
 decrease	
 through	
 attrition	
 
     •    Active	
 devices	
 
     •    Message	
 delivery,	
 open	
 rates,	
 open	
 rates/time	
 
     •    Battery	
 usage	
 
     •    Device	
 location	
 –	
 at	
 event	
 or	
 world	
 wide	
 
     •    Device	
 mobility	
 
     •    Device	
 type	
 (OS)	
 




                                                                                                                         3	
 
                                     Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
App	
 Universe	
 Analysis
                                                    	
 

•  LEMON	
 will	
 supply	
 a	
 breakdown	
 
   of	
 the	
 number	
 of	
 devices	
 that	
 
   opt-­‐in	
 to	
 the	
 location	
 service	
 
   (need	
 total	
 number	
 of	
 
   downloads	
 from	
 app	
 producers	
 
   to	
 generate	
 a	
 %	
 thereof)	
 
   	
 
•  Reports	
 show	
 device	
 opt-­‐ins	
 over	
 
   time	
 to	
 be	
 aligned	
 with	
 external	
 
   media	
 campaigns	
 to	
 indicate	
 
   success	
 




                                                                                                                              4	
 
                                          Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Messaging	
 




•  Number	
 of	
 messages	
 delivered	
 and	
 subsequently	
 opened	
 
•  Number	
 of	
 messages	
 delivered	
 and	
 or	
 opened	
 over	
 time	
 to	
 be	
 
   aligned	
 with	
 external	
 campaign	
 data	
 to	
 gauge	
 success	
 of	
 
   campaigns	
 
•  Quick	
 view	
 of	
 all	
 events	
 (active	
 and	
 disabled)	
 
•  Quick	
 view	
 of	
 Events	
 changing	
 device	
 cadence	
 (frequency	
 of	
 
   location	
 update)	
 



                                                                                                                      5	
 
                                  Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Fan	
 Mobility	
 –	
 Game	
 Day	
 
•  Breakdown	
 of	
 fan	
 mobility	
 on	
 
   game	
 day	
 (heatmaps)	
 
   	
 
•  Depiction	
 in	
 time-­‐slices	
 that	
 
   give	
 visual	
 representation	
 to	
 
   device	
 mobility	
 over	
 time	
 
   	
 
•  Events	
 and	
 messaging	
 can	
 
   react	
 to	
 device	
 numbers	
 	
 by	
 
   identifying	
 congestion	
 points	
 
   or	
 fan	
 congregations	
 before	
 
   or	
 after	
 game	
 
   	
 

                                                                                                                                6	
 
                                            Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Device	
 Temporal	
 Activity	
 –	
 Game	
 Day	
 

          Analysis	
 of	
 arrival	
 time	
 of	
 fans	
 and	
 their	
 proximity	
 to	
 the	
 stadium	
 ,	
 
        sponsor	
 locations	
 or	
 other	
 landmarks	
 (such	
 as	
 pub	
 or	
 restaurant,	
 public	
 
                       transport	
 etc.)	
 by	
 using	
 latitude	
 and	
 longitude.	
 
                                                               	
 
Different options available
                                Traffic	
 around	
 Columbus	
 Circle	
 during	
 large	
 NY	
 event	
 
    #	
 Devices	
 




                                                                                    Time	
 


                                                                                                                                         7	
 
                                                     Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Device	
 Home	
 Location	
 

•  Anonymous	
 analysis	
 of	
 
   fan	
 home	
 location	
 and	
 
   representation	
 thereof	
 
   in	
 heat	
 maps	
 and	
 other	
 
   Google	
 map	
 
   representation	
 
   	
 
   	
 
•  Graphical	
 representation	
 
   of	
 data	
 in	
 alternative	
 
   formats	
 for	
 analysis	
 and	
 
   reporting	
 




                                                                                                                                8	
 
                                            Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Demographic	
 Profiling	
 

 Anonymous	
 analysis	
 of	
 fan	
 location	
 broken	
 down	
 in	
 the	
 categories	
 of	
 top	
 
neighborhoods,	
 cities,	
 regions	
 and	
 countries	
 supplied	
 in	
 Excel	
 and	
 as	
 visual	
 
                 representations	
 (pie	
 chart,	
 graph,	
 column)            	
 
                                                   	
 
                                                                            Top	
 Regions	
                                                                                                                                                                              Top	
 Cities	
 
                                                                                                                                                                                                                             5	
 
 6000	
 
                                                                                                                                                                                                                           4.5	
 
 5000	
                                                                                                                                                                                                                     4	
 
 4000	
                                                                                                                                                                                                                   3.5	
 
                                                                                                                                                                                                                             3	
 
 3000	
 
                                                                                                                                                                                                                           2.5	
 
 2000	
                                                                                                                                                                        Series1	
                                   2	
 
  1000	
                                                                                                                                                                                                                  1.5	
                                                              Series1	
 
                                                                                                                                                                                Series2	
                                   1	
 
       0	
                                                                                                                                                                                                                0.5	
 
               Florida	
 
                             Pennsylvania	
 
                                                North	
 Carolina	
 
                                                                        Maryland	
 


                                                                                                     Ohio	
 




                                                                                                                                                                Louisiana	
 
                                                                                       Arizona	
 




                                                                                                                                                 Missouri	
 
                                                                                                                                Washington	
 
                                                                                                                Tennessee	
 




                                                                                                                                                                                                                             0	
 




                                                                                                                                                                                                                                                                                                             9	
 
                                                                                                                                                                                       Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.
Thank	
 You!
                               	
 




For	
 any	
 additional	
 information	
 about	
 our	
   	
 
  Data	
 Analytics	
 &	
 Reporting	
 tool	
 set,	
 
                                                        	
 
       please	
 contact	
 James	
 Rodmell	
 at	
 
                                                   	
 
                james@lemonllc.com         	
 
                              	
 




                                                                                                        10	
 
                    Confidential	
 &	
 Proprietary	
 Information.	
 All	
 Rights	
 Reserved.

More Related Content

Data analytics01

  • 1. Data Analytics and Reporting All the stuff about your attendee that you June 2012 never knew you could ask for… This LEMON presentation is confidential and contains proprietary information. Neither this presentation nor any of the information contained herein may be disclosed to any person under any circumstance without prior written permission of LEMON Mobile LLC. 1 Confidential & Proprietary Information. All Rights Reserved.
  • 2. Data Analytics and Reporting •  LEMON will supply information which can be easily digested and interpreted by the client and is delivered in standard formats and visual representations. •  Formats include (but are not limited to) .csv, Excel charts, heat maps and Google maps showing device location data which can be supplied as both video and in image format (.jpg, .png). •  LEMON will work close with the client to further customize and refine current standard formats to best answer client specific questions regarding their fans’ migratory patterns. Any additional costs incurred from this additional service will be pre-­‐ agreed. 2 Confidential & Proprietary Information. All Rights Reserved.
  • 3. Data Analytics and Reporting Data analyzed and made available to client: •  Device universe •  Device decrease through attrition •  Active devices •  Message delivery, open rates, open rates/time •  Battery usage •  Device location – at event or world wide •  Device mobility •  Device type (OS) 3 Confidential & Proprietary Information. All Rights Reserved.
  • 4. App Universe Analysis •  LEMON will supply a breakdown of the number of devices that opt-­‐in to the location service (need total number of downloads from app producers to generate a % thereof) •  Reports show device opt-­‐ins over time to be aligned with external media campaigns to indicate success 4 Confidential & Proprietary Information. All Rights Reserved.
  • 5. Messaging •  Number of messages delivered and subsequently opened •  Number of messages delivered and or opened over time to be aligned with external campaign data to gauge success of campaigns •  Quick view of all events (active and disabled) •  Quick view of Events changing device cadence (frequency of location update) 5 Confidential & Proprietary Information. All Rights Reserved.
  • 6. Fan Mobility – Game Day •  Breakdown of fan mobility on game day (heatmaps) •  Depiction in time-­‐slices that give visual representation to device mobility over time •  Events and messaging can react to device numbers by identifying congestion points or fan congregations before or after game 6 Confidential & Proprietary Information. All Rights Reserved.
  • 7. Device Temporal Activity – Game Day Analysis of arrival time of fans and their proximity to the stadium , sponsor locations or other landmarks (such as pub or restaurant, public transport etc.) by using latitude and longitude. Different options available Traffic around Columbus Circle during large NY event # Devices Time 7 Confidential & Proprietary Information. All Rights Reserved.
  • 8. Device Home Location •  Anonymous analysis of fan home location and representation thereof in heat maps and other Google map representation •  Graphical representation of data in alternative formats for analysis and reporting 8 Confidential & Proprietary Information. All Rights Reserved.
  • 9. Demographic Profiling Anonymous analysis of fan location broken down in the categories of top neighborhoods, cities, regions and countries supplied in Excel and as visual representations (pie chart, graph, column) Top Regions Top Cities 5 6000 4.5 5000 4 4000 3.5 3 3000 2.5 2000 Series1 2 1000 1.5 Series1 Series2 1 0 0.5 Florida Pennsylvania North Carolina Maryland Ohio Louisiana Arizona Missouri Washington Tennessee 0 9 Confidential & Proprietary Information. All Rights Reserved.
  • 10. Thank You! For any additional information about our Data Analytics & Reporting tool set, please contact James Rodmell at james@lemonllc.com 10 Confidential & Proprietary Information. All Rights Reserved.