I would like to query the Recipients table in Campaign and get an output with all the different email Domains ( of all recipients ) along with the count of these domains.
My question is :
Any help will be appreciated
thanks
a
Solved! Go to Solution.
Views
Replies
Total Likes
Hi,
1: Use a query activity, with nms:recipient as targeting/filtering dimensions, @ID>0 as where clause and select clause defined by Edit additional data:
2: Don't use sqlSelect unless there is a clear reason, e.g. complex queries that have perf requirements. In querydef:
var recipients = xtk.queryDef.create( <queryDef schema="nms:recipient" operation="select" distinct="true"> <select> <node expr="@domain" groupBy="1"/> <node expr="count(@id)" alias="@count"/> </select> </queryDef>).ExecuteQuery(); for each (var recipient in recipients.recipient) { logInfo(recipient.@domain, recipient.@count); }
Thanks,
-Jon
Views
Replies
Total Likes
Hi,
1: Use a query activity, with nms:recipient as targeting/filtering dimensions, @ID>0 as where clause and select clause defined by Edit additional data:
2: Don't use sqlSelect unless there is a clear reason, e.g. complex queries that have perf requirements. In querydef:
var recipients = xtk.queryDef.create( <queryDef schema="nms:recipient" operation="select" distinct="true"> <select> <node expr="@domain" groupBy="1"/> <node expr="count(@id)" alias="@count"/> </select> </queryDef>).ExecuteQuery(); for each (var recipient in recipients.recipient) { logInfo(recipient.@domain, recipient.@count); }
Thanks,
-Jon
Views
Replies
Total Likes
Hi Jon
Sorry my question was not clear. What i would like to do is to group the results based on emailDomain and show the count. Something like this
gmail.com 32
yahoo.com 5
reditt.com 6
Thanks
a
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies