Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

michaelr8873103
Level 2
Level 2

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. 

Campaigns
1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

3 Replies
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

michaelr8873103
Level 2
Level 2
Thanks, but I need this for AC classic, and RowNum & PartitionBy don't work in Classsic