Analyze your data in Data View

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:

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:

Analyzing using the toolbar

The first way to analyze is by using the toolbar:

1. Navigate to the Data View.

2. In the toolbar on the right-hand side, click the pie chart (analyze) icon.

3. Click on a column you wish to analyze.

4. 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:

1. Navigate to the Data View.

2. Click on analyze for a column.

3. 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).

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).

1. Navigate to the Data View

2. Click on analyze for a column

3. 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.

1. Navigate to the Data View.

2. Navigate to an export channel of your choice.

3. 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:

1. Click on the percentage readiness for the column.

2. The toolbar will be expanded with suggestions of boxes to add.

3. Click on the suggestions (if desired).

   • alternatively, you can add the boxes manually in the Data View.

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.

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.

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.

Follow these steps to download an optimization report: