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
| 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 | |||
| 10D727BD-2F62-4785-9867-058EEACB4B0B | 430afd54922f413aa172d4a9f845a746 | 2021-02-23 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | m | |||
| A1462356-9931-4E4C-AE6B-7788EBA82A1C | 4797b27a5da5488a94b610c5fc44aeea | 2021-08-24 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | TRUE | m | |||
| 5A7A1E43-69A2-488C-8DA9-38BD5BA01D94 | c62122cefd4e4b4e9cb5edefb508a06a | 2021-08-19 00:00:00 | Campaign | 1 | 1 | 0 | 1 | 0 | FALSE | m |
python
# Group the dataset by Journey_id to identify the performance of each campaign,
#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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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
Authors: Ted Dunning, Ellen Friedman
1st Edition
1491914726, 978-1491914724
