vwEmailJobClickthroughs

Fields

Field	Field Type	Null	Description
EmailJobID	int
Clickthroughs	int	yes

Definition

Copy


CREATE VIEW [dbo].[vwEmailJobClickthroughs]
AS
    select
    EJR.[EmailJobID] As [EmailJobID],
    Count(s.[StatsID]) As [Clickthroughs]
    from dbo.Stats S
    inner join dbo.EmailJob_Recipient EJR on EJR.ID =  S.EmailJobRecipientID
    inner join dbo.EmailLink EL on EL.PID = S.PageID
    where el.EmailID = EJR.EmailID
    group by ejr.EmailJobID