Use Case
How to launch an entitlement owner campaign based on the inputs from a user manager campaign.
Pre-requisites
User Manager Campaign is configured
Applicable Version(s)
All
To initiate an entitlement owner campaign that incorporates revocations from a user manager campaign, you can follow these steps to configure the campaign settings:
1. Access the advanced campaign configurations.
2. Include the following query in the "Account Entitlements Query" section, along with the necessary details regarding the account, entitlement, and users:
```sql
(ae1.accountkey, ae1.entitlement_valuekey) in (
select distinct ae.accountkey, ae.entitlement_valuekey
from Account_entitlements1 ae, Certification_account_entitlement1_status cae,
Certification_account ca, Certification_entitlement_value cev,
Accounts a, Entitlement_values ev, Campaign c, Certification ce
where cae.cert_accountkey = ca.id
and ca.accountkey = a.id
and a.id = ae.accountkey
and cae.cert_entitlement_valuekey = cev.id
and cev.entitlement_valuekey = ev.id
and ev.id = ae.entitlement_valuekey
and c.id = ce.campaignKey
and ce.id = cae.certkey
and c.id = (select id from Campaign where campaignName = '<campaign name>')
and c.status in (2, 7)
and c.campaignType = 2
)
```
3. Additionally, add the following query to exclude the revocations from the corresponding entitlement owner campaign:
```sql
(ae1.accountkey, ae1.entitlement_valuekey) not in (
select distinct ae.accountkey, ae.entitlement_valuekey
from Account_entitlements1 ae, Certification_account_entitlement1_status cae,
Certification_account ca, Certification_entitlement_value cev,
Accounts a, Entitlement_values ev, Campaign c, Certification ce
where cae.certified = '3'
and cae.cert_accountkey = ca.id
and ca.accountkey = a.id
and a.id = ae.accountkey
and cae.cert_entitlement_valuekey = cev.id
and cev.entitlement_valuekey = ev.id
and ev.id = ae.entitlement_valuekey
and c.id = ce.campaignKey
and ce.id = cae.certkey
and c.id = (select id from Campaign where campaignName = '<campaign name>')
and c.status in (2, 7)
and c.campaignType = 2
)
```
By implementing these modifications, you will retrieve the master data from the user manager campaign while excluding any revocations from the corresponding entitlement owner campaign.
References
https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter17-EIC-Analytics/Managing-An...
