Opens / Clicks using RowID (or something similar) of BroadLog

Avatar

Avatar
Validate 1
Level 1
michaelr8873103
Level 1

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
michaelr8873103
Level 1

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
michaelr8873103
Level 1

16-12-2019

Trying to build a report table show Opens / Clicks using something similar to the recipient delivery log 'RowId' 

 

Have built workflow using BroadLog, TrackingLog & Recipient tables, and complimentary data: RowId(GetDate([delivery/broadLogRcp/eventDate])).... but this generates the RowId of the BroadLog, not the Recipient Broad Log.

 

I'm just trying to build a table something like the following: 

 

1st email recipients receivedopensclicks
2nd email recipients receivedopensclicks
3rd email recipients receivedopensclicks

 

All recipients have received different emails 1st, 2nd and 3rd depending on when they subscribed. 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

18-12-2019

Hi,

 

RowId() returns the line number of the row in the result set, and so would ignore any args passed to it.

You can get the 1st delivery, 2nd delivery.. with rownum(partitionby([@recipient-id]), orderby(min(@eventdate)) = 1, 2.. on broadlogrcp. From there it's a join to trackinglogrcp for the counts.

 

Thanks,

-Jon

Answers (0)