Where can we get the campaign execution time in Hybris Marketing?

[spvamsi]

In CUAN_D_INI_ROOT table, i see that the field PERIOD_START and PERIOD_START_TIME are blank for my campaign which is already executed. Is there any specific table and field that I can collect execution start date/time of a campaign. I am currently using in 1709 SP1

[former_member226]

Hi,

Can you pls check: CUAN_D_MKTORC_ER field EXECUTION_START_DATE_TIME which holds the timestamp of execution start date and time.

Here take the CUAN_D_MKTORC_ER-ROOT_KEY = CUAN_D_MKTORC_RT-DB_KEY and you can get the DB_KEY of CUAN_D_MKTORC_RT using INITIATIVE_ID as camapign ID.

Hope it helps!

Thanks

Saurabh

[KunalBansal]

Hello Vamsi,

You can check/add the fields START_DATE and END_DATE:

cuan-d-ini-root.jpg

For exact time-stamp, open transaction SLG1

1. Filter according to system date/time
2. Filter Object: CUAN
3. Filter Sub-object: CUAN_MKT_ORC_RT
4. Filter Program: CUAN_MKT_EXEC_EXECUTE

Regards,

Kunal Bansal

CRM & Hybris Marketing - Consultant