dashboard

[leandrosardi]

• show # of outreach sent
• show # of accepted
• show # of responses
• Filter by profile-tag.
• Draw SanKey flowchart in the dashboard - filter by seed rule
• scraping timeline, filter by source
• enrichment timeline, filter by enrichment type
• outreach timeline, filter by outreach type

[leandrosardi]

Helping Queries

Outreach Performance Summary

select 
    sum(coalesce(t.outreaches_created)) as outreaches_created,
    sum(coalesce(t.outreaches_performed)) as outreaches_performed,
    sum(coalesce(t.outreaches_failed)) as outreaches_failed,
    sum(coalesce(t.outreaches_aborted)) as outreaches_aborted,

    sum(coalesce(t.outreaches_accepted)) as outreaches_accepted,
    sum(coalesce(t.outreaches_opened)) as outreaches_opened,
    sum(coalesce(t.outreaches_unsubscribed)) as outreaches_unsubscribed,
    sum(coalesce(t.outreaches_clicked)) as outreaches_clicked,
    sum(coalesce(t.outreaches_replied)) as outreaches_replied,

    sum(coalesce(t.outreaches_unique_accepted)) as outreaches_unique_accepted,
    sum(coalesce(t.outreaches_unique_opened)) as outreaches_unique_opened,
    sum(coalesce(t.outreaches_unique_unsubscribed)) as outreaches_unique_unsubscribed,
    sum(coalesce(t.outreaches_unique_clicked)) as outreaches_unique_clicked,
    sum(coalesce(t.outreaches_unique_replied)) as outreaches_unique_replied

from timeline t

-- timeline records belonging to this user.
where t.id_account='897b4c5e-692e-400f-bc97-8ee0e3e1f1cf' 

-- this is to avoid repliers and accepters that happened outside MassProspecting.
-- example: repliers received by leads not registered in massprospecting, and previous to the profile integration.
and t.id_action is not null

-- filter by timeframe
and t.dt > current_timestamp - interval '1 day'