data visualization storytelling and reporting #brightonseo - aaron friedman

55
@aaronfriedman BRINGING SEXY BACK How a Story Can Enhance Your Data and Client Relationships

Upload: aaron-friedman

Post on 22-Jan-2015

7.028 views

Category:

Marketing


0 download

DESCRIPTION

This is a presentation I gave at BrightonSEO on Data visualization, storytelling, and reporting. Here are some of the links I mentioned: The Report - http://bit.ly/brighton-report Offset Video - http://bit.ly/1xJO3Si Annie Cushing Discount - http://www.annielytics.com/blog/coupon/brighton/ Video of Magic Trick:

TRANSCRIPT

  • 1. @aaronfriedmanBRINGING SEXY BACKHow a Story Can Enhance Your Data and Client Relationships

2. @aaronfriedmanhttp://www.sperience.com/wp-content/uploads/2014/03/Justin-Timberlake-Wallpaper-60.jpgAfter All, Sex Sells 3. @aaronfriedmanAARON FRIEDMANIndependent Inbound Marketing Consultantand lead marketer at &[email protected]@aaronfriedman 4. @aaronfriedmanI HAVE DONE SEO FOR SOME BIG BRANDS 5. @aaronfriedmanI have not come to tell you anything you dont know 6. @aaronfriedmanSTORIESAREPOWERIf you know how to use the data to tell the stories, than the power is yours 7. @aaronfriedmanTHE POWER TO CHANGE OUR PERSPECTIVEhttp://www.spin.com/sites/all/files/styles/style820_546/public/130207-justin-timberlake.png 8. @aaronfriedmanThey Are The Reason We Can Behttp://thisisiantan.files.wordpress.com/2013/04/20130402-015512.jpg?w=500&h=700 9. @aaronfriedmanThey Are The Reason We Can BeFoundershttp://www.guitargirlmag.com/news/myspace-2-0---can-timberlake-bring-sexy-back 10. @aaronfriedmanThey Are The Reason We Can BePhilosophershttp://media3.onsugar.com/files/2013/11/04/848/n/1922398/34b2c587b22515ca_justinPINTEREST.xxxlarge/i/Justin-Timberlake-has-thing--between.jpg 11. @aaronfriedmanThey Are The Reason We Can BeDancershttp://www.zap2it.com/blogs/where-is-justin-2008-11 12. @aaronfriedmanWhat do Storiesdo for us?http://i.ytimg.com/vi/efNzhEKm3w4/maxresdefault.jpg 13. @aaronfriedmanMASSIVE SPIKE IN CURIYO LOOKUPSWUT HAPPENED?!?! 14. @aaronfriedmanCELEBRITY NUDITY! (and dancing)WUT HAPPENED?!?! 15. @aaronfriedmanVARIOUS SCENARIOSWe still dont have answered, but this data, and scenarios, have led us to a point of additional testing and questioning what users want and why they click.1.People wanted to see porn and thought the link would take them there2.They were curious who 4Chan was#BETHANYMOTAWHO?? 16. @aaronfriedmanTHE JUNE SQUIBB PHENOMENON 17. @aaronfriedmanTHIS IS NO DIFFERENT THAN CLIENT COMMUNICATIONhttp://ewwatchingtv.files.wordpress.com/2009/04/justintimberlake_l.jpg 18. @aaronfriedmanTHE PERSON YOU SEND IT TOhttp://thisisiantan.files.wordpress.com/2013/04/20130402-014601.jpg?w=500&h=355 19. @aaronfriedmanMIGHT NOT BETHE PERSON WHOCARES 20. @aaronfriedmanMIGHT NOT BETHE PERSON WHOMAKES DECISIONS 21. @aaronfriedmanOr, they might just not understand what you are trying to sayhttp://img2.timeinc.net/ew/i/2013/03/13/fallon-timberlake-sexyback_510x317.jpg 22. @aaronfriedmanOverall Traffic Down -9.10% 23. @aaronfriedmanOverall Revenue Growth+ 67.18% 24. @aaronfriedmanOUR REPORTING IS FLAWED 25. @aaronfriedmanLIKE, REALLY UN-INFORMATIVE FLAWED 26. @aaronfriedmanOUR RANKING REPORTS SUCK 27. @aaronfriedmanLEGIT HOW I IMAGINE MY CLIENTS IF THEY GOT THIShttp://cdn.3news.co.nz/3news/AM/0-Articles/217095/justin-timberlake_socialnetwork.jpg?width=700 28. @aaronfriedmanBUT WE HAVE STORIES TO TELLhttp://i.dailymail.co.uk/i/pix/2013/12/19/article-0-1A3264FA00000578-604_634x422.jpg 29. @aaronfriedmanhttp://blog.nuserve.co.uk/wp-content/uploads/2013/12/JT_Sean_Parker_blog.jpg 30. @aaronfriedmanCREATED A NEW TEMPLATEThis is nothing original. Anyone with a little basic skill in excel can do it.Makes data pulling:FastEfficientAccurate (removes the possibility of human error)* This is a re-make of a post I wrote on Moz.comGET YOUR COPY HEREhttp://bit.ly/brighton-report 31. @aaronfriedmanTHE REPORTING PACKAGE HOW-TOSEO Tools for ExcelExcel Formulas and FunctionsCreativity to tell the story 32. @aaronfriedmanPULLING THE DATA WITHFirst Figure out Which is the right profile. 33. @aaronfriedmanFirst Figure out Which is the right profile.Choose Dimensions and MetricsPULLING THE DATA WITH 34. @aaronfriedmanFirst Figure out Which is the right profile.Choose Dimensions and MetricsAdd in Any SegmentsPULLING THE DATA WITH 35. @aaronfriedmanFirst Figure out Which is the right profile.Choose Dimensions and MetricsAdd in Any SegmentsPut in the appropriate FiltersPULLING THE DATA WITH 36. @aaronfriedmanPULLING THE DATA WITH 37. @aaronfriedmanBOOM! 38. @aaronfriedmanPULLING THE DATA FROM THE DATAThis happens automatically from the last sheetCopy and PATE VALUES into the appropriate monthPRO TIP:This is a common theme throughout the entire report. Pull in the data you want to copy to that sheet. 39. @aaronfriedmanMANIPULATE YOUR DATA WITH OFFSETS 40. @aaronfriedmanWATCH MORE: http://bit.ly/1xJO3Si 41. @aaronfriedmanKeyword Research..BORING! 42. @aaronfriedmanWordclouds 43. @aaronfriedmanEXTRA FEW HUNDREDS OF VISITS A DAYEXTRA FEW THOUSANDSOF VISITS A MONTH 44. @aaronfriedmanGOOGLE BENCHMARK REPORTSAnnounced on Sept 10thCompare yourself in your industryhttp://analytics.blogspot.com/2014/09/new-benchmarking-reports-help- twiddy.html 45. @aaronfriedmanTHERE ARE SOME OPTIONS IF YOU DONT WANT TO MAKE A WHOLE REPORT FOR YOURSELF 46. @aaronfriedmanFully Automated, Pre Built, Reportshttp://www.annielytics.com/blog/coupon/brighton/ 47. @aaronfriedmanDashboard Solution 48. @aaronfriedmanHOW ABOUT CONTENT?http://www.chilightful.com/wp-content/uploads/2014/02/insert.visual.artwork.jpg 49. @aaronfriedmanJust Visualize the Data Different:http://www.davidmccandless.com/ 50. @aaronfriedmanWHO CAN GUESS WHAT THIS IS? 51. @aaronfriedmanTHIS IS $111.6 MILLIONIN DONATIONSFacebook plotted out how the ice bucket challenge spread across the US in a data analysis post they had, which is eye opening!Read more: http://marketingland.com/als-ice- bucket-challenge-viral-success-cause- 96463 52. @aaronfriedmanLet The DatasetChange Your Mindset-Hans Roslinghttp://www.ted.com/talks/david_mccandless_the_beauty_of_data_visualization 53. @aaronfriedmanITS ALL ABOUT THE DATAhttp://blog.tiqiq.com/wp-content/uploads/2013/05/Justin-Timberlake.pngBUT ITS ALL ABOUT PRESENTATION 54. @aaronfriedmanYOU ARE BEAUTIFULNOW MAKE YOUR DATA LOOK NICE TOO! 55. @aaronfriedmanAARON [email protected]@aaronfriedman