Campaign Query

[AshishDas]

Hi,

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?

[sk]

You can actually download a summary report from previous campaign and filter by certified column as 'No Response'. Summary report will have below sheets

1. Certification Summary Report
2. List of Accounts for Certification
3. Deprovision Tasks for Certification

You can use 2nd sheet List of Accounts for Certification to find out of the list which has no response

[sk]

Sorry ignore my previous comment, I jumped too early Can you confirm which type certification you are talking about

[rushikeshvartak]

Which campaign ?

[AshishDas]

The User Manager Campaign

[sk · Accepted solution]

Try this

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

[AshishDas]

This works. Thanks!

[rushikeshvartak]

Can you share exact query used in campaign