- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Chris,
This is what you can do - Start with Broad log and include all deliveries period you want to include
[target/delivery/label] included in =''
and [target/status]='Sent'
Contact Date on or after <> and Contact date On or Before <>.
In the compliment , Include Country code from recipient and Broad log id ( primary key ) and Delivery Id . Then enrich to tracking log based on Broad log id and delivery Id and include URL/type as an additional data . You could see more records after this enrichment due to more than one action.
Add a query next to enrichment and choose as a temporary schema. In the compliment add country code in group by then
CountDistinct(broadlogId) as Email_Sent,
Iif(type=1 ,broadlogid,'') as email_Click,
Iif(type=2 ,broadlogid,'') as email_Open,