Skip to Content

How to write the results of a campaign on CSV

Nov 09, 2016 at 11:21 AM


avatar image
Former Member

Dear all,

I need to export on a csv file the results of a campaign in Hybris Marketing, in term of hard bounces, soft bounces, click on a trackable link, which link is set to trackable in the campaign, opened messages, unopened messages and so on.

CUAN_D_INI_ROOT is the table with the information of the campaign as it has been created, but I can't find the one in which the output of a campaign is stored! For example, where are the following details stored?



10 |10000 characters needed characters left characters exceeded
Former Member

CUAN_D_INI_ROOT contains the campaign information, but all interactions linked to a campaign are stored in CUAND_CE_IA_RT.

The field INITIATIVE_ID (linked to field ID in CUAN_D_INI_ROOT) in table CUAND_CE_IA_RT will show you which interaction is linked to which campaign.

To come back to your question about exporting campaign results to CSV, I don't think there is an easy way to accomplish that.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Joyca Vervinckt Jan 31, 2017 at 02:38 PM


You could check the HANA view sap.hana-app.cuan.initiative.internal::CA_C_CAMPAIGN_METRICS.

It's basically a join on many if the tables, a.o. INI_ROOT and IA_RT, which contains the campaign metrics like bounces, clicks, etc.

I'm not the HANA expert but I think you can export from data previews in HANA studio. Maybe even connect this view to Excel directly.



10 |10000 characters needed characters left characters exceeded