Hi there, How can I fetch the recipients' open and click percentages where the record create date in a certain schema (linked with the recipient) is within the last 30 days? I attempted using the Targeting and Filtering dimension as Delivery, but it only provides the number of emails sent on a parti...

Hi @Craig_Thonis , It has to be either an intersection or a union. Please confirm. Currently, I am using the recipient as the target dimension and filtering on recipient delivery logs. When I added additional columns from Delivery > Indicators, it started fetching all the sent emails, not just the s...

Hi there, I am creating a report with the targeting and filtering dimensions set to Delivery, aiming to obtain the counts of successful emails, opens, and clicks from indicators However, I specifically want to see the opens and clicks for data where the rec_create_date from another table is within t...

Hi @LakshmiPravallika , Thank you for looking into it. I found the issue; it appears there were duplicates causing the incorrect count. I have made the necessary changes in the deduplication activity, and it is now working fine.  

Hi @LakshmiPravallika , please find the below the conditions I am using and also checked the Generate compliment.  

Hi @Sukrity_Wadhwa , I was able to sort this out by using the below expression: <node expr="ToInteger((Percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*1000)/10" alias="@OpenRate"/> <node expr="ToInteger((Percent([indicators/@recipientClick], [indicators/@estimated...

Hi there, I've observed that when using a split condition, 1308 records were initially sent into the split. After configuring multiple conditions within the split, including checking the "generate complement" option, I now receive 1303 records. Upon manual inspection, I tested the missing 5 records ...

Hi there,    I have several JavaScript activities that retrieve the total record count based on split conditions. Now, I've added another JavaScript activity to extract the segment code from the split activity. Additionally, I'm attempting to access the instance.vars variable within this new JavaScr...

Hi @vraghav , Thank you for looking in to this. I have a column named segment_code containing values like scen3_IS_DELETED, scen3_IS_EMAIL_OPT_IN, and scen4_IS_DELETED.My goal is to extract the substring before the first underscore and display it in one column. Additionally, I want to count the occu...

Hi there,  Is there a method to compare two columns (feature_purchased_date and email_sent_date) belonging to different tables? I want to retrieve records where feature_purchased_date from the "feature" table is greater than email_sent_date from the "recipient delivery logs" table.  Thank you in adv...