For more on the content of these reports, refer to this section. Relative referencing lets you enter the URL of the server containing the images in the NcmRessourcesDir and NcmRessourcesDirPreview options. From the Explorer, access a workflow folder. Created for: Beginner. The available fields correspond to the standard fields in the profiles of the delivery recipients (nms:recipient table): name, first name, email, etc. In the Lines to retrieve field, select ‘1’ as a value. Query using grouping management. You can now. The main steps to create typology rules are detailed in this section. Most organizations are importing records from external systems. You can then start the delivery analysis, then confirm the delivery sending. The next page defines the filter condition. You can choose whether or not to activate certain identification standards and encryption keys to check the domain name, such as Sender ID , DomainKeys , DKIM. With workflows, import and export operations can be repeated automatically according to a schedule, for example to automate data exchange. I feel that if an extension table is used it would be ok for my requirement as all out of box functionalities will come along with that. Create a new workflow template from Resources > Templates > Workflow templates. While the physical key of the Recipient table is the “id” attribute, it is possible to determine a custom key in addition. Installation and configuration of the Adobe Campaign platform: check network. To avoid conflicts between campaigns, Adobe Campaign can test various combinations by applying specific constraint rules. 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. Most organizations are importing records from external systems. 3. Quick linksPerform a mass update. I'm trying to optimize a workflow: I see this workflow loads a entire table (Carga Recipients) to then do a join with table "Leads" in "Leads vs Recipient". Use an external recipient table. You can retrieve call data when the proposition is generated or when it is accepted (when the person clicks on the offer. The ‘Test’ activity evaluates JavaScript expressions in order to activate the appropriate transition. 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 channels are used. Examples of JavaScript code in workflows | Adobe Campaign. Enter a new type in the folder of the explorer tree. This report combines the key indicators for tracking the behavior of recipients upon receiving the delivery such as open, click-through rates and click streams. Then click Next. It is the default table used for the recipients of deliveries. Learn how to use a custom recipient table. Insert a list with group via the toolbar and enter its label, for instance: List of deliveries per campaign. The following list contains only the tables most subject to fragmentation. First, we need to target the week before the birthdate as the Validity start date with the following Expression: SubDays ( [target/@birthDate], 7). In the Value (long text) field, you can paste the following JSON code, which specifies two triggers. Topics: Social Marketing. It must be reconciled to find the Shopper ID, which is the primary key. Schemas enable you to define an entity in the database. If the relationship is the other way (recipient table has fk's to custom table. 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'"/>. User. Standard schema. To create conditional content according to the value of a field, apply the following steps: Click the personalization icon and select Conditional content > If. Click the Add button to define restriction filters. Click Save to create the offer. 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. You can change how the details are shown in their respective visualization settings. 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. Only <element> elements can contain <attribute> elements and <element> elements in the XML structure. Their target mapping therefore uses the fields of the nms:recipient table. Leader. Firstly, create a query activity in your workflow that joins the delivery logs and the recipient table based on the recipient ID. Insert: only add data. Adobe Campaign comes with common schemas to identify data such as: recipients, delivery logs, subscriptions,. Then, to create the custom date field Validity end date which will target the week after the birthdate, you. Query delivery information. Double-check your active target mappings. Adobe Campaign comes with a built-in profile table: nmsRecipient. , 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. For more on this, refer to Creating a query. The last page launches a preview of the data returned by the query. To perform manual updates, right-click the selected recipient (s) to use the Actions shortcut menu, or use the Actions icon. To do this, you need to create the schema of the table and update the database structure to generate the corresponding table. To avoid common issues that could prevent you from executing your delivery and to improve your recipients’ experience, Adobe Campaign enables you to personalize your messages. abc:Recipients already has column "codigointernocomputacional" on this table with data. Creating and configuring schemas linked to the custom table. A schema is an XML document associated with a database table. Enter an ID and a label, and select the Limit the line count option in the Data collected field. Delivery table: The data model also includes a part dedicated to store all the marketing activities. Developer. Click Tools > Generic query editor… and choose the Recipients ( nms:recipient) table. Hi , Yes, you can use the query activity and add the additional Data and mask the middle characters of VIP Numbers and use it as the targetData in the Delivery activity Regards, Pravallika. To populate a collection of links, add the unbound=“true” attribute to the definition of the link element in the data schema: <element. In the Data to extract window, select Primary key, First name, Last name and Email. Other tables linked to the Recipient table also contain. By default, Adobe Campaign offers a built-in recipient table to which out-of-the-box functions and processes are linked. add an extra field i. If the Leads package is enabled, before searching the “trackingLog” table, Adobe Campaign will search the “incomingLead” table for previous tracking log records. Regards, Pravallika. 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. Compute aggregates. Click on the Advanced parameters… link then check the “The content of the block is included in an. I am currently using default form creation from Adobe Campaign under online web application, please see the workflow below. I feel that if an extension table is used it would be ok for my requirement as all out of box functionalities. Beginner User Developer In this example, we want to recover the names and emails of recipients whose email domain is “orange. Go to the Message Center >Transactional message templates folder in the Adobe Campaign tree. To create the corresponding schema, apply the following stages: Edit the Administration>Configuration>Data schemas node of the Adobe Campaign tree and click New . When admin user login to system, based on his country, he should be able to see only those recipient so that - 371954This aggregate table is used for performance reasons when displaying reports, in the place of the Recipient tracking logs table (nms:trackingLogRcp) and it is not calculated in real-time. These fields are added to Output columns. Can you confirm that all your data (including custom fields) are part of the recipients table? Or do you use a different table - related to the recipients table - to store the brData? Let me know, FlorentVia Adobe I/O Runtime, Adobe’s serverless platform, marketers and developers can leverage Unified Profiles built-in AEP and then get that data into Adobe Campaign Classic. Recipient means the end user that receives Customer's message via any available Channel. The descriptive analysis wizard can be launched via the Tools > Descriptive analysis menu: in this case, the analysis concerns recipients by default ( nms:recipient ). Regarding Cons. Adobe Campaign lets you set up tools to encourage viral marketing. Read list. Insert a table object, and choose the query XML object related in path for broadlogs: Do the same with trackingLogs: Hope this helps. . The Adobe Campaign default data model is presented in this document. The nms:seedmember schema must be extended. Experience League. Select the type of proof you would like to use: Email rendering: select this option to test the way your message is received according to the inboxes targeted. Add an enumeration type calculated field. If the delivery table is an external table, you will need to make additional configurations. For each recipient, the enrichment activity will add a single line from the. In Adobe Campaign, daily updates from external systems are made via a CSV or TXT file. Learn more about custom recipient tables in this page. . ) to your customers. The impacts are as follows: overconsumption of disk space, thus affecting database access, indexes which have not been regularly updated,. 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 directly in. From this page, you can create new recipient, edit an existing recipient and access its profile details. In Adobe Campaign, recipients are the default profiles targeted for sending deliveries (emails, SMS, etc. Created for: Intermediate. These options contain the location of images for. Profiles are contacts stored in Campaign database. Specify a start date in the Contact date field. Browse to Profiles and targets to access recipients stored in Adobe Campaign database. Select the Access data from an existing table or an SQL view option and click Next . You can add as many subscription check boxes as needed. Views. 3. Choose: Last name, First name, Email, City and Account number. 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. Sort the columns to display them in the right order. Learn. Hi Vipul, Could you please tell the steps of how to export schema from one instance to another? Or if there is any link describing the same could you please share. Viral and social marketing. To create a new Group type list, apply the following steps: Click the Create button and select New list. This custom key is the actual record primary key in the external system feeding Adobe Campaign. Learn more. Workflows. I added the JS script activity and try to pass the language field. Topics: Audiences. A list is a static set of recipients that can be targeted in delivery actions or updated during import operations or during workflow execution. Select the creation folder for the new list. 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. If relevant, you can use the default Recipient table with the out-of-the-box fields, such as described in this section. Choose: Last name, First name, Email, City and Account number. Adobe Campaign Classic allows marketers to design cross-channel customer experiences and provides an environment for visual campaign orchestration, real time interaction management, and cross channel execution. I am currently using default form creation from Adobe Campaign under online web application, please see the workflow below. This table has a number of pre-defined fields and tables that can be easily extended. Create a new web application to access the custom table via the Adobe Campaign home page. . The data of the Adobe Campaign database and the existing lists can be updated using two dedicated activities: The List update activity lets you store worktables in a datalist. But what if we want to push real-time data to Adobe Campaign, and more specifically to the recipient table? Then we have to make use of SOAP web services. The recipient table SQL update script is as follows: ALTER TABLE NmsRecipient ADD iFeatureId INTEGER; UPDATE NmsRecipient SET. The list can be selected from the list of existing groups. If you want to expire cryptedId's, you can reload the data in recipient table. Last update: 2023-07-31. Most of the time, performance issues are linked to database maintenance. The ‘JavaScript code’ activity is simply used to execute a script. 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. Meet our community of customer advocates. Determine whether you use custom profiles tables in addition to the out-of-the-box profiles table (nmsRecipient). Insert a list with group via the toolbar and enter its label, for instance: List of deliveries per campaign. Sign In. For further information, refer to Schema reference. You can then select the type of filtering to apply: You can select recipients using the types of targeting defined in the database. For example, between a recipient and their country. Have the 'Update data' activity for nms:recipient output a transition, then connect it to a 2nd update activity for your custom table. Distinct clicks for the population reached. It applies to all the data in the Adobe Campaign database. Choose: Last name, First name, Email, City and Account number. Extend an existing table with new fields. 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. Cardinality 1-N. This enables access to the list of tables available in the external base. orderBy clause. Key management and unicity. To create this example, apply the following steps: Click Tools > Generic query editor… and choose the Recipients (nms:recipient) table. Random field substitution lets you attribute a value from the recipient list to the seed addresses that are empty when the user uses this value in a delivery (example: name, city, etc. Reports based on a schema that is specific to the default Adobe Campaign recipients (nm:recipient or schema linked) must be re-developed in order to take into account the data from the custom table and its tables linked via the target mapping (see the Target mapping section). Creating and configuring schemas linked to the custom table. To create a data schema, apply the following steps: Open the Adobe Campaign Explorer and select the Administration > Configuration > Data schemas node. Click Finish to confirm. In Adobe Campaign, recipients are the default profiles targeted for sending deliveries (emails, SMS, etc. Linking survey responses to a recipient. In the context of an Enterprise (FFDA) deployment, the primary key is a Universally Unique IDentifier (UUID), which is a string on characters. Experience League. You can defer the message sending by scheduling the delivery. 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. Then select the Data linked to the filtering dimension option, select the Competition results table and click Next. 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. g. If you want to expire cryptedId's, you can reload the data in recipient table. Some internet access providers automatically consider emails as spam if the rate of invalid addresses is too high. Hi Ankur, BR_data schema is a table storing master branch codes( BR_Code). Archive your tracking logs beyond the retention period of Adobe Campaign: Check the duration of the retention period in your campaign instance. 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. Enter the information in the Edit tab of the list creation window. Learn more in Campaign Classic v7 documentation. Create a new workflow. Most text fields are JavaScript templates: JavaScript expressions can be included between <%= and %>. The Adobe Campaign default data model is presented in this document. A list of recipients is also referred to as audience. SOAP methodsAlso consider that due to the volume of information processed daily, the IOPS of the database server is critical. Once identified, they can be removed from the quarantine list, and included in future Campaign email deliveries. Hi , The Column which is used as Joining Key in the Enrichment (The field "recipients" and "comunications_preference" share is: "codinternocomputacional") differs from the joining keys being used in the Link (<join xpath-dst="@id" xpath-src="@RECIPIENTID"/>). Click Tools > Generic query editor… and choose the Recipients ( nms:recipient) table. Recipient means the end user that receives Customer's message via any of the. Adobe Campaign: Subscribe to Services:. This page lists new capabilities, improvements and fixes coming with the latest Campaign Classic v7 Release. These fields are added to Output columns. 2. Insert a list with group via the toolbar and enter its label, for instance: List of deliveries per campaign. While the physical key of the Recipient table is the “id” attribute, it is possible to determine a custom key in addition. Solved: Any suggestion . Creating the data schema. 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. Milan_Vucetic. Adobe consultants or technical administrators to learn more about retention or if you need to set retention for custom tables. 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. This is the default mode. Then click Next. Here we want to sort account numbers in descending order and names. email: Now the page tables for displaying the results. Here are the main items to check: Configuration: we recommend checking the initial Adobe Campaign platform configuration and running a full hardware check. Add a Label. Tables and schemas. Select the Create a schema option for content management, then click Next. Select the transactional message template. Click Save to create the cube: it is added to the list of cubes. To use a target type, select it and click Next. Then click Next. To do this, open the Schema Editor and - 622775To retrieve the broadlogid of each email corresponding to the correct offer or order number, you can use a query activity in your Adobe Campaign workflow. Proof: select this option to test the message before sending it to the main target. The calculation of the key value depends on a sequence. Interest 4 – > Block 4. Hi, Have the 'Update data' activity for nms:recipient output a transition, then connect it to a 2nd update activity for your custom table. Open the Generic query editor and select the Recipient table (nms:recipient). Better understand the tracking difference between a person/people and a recipient in Adobe Campaign with this example. These fields offer a button that opens a drop-down list to help you. Where necessary, edit the Web application properties to select another table. For a better understanding of Campaign built-in tables and their interaction, refer to this section. Click the Data tab and change layout of the table: add three columns on the right. Sort the columns to display them in the right order. Topics: Audiences. 1 Adobe Campaign doesn’t allow direct usage of custom SQ functions, we need to whitelist them first inside the xtk:funcList entity. Beginner. These mappings are as follows: Name. It defines data structure and describes the SQL definition of the table: Labels, descriptions, and other properties. Adobe Campaign comes with a built-in profile table: nmsRecipient. When creating a custom table, you have two options: All the profile data is maintained in the Adobe Campaign database. The steps for building a query in Adobe Campaign are as follows: Select the work table. Hi , Have you assigned alias to the Masked VIP Number in the query's Additional Data as shown below. it also mentions an extension table which will by default have out of box functionality linked. The Delivery statistics table contains the data available for sent. In the Target element window, the filtering condition for. orderBy clause. Then click Next. Click the Edit link, select Activate random sampling, and click Next. This custom key is the actual record primary key in the external system feeding Adobe Campaign. For your case, it doesn't surprise me that the recipient extension doesn't have the 'view' attribute. Many thanks Ankur. To do this, open the Schema Editor and - 622775 To retrieve the broadlogid of each email corresponding to the correct offer or order number, you can use a query activity in your Adobe Campaign workflow. Learn how to use a custom recipient table. Experience League. To view and dialog with the new recipient table in the Adobe Campaign interface, apply the following steps: Create a new form to edit the content of the new recipient table. Click the New icon located above the list of data schemas. g. Adobe Campaign Community Lens 8th edition is out! Read More. Could you Please check by adding th. 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. To create this UUID, the main element of the schema must contain the autouuid and autopk attributes set to true. 4. For your case, it doesn't surprise me th. Before you create a target mapping, several configurations are necessary in order for Adobe Campaign to operate with a new recipient data schema. Regards, Milan - 399209Sign In. Adobe Campaign provides a graphical assistant, available in the Adobe Campaign client console, to define the parameters of the instance to which you are going to connect. Specify whether the template is destined for hypotheses on offers or deliveries via. To analyze a table other than the standard recipients one ( nms:recipient ), click the Advanced settings… link in the. The pre-defined Adobe Campaign data model includes the main tables listed below. You must now configure them. This icon can take. - 634613To create a data distribution template, apply the following steps: To create the data distribution template, go to the Resources > Campaign management > Data distribution node and click New. Courses Tutorials Certification Events Instructor-led training View all learning options. 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. Sign In. In some reports, Adobe Campaign differentiates. This table matches the nms:recipient schema. Recipient data stored in the database enable you to filter the target that will receive any given delivery and to add personalization data in your delivery contents. Hi , The Column which is used as Joining Key in the Enrichment (The field "recipients" and "comunications_preference" share is: "codinternocomputacional") differs from the joining keys being used in the Link (<join xpath-dst="@id" xpath-src="@RECIPIENTID"/>). Deliver to recipients of the Adobe. Firstly, create a query activity in your workflow that joins the delivery logs and the recipient table based on the recipient ID. Sort the columns to display them in the right order. For example, between a recipient and the subscriptions table. Each entity contained in a. A list is a static set of recipients that can be targeted in delivery actions or updated during import operations or during workflow execution. When creating a custom table, you have two options: Person/people and recipients. 2. The referrer must also enter their Last name, First name and Email. Use an external recipient table. The information entered in the fields is stored in a specific table known as the visitor table. I made an entry (Folder-id) in Recipient Form in Adobe Campaign and Folder-id (Primary key) is showing in Recipient folder structure now, but. Step 2: create the personalization block: Go to the Resources > Campaign management > Personalization blocks menu of the Adobe Campaign console. In the delivery window, select the delivery template suitable for the channel. Like. Enter a label and click Save. 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 directly in the matching. Choose the Create a new table in the data model option and click Next . The application is therefore prohibited from synchronizing the table, its columns and its. 1. For reference,. 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 template, click the Seed addresses tab. Based on the timeframe of the incident, below are the recommended guidelines for this query. Elements are designated by their name, and attributes are designated by the name preceded by the character “@”. From there, you can design, plan, execute, manage, and optimize data-driven, cross-channel marketing campaigns. To configure URLs, select the Display URLs option in the lower section of the delivery wizard. 1 Accepted Solution. Could you Please check by adding th. Here we want to sort account numbers in. Federated Data Access: Mix target data and base table data in delivery template. Campaign Optimization is the Adobe Campaign module which lets you control, filter and monitor the sending of deliveries. Hi guys, I'd like to configure an import WF that, from a csv file (name,surname,email) will send campaigns to these users, without any - 307501. - Access to the Adobe campaign (CM) system tables in the hybrid deployment (believe me this is very helpful) - More customizable. This report combines the key indicators for tracking the behavior of recipients upon receiving the delivery such as open, click-through rates and click. An <attribute> element must have a unique name within an <element>. By default, searches in previous tracking logs are performed in the “trackingLog” table. To target another table (visitor table for anonymous offers or a. In the split activity, specify the subsets to create, according to the Event column. Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023! Read More. Profile means a record of information (e. Each table is represented by summary numbers and charts. Learn. However, in the structure of Leads table I see it is linked to Recipients. Refer to List update. To add a field or index or other element to one of the core data schemas in Campaign, such as the recipient table (nms:recipient), you have to extend that schema. The view=“true” attribute tells the database structure update wizard to ignore this schema. It is then accessible throughout the workflow. About workflows. Hi you can set up a custom Recipient schema. Configure the interface. You can create recipients from this view, as well as: To access advanced functionalities and configurations, you need to click the Explorer icon. XPath is a syntax that lets you locate a node in the tree of an XML document. Also, the waves were not set in the Delivery properties. This can be data belonging to the filtering dimension or data stored in linked tables. Recipient data stored in the database enable you to filter the target and add personalization data. Create a filter. So the information in the file "md_preferencias. This occurs when there is a need to map tables that have already been created in the database. . Then click Next. [query/delivery]. If the relationship is the other w. Adobe Campaign APIs are used in JavaScript within the application and in SOAP outside of it. The offer is available in the platform and its content can be configured. Breakdown of opens, clicks and transactions by time period. The configuration steps are as follows: General parameters. Experience League. 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 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. IMPORT allows you to import data into any other table whereas the RECIPIENT IMPORT right allows to import into the recipient table. In the Type column, the possible values are: Email click: the recipients clicked on a custom link. What are the filtering conditions of the recipients? city and email domain. Select the country table in the Target schema field. Bounces and non-deliverables by cause and domain. Tracking indicators. Refer to Step 3 - Sort data. The Adobe Campaign tab lets you link the field to a field in the Adobe Campaign recipient table. Dynamic Reporting provides fully customizable and real-time reports. co. Moreover, quarantines. This table stores all the marketing profiles. This custom key is the actual record primary key in the external system feeding Adobe Campaign. The root element of the schema must contain the extendedSchema attribute with the name of. Just like the built-in recipient table provided with Adobe Campaign, the new recipient table may receive a batch of predefined filters. This guarantees that the messages sent meet the. Select 'Define a collection' as the link type. These filters will be available in the target selection window with the same functionalities as segments for recipients (using parameter input forms, folders, etc. Then click Next. Clicked on the “LEARN MORE” custom link. MaskedVIPNumber %>. Topics: Release Notes. Delivery throughput charts, in messages/hour and Mbits/s. In a multi-channel campaign, a single marketing communication uses multiple channels to reach a wider target audience. Thanks Milan for the information. you can filter on @address of broadLogRcp, it is the short path instead of recipient. This table has a number of pre-defined fields and tables that can be easily extended. Delivery throughput charts, in messages/hour and Mbits/s. co. By default, Adobe Campaign offers a built-in recipient table to which out-of-the-box functions and processes are linked. For more on the content of these reports, refer to this section. Click Tools > Generic query editor… and choose the Recipients ( nms:recipient) table. Recipients. Schedule the delivery sending. VIP %> If it is not linked to nms:recipient Schema , then Please create a link between the Custom Schema and Recipient Schema or you. The built-in reports provided by Adobe Campaign can be found in the table below. lastName %> syntax. ). I've been trying to build some simple examples based on the documentation: Data oriented APIs. Is there a better way to do the join without having to load the entire "Recipients. If the data belongs to the query’s filtering dimension, simply select it in the list of available fields to display it in the output columns. : information on the instance: version, name, database engine, installed packages, server system indicators, a view of workflows and. Query the recipient table.