mta-credit-card-stats.py

df_scatter = df_multi.copy()

df_scatter['Coverage'] = df_scatter['Channel'].map(
    campaign_data.groupby('channel')['customer_id'].nunique().to_dict()
)

df_scatter['Total Clicks'] = df_scatter['Channel'].map(
    journeys['path'].apply(lambda x: x[-2]).value_counts().to_dict()
)

df_scatter['Activation Clicks'] = df_scatter['Channel'].map(
    journeys.loc[
        journeys.path.apply(lambda x: x[-1]) == 'Activation', 
        'path'
    ].apply(lambda x: x[-2]).value_counts().to_dict()
)

df_scatter['Attribution'] = df_scatter['Activations'] / df_scatter['Activations'].sum()
df_scatter['Activation Rate'] = df_scatter['Activations'] / df_scatter['Coverage']
df_scatter['Click Activation Rate'] = df_scatter['Activation Clicks'] / df_scatter['Total Clicks']