Narrator Documentation

Received Email

An email was delivered to the user


Postmark webhooks the data to you EL system. They only give you a tag for the data so make sure you set the tag.

Type: Activity Transformation

SELECT
    e.message_id AS activity_id,
    e.delivered_at AS ts,


    NULL AS source,
    NULL AS source_id,
    e.recipient AS customer,


    'received_email' AS activity,


    e."tag" AS feature_1,
    NULL AS feature_2,
    NULL AS feature_3,


    NULL AS revenue_impact,
    NULL AS link

FROM postmark.events e 
where e.record_type = 'Delivery'

Opened Email

An email was opened

Type: Activity Transformation

SELECT
    e.message_id || e.received_at AS activity_id,
    e.received_at::TIMESTAMPTZ::TIMESTAMP AS ts,


    NULL AS source,
    NULL AS source_id,
    e.recipient AS customer,


    'opened_email' AS activity,


    e."tag" AS feature_1,
    JSON_EXTRACT_PATH_TEXT(e.client, 'Name') AS feature_2,
    e.read_seconds AS feature_3,


    NULL AS revenue_impact,
    NULL AS link

FROM postmark.events e 
where e.record_type = 'Open'



Bounced Email

An email was bounced

Type: Activity Transformation

SELECT
    e._id AS activity_id,
    e.bounced_at::TIMESTAMPTZ::TIMESTAMP AS ts,


    NULL AS source,
    NULL AS source_id,
    e.email AS customer,


    'bounced_email' AS activity,


    e."tag" AS feature_1,
    e.description AS feature_2,
    e.subject AS feature_3,


    NULL AS revenue_impact,
    NULL AS link

FROM postmark.events e 
where e.record_type = 'Bounce'



Clicked Email

An email was Clicked

Type: Activity Transformation

SELECT
    e._id AS activity_id,
    e.recieved_at::TIMESTAMPTZ::TIMESTAMP AS ts,


    NULL AS source,
    NULL AS source_id,
    e.email AS customer,


    'bounced_email' AS activity,


    e.platform AS feature_1,
    NULL AS feature_2,
    NULL AS feature_3,


    NULL AS revenue_impact,
    e.original_link AS link

FROM postmark.events e 
where e.record_type = 'Cick'

Tips:



šŸ‘

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 about a month ago


What's Next

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

Transformations by Activity

Postmark


Suggested Edits are limited on API Reference Pages

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