Case Study 2: Improving E-Mail Marketing Response

Case Study 2: Improving E-Mail Marketing Response Order Description see Week 8 Case Study attachment •    Read the following case study. Students, please view the "Submit a Clickable Rubric Assignment" in the Student Center. Instructors, training on how to grade is within the Instructor Center. A company wishes to improve its e-mail marketing process, as measured by an increase in the response rate to e-mail advertisements. The company has decided to study the process by evaluating all combinations of two (2) options of the three (3) key factors: E-Mail Heading (Detailed, Generic); Email Open (No, Yes); and E-Mail Body (Text, HTML). Each of the combinations in the design was repeated on two (2) different occasions. The factors studied and the measured response rates are summarized in the following table. Table: Improving Email Response Rate Run    Heading    Email Open    Body    Replica    Response Rate 1    Generic    No    Text    1    46 2    Detailed    No    Text    1    34 3    Generic    Yes    Text    1    56 4    Detailed    Yes    Text    1    68 5    Generic    No    HTML    1    25 6    Detailed    No    HTML    1    22 7    Generic    Yes    HTML    1    21 8    Detailed    Yes    HTML    1    19 1    Generic    No    Text    2    38 2    Detailed    No    Text    2    38 3    Generic    Yes    Text    2    59 4    Detailed    Yes    Text    2    80 5    Generic    No    HTML    2    27 6    Detailed    No    HTML    2    32 7    Generic    Yes    HTML    2    23 8    Detailed    Yes    HTML    2    23 Write a two to three (2-3) page paper in which you: 1.    Use the data shown in the table to conduct a design of experiment (DOE) in order to test cause-and-effect relationships in business processes for the company. 2.    Determine the graphical display tool (e.g., Interaction Effects Chart, Scatter Chart, etc.) that you would use to present the results of the DOE that you conducted in Question 1. Provide a rationale for your response. 3.    Recommend the main actions that the company could take in order to increase the response rate of its e-mail advertising. Provide a rationale for your response. 4.    Propose one (1) overall strategy for developing a process model for this company that will increase the response rate of its e-mail advertising and obtain effective business process. Provide a rationale for your response. Your assignment must follow these formatting requirements: •    Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions. •    Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. The specific course learning outcomes associated with this assignment are: •    Build regression models for improving business processes. •    Design experiments to test cause-and-effect relationships in business processes. •    Use technology and information resources to research issues in business process improvement. •    Write clearly and concisely about business process improvement using proper writing mechanics. Run    Heading (x1)    Email Open(x2)    Body(x3)    x1 x2    x1x3    x2x3    x1x2x3    Repeat Rate 1    Repeat Rate 2    Average RR    SD RR 1    Generic(-)    No(-)    Text(-)    +    +    +    -    46    38    42    5.656854249 2    Detailed(+)    No(-)    Text(-)    -    -    +    +    34    38    36    2.828427125 3    Generic(-)    Yes(+)    Text(-)    -    +    -    +    56    59    57.5    2.121320344 4    Detailed(+)    Yes(+)    Text(-)    +    -    -    -    68    80    74    8.485281374 5    Generic (-)    No(-)    HTML(+)    +    -    -    +    25    27    26    1.414213562 6    Detailed(+)    No(-)    HTML(+)    -    +    -    -    22    32    27    7.071067812 7    Generic(-)    Yes(+)    HTML(+)    -    -    +    -    21    23    22    1.414213562 8    Detailed(+)    Yes(+)    HTML(+)    +    +    +    +    19    33    26    9.899494937 sum+    163    179.5    101    168    152.5    126    145.5 sum-    147.5    131    209.5    142.5    158    184.5    165 ave +    40.75    44.875    25.25    42    38.125    31.5    36.375 ave-    36.875    32.75    52.375    35.625    39.5    46.125    41.25 effect    3.875    12.125    -27.125    6.375    -1.375    -14.625    -4.875 Regression Coefficients b0 =    77.625    1    77.625        Run    Regression b1=    1.9375    1    1.9375        1    80.8 b2=    6.0625    1    6.0625        2    74.8 b3=    -13.5625    1    -13.5625        3    96.3 b4=    3.1875    1    3.1875        4    112.8 b5 =    -0.6875    1    -0.6875        5    64.8 b6=    -7.3125    1    -7.3125        6    65.8 b7=    -2.4375    1    -2.4375        7    60.8 64.8125        8    64.8 Regression Model y = 77.625 + 1.9375 x1 + 6.0625 X2 -13.5625 x3 + 3.1875 x1 x2 -0.6875 x1 x3 -7.3125 x2 x3 - 2.4375 x1 x2 x3 Interaction Effect Chart Example Generic(-)    42    57.5 Detailed(+)    36    74 Format of email heading has small effect Using detailed Email heading attracts much higher response rate when email is open