Analytics are limited to Action emails only

[serge005]

Campaign links are tracked, but they are not reported in the Analytics dashboard. Only emails that originated from an Action (automation) are reported in Analytics. Is that by design?

The Campaign link click is successfully recorded in the database, but the analytics page only returns emails that have an actionId. Campaign and transactional emails have a NULL actionId and are not returned due to the sql query in ProjectService.ts:

SELECT clicks."link", a."name", count(clicks.id)::int FROM clicks
JOIN emails e on clicks."emailId" = e.id
JOIN actions a on e."actionId" = a.id
WHERE clicks."link" NOT LIKE '%unsubscribe%' AND DATE(clicks."createdAt") BETWEEN DATE(${start}) AND DATE(${end}) AND a."projectId" = ${params.id}
GROUP BY a."name", clicks."link"

[driaug]

Closing this in preparation of next branch.