So I can fully see that there is enough support for ongoing statistics, such as uptime or visits on a website. I haven’t really come across support for multiple events/campaigns within one dashboard however. The use case I’m looking for is building an overview of the latest say, 5 campaings sent out via email.
That is sort of possible using the following as a starting point:
WITH
campaign1 AS (
SELECT jobid FROM emails
ORDER BY starttime DESC OFFSET 0
),
campaign2 AS (
SELECT jobid FROM emails
ORDER BY starttime DESC OFFSET 1
),
but it would involve hard-coding everything from start to finish and it wouldn’t allow for any interaction. Say that if somebody wants to see the latest 10 campaigns, to see if there is a trend, then that would require a whole new tailored dashboard, wouldn’t it?
Is there a way in which it is possible to provide the information for certain campaigns but without hard coding everything and allow users to select the campaigns themselves and would there be a way to link to detailed statistics for individual campaigns?
Any input is very much appreciated!
Best, Erwin