Analyze your data in Data View
Analyze your data in Data View in Productsup.
Introduction
Data View is a powerful module that gives you a clear and direct look into your feed and product data. You can analyze and filter data in Data View to receive statistics for items in your product catalog.
Analyze a product catalog on the import, intermediate, and export stage to receive the following information:
Distinct values - product or item values
Length distribution - text space limits
Logarithmic length distribution - calculated digit limits
Percentage of empty values - no values in column
Average length - text length
Data type distribution - distinguishes if fields in a column contain images, text, or are empty
Access Data View
Navigate to a site.
Navigate to the Dataflow tab in the left-hand menu.
Analyze your products in the import and intermediate stages
If you want to analyze products for a certain column or attribute, you can do so by using the analyze functionality. Here you can select a column on the import or intermediate stage and view the key analysis of the data for this column.
You can also download a CSV of this analysis:
Navigate to the Data View.
In the toolbar on the right-hand side, click the pie chart (analyze) icon.
Expand the download analysis drop-down menu.
Click download top values.
Analyzing using the toolbar
The first way to analyze is by using the toolbar:
Navigate to the Data View.
In the toolbar on the right-hand side, click the pie chart (analyze) icon.
Click on a column you wish to analyze.
You will be shown analyses such as:
how many instances of a unique value occur across all products for this column (distinct values)
the length of the values for each product in this column
how many products have no data for this column (the value is empty).

Filtering directly on a column
Alternatively, you can analyze a column directly:
Navigate to the Data View.
Click on analyze for a column.
The column on which you clicked will display analysis in the toolbar, such as:
how many instances of a unique value occur across all products for this column (distinct values)
the length of the values for each product in this column
how many products have no data for this column (the value is empty).

Analyze your export feeds
Each export channel will normally have specifications or guidelines for how they accept data. This will detail a list of attributes that they expect to retrieve and will often mention what format the values should be sent in.
For example, an export channel such as Google Merchant Center only accepts prices that are separated with a point and have the currency code appended: 15.00 USD. Any prices not matching this would be rejected by Google and could cause product disapproval.
As a result, you may wish to check Productsup’s in-depth analysis of your export attributes to ensure your data is exported as required by the export channel.
The analysis will differ per channel, dependent on what is required by each partner. As such, you can rely on the specialized analysis for each export feed.
Analyzing your export feeds by column
You can analyze on a column directly, similar to the import and intermediate stage.
Alongside the standard analysis, you will also receive validation tests (dependent on the analyzed attribute and export channel).
Navigate to the Data View
Click on analyze for a column
The column on which you clicked will display standard analysis in the toolbar, as well as export-specific analysis

Analyzing your entire export feed with Channel Readiness
You can use *Channel Readiness to analyze your entire export feed at once. This feature determines whether you adhere to all necessary specifications of the export partner required to have your products listed with the export partner.
This may be helpful when you are first creating an export feed and wish to analyze all of it in one go, rather than one column at a time.
Navigate to the Data View.
Navigate to an export channel of your choice.
Expand the overview dropdown menu and click on readiness.

At the top, you have two graphics detailing quick statistics.
Products ready shows you the total amount of products that are ready to be exported.
Channel ready shows you the percentage of your overall readiness for the columns, as determined by the export channel.
Below, you have information on readiness for each column and product. This highlights which areas you need to pay attention to.
Making your export channel “ready”
To solve any readiness issues with the columns:
Click on the percentage readiness for the column.
The toolbar will be expanded with suggestions of boxes to add.
Click on the suggestions (if desired).
alternatively, you can add the boxes manually in the Data View.

Analyze potential optimizations with Channel Optimization
The Channel Optimization feature shows you what conditional requirements are defined by the export partner. You may wish to optimize your feed as providing your product data according to the standard of the export partner will most likely bring the best results.
Navigate to the Data View.
Navigate to an export channel of your choice.
Expand the overview drop-down menu and click on optimization.

At the top, you have a graphic detailing the percentage of your channel which is optimized according to the instructions of the export partner.
Below, you have information on the optimization level for each column and product.
Optimizing your export channel
To solve any readiness issues with the columns:
Click on the percentage optimization for the column.
The toolbar will be expanded with suggestions of boxes to add.
Click on the suggestions (if desired).
alternatively, you can add the boxes manually in the Data View.
Create reports on product data optimization
You can access and download optimization reports in Data View to share stats on your product data optimizations. Creating such reports may be helpful if, for example, you need to share data optimization info with a colleague who doesn't have access to Productsup.
Note
The Download Optimization Report option is available on the export stage only. Your site must have at least one export to let you download an optimization report.
Follow these steps to download an optimization report:
Go to Data View from your site's main menu.
In the drop-down menu on the left, select the needed export channel.
Open the context menu on the right and select the pie-chart icon.
Expand the Download Analysis drop-down menu by selecting the downwards triangle icon (▾).
Select 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.
Note
The report isn't available at a unique URL, so you can't share it using the link. You need to download the report file to share it.