1
EMVI
EMAIL CONTENT MANAGEMENT SYSTEM
CS 410 Orange Team
www.cs.odu.edu/~410yello/
OUTLINE 1-4 Introduction 5-11 Case Study 12 Problem Statement 13 - - PowerPoint PPT Presentation
E M V I E MAIL C ONTENT M ANAGEMENT S YSTEM CS 410 Orange Team www.cs.odu.edu/~410yello/ 1 April 9, 2013 OUTLINE 1-4 Introduction 5-11 Case Study 12 Problem Statement 13 Solution Statement 14-21 Historical Background 22-23 Current
1
EMAIL CONTENT MANAGEMENT SYSTEM
CS 410 Orange Team
www.cs.odu.edu/~410yello/
2
April 9, 2013OUTLINE
Introduction Case Study Problem Statement Solution Statement Historical Background Current Process Goals and Objectives Improved Process Competition Component Analysis Milestones Database Structure User Interface Risks Conclusion References 1-4 5-11 12 13 14-21 22-23 24-25 26 27-29 30-31 32-38 39-43 44-51 52-57 58 59
3
INTRODUCTION
KEITH WALSH
4
April 9, 2013ROLES
CLASS PRIMARY SECONDARY WEBMASTER Chris Yolanda EXPERT LIAISON Keith Chris POWER POINT Richard Keith RISK TRACKING Yolanda David COMPETITION David Tamara PROJECT MANAGER Tamara Richard PRODUCT PRIMARY SECONDARY WEB DEVELOPER / UI Yolanda David SOFTWARE DEVELOPER Chris Richard DATABASE DEVELOPER David Keith DOCUMENTATION Tamara Yolanda INTEGRATION/API Richard Chris PROJECT MANAGER Keith Tamara5
CASE STUDY
KEITH WALSH
6
MARKETING DEPARTMENTMICROSOFT CASE STUDY
CASE STUDY IDENTIFIED7
RACI CHART TASK
MARKETING AGENCY OPERATIONS STRATEGY R C C COPY & COLOR A R C UPLOAD IMAGES A I R SEND PREVIEWS A I R TEST A R C APPROVE R C C SEND A I R TRACK A I R ANALYZE A C R REPORT R C C CASE STUDY IDENTIFIEDMICROSOFT CASE STUDY
8
TASK MARKETING AGENCY OPERATIONS STRATEGY R C C COPY & COLOR A R C UPLOAD IMAGES A I R SEND PREVIEWS A I R TEST A R C APPROVE R C C SEND A I R TRACK A I R ANALYZE A C R REPORT R C CMISMATCH
CASE STUDY IDENTIFIED Responsible Accountable Consulted InformedMICROSOFT CASE STUDY
9
TASK MARKETING AGENCY OPERATIONS STRATEGY R C C COPY & COLOR A R C UPLOAD IMAGES A I R SEND PREVIEWS A I R TEST A R C APPROVE R C C SEND A I R TRACK A I R ANALYZE A C R REPORT R C CIMPROVEMENT
R R CASE STUDY IDENTIFIED Responsible Accountable Consulted InformedMICROSOFT CASE STUDY
R R10
TESTING COMPLEXITY
Clients: Android AOL Apple Mail Blackberry Gmail Hotmail iPad iPhone Lotus Outlook Outlook.com Thunderbird Yahoo Windows Phone ETC! Browsers: Chrome Firefox Internet Explorer Opera Safari Versions: 4, 4S, 5 2000, 2003,…,2013 Jelly Bean, ICS Operating Systems: Windows Android OS X ETC! CASE STUDY IDENTIFIEDMICROSOFT CASE STUDY
11
Correct Rendering - Outlook Incorrect Rendering – Lotus NotesTESTING SIGNIFICANCE
CASE STUDY IDENTIFIEDMICROSOFT CASE STUDY
Apology – Wrong Content Apology – Broken Links12
April 9, 2013THE PROBLEM STATEMENT
The process
email content and testing across all emails clients is time consuming and complicated.
PROBLEM IDENTIFIED13
April 9, 2013THE SOLUTION STATEMENT
SOLUTION IDENTIFIEDProvide a stand-alone email marketing content management system that streamlines the development and testing process so designers can perform end-to-end testing independently.
14
BACKGROUND
RICHARD TRUCHANOWICZ
15
April 9, 2013WHY EMAIL MARKETING?
Has it not been replaced in the realm of modern communication by: texting instant messaging tweeting wall posting blogging pinning checking in yelping etc… etc...
PROBLEM HISTORICALLY DEFINED16
PROBLEM HISTORICALLY DEFINEDEMAIL IS…
17
PROBLEM HISTORICALLY DEFINED 500 1000 1500 2000 2500 3000 3500 4000 4500 2012 2013 2014 2015 2016 Worldwide Email Accounts in Millions…ABUNDANT!
SOURCE: The Radicati Group, Inc - Email Market, 2012-201618
PROBLEM HISTORICALLY DEFINEDOnce per week or less 2-6 times per week 1-3 times daily 4+ times daily
31% 32% 26% 11%
…CHECKED OFTEN!
SOURCE: Merkle, “View from the Digital Inbox”19
PROBLEM HISTORICALLY DEFINED SOURCE: SOS Emarketing November 15, 2011…A GOOD INVESTMENT!
$0 $5 $10 $15 $20 $25 $30 $35 $40 $45 ROI PER DOLLAR SPENTMARKETING CHANNEL
4000%
20
PROBLEM HISTORICALLY DEFINED…BIG BUSINESS!
Spent on Email Marketing in 2012
$1.3 Billion
SOURCE: The Radicati Group, Inc - Email Market, 2012-201621
19% 32% 16% 22% 1% 1% 1% Increase more than 30% Increase 10% to 30% Increase less than 10% 2012 will stay the same as 2011 Decrease less than 10% Decrease 10% to 30% Decrease more than 30%97% of companies
expected increase or maintain their email marketing budgets
PROBLEM HISTORICALLY DEFINED SOURCE: 2011 Marketing Sherpa Email Marketing Benchmark Survey…STILL GROWING!
2012 PROJECTIONS
22
PROCESS ANALYSIS
RICHARD TRUCHANOWICZ
23
OPERATIONS CREATIVE AGENCY MARKETING
CURRENT PROCESS
REPORT RESULTS TO MARKETING COLLECT ANALYTICS DISPATCH EMAIL TO MAILING LISTS SEND APPROVAL TO OPERATIONS YES MAKE CORRECTIONS NO TESTS PASSED? EVALUATE TEST EMAILS IN ALL EMAIL CLIENTS SEND TEST EMAILS LOAD ASSETS INTO OUTBOUND TOOL UPLOAD IMAGES TO CDN APPROVE ASSETS FOR TESTING NO YES NO ASSETS APPROVED ? SEND TO MARKETING FOR REVIEW GENERATE CAMPAIGN ASSETS BRIEF CREATIVE AGENCY CREATE CAMPAIGN CONCEPT ASSETS APPROVED ? YES CURRENT PROCESS24
Streamline the email testing process to enable rapid iteration on designs.
GOAL
SOLUTION GOALS25
AUTOMATE:
OBJECTIVES
OBJECTIVES IDENTIFIED26
OPERATIONS CREATIVE AGENCY MARKETING
PROPOSED PROCESS
REPORT RESULTS TO MARKETING COLLECT ANALYTICS DISPATCH EMAIL TO MAILING LISTS SEND APPROVAL TO OPERATIONS YES NO ASSETS APPROVED ? YES MAKE CORRECTIONS NO TESTS PASSED? EVALUATE TEST EMAILS IN ALL EMAIL CLIENTS SEND TEST EMAILS UPLOAD CONTENT INTO EMVI GENERATE CAMPAIGN ASSETS BRIEF CREATIVE TEAM CREATE CAMPAIGN CONCEPT IMPROVED PROCESS IDENTIFIED27
COMPETITION
TAMARA JONES
28
COMPETITION MATRIX
COMPETITION IDENTIFIED EMVI LITMUS EXACT TARGET DRUPAL EMAIL CAMPAIGN CREATION X X X CUSTOMIZABLE X X DOWNLOADABLE X X E-MAIL TESTING CAPABILITY X X WEB BASED X X X X CONTENT MANAGEMENT SYSTEM X X CONTENT DISTRIBUTION NETWORK INTEGRATION (IMAGE HOSTING) X X X MONTHLY PRICING OPTIONS Free $49 a month per user Usage Dependent Free29
April 9, 2013 FEATURE INCLUDED VIA API API(S) SUPPORTED Version Control Yes No Access Control Yes No Approval Tracking Yes No Preview Across Email Clients Yes Yes Litmus or EOA Upload Images to CDNs Yes Yes AWS, Akamai, Azure Upload HTML and Text Docs Yes No Send Text Email to List Yes No Send Multipart Email to List Yes No Template Based Creation TBD No Edit HTML and Text Docs TBD No Image Editing No No Upload Target Email List No No Send Email Campaign No No Track Email Campaign No No Email Metrics No NoFEATURE MATRIX
29
30
COMPONENT ANALYSIS
TAMARA JONES
31
MFCD
EMVI
In Scope Manual DESKTOP APPS (i.e. Photoshop, Dreamweaver)32
MILESTONES
CHRIS DASHIELL
33
HIGH LEVEL OVERVIEW
MILESTONESSoftware Third Party
Hardware
EMVI
34
HARDWARE
MILESTONESHardware Servers
Development Machines
35
3RD PARTY SOFTWARE
MILESTONESThird Party
CDN and Test Renderer via APIDatabase Engine
Play Framework
36
WEB SERVER
MILESTONESSoftware
Interface with Third Party API Access Control System Public API Webpage Logic Database Interface Email SMTP InterfaceDatabase
Graphical User InterfaceWeb Server
37
SITEMAP
SITE OVERVIEW38
API INTERFACES
MILESTONESCDN
Software
Database
Graphical User InterfaceWeb Server
Email Preview Renderer Interface with Third Party API39
DATABASE
DAVID WISE
40
DATABASE
MILESTONES Access Control Schema Version Control Data SchemaSoftware
Interface with Third Party APIDatabase
Graphical User InterfaceWeb Server
41
DATABASE SCHEMA
DATABASE42
CAMPAIGN ERD
DATABASE has CampaignID, VerID, StartDate, EndDate, CStatusID, StatusDate, UID CAMPAIGN IMAGES has CAMPAIGN EMAIL has CAMPAIGN OWNERS ImagesID, CampaignID, Name, URL, Tag CEmailID, CampaignID, EMailAddress COwnerID, CampaignID has CAMPAIGN VERSIONS VerID, CampaignID, CampaignURL, VersionDate, CurrentVer43
USER ERD
DATABASE has UID, LocID, Fname, MI, Lname, UserName, Email, PhNum, Pass, Status, RoleID USER LOCATION has ROLE LocID, Street, City, State, Zip, PhNum RoleID, RoleName44
USER INTERFACE
DAVID WISE
45
GUI
MILESTONESLogin Page
Admin Page
Email Preview Page Approval Page Creator Page Sender PageSoftware
Interface with Third Party APIDatabase
Graphical User InterfaceWeb Server
46
LOGIN PAGE
WEB USER INTERFACEEMVI
Login" EmVi www.EmVi.com47
REGISTRATION EMAIL
WEB USER INTERFACE gmail.google.com Gmail48
ADMIN ROLE UI
WEB USER INTERFACEEMVI
Signed in as David. Your role is Admin.ADMIN
PREVIEWS49
CREATOR ROLE UI
WEB USER INTERFACEEMVI
Signed in as Joe. Your role is Creator.CREATOR
50
EMVI
Signed in as John. Your role is Approver.APPROVER
PREVIEWSAPPROVER ROLE UI
WEB USER INTERFACE SUBMISSIONS51
SENDER ROLE UI
WEB USER INTERFACEEMVI
Signed in as Jill. Your role is Sender.SENDER
PREVIEWS52
RISKS
YOLANDA QUINONES
53
RISK MATRIX
RISKS Consumer Risks: C1: System Maintenance C2: Associated Costs C3: Campaign Security Technical Risks: T1: Program Latency/Scaling T2: Problematic Version Control T3: Problems Rendering Test Emails T4: Security RisksC1
C2 T1 C3
T3 T2 T4
IMPACT PROBABILITY54
RISKSCONSUMER RISKS
C2: Associated Costs
Impact-3 Probability-4 Risk: Marketing teams will have a cost associated with planning, resources, and time. Risk Strategy: Ensure marketing teams know and understand the costs upfront, and try to mitigate them. C1 C2C1: System Maintenance
Impact-3 Probability-5 Risk: Software will be open source. Marketing teams will be responsible for maintaining and extending the scope of the solution. Risk Strategy: Will provide a well documented design for easy turnover.55
RISKSCONSUMER RISKS
C1 C2 C3C3: Campaign Security
Impact-2 Probability-2 Risk: Possible application vulnerabilities allow unauthorized personnel access to working campaigns. Risk Strategy: Implement and enforce proper security protocols.56
T2: Problematic Version Control
Impact-5 Probability-2 Risk: Automatic version control does not work in some cases. Risk Strategy: Provide a manual interface for the version control allowing for the automatic version control to be overridden when needed. RISKSTECHNICAL RISKS
C1 C2 T1 C3 T2T1: Latency/Scaling
Impact-3 Probability-3 Risk: The algorithms used to implement the solution take too much time processing data, or adding multiple tasks and campaigns cause the system to experience data latency. Risk Strategy: Create better57
TECHNICAL RISKS
T4: Security Risks
Impact-4 Probability-1 Risk: Permissions software does not function correctly. Risk Strategy: Implement industry standard best practices and utilize proven frameworks. RISKS C1 C2 T1 C3 T3 T2 T4T3: Rendering Errors
Impact-4 Probability-2 Risk: Rendering of test campaigns incorrect or nonexistent. Risk Strategy: If the programming associated with automatically rendering the test email campaigns is too challenging, implementation will instead provide a test email and the clients will manually check the campaigns.58
CONCLUSION
YOLANDA QUINONES
59
REFERENCES
REFERENCES 2011 MARKETING SHERPA EMAIL MARKETING BENCHMARK SURVEY www.marketingsherpa.com/2011EmailBMR_ExecSummary_Final_101110.pdf VIEW FROM THE DIGITAL INBOX 2011 www.jonrognerud.com/docs/Merkle_Digital_Inbox_2011.pdf THE RADICATI GROUP EMAIL MARKET, 2012-2016 http://www.radicati.com/?p=8963 SOS EMARKETING, ROI COMPARISON ACROSS MEDIA CHANNELS www.sosemarketing.com/2011/11/15/roi-comparison-across-media-channels-email-marketing-wins-by-a-landslide/ LITMUS www.litmus.com/ EmailReach www.emailreach.com/ EMAILONACID www.emailonacid.com/ Campaigner www.campaigner.com/60
QUESTIONS? COMMENTS?
61
APPENDIX
62
RISK MATRIX
Technical Risks: T1: Program Latency T2: Problems Rendering Test Emails T3: Security Risks T4: Problematic Version Control T5: Scaling Consumer Risks: C1: Information Loss C2: Image Security C3: Campaign Security C4: System Maintenance C5: Associated Costs Developmental Risks: D1: Lack of Consumer Interest D2: Lack of Trust in Solution D3: Time Constraints D4:tbdtbdtbd D5: tbd tbd tbd RISKS IDENTIFIED63
C1: Information Loss Risk: Data stored utilizing EmVi is lost Risk Strategy: Store backups on separate servers that are in another location C2: Image Security Risk: Images uploaded to CDN are not technically secure Risk Strategy: Images can only be accessed by direct link, ensure links are secure and protected C3: Campaign Security Risk: Possible application vulnerabilities allow unauthorized personnel approval permissions Risk Strategy: TBD-GROUP MEETING 2/26 C4: System Maintenance Risk: Software will be open source, marketing teams will be responsible for maintaining and extending the scope of the solution Risk Strategy: TBD- GROUP MEETING 2/26 C5: Associated Costs Risk: Marketing Teams will have a cost associated with planning, resources, and time. Risk Strategy: Ensure marketing teams know and understand the costs upfront, and try to mitigate costsCONSUMER RISKS
RISKS IDENTIFIED64
D1: Lack of Consumer Interest Risk: Teams feel current systems are efficient Risk Strategy: EmVi will provide users with an API that will allow users to integrate the parts of their current system that they feel are efficient D2: Lack of Trust in Solution Risk: Teams feel that EmVi will not be able to improve current workflow Risk Strategy: EmVi will be versatile and will have the capability of improving their workflow -WIP D3: Time Constraints Risk: Yellow Team only has one semester to work on this solution Risk Strategy: Create all critical components of the solution and build from there. It is open source, so there will be the potential for further design in the futureDEVELOPMENTAL RISKS
RISKS IDENTIFIED65
T1: Program Latency Risk: The algorithms used to build our solution take too much time processing data Risk Strategy: Create better algorithms, utilize Dr. Zeil T2: Problems Rendering Test Campaigns Risk: Rendering of test campaigns incorrect or nonexistent Risk Strategy: If the programming associated with automatically rendering the test email campaigns is too challenging, we will provide a test email and the clients will manually check the campaigns T3: Security Risks Risk: Permissions software does not function correctly Risk Strategy: TBD-GROUP MEETING 2/26 T4: Problematic Version Control Risk: Automatic version control does not work in some cases Risk Strategy: Provide a manual interface for the version control T5: Scaling Risk: A single task might not be resource intensive, but when multiple tasks and campaigns are added EmVi experiences data latency Risk Strategy: Create better algorithms and ensure we do multiple levels of testingTECHNICAL RISKS:
RISKS IDENTIFIED66
COMPUTER COMPONENTSMFCD
67
April 9, 2013BOTTOM LINE
SOURCE: THE RADICATI GROUP, INC EMAIL MARKET 2012-2016 PROBLEM HISTORICALLY DEFINED68
April 9, 2013EMAIL MARKETING INDUSTRY LANDSCAPE
69
April 9, 2013WHY IS EMAIL MARKETING SUCCESSFUL? • 30% of non-business email
engagement time is devoted to commercial email which consumers70
April 9, 2013WHAT MAKES EMAIL MARKETING SUCCESSFUL?
71
April 9, 2013BENEFITS
OF EMVI
Integrative
upload media
emails
resources
72
April 9, 2013POSSIBLE PROBLEMS
WITH
EMVI
performance
integrate preview
HTML
PROBLEMS WITH SOLUTION73
TOOLS
NETWORKS
TEMPLATES
LIMITATIONS OF EMVI
RISKS