We have a requirement to relaunch a campaign for all users whose campaign response was ' No Response'.
We have selected to revoke tasks for certified users on campaign expiry and hence, for users for whom 'No Response' was selected, we need to relaunch a new campaign.
While launching a new campaign we have an option for selecting the set of users via the Advanced query. Can I get the query for all users for whom no response was selected from the previous campaign?
Solved! Go to Solution.
You can actually download a summary report from previous campaign and filter by certified column as 'No Response'. Summary report will have below sheets
You can use 2nd sheet List of Accounts for Certification to find out of the list which has no response
select u.username from campaign cm inner join certification c on cm.id=c.campaignkey inner join certification_user_status cus on c. certkey=cus.certkey inner join certification_user cu on cus.cert_userkey= cu.cert_userkey inner join users u on cu.userkey=u.userkey where cus.certified is null and cm.campaign_name='<campaign_name>'
You can validate the output of this query by comparing it with summary report as previously mentioned