Campaign Query

AshishDas
Regular Contributor
Regular Contributor

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?

7 REPLIES 7

sk
All-Star
All-Star

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

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

rushikeshvartak
All-Star
All-Star

Which campaign ?

The User Manager Campaign

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
Regular Contributor
Regular Contributor

This works. Thanks!

Can you share exact query used in campaign