Question
python journey_id subscriber_key sendout_date email_scope total_email_sent total_email_delivered total_email_clicks total_email_open total_email_bounces total_sessions total_pageviews global_opt_in gender flag_unsubscribe CA109963-EF62-4C93-9B83-1241878720DE 15597b76e2594c6abce93391553c89a6 2021-06-08 00:00:00 Campaign 1 1 0 1 0
python
| journey_id | subscriber_key | sendout_date | email_scope | total_email_sent | total_email_delivered | total_email_clicks | total_email_open | total_email_bounces | total_sessions | total_pageviews | global_opt_in | gender | flag_unsubscribe |
| CA109963-EF62-4C93-9B83-1241878720DE | 15597b76e2594c6abce93391553c89a6 | 2021-06-08 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | m | |||
| F6E3A4E0-376F-4B2F-B6AB-8F91CC7A4D77 | 4994f03f1efa4c7a975cc69724f079e4 | 2021-10-19 00:00:00 | Campaign | 1 | 0 | 0 | 0 | 1 | TRUE | m | |||
| 8AE912AA-2C9F-43A0-9B1B-634CF6826820 | 87b52787df814ac788ddefe90c463dd6 | 2021-08-04 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | f | |||
| 9A8BFD01-EB0F-4A08-8CBA-99771ED4567A | 8c5a19b0ae464b27b6b2077d3f34d89f | 2021-05-28 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | f | |||
| C967F70E-AA56-4A88-BF82-C4BD046FC525 | 7951a93a89774492b5930b368d0971da | 2021-05-06 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | m | |||
| F6CEABD8-242B-4C51-8B0C-81FF1C39D10D | 6d2cd4561d774e03af7fadfe1ba96cc9 | 2021-09-28 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | m | |||
| A1462356-9931-4E4C-AE6B-7788EBA82A1C | 455efd1d73384f46b80bc89b62b59fab | 2021-08-24 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | m | |||
| 8CEA98E0-5707-473B-A38C-98361F836FF6 | 42fd6400027b4c08be0b2520431a329f | 2021-07-22 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | m |
#Calculate the Open Rate (OR) #and the Click to Open Rate (CTOR) for each campaign (journeys_id) #What is the AVG OR and AVG CTOR for all the campaigns launch during 2021?
#Identify the top 3 campaigns with best performance by OR and CTOR
#Is the campaign with the lowest performance are those with the higher number of "flag_unsubscribe" == TRUE or these variables are not related?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement
Authors: Eric Redmond ,Jim Wilson
1st Edition
1934356921, 978-1934356920
