​

fact_redirections

​

What questions does it answer?

• How many transfers occurred in a period?
• Which agents transfer the most conversations?
• Which agents receive the most transferred conversations?

​

Columns

​

Example queries

​

Transfers per source agent

SELECT
    from_agent_name,
    count() AS transfers_sent
FROM client_analytics.fact_redirections
WHERE created_at >= now() - INTERVAL 30 DAY
GROUP BY from_agent_name
ORDER BY transfers_sent DESC