10 TOTAL. Hi Team, I have imported the SAINT classification files in Adobe Analytics with same key value with different data sets as shown like below: Key Product Product Code 123 Books 10 123 Pen 15 123 Bag 20 When I checked in the report, I could see the data of last row only i. Adobe I/O. Admin. . In insight there is a transformation called "copy" where you can classify multiply items into one group. Admin. Does. Hi Team, I am running a SAINT classification rule on eVar, most of the time it is working as expected but for few instances is not working even though when same data is validated correctly on Test rule. The client has already ensured that the "Quote Output" box is unchecked so they can receive special characters. Is there a rule of thumb when it comes to the ETA of SAINT uploads? Thanks again. They provide a means to upload metadata that can be connected to the information being gathered by Adobe Analytics. Here are a few articles on how Adobe Classifications and Groupings work (aka SAINT)Can only Admins access the Classification Importer or can others be granted access? If others can, how would I go about doing that? It seems after the new June Release updates, some users can no longer get to the Classification Importer section. Classifications take a day or two to fully propagate across all servers. I'd like to be able to copy the structure of a SAINT table from one eVar to another. If you look at row 4, you can see that the total Out of Stock Amount is $348, but that the Weighted Out of Stock Amount is $34. 1 Accepted Solution. Analysis Workspace: Click Analytics > Workspace, open a project and click + New > Create Segment. Community of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsAdvertising 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 EngageAs long as the parent classification is correct, you can ignore column A altogether in context of subclassifications. The objective of classification is to enrich the already collected data item with more information for better analysis and insights. The data includes the key that is associated to an eVar along with conversion classifications. Learn how to use Adobe Analytics APIs to classify your data with metadata and rules. We are sending data to a client's Adobe Analytics Reporting Suite via POST API. Root Cause: Using different evars is the cause for this behavior. Logic and Reasoning. In this video, we walk through the configuration of classifications for conversion variables, often known as “eVars”. Hi Matt yes that is correct. Select "Regular Expression" for rule type, and for the regex, use. Adobe analytics is completely grey area to me can you help me understand little more. products, is the fundamental dimension for commerce tracking and reporting in Adobe Analytics. Main Street #360 Lehi, Utah 84043. Learn. We work with clients who would like to see their metrics grouped geographically the way they group countries, by their sales regions. which we configure with report suite already selected in Adobe Analytics on top-right corner. The downside was that users could open up the actual eVar28 report in Adobe Analytics and see the ugly values shown above (yuck!). Select the report suite from which you want to export the report data. 1-(385) 286-0800. This makes it really hard to change classifications across rsids, especially since there's no easy way to tell which rsids d. . As a reminder the Classification Rule Builder is meant to help you create automatic and rule-based classifications that can be applied across multiple variables and multiple report suites. 12-06-2018 10:21 PDT. Root Cause: Using different evars is the cause for this behavior. I would like to recommend adding the ability to print/list all classfications for any report suite. Advanced details: Most likely your firewall, VPN, or adblocker is blocking the url:. fin file: Create a blank text document on your desktop and rename the filename extension from . However, periods of heavy classification use across organizations that use Adobe Analytics can cause files to take longer than 72 hours. Logic and Reasoning. 3) SAINT API. The report suite and variable list is populated with all classified variables available. The first is a numeric identifier of the report suite. Overview of Classifications in Adobe Analytics. Furthermore, each classification constitutes one data column in the data file, with the classification name as the column heading. I want to have the same structure across all 14 of my production suites. Search Box|$1. This would allow users to come into the tool. Based on your 2 sample strings, I'd say your regex pattern may not be accounting for the "-" character. The classifications (SAINT) FTP option provides more flexibility in uploading large classification data sets, including the ability to upload data into multiple report suites and to upload data sets larger than 50,000 rows. It would be helpful to have status to know an - 343743. The recommended number of rules per rule set is between 500 and 1000, although there are no limits. SAINT Classifications? BR, Vitali - 247351. Most rece. Click Import File. To create the rule set, click Admin > Classification Rule Builder > Add Rule Set. So if you go to Star >> Admin tools >> Classification importer >> export, then export all the tracking code that. The following are common causes behind FTP classifications not processing uploaded files: Missing . jasminesthegrea. Use ~deletekey~ in any column to delete the entire classification row. Select Adobe Analytics. Based upon the book, The Adobe SiteCatalyst Handbook, our class provides a four hours deep dive into all of the critical features of Adobe Analytics, followed by scenario-based learning exercise to help enforce the concepts learned in. one for Body and one for the Band. Configure conversion classifications. Sign In. Originally written by Analytics Demystified on September 18, 2018. 1 Accepted Solution. ymiki. {"payload":{"allShortcutsEnabled":false,"fileTree":{"docs/getting-started":{"items":[{"name":"graphics","path":"docs/getting-started/graphics","contentType. For example: Using ~empty~ under the Brand Category classification. But as Adobe Analytics. I was disappointed to find that I can't use SAINT to group geo-segmentation values. The most popular GA method uses a set of UTM parameters to identify the campaign source, medium, term, content and campaign (though there is a “utm_id” option similar to how Adobe does it). You perform this using a regular expression. Support. PROPERTY 2. Experience League. What is it though? What is classification in Adobe Analytics: Classification allows us to append additional data points to any value. Courses Tutorials Events Instructor-led training View all learning optionsHi, I have a multi-level campaign classification set up with the following features, 1. 28-04-2021 11:55 PDT. Thank you in advance. With my new company, they do not allow any feeds to external partners to be FTP. . Troubleshoot FTP imports. Step 3: Configure report suites and variables. . fin. Doing it in Excel is fine but it would be better if we could just do it within sitecatalyst or the admin console. . This could happen when not all the report suites have the same "Display Name" for that particular classification eVar, i. They want us to generate them for them to help them track performance on their campaign. This is great but for sitecatalyst i use saint to classify multiply items the only problem is that I have to classify every row in the saint file where as with insight you can set-up a. 14-10-2010. Sample values: 5704396::en_us::null:null:::::gb -. This can be accomplished by passing s. Transcript. Click Export File, and open the downloaded file in a. Additionally, you can access other reports configured by using SAINT classifications. Looking at the notification, it seems to have uploaded the rows successfully for classification, so no issues there. Search for media from: "Daniel Robledo "Media; Sort by Alphabetically - A to Z. But not familiar. Mouse over the Edit Classification icon, then select Add Classification. - 341725Hi Team, I have added the classification data, imported manually and it is uploaded successfully too. 01-06-2021 08:24 PDT. Example: FTP Classification Account Name : Products Categorization. Level 1. Level 2. The selected report has a SAINT import that is processing. Like, Browser report is populated using information from the user agent, Countries information is populated using the data shared by Device Atlas and so on. Usually it would take upto 72 hours for classification data to showup in reports and that would be the best way to validate the classification import data. They have to b. 1) Browser import (1MB limit) 2) FTP. Adobe Analytics Tutorial | What is SAINT. Following an initial upload in a report suite (for a given variable or report), Adobe recommends uploading only new and updated rows in subsequent imports. Select Service Account (JWT) here. Sign In. I've got classification "A" based on evar 41 and classification "B" based on evar 41. Doing it in Excel is fine but it would be better if we could just do it within sitecatalyst or the admin console. What about having two Product Classifications set up. Looking at the notification, it seems to have uploaded the rows successfully for classification, so no issues there. These attributes can help you better understand your marketing and experience efforts by allowing you to group similar elements and break down data to dive. Classifications have 2 pieces : Relationships (Variables) and divisions (classification. Best, Brian. SaveClassification method doesn't have a description field. "Classifications are cool (and sometimes hard to keep up-to-date. the files. In the Classifications Rule Builder, classify the sub-classification key from the original tracking code. In its simplest form, SAINT technology is essentially a big lookup table for a specific report in Adobe Analytics. Since for SAINT, we select report suites at later stage (as part of SAINT itself) looks like we cannot change time zone in this case. Do you know also if the description can be edited? I noticed the ReportSuite. Manage data using components like Segments, Calculated Metrics, Virtual Report Suites, Marketing Channels, and Classifications. What’s really cool about classifications in Adobe Analytics is you can actually classify a. The following apply only to the Customer Journey Analytics Select package: Ad Hoc SQL Query. This sounds like a perfect use of SAINT, and yet it's not supported. 1 Accepted Solution. It allows you to group disparate values and report on them in. . The initial setup populates the classifications database with a large set of original data, or restructures the classifications, rather than reclassifying a few rows or adding rows. See Adobe Experience Cloud privacy for more information. Learn. 5. <br>Competencies:<br>Adobe. This is useful for people using data feed and analysing clickstream but also need the classifications. . When I have different classification hierarchies set up across multiple report suites, there is no way of seeing which report suites are not matching (you just get the message "The classifications for this report do not match for all report suites. Classifications have 2 pieces : Relationships (Variables) and divisions (classification columns) Here you are using the same name, but they really refer to 2 different relationships (or variables eVar 1 and eVar 4). Claravine 770 E. • Transitioned the team to SiteCatalyst 15. @harshu_4u In order to know why it is getting classified correctly, it is important to know how you are uploading the files, you might have to reach out to client care to get more assistance on this to know the exact root cause. stephen_desmond. Once you have logged into the portal, you can (1) access the Admin > Admin Console to create the new classification fields in the appropriate report suite. User. On the rule set page, click Add Rule. These parameters are normally passed in the URL and parsed by GA to populate the appropriate analytics reports. we will be using this file to import additional attributes in Analytics. Getting Google Search Keywords into Adobe Analytics While Adobe Analytics is a much more mature solution compared to Google Analytics, the latter always had an advantage when it comes to Search Keywords. Following an initial upload in a report suite (for a given variable or report), Adobe recommends uploading only new and updated rows in subsequent imports. - 166021 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 Engage Recently, Adobe provided an Adobe Analytics update that includes a cool new feature called “Virtual Report Suites. If v2. Adobe uses SAINT (SiteCatalyst. Classification breakdowns are used to map analytics reporting data to related properties. - 166021Advertising 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 EngageRecently, Adobe provided an Adobe Analytics update that includes a cool new feature called “Virtual Report Suites. Your key values should start on row 6. • Implemented Adobe Analytics to replace internal tracking and Google Analytics. This blog post is to guide you through the custom classification steps that a marketer needs to take to complement the data available in Adobe Analytics. . campaign / v0) report. As for #3, I don't have any screen shots right now but let's assume that files were uploaded successfully without any errors. Community of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsExperience League CommunityCommunity of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsI'm working with a client that is using Adobe Analytics and I want to check if the channel's classifications that are actually configured are ok. Classifications can be used for a variety of purposes but are most commonly used for classifying campaign tracking codes, both internal and external, and product IDs. e. Classifications are a powerful way to add metadata – descriptive attributes – to your products, campaigns, pages, customers, and more. Hi there. . You will need to test the rule, and then activate it. Hi there. In addition to the normal function of rolling up data into groups, SAINT Classifications are great in cases where the root. Sometimes under FTP classification Account shows different report suite or but different variables for same report suite for different login users. Alphabetically - A to Z; Alphabetically - Z to ASearch for media from: "Daniel Robledo "Media; Sort by Alphabetically - A to Z. You can also export the data for updating prior to an import. Classifications are a powerful way to add metadata – descriptive attributes – to your products, campaigns, pages, customers, and more. Classifications, formerly known as SAINT Classifications, are used to add custom metadata to your analytics. Manage data using components like. k. A quick walkthrough on using the Classification Rule Builder within the Adobe Analytics. Adobe Analytics. . I uploaded product sku classification for 85k rows and 7 columns. transactionID Can Be Used To Reconcile Missing Orders Late last year I wrote an article about data variance between Web Analytics tools and mentioned that there is a way to reconcile missing eCommerce orders on the purchase page with the help of Adobe engineering. In this video, we walk through the configuration of classifications for traffic variables, often known as “props,” or also for pagename, etc. Right now you cannot break - 343829. Is the only way to create the creative tracking codes is to build them out within Adobe? Or can we - 554275Also learn about the power of SAINT classifications, very very powerful and very streamlined way of working with tracking IDs. e. For instance, Analytics may track that a visitor clicked a "call support" button but the details about length of the call, subject, customer. Click Import File. 5. If you have given it a few days and classifications are not propagating 'in progress'; I would recommend a re-upload attempt of the blank classification keys. tab filename extension) that most spreadsheet. Community of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsAdvertising 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 EngageSometimes under FTP classification Account shows different report suite or but different variables for same report suite for different login users. For the rest of the details, Customer Care would be a great place to ask. Classifications have 2 pieces : Relationships (Variables) and divisions (classification columns) Here you are using the same name, but they really refer to 2 different relationships (or variables eVar 1 and eVar 4). Courses Tutorials Events Instructor-led training View all learning optionsThe initial setup populates the classifications database with a large set of original data, or restructures the classifications, rather than reclassifying a few rows or adding rows. Mark as New; Follow;. Sample values: 5704396::en_us::null:null:::::gb - Test rule result is correct Hello, I've uploaded a number of SAINT classifications and then, a few days later, downloaded the full list of classifications in my report suite but noticed that many rows has only the Key Field but that the rest of the fields in the row were blank. Alphabetically - A to Z; Alphabetically - Z to ASearch for media from: "Daniel Robledo "Media; Sort by Alphabetically - A to Z. Transcript. Click the Browser export tab. Root Cause: Using different evars is the cause for this behavior. To add or edit a classification rule: Create a Classification Rule Set . Adobe Classifications exports classifications data to Adobe Analytics in a scheduled manner. Discover more. In insight there is a transformation called "copy" where you can classify multiply items into one group. Create classifications and sub-classifications in the Classification Manager. style. which we configure with report suite already selected in Adobe Analytics on top-right corner. Automatic, rule-based SAINT classifications based. Create Marketing Channels classifications. Create classifications for Marketing Channels. 76), which means that the $34 amount is much more. It shouldn’t surprise us that the company who offers both the search engine and the analytics tool has some integration. We are sending data to a client's Adobe Analytics Reporting Suite via POST API. It allows you to group disparate values and report on them in bunches or other clarifying ways. Adobe Analytics clients are genuinely surprised to learn how far off the mark their own reports have strayed. {"payload":{"allShortcutsEnabled":false,"fileTree":{"docs/getting-started":{"items":[{"name":"graphics","path":"docs/getting-started/graphics","contentType. They provide a means to upload metadata that can be connected to the information being gathered by Adobe Analytics. Use the importer to upload classifications into Adobe Analytics. Adobe Experience Manager Training in Bangalore. s. Attend local and virtual eventsThat would help proritize or qualify different market based on their size, the traffic/revenue they generate, etc. Currently I am classifying page names so I would like to remove the page names and the classifications associated with them. Like for example lets say you are. *) That first part MOD123 will be a hardcoded value for each rule. In this video, we walk through the configuration of classifications for traffic variables, often known asCommunity of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsCommunity of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsLight & comfortable for dogs of all sizes. Experience League. Community of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsCommunity of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analyticsUsing my blog as an example, I have created a SAINT Classification of the Blog Post Title eVar and classified each post with the publish date: Read the rest of this post on analyticsdemystified. Automatic, rule-based SAINT classifications based on specific criteria. Select Service Account (JWT) here. . Manual import of a classification file on a regular basis for mapping the v. For example, you can see the same Form Completions report above in more concrete buckets by using SAINT to see the following: Final ThoughtsAnalytics Demystified have created an intensive one-day Adobe Analytics class that goes deep into the product. Of course they weren't when I uploaded them. . Name the rule set, then click Create Rule Set. Hello, I've uploaded a number of SAINT classifications and then, a few days later, downloaded the full list of classifications in my report suite but noticed that many rows has only the Key Field but that the rest of the fields in the row were blank. Does. The following are common causes behind FTP classifications not processing uploaded files: Missing . 21 Ranked report allows __ number of metrics. Troubleshoot FTP imports. It’s a. Click the Browser export tab. Configure export settings, and make sure that ‘Quote Output’ is NOT selected. The Products Variable (s. Data collection is supported for the. 1 is enabled, you will see a line similar to:{"payload":{"allShortcutsEnabled":false,"fileTree":{"docs/getting-started":{"items":[{"name":"graphics","path":"docs/getting-started/graphics","contentType. When it comes to tracking online purchases in SiteCatalyst, there are many different ways to report on Orders, Units and Revenue. 4 vs Adobe Analytics API 2. Use the importer to upload classifications into Adobe Analytics. Here is the. Solved: Hi Team, I have imported the SAINT classification files in Adobe Analytics with same key value with different data sets as shown - 378648Root Cause: Using different evars is the cause for this behavior. Click Edit Settings > Conversion > Conversion Classifications. *Worked managing the implementation of adobe analytics for a new mobile application that was launched in 92 countries around the world supporting multiple languages, working. Configure export settings, and make sure that ‘Quote Output’ is NOT selected. Automate the FTP export of Classifications. Optionally you can specify the Name, for the node that stores the framework details in the repository. It is access by going to Admin | SAINT Classifications. When uploading the classification file all Sub Site Sections seem to be overwritten with one of the Sub Section values. Follow answered Sep 10, 2019 at 15:49. The template file is a tab-delimited data file ( . com)procedural concepts to configure marketing channel reports, to configure SAINT classifications, to configure classification rules, to develop marketing URLs, and to configure a virtual report suite. The data includes the key that is associated to an eVar along with conversion classifications. The Adobe Analytics Implementation specialist plays an integral role to ensure analytic/metrics plan is implemented properly. This would apply to reports, dashboard, data warehouse etc. Learn. This is the maximum length of each. Esquire demo application for this article creates classifications for Products, you can see the new classifications by selecting Analytics > Reports & Analytics > View All Reports > Products > Products. Proficient in SAINT classification. Tracking code format is something like: [region][channel][campaign][publisher][date] . Discover, and SAINT Classifications. It would be nice if you could enter your campaigns directly into the interface instead of importing/exporting. (which is the new name for saint classification). Analytics software like Google Analytics 4 and Adobe Analytics lets you record where your visitors are coming from and the channels they fall under with UTM tags, or the gclid and cid parameters, respectively. But as Adobe Analytics. Name: Each delimited value can contain a maximum of 255 characters (or less if using multi-byte characters). Courses Tutorials Certification Events Instructor-led training View all learning options. You could add a new classification. Learn. Classifications. To check and see if a classification file has finished uploading, do the following: Log in to SiteCatalyst and go to Admin > SAINT Classifications. That would also help reducing the number of rows / records within the Data Warehouse while looking at. Adobe Analytics Training in Hyderabad. Unfortunately, Pathing is not available on SAINT Classifications in Adobe Analytics (though it is in Discover, now known as Ad Hoc Analysis) Data Feeds – Many companies use Data Feeds to export Adobe SiteCatalyst data to other data warehouses and Data Feeds only contain data that is organically passed into SiteCatalyst, which excludes SAINT data API support for creating SAINT classifications. Click Download. Last week, I shared how to quantify content velocity in Adobe Analytics. k. It can be used to create Classification values out of existing data and populate Classification dimension based on regular expressions. They want us to generate them for them to help them track performance on their campaign. Classifications are a powerful way to add metadata – descriptive attributes – to your products, campaigns, pages, customers, and more. This is a great approach, though I may need a bit of clarification on how can I map the SKU to product name if I'm using Classification Rule builder which uses Regex. Does anyone have experience with these? I'm very familiar with the Google UTM codes and how they work in Google Analytics. You can right click > Inspect Element on the classification drop down in the Classification Importer to check the relation IDs for other classifications. This article is the first in a series of educational posts about. {"payload":{"allShortcutsEnabled":false,"fileTree":{"docs/getting-started":{"items":[{"name":"graphics","path":"docs/getting-started/graphics","contentType. Ad Hoc SQL Queries will time out after. Admin > Classification Rule Builder > Add Rule Set. This does not require to be a product admin. Created for: Beginner. . prop ones don't show up as an option. To add conversion classifications in Admin: Click Admin > Report Suites. NEW Real-time Live GPS Tracking when your dog is lost. I've got classification "A" based on evar 41 and classification "B" based on evar 41. The second part is the relation ID of the classification. . . • Created, measured, ran. I would give it more time and and as long as you were comprehensive in your classifications upload file to cover all key values then eventually those reports should reflect the latest uploaded values. Root Cause: Using different evars is the cause for this behavior. In this post, I will share some of my thoughts on this new feature and share some resources that Adobe has provided. Once classifications are enabled, you can use the importer and the rule builder to classify specific values. SiteCatalyst should offer the ability to automatically classify "key" values that match a specified set of criteria. The second part is the relation ID of the classification. Why Classifications Mess up the Menu Customizer For those of you who are savvy enough to understand SAINT Classifications, you will quickly realize how powerful they can be in a SiteCatalyst implementation. New. The template file is a tab-delimited data file ( . exporter. 2. Watch the status window for processing messages. Scroll to Adobe Analytics and. Glad it's fixed for you. ) Classifications (formerly SAINT classifications) are a powerful tool for gaining more insight from your analysis of online behavior. Now that you have UTM links reported using a consistent format, you will use the classifications to split. In previous jobs we used the FTP to automate a feed from our database to the SAINT Classification for auto updates. What is unique about Adobe Analytics, is the platform is not exclusive or doesn't just track UTM source, medium or campaign as you might be used to. The name of this . In the Report Suite Manager, click Edit Settings > Marketing Channels > Marketing Channel Classification. Kindly wait, you can see the results. . Sign In. Learn. Reports exported through Full Table Export are limited to 3 million rows of data per Report. Once the file has been downloaded, open the file and replace any classification values with either ~empty~ or ~deletekey~. Admin Classification rules regularly look for unclassified terms. The url can vary from test: testa: testb: testc:testd to testa: testb: testc to testa: testb to test. I wish to do a total overhaul of my SAINT classifications. I am running a SAINT classification rule on eVar, most of the time it is working as expected but for few instances is not working even though when same data is validated correctly on Test rule. Logic and Reasoning. Classifications can be used for a variety of purposes but are most commonly used for classifying campaign tracking codes (both internal and external) and product IDs. list2="Clickable Link A, Clickable Link B" A & B are part of a single creative unit, so I. Option 1 – SAINT Classifications. Sign In. Community of Experience Makers in web analytics, marketing and cross-channel analytics, attribution, and predictive analytics100/day. Community home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager Sites & More Experience Platform Journey. What are Classifications? Adobe Analytics collects visitor data from web sessions but this data doesn't always include all of the information that a customer might want to have in their reports. Now, you need to select the authentication type. SAINT Classification technology isn’t rocket science—anyone who has used a Pivot table or a Lookup function in Excel is capable of getting their head fully around the deep magic involved. scheduled. Classifications are cool (and sometimes hard to keep up-to-date. Usually it would take upto 72 hours for classification data to showup in reports and that would be the best way to validate the classification import data. It is a hit-based variable that stores contextual information about products and can be set together with both standard commerce events and custom success events. 4. Correct answer by. . To check and see if a classification file has finished uploading, do the following: Log in to SiteCatalyst and go to Admin > SAINT Classifications. In previous jobs we used the FTP to automate a feed from our database to the SAINT Classification for auto updates. Sample values: 5704396::en_us::null:null:::::gb - Test rule result is correct This would apply to reports, dashboard, data warehouse etc. Logic and Reasoning. Select All to download all report data (up to 50,000 rows). We have two options: 1. In order to help you understand better, I'll show you what I did exactly: 1. cq.