Export Campaign Details

[ARNAB86]

Hi Team,

While i export the campaign details i am able to see most of the values populated as per below sreenshot

But if i want to add some more user metadata like some other cp in the export report how to do this.

Thanks

Arnab Pal

[Raghu]

@ARNAB86  you can write sql query and get report from analytic , include required columns

example:

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>'

[ARNAB86]

Can you please provide me the query to fetch the above details

Thanks

Arnab Pal

[Raghu]

or u can add below config : required attribute it will come in export list

[rushikeshvartak]

Its already in OOTB report export why do you need custom report ?

[ARNAB86]

But Client want it should be custom query so we can add some extra attributes in query itself to fetch the details instaed in OOTB export report functionality

[rushikeshvartak]

When you are running export you can get query from logs

[Manu269]

Did you checked following posts :

Campaign Report Queries - Saviynt Forums - 50171

Solved: Campaign Query Report - Saviynt Forums - 90168

Solved: UM Campaign Data - Analytics Report - Saviynt Forums - 54339

Frequently used Campaign Reports based on Campaign... - Saviynt Forums - 28534

How To - Create Frequently used Campaign/Certifica... - Saviynt Forums - 29145