how to fetch the user details for whom the campaign is being launch in an analytics report

[Debankita]

Hi Team,

I need to create an analytics report by fetching the user details of the user for whom a particular campaign has been launched..

Can someone please help me with the suitable analytics query.

[AmitM]

Hi @Debankita , for different type of campaign there could be different query, here is one for user manager. You need to add different tables for different type of cert.(AFAIK)

SELECT p.campaign_name AS 'CampaignName', k.CERT_NAME AS 'Certification Name', u.SYSTEMUSERNAME AS 'Certifier Username', u.FIRSTNAME AS 'Certifier First Name', u.LASTNAME AS 'Certifier Last Name', a.ACCOUNTID AS 'Account ID', a.name AS 'Account Name' FROM campaign p, certification k, certification_user_account_status cu, certification_account ca, user_accounts ua, accounts a, users u WHERE ua.accountkey = a.accountkey AND ca.userkey = ua.userkey AND ca.ACCOUNTKEY = ua.ACCOUNTKEY AND k.certkey = cu.CERTKEY AND p.id = k.CAMPAIGNKEY AND k.CERTIFIER = u.USERKEY

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.