Using the sqlda database under Loading the Sample Datasets instructions there are over 100 emails that contain an opened date BEFORE the sent date. After looking at the data, why is this the case?
Added by Jes-S C.
Step 1
** Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 91 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Database Analysis Exercise Open the Snappos email database. Snappos is a hypothetical online shoe retailer (like Zappos). Snappos has only recently begun their email marketing efforts. They have collected 250 email addresses and have been sending bi-weekly emails to their entire email list for the last eight weeks. They have made no efforts to clean, segment, or optimize their email list in any way. The database provides information about the 16 sent emails and the resulting action of each of the 250 members of the email list. Information About the Emails The coding key for the emails is as follows: Key Time of Day Offer Category 1 Early Morning BOGO Women's athletic shoes 2 Late Afternoon 20% off Women's dress flats 3 Afternoon 30% off Women's high heels 4 Evening 50% off Women's sandals 5 New products Women's slippers 6 Free shipping Women's boots 7 Men's athletic shoes 8 Men's sandals 9 Men's dress shoes 10 Men's boots Each of the 16 emails had the same layout with three visual fields: Each field featured one of ten possible shoe categories. Emails were sent at various times of the day. The subject line of each email featured an offer and highlighted the product category in field 1. Email 1 has the following properties: ToD 4 Offer 5 F1 3 F2 1 F3 6 This means this email was sent in the evening. The subject line talked about new products, specifically new women’s high heels. Women’s high heels were pictured in field 1; women’s athletic shoes were pictured in field 2; and women’s boots were pictured in field 3. Email Response Below is the response key. 0 Delivered, unopened 1 Hard bounce 2 Soft bounce 3 Delivered, opened 4 Field 1 clicked 5 Field 2 clicked 6 Field 3 clicked Most emails were delivered, but unopened (which is typical of email lists). Emails could also bounce via hard or soft bounce, or be delivered (but result in no clicks). Recipients who opened the email and clicked on one of the fields are coded 4, 5, or 6 to indicate which field they clicked. Analyze the email data to answer the following questions. What is the best time of day to send emails?
Akash M.
Which two columns are mislabeled? First name Last name State Order type First order date Most recent order date None; all columns are correct
Donna D.
Your company recently moved to a new data storage system. As part of your monthly work, you check for any invoices that do not have a CustomerOrderID. You find 10. What does this most likely mean?
Breanna O.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD