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


    NULL AS anonymous_customer_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'

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


    NULL AS anonymous_customer_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'

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


    NULL AS anonymous_customer_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'

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


    NULL AS anonymous_customer_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'