how to fetch count of daily recurring delivery occurence created

[DishaSharma]

what should i put in query acitivty

I need to send a report on email for open,click and all for 1 campaign having
recuiring dleeievry which run daily

I have configured the activites to send report on email
what should i put in query acitivty:
i know i have to take target dimension as nms:delievry

may i please know what should i put in query conditon --so that workflow fetches
report for recuuring deleivry occurence craeted today
like that for daily
please help

Basically m looking for a idea for conditions to put in query activity

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni 

,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki

@Denis_Bozonnet 

[InMo]

Hi @DishaSharma ,

If I understood correctly, you need to know what condition you can put in your query activity.

You can put anything like 'campaignCode' is equal to '<code of campaign>', so that you get only those record which you want in the result.

Please write back, if you are facing any other challenge. 

Regards,

[Sujith_02kumar]

Hi @DishaSharma ,

You can use delivery code from the recurring delivery along with the condition mentioned below,

I hope this helps,

Regards,

Sujith Kumar.