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?