Narrator Documentation

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 source,
    NULL as source_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 source,
    NULL as source_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-min meeting with our data team

Updated 8 months ago


What's Next

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

Transformations by Activity

Mandrill


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.