Skip to main content

Analyze your data in Data View

Learn to analyze your attribute data in Data View in Productsup.

Introduction

When you set up all your exports and map the needed attributes from import to export, it is time to get your data ready for your channels. To help you identify what items and attributes require optimization, Productsup offers attribute data analytics features in Data View. These features can help you see how many attribute values are empty, what type of data the values should have, whether they meet the channel requirements, and so on.

The features that provide attribute data analytics in Data View:

  1. Analyzer is a feature in Data View that provides attribute data analytics, such as value statistics and the correspondence between attribute values and channel requirements.

  2. Core readiness score is a view option at the export stage in Data View that shows how many mandatory attributes are export-ready.

  3. Enhanced readiness score is a view option at the export stage in Data View that shows how many mandatory and optional attributes are export-ready.

You can use the Analyzer at any stage in your site to track how your data changes throughout the stages. But you can find the most insights about your attribute data at the export stage, where you can use the Analyzer, and core and enhanced readiness scores. All channels have different requirements, so you need to analyze and optimize your attribute data for each export individually.

This document explains what information you can get with attribute data analytics features in Data View and how to use these features to get your data ready for export. See Optimize your data in Data View with rule boxes for information on using rule boxes to optimize data in Data View.

Analyzer

The Analyzer feature is a part of the context menu in Data View that provides attribute data analytics. You can access it in two ways:

Access the analyser tests and statistics from the context menu on the right or select the Analyze button in any column

  1. Via the context menu:

    1. Go to Data View and select the needed stage or export from the dropdown on the left.

    2. Open the context menu on the right and select the tab marked with a pie-chart Analyzer_icon.png icon.

    3. In the attribute overview, select the pie-chart icon next to the needed attribute to see the analytics of its values.

      Tip

      Not all exports use the analyzer tests, but if you choose an export that uses them in Step 1, the attributes overview also shows the percentage of failed analyzer tests next to each attribute.

      In the export stage, you can see the percentage of failed tests next to each attribute in the Analyzer feature.

  2. Via the Analyze button:

    1. Go to Data View and select the needed stage or export from the dropdown on the left.

    2. Find the needed attribute and choose Analyze under the attribute name.

      the Analyze button

Once you access the analytics of a desired attribute, you can see the following sections in the Analyzer:

  • Analyzer tests

    This section runs multiple analyzer tests with the data provided in the attribute and displays pie charts to show how many values meet particular channel requirements.

    The Tests section in the Analyzer feature contains multiple tests based on the requirements of the export channel to this specific attribute.

    Note

    The Analyzer tests section is available at the export stage only. It appears in the Analyzer if the chosen export uses analyzer tests, which means the platform knows the requirements of that channel and tests the attributes' data against those requirements. For example, the export Google Content API for Shopping uses analyzer tests, while Blank Export (empty) doesn't.

    The subsections present in Analyzer tests, for example, Empty Column, Contains HTML, GOOGLE - Image Extension Checker, always depend on what your channel requires from each attribute.

    In case of data inconsistencies, you can perform the suggested data optimization tasks right there in the respective Analyzer tests subsection. For example, if you select Add box: "Skip Row if Empty", the platform adds the Skip Row if Empty rule box to the analyzed attribute at the export stage and sets it up as recommended.

    Apply a rule box from the analyzer test

  • Distinct Values

    This section lists all the unique values in the attribute and shows how many times each unique value appears.

    The Distinct Values section shows all unique values in the attribute

  • Length Distribution

    This section analyzes the length of each value in the attribute, lists all length variants, and shows how many values have the same length.

    The Length Distribution section shows all lengths of the values

  • Min/Mix Values

    This section arranges all the unique values in a number attribute from minimum to maximum and shows how many times each unique value appears.

    min_max_value.png

  • Logarithmic Value Distribution

    This section splits all values in a numeric attribute into intervals, or buckets, and shows how many values there are in each bucket.

    logarithmic_value_distribution.png

  • % Empty

    This section shows the percentage and number of empty values in the attribute.

    In the following examples, 0.00 % means you don't have any empty values in this attribute, and 100.00 % means all 7 values in the attribute are empty.

    The % Empty section shows how many empty values there are in an attribute
    __Empty_-_100_.png

  • Average Length

    This section calculates the average number of characters in the values.

    You should hover over the blank space under the section's title to see the calculated average length.

    The Average Length section

  • Average Value

    This section calculates the average number based on the numeric values in the attribute. For example, if you have two (2) items with values 20 and 22 in the analyzed attribute, the average value is 21.

    You should hover over the blank space under the section's title to see the calculated average value.

    The Average Value section in the Analyzer

  • Data Type Distribution

    This section shows the type of data stored in the attribute, such as images, text, URL, numbers, or empty values.

    The Data Type Distribution section

Tip

If you select a pie chart or a row in one of the Analyzer sections, Data View creates a filter and displays only the items featured in the selected pie chart or row.

Create a filter from the analyzer test

The sections in the Analyzer vary depending on the data type of the analyzed attribute. For example, the set of sections in the Analyzer of the numeric values attributes differs from the image or text attributes.

Core readiness score

Core readiness score is a view option at the export stage in Data View that shows how many mandatory attributes are export-ready. It is available only for exports that use analyzer tests.

To access and use the core readiness score, you need to:

  1. Go to Exports, add, and set up an export that uses analyzer tests.

  2. Go to Dataflow, select the added export in the dropdown on the left, and map all mandatory attributes from import to export.

  3. Go to Data View, select the needed export in the dropdown on the left, and choose Readiness in the Overview dropdown.

    Open the Overview drop-down menu to select Readiness and access the Channel readiness view

The core readiness score is at the top of the page:

Core readiness score view in the export stage in Data View

  • The products ready figure shows the overall percentage of export-ready items whose mandatory attributes meet the requirements of the target channel. In the screenshot above, 0.0% items are ready because all items have issues with several values in the id, title, and other attributes highlighted in orange.

  • The channel ready figure shows the average percentage of how many mandatory attributes are export-ready per item. In the screenshot above, 89.8% is an average percentage of the mandatory attributes ready for export per item.

To help you identify issues, the platform highlights the ready attributes in green and the problematic ones in orange or red. It also displays the percentage of values meeting the channel's requirements under each attribute name. If you select the readiness percentage under the attribute name, the Analyzer feature opens on your right.

Enhanced readiness score

Enhanced readiness score is a view option at the export stage in Data View that shows how many mandatory and optional attributes are export-ready. It is available at the export stage only for exports that use analyzer tests.

To access and use the enhanced readiness score, you need to:

  1. Go to Exports, add, and set up an export that uses analyzer tests.

  2. Go to Dataflow, select the added export in the dropdown on the left, and map all relevant attributes from import to export.

  3. Go to Data View, select the needed export in the dropdown on the left, and choose Optimization in the Overview dropdown.

    Open the Overview drop-down menu to select Optimization and access the Channel optimization view

The enhanced readiness score is at the top of the page:

Enhanced readiness score in the export stage in Data View

  • The channel optimized figure shows the average percentage of how many attributes are export-ready per item. In the screenshot above, 86.1% is the average of all attributes ready for export per item.

    To help you identify issues, the platform displays the percentage of an item's attributes that meet the channel's requirements at the start of each item row on the left. It also highlights the ready attributes in blue and the problematic ones in white or gray. You can find the percentage of values meeting the channel's requirements under each attribute name and select it to open the Analyzer feature on your right.

Get your attribute data ready for export

You can use all the analytics features in Data View to get your data ready for export. We recommend the following process to analyze and optimize your data:

  1. Once you add and set up all your needed data sources and exports, go to Dataflow to map all relevant attributes from import to export.

  2. Go to Data View, select the needed export in the dropdown on the left, and choose Readiness in the Overview dropdown.

  3. When you identify what attributes and items require your attention, open the Analyzer feature using the context menu or the readiness percentage under the needed attribute name.

  4. Apply the recommended rule boxes right in the Analyzer or add them manually. See Add a rule box for more information on adding rule boxes.

  5. If you want to optimize and send both mandatory and optional attributes to your target channel, choose Optimization in the Overview dropdown in Data View and repeat Step 3 and Step 4 using the channel optimization data.

Download reports with attribute data analytics

You can download reports in Data View. For example, you can share the results of attribute data analytics with a colleague who doesn't have access to Productsup.

In Data View, you can create and download the following reports:

  • Download Analysis creates a list of all analyzer tests performed with your attribute data and collects the results of those analyzer tests in a CSV file. The file displays all subsections of the Analyzer Tests section for all your mapped attributes.

    This report is available at the export stage only.

  • Download Top Values creates a CSV file with a list of all Analyzer sections, such as Distinct Values, Length Distribution, % Empty, etc., and the related value data stats, excluding the Analyzer tests section.

    This report is available at all stages of your site.

  • Download Enhanced readiness score summarizes the overall export readiness of your mandatory and optional attributes as an HTML page that displays the enhanced readiness score of your export. The report isn't available at a unique URL, so you can't share it using a link to that HTML page. You need to download the report file to share it.

    This report is available at the export stage only.

Follow these steps to download an attribute data analytics report:

  1. Go to Data View from your site's main menu.

  2. In the dropdown on the left, select the needed export.

  3. Open the context menu on the right and select the pie-chart Analyzer_icon.png icon.

  4. In the Download Analysis dropdown, select the downwards triangle icon (▾) and choose your report type:

    1. Select Download Analysis to download a report with analyzer tests.

    2. Select Top Values to download a report with all Analyzer sections,E excluding Analyzer tests.

    3. Select Download Enhanced readiness score to download a report with an enhanced readiness score.

      A new tab opens in your browser with a report presented as an HTML page. Use the functionality of your browser to print or download the report.

Tip

You can create reports using the options Top Values and Download Enhanced readiness score to feature data on all attributes or a selected attribute only:

  • To create a report on all attributes, follow the procedure described above.

  • To create a report about a single attribute, follow the procedure described above, but instead of performing Step 3, select Analyze under the needed attribute name.

In this section: