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 products ready for your export channels. To help you identify what products 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 export channel requirements, and so on.

The features that provide attribute data analytics in Data View:

  1. Analyzer

  2. Channel readiness

  3. Channel optimization

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, Channel readiness, and Channel optimization. All export 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 (2) 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 drop-down menu on the left.

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

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

      Tip

      If you choose an export that uses analyzer tests 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 drop-down menu on the left.

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

Once you access the analytics of a desired attribute, you can see the following sections in the 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 export channel requirements.

    Note

    The 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 export 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 Tests, for example, Empty Column, Contains HTML, GOOGLE - Image Extension Checker, always depend on what your export channel requires from each attribute.

    In case of data inconsistencies, you can perform the suggested data optimization tasks right there in the respective 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.

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

  • 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 number 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 number values in the attribute. For example, if you have two (2) products 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, number, 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 products featured in the selected pie chart or row.

The specific set of sections you see in the Analyzer depends on the type of data your analyzed attribute contains. For example, all attributes with number values have a slightly different set of sections in the Analyzer than image or text attributes.

Channel readiness

Channel readiness is a view option in Data View that shows how many products and attributes in your feed are export-ready. It is available at the export stage only for exports that use analyzer tests.

Note

Channel readiness only considers the mandatory attributes to produce readiness reports.

To access and use channel readiness reports, you need to:

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

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

  3. Go to Data View, select the needed export in the drop-down menu on the left, and choose Readiness in the Overview drop-down list.

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

The main channel readiness reports are at the top of the page:

Open the Channel readiness view in the export stage in Data View

  • The products ready figure shows the overall percentage of export-ready products whose mandatory attributes meet the requirements of the export channel. In the screenshot above, 0.0% of products are ready because all products have issues with their values in the price and image_link attributes.

    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.

  • The channel ready figure shows the average percentage of how many mandatory attributes are export-ready per product. In the screenshot above, 85.7% of mandatory attributes are export-ready per product because the mandatory attributes of all three products in this site are 88.57%, 82.86%, and 85.71% ready, and 85.7% is the average of these three numbers.

    To help you identify issues, the platform highlights the ready products in green and the problematic ones in orange. It also displays the percentage of a product's attributes that meet the channel's requirements at the start of each product row on the left.

Channel optimization

Channel optimization is a view option in Data View that shows how many products and attributes in your feed are export-ready. It is available at the export stage only for exports that use analyzer tests. Unlike channel readiness reports, channel optimization reports consider all mapped attributes, both mandatory and non-mandatory.

To access and use channel optimization reports, you need to:

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

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

  3. Go to Data View, select the needed export in the drop-down menu on the left, and choose Optimization in the Overview drop-down list.

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

The main channel optimization report is at the top of the page:

Open the Channel optimization view in the export stage in Data View

  • The channel optimized figure shows the average percentage of how many attributes are export-ready per product. In the screenshot above, 85.1% of all attributes are export-ready per product because the attributes of all three products in this site are 87.23%, 82.98%, and 85.11% ready, and 85.1% is the average of these three numbers.

    To help you identify issues, the platform displays the percentage of a product's attributes that meet the channel's requirements at the start of each product row on the left. It also highlights the ready attributes in blue and the problematic ones in white or grey. 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 drop-down menu on the left, and choose Readiness in the Overview drop-down list.

  3. When you identify what attributes and products 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 manually.

  5. If you want to optimize and send both mandatory and non-mandatory attributes to your export channel, choose Optimization in the Overview drop-down list 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 to share the results of attribute data analytics. Creating such reports may be helpful if, for example, you need to share attribute data analytics results 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 tests in a CSV file. The file displays all subsections of the Analyzer's Tests section for all your mapped attributes.

    This report is available at the export stage only.

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

    This report is available at all stages of your site.

  • Download Optimization Report summarizes the overall export readiness of your mandatory and non-mandatory attributes as an HTML page that displays the channel optimization 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 drop-down menu on the left, select the needed export.

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

  4. Choose your report type:

    1. To download a report with analyzer tests, select Download Analysis.

    2. To download a report with all Analyzer sections excluding Tests, expand the Download Analysis drop-down menu by selecting the downwards triangle icon (▾) and choose Top Values.

    3. To download a report with a channel optimization score, expand the Download Analysis drop-down menu by selecting the downwards triangle icon (▾) and choose Download Optimization Report.

      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 Optimization Report 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: