Sign In. Replies. If. BroadLog iD : The primary key for each delivery log sent to recipients. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. trackingLogEventHisto table Regards, Priyanka sub and dlvrd are supposed to count the amount of delivered parts and delivered messages, but this is not used by Adobe Campaign since the broadlog system gives a better, and more integrated information. 1 Accepted Solution Correct answer by Anita_punmiya Level 7 04-08-2019 21:54 PDT Hi , Use BroadlogRcp for your requirement as this will have log of all the. becker77. Level 3 9/26/23 2:23:05 AM. Destination: [delivery/@cusCommID] Source: [@cusCommID] And to achieve that I modified the email delivery template to have target mapping set as. Currently, we are experiencing a situation where we see a lot of repeat email clicks in the tracking log table. rahuladwani. e. I understand that th. A delivery may contain multiple recipients and correspondingly multiple delivery log entries. I've been noticing in the broad logs, tracking logs and exclude logs in our database that we have a single row with broad log id of 0 and all other fields blank. 07-07-2020 23:13 PDT. The Adobe Campaign Managed Cloud Services source allows you to bring Adobe Campaign v8 delivery logs and tracking logs data to Adobe Experience Platform. instead of label like Ignored, Sent, Failed. aggabhi. You will find the links. Then select the. You will find the links. the final delivery sent just fine. Adobe Campaign manages a list of quarantined addresses. I was assuming the records would simply be updated as the delivery was approved. However, the solution #2 seems the way to go. Extend an existing table with new fields. id=b. In the integration there are two conversion variables that you define Campaign ID Broadlog ID (I believe you have renamed this to Delivery ID) Example screenshot: The Data that is consildated from Adobe Campaign over to Adobe Analytics is on the basis of Campaign ID. Hello Ujjyals, It looks like you already submitted the same question in the ACC forum. Select the columns that you want to export in. . Great! Thanks for letting us know. Thank you for the message the simple case will be : the target will be segmented with several criteria. Adobe Campaign Community Lens 8th edition is out! Read More. submit date and done date fields are indicative timestamps of when the MT was sent and when the SR was sent by the. . SMPP opens 1 or 2 TCP connections, depending on its mode. a retry was done due to some tempor. NB: Typology to check broadlog would be expensive, unnecessary and would fail after broadlog retention period's el. Available options vary according to the packages installed with your instance. . 03-01-2021 22:12 PST. Hi Kevin, Can you give an example of exactly what you are trying to achieve?Advertising Cloud Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Cloud Extensibility Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Workfront Creative Cloud Document Cloud Commerce Marketo EngageAdobe Campaign does not support multiple recipient schemas, know as targeting schemas, linked to the same broadlog and/or trackinglog schemas. Is it possible to get it in same WF so we can do 1-1 mapping between input file parameter and corresponding delivery?I am doing segmentations in Adobe Campaign but the actual campaign is being sent out of another system (EPSILON). If you're hosted by Adobe use url-encoding cryptString('-1|<broadlog id in base16>|<delivery id in base16>') If you want to use JS activity inside a workflow, see the example: var url = nms. How to change a subject line script into an actual subject line in the broadlog. Learn. Adobe Campaign Community Lens 8th edition is out! Read More. Reach out to the Adobe consultants or technical administrators to learn more about retention or if you need to set retention for custom tables. We have a few workflows that run quite a bit of data through them (over 5 mill records). Adobe Campaign offers tools and best practices to help you optimize your database usage. Mark as New. Level 7. SOLVED Adobe Campaign Classic - Analytics Integration. So, I need some kind of passive delivery (which will not be executed like sending email, etc. Hence it was not able to add the data to OOTB broadlog which does not have those fields. See moreAccess the tracking logs. Also, we add the broadlogid on the file we generate so as to have reconciliation key when we receive a response back from the vendor. Make sure you update the aggregated delivery statistics afterward with nms. But I am failing to export the fields of the broadlog schema. Thanks! We chose the insert into nms:addressThe Adobe Campaign Managed Cloud Services source allows you to bring Adobe Campaign v8 delivery logs and tracking logs data to Adobe Experience Platform. Countdistinct ([@broadLog-id]) Clicks: @recipientClick: Distinct count of @broadLog-ids with a URL type equal to "Email click". Create datasets in Experience Platform for data to be ingested. Hello Your final delivery didn't go out because in the JS code, you have used validationMode as manual. Sign In. Is this something Adobe campaign generates by default for some reason? When we try to run any query against broadlog RCP table, we always see that the data retrieval is very slow, for example :-. Hi We have done a similar setup for multiple projects as we have implemented file-based channel integration. But I am failing to export the fields of the broadlog schema. We also have checked if there are any parallel jobs running on the same table or. Adobe Campaign Classic v7 & Campaign v8. Multiple paramters support Deployment wizard. In this video, we will discuss the steps to resolve the issue of SMS broad log status showing sent when SMS is sent to an incorrect number in Adobe Campaign. Level 2 11/12/20 11:37:37 AM. select Administration and then select Configuration. And of course you can see every single table. Adobe Campaign connects to the network equipment of the SMS service provider via TCP. col1, b. The above is explained in more detail here Adobe Campaign: Sequences Exhaustion - Adobe Campaign Classic (from 15:00 onwards and 4:00 onwards respectively). In the list that appears, select the recipient. The continuous delivery lets you add new recipients to an existing delivery and avoids you having to create a new delivery each time a new recipient is added. 3/15/22 11:06:35 AM. 2 (build 8795). A delivery may contain multiple recipients and correspondingly multiple delivery log entries. Adobe Campaign Community Lens 8th edition is out! Read More. Next, select Data schemas and then apply the broadLog filter for name or label. Community home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Real-Time Customer Data Platform Workfront Creative Cloud Document Cloud Commerce Marketo EngageAdobe Campaign uses a "Nms_DefaultRcpSchema" global variable to dialog with the default recipient database (nms:recipient). Create Adobe Campaign schemas for broadLog, trackingLog, non-deliverable addresses, and profile preferences (optional). List of Campaign Classic options. A continuous delivery will create a SINGLE delivery. Hello community, I have a problem when I set up a workflow on broadlog of a specific date like for example "01-01-2021",the Sent volume is 13 but it changes every day each time the workflow is executed even if I don't change the date in the query. The 5th edition of the Campaign Community Lens newsletter is out now!. Administrators can manage — that is, access, delete, and modify information or. Adobe Campaign Standard. SOLVED Concatenate the segment code of parent segment with the child segment. SOLVED get datas from temp schema in different workflow. Milan, I believe you can either come up with standard code/naming for your non-email delivery which campaign or reporting teams can later parse it to pull the proper channel or you can extend the NMS Delivery schema to add a field to capture the real channel code (extend schema, change delivery for. Create a new target mapping and select your custom schema as the targeting dimension. After making the changes, restart the analysis clicking Analyze. I have created a custom delivery channel for outbound messages. Enter the name of the service in the Label field and select the delivery channel: email, mobile, Facebook. In your case, replace broadLog by the name of your 2nd table. This document details all the steps needed to add publicID in Campaign Classic delivery logs Introduction This document's purpose is how to define which IP sent each email in a delivery. In this way, you can capture all the users who are visiting your webpage. 1. Advertising Cloud Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Cloud Extensibility Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Workfront Creative Cloud Document Cloud Commerce Marketo EngageYou can populate nms:broadLogRcp with targetData via the Additional fields section of Target mapping. -> extend your broadlog schema and enrich your mapping in order to save the segmentCode at broadlog level. Meet our community of customer advocates. The root element of the schema must contain the extendedSchema. A list is a static set of recipients that can be targeted in delivery actions or updated during import operations or during workflow execution. Level 1. You can personalize the Extension namespace in the next window, then click Next. It lists all the URLs of the content so that they can be tracked individually. A confirmation message lets you launch the delivery. While using a Query activity, go to the Property tab on the activity and in the "Resource" field, search for broadLog, you should see a series of broadlog entities associated to the Profile and. Adobe Campaign Standard. Adobe Campaign Classic transmitter connections are an exception due to the way the Adobe Campaign Classic MTA works. delivery. Level 9. eventHisto table 2. Transactional Messages delivery and tracking logs are stored in their own event broad and tracking logs. select Administration and then select Configuration. Adobe Campaign offers tools and best practices to help you optimize your database usage. Messages can also be excluded during the delivery preparation if an address is quarantined or if a profile is on denylist. The 5th edition of the Campaign Community Lens newsletter is out now! Read more. To sum up :Adobe Campaign Standard. I can do that by selecting exclusion and adding a successful delivery to it, which worked if I am correct. When a message is successfully sent to the provider, the broad log status will remain as sent with the reason of sent to provider. Views. Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023! Read More. While using a Query activity, go to the Property tab on the activity and in the "Resource" field, search for broadLog, you should see a series of broadlog entities associated to the Profile and then to each of your. Adobe Campaign comes with an intuitive data exploration tool to create dynamic reports. Hi, We have a use case wherein we want to tie data from input file with broadlog id for which we are looking to update delivery info once email/SMS is sent into the custom schema. So the same profile can receive different messages with the same transactional template. Use the External API. For example, if the workflow is scheduled to run once a week, that would result in 52. If you forward this email to two friends, the number of targeted recipients will still equal one, while the number of persons will equal three. Sign in to. Indicate the fields where the profile information is stored: last name, first name, email, address, etc. From there, you can design, plan, execute, manage, and optimize data-driven, cross-channel marketing campaigns. Learn. Sourav_Sadhu. Thanks,The Broadlog records immediately, how soon does the trackingLogRCP record delivery records after a delivery had been sent? - 278815. Use the following format: YYYY-MM-DD hh:mm:ss+tz. This can otherwise lead to anomalies in data reconciliation afterwards. Please let me know how to fetch. We use Adobe Campaign Classic. You can also choose whether to manage tracking for this delivery mapping (trackinglog). This is exporting data in a flat file with different data getting picked from the broadlog and data linked to the broadlog schema. Hi Everyone, I am sending a profile based transactional event and using some random attributes and some attributes from profile table. Learn how to create an audience by configuring a list of recipients from the Explorer. Create Adobe Campaign schemas for broadLog, trackingLog, non-deliverable addresses, and profile preferences (optional). Anita_punmiya. Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023! Read More. For example, for the broadlog and tracking log tables, you can also see how long they are retained. can anyone let me know if we can save attributes in. Have built workflow using BroadLog, TrackingLog & Recipient tables, and complimentary data: RowId. Schedule the delivery sending. You can then start the delivery analysis, then confirm the delivery sending. . The graphic below details the required relational structure for each custom recipient schema:This should generate a mirror page URL for all broadLog records, even for deliveries where the mirror page URL is not configured. Adobe Campaign Classic v7 & Campaign v8. Office: broadlog. . The integration between Adobe Analytics and Adobe Campaign allows sharing of campaign engagement data (KPIs) to Adobe Analytics. . Hi, We would like to add new broadLogRcp status for custom Phoning deliveries: - To contact (by phone call) => equivalent to standard "pending" status. Next page. Adobe's online documentation states "It is not possible to export unique identifiers (primary keys) of log resources. Learn how to share data between Campaign and Real-time Customer Data Platform (RTCDP) Control groups. Yes, default namespace (recipient email) will take care of deleting records from broadlog/tracking log. Need an email throughput by domain reportHi, Yes, the math is hardcoded in the nlserver binary: RecomputeStats. 2. Can anybody provide the data dictionary of the Adobe campaign classic system table data dictionary document where each tables like recipient, delivery, broadlog, tracking table attribute and default value, mandatory attributes and spare attribute which can be used for business need, attributes being updated by OOB workflows. This data collection is performed by the web tracking module. Adobe Campaign Features Whether you’re new to cross-channel marketing or have experience in it, we know that Adobe Campaign can help you. Adobe Campaign Community Lens 8th edition is out! Read More. We have other use cases where this would be really helpful as well, just weren't familiar that you could loop through values using that dot notation approach. Adobe Campaign Community Lens 8th edition is out! Read More. Please be sure to keep the records. A continuous delivery creates a SINGLE delivery and delivery logs (broadLog) and tracking logs, that reference that one delivery, are added each time it executes. Real-time events, broadlogs. Anything with broadlog customization needs closer attention. Is it possible in Adobe Campaign to create a Web App and check for the delivery logs and the tracking logs when I put any emails from a customer or from a campaign in a label text input ?. Thanks, Anita. Mark as New. This is exporting data in a flat file with different data getting picked from the broadlog and data linked to the broadlog schema. AntonioSerrano. Same applies for nms:deliveryLog. In a workflow, you can add the restricted column to the targeted population as an extra column of the transition, but it is still inaccessible to Adobe Campaign users. For that i created a custom target mapping. In the file I am successfully able to export. Adobe Campaign Standard. That's not coming from Adobe Campaign it self but about the amount of phone number to reply to a SMS in order to. . Hi @robertc66522596 - the subject as far as I am aware is only calculated during the delivery preparation phase and added to each individual send in the delivery. SOLVED Direct mail export file with broadlog id. Community home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Real-Time Customer Data Platform Workfront Creative Cloud Document Cloud Commerce Marketo Engage Thanks Adhiyan. Converting values into aliases. Advertising Cloud Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Cloud Extensibility Experience Cloud Experience Manager Sites &. But I am failing to export the fields of the broadlog schema. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. 1 Tracking files are being generated as expected (redir urls,tags,log) Instance 1 ( tracking uploads to frontal servers) working fine Instance 2 (registers to frontal tracking servers), tracking workfl. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. In the Additional data tab, enter the personalization data used for the deliveries created in the Data management workflows. In the screenshot Unique Clicks. We are getting a weird results, when the delivery is sent from adobe campaign classic, at first the status in the broad log RCP table is showing as sent for the particular recipient and we pull the report for that delivery which we send to the business. SOLVED broadlog vs broadlogRcp. Adobe Campaign connects to the network equipment of the SMS service provider via TCP. You can see it with the mes. In this video, we will discuss the steps to resolve the issue of SMS broad log status showing sent when SMS is sent to an incorrect number in. Last update: 2023-08-31. com broadlog@gmail. And of course you can see every single table. It is not tied to th. So one entry will have 2 child records into the. Adobe Campaign Classic v7 & Campaign v8. - 1. This option is automatically created once the delay is modified within the interface. Monitoring the temporary resources is key. Call Us: +234 906 7576. _bid relates to the nms:broadLogAppSubRcp that was created when the push went out. Understand quarantine management. External API. You may refer to this page for a description of the datamodel. Hi Terrence, So an ID of 0 or "zero record" gets automatically created when links are established with other tables. Adobe Campaign Standard - Experience League Community. on a. SOLVED A/B test - Final send broadlog fields not populated. Create datasets in Experience Platform for data to be ingested. If you're using any other field on the OOTB recipient resource or custom resource then you will have to setup new namespace containing target mapping. You can see it with the mes. For more on this rule, see this. A continuous delivery will create a SINGLE delivery. Once a delivery has been sent, the delivery dashboard displays a status that allows you to monitor if the sending has been successful. Courses Tutorials Certification Events Instructor-led training View all learning options. Hence it has no corresponding physical SQL table. When an internet user clicks a tracked link in. queryDef. . Ideally, we'd like to preemptively blacklist these types of interactions so that they do not skew our statistics. . I want to save attributes like "Promo Code" in broadlog table which is already in profile table but same is not getting saved. Note: This modification is different if you are using a single instance or mid. Hi, We would like to add new broadLogRcp status for custom Phoning deliveries: - To contact (by phone call) => equivalent to standard "pending" status - Contacted with success (by phone call) => "sent" - Contacted with failure (by phone call) => "failed" and 10 other status with either pending/se. i will have to find another way for my problem. The issue I'm asking about is that the enriched target data fields (i. 3. Mark as New. High level you should double check your data schema fields you extended. Yes, you can check the opt out link as well in the Delivery Preview. -> extend your broadlog schema and enrich your mapping in order to save the segmentCode at broadlog level. Excluded messages are listed in the delivery dashboard. You will find the links. Experience League. SG1997. A continuous delivery creates a SINGLE delivery and delivery logs (broadLog) and tracking logs, that reference that one delivery, are added each time it executes. The Adobe Campaign Managed Cloud Services source allows you to bring Adobe Campaign v8 delivery logs and tracking logs data to Adobe Experience Platform. And of course you can see every single table. Replies. If. Questions. This means option #3 is not a good option. Hi Darren, let me explain- So i have one delivery where i have a script in the subject field (if segment='A', subject='B' else subject='C') This script works perfectly for the end user who will receive the email, however, when i try to check in the [delivery/mailParameters/subject] field i see the exact script which i wrote in the subject field of delivery. For each segment: Fill in the Segment code field: manually enter the desired date and time for sending the message. Now let’s talk about best practices. Yes the direct mail option does have the control group functionality. After checking the result of the analysis, you will be able to click Confirm delivery to send the message to the specified target. You can update the creative directly in the campaign workflow and it will update the template in the delivery template Resource folder. Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023! Read More. . Discussions. May be at first you might have to consider deleting the tracking logs data of the deliveries that are sent. If the reminder email is not going to be opened by the same audience, the 3rd email will be sent to t. Create datasets in Experience Platform for data to be ingested. For example, for the broadlog and tracking log tables, you can also see how long they are retained. Tried using comma, semi-colon, but nu luck. In this way, you can capture all the users who are visiting your webpage. e. In the file I am successfully able to export different. Yes, broadlog and tracking logs are huge tables, and the query could last some seconds, but 10 minutes seems abnormal, because email fields are indexed. The problem I have is that the service provider is returning with an Message ID once the message has been received our failed to a jssp on the Adobe campaign server. create( <queryDef schema="nms:trackingLogEventHisto" operation="select">. Adobe Campaign Standard. Yes but you don't know the timing of whatever's setting it to 1. 4. For example, for the broadlog and tracking log tables, you can also see how long they are retained. select Administration and then select Configuration. Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023! Apply Now. To do this, you need to create the schema of the table and update the database structure to generate the corresponding table. Read real-world use cases of Experience Cloud products written by your peersLevel 5. I am currently facing a tracking issue in one of my instances after upgrading from 6. and with a few normal deliveries/large number of broadlog, 1,6 M broadlogs records, you are right, it would take too much time, I had to stop the job. Hi ,Greetings All, We have a custom broadLog table which is separate from recipient table. 5K. 959. The 7th edition of the Campaign Community Lens newsletter is out now! Read more. Community. Adobe Campaign uses the SMPP protocol to send SMS to a service provider. Hello, I am using Adobe Campaign Classic v7, build 8936 and currently, my objective is to send push notifications to a target population where each target recipient can receive more than one unique notification. I just have one more question may be related or unrelated to this thread. 10, XtkNewId is no more the default value for the sequence in the out-of-the-box schemas. Do you have any i. It seems you are trying to use data from the workflow in the personalization of your message. Percent(Countdistinct([trackingLog/@id]), Countdistinct([broadLog/@id])) greater than 0. Recipients whose address is quarantined are excluded by default during delivery analysis, and will not be targeted. Issues with Big Workflow Deliveries and Getting Errors on Broadlog. Correct answer by. above is the only query to read the data from the broadlogRCP table, which takes long hours to get the data and sometimes even times out. I understand that th. In the Response management category, make sure that. Web Server deposits a session cookie containing the broadlog identifier (broadlogId) and the delivery identifier. The Incremental query allows you to filter and extract a population of elements from the Adobe Campaign database. select Administration and then select Configuration. broadLog table). Access the tracking logs. Adobe Campaign Standard. 12-02-2021 00:51 PST. . If you have extended your broadlog, you may have used different target mapping(and different storage for broadlog and tracking logs), but the code you used will only use out of the box target mapping, and OOTB recipient broadlog. You can update the creative directly in the campaign workflow and it will update the template in the delivery template Resource folder. deliveryLogStats is an aggregate built on top of all deliveries sent from Adobe campaign, you can use this to. You have to include the recipient's key as 'externalId' in your calls to Message. trackingLogEventHisto table Regards, Priyankasub and dlvrd are supposed to count the amount of delivered parts and delivered messages, but this is not used by Adobe Campaign since the broadlog system gives a better, and more integrated information. create an operator group for example "Delivery alerts". Eaxmple : Say you have sent an Delivery to 100 recipients . Adobe Campaign Standard. About web tracking. . The redirection of the links works and also the /r/test call. Subscribe to RSS Feed; Permalink; Print; Report; Hello, I am trying to query the BroadLog for a specific subject line using querdef. The continuous delivery lets you add new recipients to an existing delivery and avoids you having to create a new delivery each time a new recipient is added. SOLVED New 32bit PK attribute (that references NmsBroadLogId sequence) on an nms:broadLogEventHisto schema, but does not overwrite the current field @id (int64). It turns out, all broadLog tables, with the. Hi Marcel, nms:trackingLog schema is a template schema that trackingLogXXX schemas inherit from. Adding CC/BCC Feature in Email Delivery. Community. Delivery statuses. recipient=1, person=1). Eaxmple : Say you have sent an Delivery to 100 recipients . Where as in the URL and Click streams, it displays the cumulated clicks by recipients per link. 2 to 6. Questions. . But i still have the same problem even after updating the DB structure and logging out/ back in . The 7th edition of the Campaign Community Lens newsletter is out now!. Then select the. Create Adobe Campaign schemas for broadLog, trackingLog, non-deliverable addresses, and profile preferences (optional). @initiativeName) from Enrichment 3 did not get added to the extended broadlog fields for the 'final' send like it did for the test sends. Monitoring the temporary resources is key. Distinct clicks for the population reached. 2 to 6. If you want, you can submit this as an idea. Output Fields: Campaign Id, Campaign Label, Delivery Id, Delivery Label, Delivery Log Event Date, Status, Recipient Id, Scv Id. I also depends on the way links to broadlog and tracking logs are created: 1-1 or 0-1. Attend local and virtual eventsIf you want it to be handled in Adobe Campaign only, then you might need to have a feature in your website to insert user data in one of the table. Mark as New; Follow; Mute; Subscribe to RSS Feed; Permalink; Print;Adobe Campaign Classic v7 & Campaign v8. xml file:A continuous delivery will create a SINGLE delivery and delivery logs (broadLog) and tracking logs that reference that one delivery are added each time it executes. The application uses dedicated sequences for the nms:broadLog and nms:trackingLog schemas (NmsBroadLogId and NmsTrackingLogId respectively) because these are the tables that contain the most records. Hi @terrence_szeto This is expected and you shouldn't remove these records as you might end up in situation where you won't be able to load an entity record because of link to these logs schema containing 0. Hi Darren, let me explain- So i have one delivery where i have a script in the subject field (if segment='A', subject='B' else subject='C') This script works perfectly for the end user who will receive the email, however, when i try to check in the [delivery/mailParameters/subject] field i see the exact script which i wrote in the subject field of delivery. But carefull, there is no "easy" way to be 100% sure for a response to be linked to the outgoing SMS as this depends from the SMS provider arbitrary rules. A delivery may contain multiple recipients and correspondingly multiple delivery log entries. The 6th edition of the Campaign Community Lens newsletter is out now!. This will take all elements, attributes, enumerations, links etc which are created in nms:broadLog and create the same in nms:broadLogRcpIn Adobe Campaign Classic, a target mapping is supposed to be unique in term of recipient schema vs broadlog / trackinglog schemas. SOLVED [ACS] - broadlog for users. Go to the campaign dashboard and click the confirm delivery button. May be at first you might have to consider deleting the tracking logs data of the deliveries that are sent. Hello, We are trying to get to a Unique Opens vs Person Opens. Learn. We have created this campaign to send mail with API input. It will helps for reporting / analysis purpose. 1st solution is to create a union of the 3 lists a, b and c and to exclude its recipients from list d. SOLVED Loop through linked data in delivery/personalization block. Yes, default namespace (recipient email) will take care of deleting records from broadlog/tracking log. @initiativeName) from Enrichment 3 did not get added to the extended broadlog fields for the 'final' send like it did for the test sends. Hi, as part of workaround there is a need to record some recipients in BroadLog but without real delivery. Next, select Data schemas and then apply the broadLog filter for name or label. If you modify the value from the options list, it. Assign people to this operator group. So this would make sense as the broadlog, tracking, and exclusion all have links to other tables. g. Countdistinct ([@broadLog-id]) Clicks: @recipientClick: Distinct count of @broadLog-ids with a URL type equal to "Email click". Topics: Monitoring.