Mandrill

Suggest Edits

Clicked Email

Customer clicked a link from inside of an email

Type: Activity Transformation

select 
    s.uuid as activity_id,
    timestamp 'epoch' + s.ts * interval '1 second' as ts,

    NULL as anonymous_customer_id,
    
    s.msg_email as customer,
    
    'clicked_email' as activity,
    
    s.msg_template as feature_1,
    s.msg_subject as feature_2,
    s.user_agent_parsed_os_family as feature_3,
    
    NULL as revenue_impact,
    s.url as link

from mandrill.click s



Opened Email

Customer opened an email

Type: Activity Transformation

SELECT 
    s.uuid as activity_id,
    timestamp 'epoch' + s.ts * interval '1 second' as ts,

    NULL as anonymous_customer_id,
    
    s.msg_email as customer,
    
    'opened_email' as activity,
    
    s.msg_template as feature_1,
    s.location_city as feature_2,
    s.user_agent_parsed_os_name as feature_3,
    
    NULL as revenue_impact,
    NULL as link

from mandrill._open s

👍

Contribute to the Narrator Community

Help the Narrator community by suggesting edits or contributing SQL transformations. Use the "Suggest Edits" button at the top right or visit our Contributors page for more info on how to get involved.




Have questions?

Our data team is here to help! Here are a couple ways to get in touch...

💬 Chat us from within Narrator

💌 Email us at [email protected]

🗓 Or schedule a 15 minute meeting with our data team

Updated over 2 years ago

What’s Next

Don't see what you're looking for? Browse the Activity Index for more examples...