Adobe campaign recipient table. These options allow you to select the. Adobe campaign recipient table

 
 These options allow you to select theAdobe campaign recipient table  The pre-defined Adobe Campaign data model includes the main tables listed below

e. To use it simply click on the Select Adobe Campaign Variable icon next to the applicable field. Select Recipients>Title. 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. Interest 1 – > Block 1. Most text fields are JavaScript templates: JavaScript expressions can be included between <%= and %>. A tab is added to the seed addresses to define the adequate fields, as shown below: In this case, to add seed addresses to the delivery, enter the adequate fields. Then click Next. As a consequence, using a custom recipient table can be a good option when your datamodel differs drastically from Campaign built-in recipient table structure, or if you have a large. Select the campaign from the drop-down list of the Folder. For further information, refer to Schema reference. The form is identified by its name and namespace. Views. In the Target element window, the filtering condition for. The list can be selected from the list of existing groups. Hope this can help. Use an external recipient table. Implementation To add data from the Adobe Campaign database: Select the type of data you want to add. Add an enumeration type calculated field. Archive your tracking logs beyond the retention period of Adobe Campaign: Check the duration of the retention period in your campaign instance. Map the input field at a corresponding recipients tables first name attributes. These options allow you to select the. Enter the information in the Edit tab of the list creation window. ru addresses after registering with the corresponding providers. To analyze a table other than the standard recipients one ( nms:recipient ), click the Advanced settings… link in the. The purpose of an extension table is to avoid limitations on the number of fields supported in a table, or to optimize the space occupied by the data, which is consumed on demand. This is the default mode. Beginner. The OOTB schema nms:recipient is set to use the sequence ''XtkNewId'' from table ''XtkNewId'' (yes the sequence and the table share the same name ). To do this: Select the first element of the expression, <field>, (by default, this element is highlighted during insertion of the if. A recipient can be related to several occurrences on the subscriptions table. Add a description for this list. , a record in the nmsRecipient table or an external table containing cookie ID, Customer ID, mobile identifier or other information relevant to a particular Channel) representing an end-customer, prospect, or lead. The personalization fields are inserted, and ready to be interpreted by Adobe Campaign: during message preparation, the fields are replaced by their value for a given recipient. To create a new Group type list, apply the following steps: Click the Create button and select New list. Addresses. If you want to expire cryptedId's, you can reload the data in recipient table. Creating the remaining population: Go to the General tab. If relevant, you can use the default Recipient table with the out-of-the-box fields, such as described in this section. For example, to select all the persons who are named Isabel Garcia, you can write this code: <condition boolOperator="AND" expr="@firstName='Isabel'"/> <condition expr="@lastName='Garcia'"/>. Click Tools > Generic query editor… and choose the Recipients ( nms:recipient) table. What is the best wa. Hello, If you need to force regeneration of all schema, for example to solve certain dependency problems in the reverse links, you can launch the following command from the Adobe Campaign application server: nlserver config -postupgrade -instance:`<instance_name>' -force You must then restart the. Adobe Campaign comes with a built-in profile table: nmsRecipient. I've added columns: flag_correo and flag_sms to abc:Recipients, they are empty. To do this, click the Explorer link on the Adobe Campaign home page. Most organizations are importing records from external systems. This query uses the Recipient tracking logs table. In the list of transactional message templates, right-click and select New in the drop-down menu or click the New button above the list of transactional message templates. source/origin in recipient table and populate "AEM" as value from AEM in this field and use that to filter it from other recipients. - Supports inbound and outbound APIs - Nicer interface but has a lot of features/options (maybe overwhelming for some) - Thin. : Cardinality 1-N. Seed Addresses schema will have to be adapted as per new recipient tables. e. Elements are designated by their name, and attributes are designated by the name preceded by the character “@”. This lets delivery recipients or website visitors share information with their network: from adding a link to their Facebook or Twitter profile to sending a message to a friend. Many thanks Ankur. Hello , 1. Learn. This means that the delivery succeeded but Adobe Campaign received an auto-reply from the recipient (e. The XPath language is used in Adobe Campaign to reference an element or attribute belonging to a data schema. Choose the table or the existing view: Adapt the schema content to suit your needs. From the Table name field, choose the. Also, the waves were not set in the Delivery properties. The referrer must also enter their Last name, First name and Email. The steps for building a query in Adobe Campaign are as follows: Select the work table. Access requests: the recipient’s data stored in Adobe Campaign is generated and made available as an XML file in the left part of the request screen. The following indicators are used: Visitors: Total number of recipients targeted (per internet browser) and having clicked on a delivery at least once. All the profile data is maintained in the Adobe Campaign database. From your External account, click the Enrich the formula… link to change the URL calculation formula to specify the Web analytics tool integration information (campaign IDs) and the domains of the sites whose activity must be tracked. Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023! Read More. The Adobe Campaign default data model is presented in this document. Export your tracking logs from Adobe Campaign. This step appears when importing recipients only and when using the default Adobe Campaign recipients table (nms:recipient). Their target mapping therefore uses the fields of the nms:recipient table. . - RT events (trigger messages) has no access to the recipient table. 1 Accepted Solution Correct answer by Vipul_Raghav Employee Advisor 10-09-2017 17:39 PDT Hi Asish, At present all REST APIs are exposed for profile schema. This information appears in the Tracking tab of the profile of recipients targeted by the delivery, as in the following example: It is also accessible. Thanks to the recipient data that are stored in the database, you will be able to filter the target that will receive any given delivery and to add personalization data in your delivery contents. Is a sort configured? Yes, based on Account number and Last name. With the drag-and-drop interface, you can explore data, determine how your email campaigns. The option value must correspond to the name of the schema which matches the external recipient table. Here we want to sort account numbers in descending order and names. Sort the columns to display them in the right order. The survey successfully submits the information and this information can be viewed in the responses. A list. Choose: Last name, First name, Email, City and Account number. You've deleted the recipient schema; You've deleted the underlying table. Unselecting the checkbox Update the preloaded record is actually useful whenever you preload with a key, or if it is a free form with no preloading, then reconciliate based on email or firstname+lastname, or other use cases, or also duplicating recipient for instance in a new recipient folder. To do this, apply the following steps: Create a new data schema which integrates the fields of the custom table that you want to use. Better understand the tracking difference between a person/people and a recipient in Adobe Campaign with this example. In the Response management category, make sure that. For example, between a recipient and the subscriptions table. Please check the Join type which you want to do in your Enrichment activity VS the Join type created in the Schema (1/1 or 1:N or N:N) and also the Joining keys defined in the Schema Level VS the keys used in Enrichment activity. The list shows unfinished deliveries contained in the Deliveries folder by default. Last update: 2023-09-07. NmsRecipient {#NmsRecipient} . Click the Data tab and change layout of the table: add three columns on the right. Go to the Message Center >Transactional message templates folder in the Adobe Campaign tree. Adobe consultants or technical administrators to learn more about retention or if you need to set retention for custom tables. This modification changes the data source. ). Then click Next. Thanks, ImranWith 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. The main steps to create typology rules are detailed in this section. The delivery dashboard is key to monitor your deliveries and eventual issues encountered during the sending of messages. BR_Code BR_Name BR_Manager_Name BR_Manager_EMAIL_ID - 278902The option to communicate with external systems is a cool feature to have in any platform. If you have a list of invalid addresses, Adobe recommends importing it to the quarantine table, through Administration > Campaign Management > Non deliverables Management > Non deliverables and addresses. Delivery table: The data model also includes a part dedicated to store all the marketing activities. It adds access to profile data, enabling demographic analysis by profile dimensions such as gender, city and age in addition to functional email campaign data like opens and clicks. Adobe Campaign comes with a built-in profile table: nmsRecipient. Learn more about built-in profiles and recipient tables in this section. Double-check your active target mappings. Beginner. Courses Tutorials Events Instructor-led training Browse content library View all learning optionsIn Campaign Classic, this information is displayed in the Tracking tab of the recipients targeted by the delivery and in the Tracking tab of the delivery. Open the Generic query editor and select the Recipient table (nms:recipient). orderBy clause. In the Filtering criteria tab, select the subscriptions in the Subscription category. co. Sort the. There is a main recipient table that stores the profile attributes such as the profiles first name, last name, email address, and birthdate, and each profile stored in Campaign equates to a record in the Recipient table. If the Join created & keys in Schema is same as used in Enrichment, yes it is good to use the existing Join defined. ) to your customers. Topics: Release Notes. For example, between a recipient and the subscriptions table. The delivery is processed up to connection to the SMTP server but is not sent: for every recipient of the delivery, Campaign connects to. So the information in the file "md_preferencias. While the physical key of the Recipient table is the “id” attribute, it is possible to determine a custom key in addition. View existing profiles. Learn more about Campaign Classic v7 build statuses in this page. It differs in the namespace with the default recipients table: abc:Recipients vs nms:Recipients. In my nms:Recipients, the Adobe Campaign Out Of the Box table, we have a field called: manager, that we want to use as BCC. When starting with Adobe Campaign, you need to assess the default data model to check which table is the best suited to store your marketing data. . These fields are added to Output columns. In Adobe Campaign, access the options menu under Administration > Platform > Options in the Explorer. User. The General tab lets you enter the label and the execution context of the distribution (targeting dimension, distribution field). In the context of an Enterprise (FFDA) deployment, the primary key is a Universally Unique IDentifier (UUID), which is a string on characters. This substitution lets you save time when creating the delivery: instead of manually adding the desired value to. To do this, go to the Add using the wizard menu. EventsI am using ACC v7 and have setup a web application that uses the survey module to enable customers to provide extra information about themselves. Community home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager. To perform manual updates, right-click the selected recipient (s) to use the Actions shortcut menu, or use the Actions icon. The XPath language is used in Adobe Campaign to reference an element or attribute belonging to a data schema. Insert a list with group via the toolbar and enter its label, for instance: List of deliveries per campaign. Creating the offer. Adobe Campaign enables you to build the most accurate target: you can select recipients according to. These are all the fields defined in the recipients table, whether standard fields (typically: last name, first name, address, town, date of birth, etc. So, if a customer requests us to delete his/her records, how can we make sure that the scheduled deliveries, pertaining to him, also gets deleted/stopped. The list can be selected from the list of existing groups. - Access to the Adobe campaign (CM) system tables in the hybrid deployment (believe me this is very helpful) - More customizable. This comprehensive graphical environment lets you design processes including segmentation, campaign execution, file processing, human. Choose: Last name, First name, Email, City and Account number. Enter the data linked to the address in the matching fields from the Recipient tab. Beginner User Developer In this example, we want to recover the names and emails of recipients whose email domain is “orange. Enter the list name in the Label field and, if necessary, change the internal name. This is because in version 6. To access other campaigns, click the Select link icon. no new table is created), but obviously I still needed to extend the recipient table. Pages viewed: Total number of clicks on links in a delivery (per internet browser) for all. : information on the instance: version, name, database engine, installed packages, server system indicators, a view of workflows and. I am currently using default form creation from Adobe Campaign under online web application, please see the workflow below. In the Lines to retrieve field, select ‘1’ as a value. A list is a static set of recipients that can be targeted in delivery actions or updated during import operations or during workflow execution. Enter a new type in the folder of the explorer tree. Transactional messaging relies on the Adobe Campaign data model, and uses two additional separate tables. Hope this helps. Elements are designated by their name, and attributes are designated by the name preceded by the character “@”. For each action, a wizard lets you configure the update. Click the Create button. Otherwise you to enrich it using enrichment activity first and than. I feel that if an extension table is used it would be ok for my requirement as all out of box functionalities. A recipient can be related to only one occurrence of the table country. Then click Next. In the Data to extract window, select Primary key, First name, Last name and Email. Select the country table in the Target schema field. Some internet access providers automatically consider emails as spam if the rate of invalid addresses is too high. Most organizations are importing records from external systems. Adobe Campaign includes a workflow module that empowers you to orchestrate the full range of processes and tasks across the different modules of the application server. So everytime a client recieves an email, their manager also recieves it. Profiles shared by the main set and at least one of the entry activities. For each recipient, the enrichment activity will add a single line from the. Developer. The use of <elements> in multi-line data strings is recommended. Could you Please check by adding th. Experience League. Example: The Personalization field option for the insert icon lets you add a database field into the content, such as the recipient’s name. 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. When the delivery has been sent and tracking activated, the Tracking technical workflow is in charge of retrieving the tracking data. Most organizations are importing records from external systems. Tracking indicators. If. For more on the Recipient table, see this section. 1 Adobe Campaign doesn’t allow direct usage of custom SQ functions, we need to whitelist them first inside the xtk:funcList entity. Then, in the Expression column, click Edit expression. In Adobe Campaign, daily updates from external systems are made via a CSV or TXT file. To load the file, apply the following steps: Configure the Enrichment type activity to reconcile the collected data with that already in the Adobe Campaign database. This recipient is a premium member as. Select the Limit the selected records option. An input form lets you edit an instance associated with a data schema from the Adobe Campaign Client Console. User consent and data retention: you must get user consent,. 7. Firstly, create a query activity in your workflow that joins the delivery logs and the recipient table based on the recipient ID. The page displayed lets you view the state of the connected instance, i. To create a service, click the Create button located above the list. This send will not be reconciled with our main recipient table, so our usual 'filters' that stop this from happening for other deliveries will not work. It obeys a grammar specific to Adobe Campaign, called a schema. In the template, click the Seed addresses tab. The channels are used. By default,. You can also specify whether the field is part of the reconciliation key which allows recipients that. . . The Recipient table in grey represents the main customer table around which everything is being built: To access the description of each table, go to Admin > Configuration > Data schemas, select a resource from the list and click the Documentation tab. 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. The impacts are as follows: overconsumption of disk space, thus affecting database access, indexes which have not been regularly updated, which. An <attribute> element must have a unique name within an <element>. The descriptive analysis wizard can be launched via the Tools > Descriptive analysis menu: in this case, the analysis concerns recipients by default ( nms:recipient ). This custom key is the actual record primary key in the external system feeding Adobe Campaign. To add data from the Adobe Campaign database: Select the type of data you want to add. Then click Next. Hi Ankur, BR_data schema is a table storing master branch codes( BR_Code). Choose: Last name, First name, Email, City and Account number. This custom key is the actual record primary key in the external system feeding Adobe Campaign. The outgoing transition will have the pk's of the upserted nms:recipient rows to use for your custom table's recipient-id fk. In the Expression column, select the additional field in the Interaction node. . To configure URLs, select the Display URLs option in the lower section of the delivery wizard. 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. So, it will pull the data from Postgres and. Built-in table extension offers flexibility, but it does not allow to remove some unused fields or links. The outgoing transition will have the pk's of the upserted nms:recipient rows to use for your custom table's recipient-id fk. To create conditional content according to the value of a field, apply the following steps: Click the personalization icon and select Conditional content > If. Use. The recipient table SQL update script is as follows: ALTER TABLE NmsRecipient ADD iFeatureId INTEGER; UPDATE NmsRecipient SET. For each page of the form, you can add a field via the first button in the toolbar. Better understand the tracking difference between a person/people and a recipient in Adobe Campaign with this example. In the split activity, specify the subsets to create, according to the Event column. Create or extend Campaign schemas. Greetings: inserts greetings with the recipient’s full name, followed by a comma. To create new reports, refer to this section. We are trying to make environment GDPR ready. Profile means a record of information (e. Data types. Creating and configuring schemas linked to the custom table. Insert a list with group via the toolbar and enter its label, for instance: List of deliveries per campaign. About custom recipient table. This mode is costly in terms of calculation during log reconciliation. The nms:seedMember schema must be extended. Check this documentation. Which table needs to be selected? The recipient log tracking table ( nms:trackingLogRcp) Fields to be selected for output columns? Primary key (with count) and Email What criteria will information be filtered based on? A specific period and an element of the delivery label Developer. Most of the time, performance issues are linked to database maintenance. As a. In this. To do this, click in the message content and click the field insertion button. Enter an ID and a label, and select the Limit the line count option in the Data collected field. Could you Please check by adding th. Select the creation folder for the new list. By default, your new workflows are based on a workflow template that is been pre-configured and based on a recipient table. In the sorting window, sort the names alphabetically. Click the Table data XPath… link and select the delivery link, i. Determine whether you use custom profiles tables in addition to the out-of-the-box profiles table (nmsRecipient). I've been trying to build some simple examples based on the documentation: Data oriented APIs. In the Data filtering window, select Filtering conditions. These fields offer a button that opens a drop-down list to help you. Right-click Recipient then select Actions and Modify the options of the targeting dimensions. The Recipient table in grey represents the main customer table around which everything is being built: To access the description of each table, go to Admin > Configuration > Data schemas, select a resource from the list and click the Documentation tab. There are two methods for extending an existing schema: Modifying the source schema directly. Query using grouping management. Learn how to create filters for a custom table 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. Refer to Step 3 - Sort data. Right-click the Age column in the recipient list, and select Filter on this column. It can also be created using the Create the list if necessary (Computed name) and Create the list if necessary (Computed Folder and Name) options. Learn how to create filters for a custom table 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. When you create or extend a schema, you need to create or modify the associated input forms to make those changes visible to end-users. This will destroy information related to the id's, comprising the tables in this pic, along with any custom tables that use @recipient-id:To create a hypothesis template, apply the following steps: In the Adobe Campaign explorer, click Resources>Templates>Hypothesis templates. This enables access to the list of tables available in the external base. Creating the data schema. The Operation type field lets you choose the process to be carried out on the data in the database: Insert or update: add data or update it if it has already been added. To create and configure a Pressure typology rule, apply the following steps: In the list of campaign typology rules, select the New icon above the list. 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. Moreover, quarantines. Name Use Standard schema; Recipients: Deliver to recipients of the Adobe Campaign database: nms:recipient: Visitors: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. This report combines the key indicators for tracking the behavior of recipients upon receiving the delivery such as open, click-through rates and click. The pre-defined Adobe Campaign data model includes the main tables listed below. it also mentions an extension table which will by default have out of box functionality linked. Learn how to create filters for a custom table 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. To create a new Group type list, apply the following steps: Click the Create button and select New list. From the Explorer, access a workflow folder. These options allow you to select the. In the Data to extract window, select Primary key, First name, Last name and Email. 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. Sign In. Learn how to use a custom recipient table. Select Adobe Campaign Variable Dialog. Mirror page: the recipient clicked on a link to the mirror page. . Learn. In a multi-channel campaign, a single marketing communication uses multiple channels to reach a wider target audience. Click the Edit link, select Activate random sampling, and click Next. To start the deployment wizard, select Tools > Advanced > Deployment wizard. A schema is an XML document associated with a database table. 7K. abc:Recipients already has column "codigointernocomputacional" on this table with data. Click Tools > Generic query editor… and choose the Recipients ( nms:recipient) table. SOAP methodsHi All, How can we delete a delivery if the target has been deleted from the recipient table. An Exclusion -type activity creates a target based on a main target from which one or more other targets are extracted. Meet our community of customer advocates. The content is defined in JSON format in Adobe Analytics for each trigger. Distinct clicks for the population reached. Select the Filtering rule type, then specify the desired channel. Interest 3 – > Block 3. This table has a number of pre-defined fields and tables that can be easily extended. Sort the columns to display them in the right order. 3. Next, add subscription boxes. Define the data sorting sequence. These are all the fields defined in the recipients table, whether standard fields (typically: last name, first name, address, town, date of birth, etc. However, in the structure of Leads table I see it is linked to Recipients. Thanks David for your reply. 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. Refer to Step 1 - Choose a table. Use case: configure the field substitution. Most organizations are importing records from external systems. The pre-defined Adobe Campaign data model includes the main tables listed below. Rest of the Pros is business value you can generate using this setup . A List update activity stores the population specified in the transition in a list of recipients. Installation and configuration of the Adobe Campaign platform: check network. Manual monitoring. Recipient means the end user that receives Customer's message via any available Channel. Example: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. Learn how to create filters for a custom table 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. Lists and direct updates. First create a new field in the comunications_preference schema to store the recipient ID. Recipient data stored in the database enable you to filter the target and add personalization data. IMPORT allows you to import data into any other table whereas the RECIPIENT IMPORT right allows to import into the recipient table. A recipient can be related to several occurrences on the subscriptions table. Filter the data. From this page, you can create new recipient, edit an existing recipient and access its profile details. To target another table (visitor table for anonymous offers or a. Topics: Audiences. The ‘Test’ activity evaluates JavaScript expressions in order to activate the appropriate transition. Select the type of field you want to create: you can choose to add a field in the database, a variable or to import a group of fields created in another form and collected in a container. Instance settings are configuration details of an Adobe Campaign instance. Image management Image referencing. Creating population B: Click Add to create a new tab for population B. Recipient. Notice that the NmsRecipients table is the value in the from argument of the query. The built-in reports provided by Adobe Campaign can be found in the table below. For example, to sort the last. To create this example, apply the following steps: Click Tools > Generic query editor… and choose the Recipients (nms:recipient) table. It defines data structure and describes the SQL definition of the table: Labels, descriptions, and other properties. For example, to select all the persons who are named Isabel Garcia, you can write this code: <condition boolOperator="AND" expr="@firstName='Isabel'"/> <condition expr="@lastName='Garcia'"/>. It must be reconciled to find the Shopper ID, which is the primary key. Here are the information you can monitor using the several tabs. The content is defined in JSON format in Adobe Analytics for each trigger. To create this example, apply the following steps: Click Tools > Generic query editor… and choose the Recipients (nms:recipient) table. Once identified, they can be removed from the quarantine list, and included in future Campaign email deliveries. Documentation. When you have your content ready, you need to carefully define who will receive your message. Adobe Campaign offers other target mappings for your deliveries, to be used based on your needs. We can see that the recipient data from previous ad-hoc list load sends is stored in Adobe Campaign, we're looking for guidance on how we can configure a new query to look at list-load delivery. The configuration steps are as follows: General parameters. To access other campaigns, click the Select link icon. I added the JS script activity and try to pass the language field. The advantage is that you can extend a table without needing to modify the original schema. ) or user defined fields. The data type is entered via the type attribute in the <attribute> and <element>. In Adobe Campaign, recipients are the default profiles targeted for sending deliveries (emails, SMS, etc. Breakdown of opens, clicks and transactions by time period. 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. Transactional messaging relies on the Adobe Campaign data model, and uses two additional separate tables. 1. You can add as many subscription check boxes as needed. Where necessary, edit the Web application properties to select another table. VIP %> If it is not linked to nms:recipient Schema , then Please create a link between the Custom Schema and Recipient Schema or you. What are the filtering conditions of the recipients? city and email domain. Enter an ID and a label, and select the Limit the line count option in the Data collected field. Formatting function for proper nouns: generates the toSmartCase Javascript function, which changes the first letter of each word to uppercase. The Delivery statistics table contains the data available for sent. Linking survey responses to a recipient. The list of tables to maintain depends on your version of Adobe Campaign, how you use it and on the datamodel configuration. To perform this, create a workflow and add a Query activity on your quarantine table to filter out all impacted recipients. This table stores all the marketing profiles. .