Skip to main content

Visualize your data in Data View

Visualize your product feed data in Data View in Productsup.

Introduction

Data View is the section of the platform where you can see how your feeds look before exporting them or check the state of your data at the Import or Intermediate stage.

To learn how to analyze your data in Data View, see Analyze your data in Data View.

If you wish to map your data, see Map your product data.

Access Data View

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

  2. Customize the number of products you wish to see per page:

    The number of products per page

Select the relevant stage

Choose whether you want to view your products on the Import stage, Intermediate stage, or a specific export channel:

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

  2. Choose the stage or an export channel you wish to view in the drop-down menu on the top left-hand side.

    The stage selection in the data view page

Customize the visibility of the columns in Data View

You can choose columns you want to see in Data View.

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

  2. In the toolbar on the right-hand side, select the eye icon.

  3. Select the eye icons next to the column names to make them visible or invisible.

    Visibility of the columns

Change the order of columns in Data View

To customize the order of the columns in Data View:

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

  2. In the toolbar on the right-hand side, select the eye icon.

  3. Select the dots icon on the left of the column name and drag the column to the desired position.

Note

Reordering the columns affects only the Data View section. To change the order of the columns in your export file, see Add export channel.

Display or hide all columns

To make all available columns visible or hide them:

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

  2. In the toolbar on the right-hand side, select the eye icon.

  3. Expand the drop-down menu by selecting the blue arrow at the top of the toolbar.

  4. Select Display All Columns or Display None.

    Display or hide all columns

Display tracking columns

To display all columns related to tracking, toggle the tracking columns on and off:

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

  2. In the toolbar on the right-hand side, select the eye icon.

  3. Expand the drop-down menu by selecting the blue arrow at the top of the toolbar.

  4. Select Toggle Tracking Columns.

Enable or disable the Before/After View for product optimizations

To enable or disable the Before/After View to display any rule boxes' before and after effects:

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

  2. In the toolbar on the right-hand side, select the eye icon.

  3. Check or uncheck the Before/After View checkbox.

    Before/After View checkbox

Tip

If you don't see the before and after columns when you perform an edit in Data View, make sure you have set a product identifier in Data Sources. For the Before/After View feature to work, you must select a column that uniquely identifies your products. See Set a product identifier for more information.

Once you have set a product identifier, select Run or Import in the top-right corner of your site's view.

Save your customized visual settings

There is no need to change settings for column display each time you log in to the platform. You can save your custom settings for columns view:

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

  2. In the toolbar on the right-hand side, select the eye icon.

  3. Customize any column visualization settings.

  4. Expand the drop-down menu by selecting the blue arrow at the top of the toolbar.

  5. Select Save as new view.

  6. Give your view a name.

  7. Select Save.

Your view is now available in the blue drop-down menu at the top of the toolbar. You can also select the Default view in the menu to restore the standard settings.

You can edit your view and select Save changes or Save as new.

Save My View

Live Preview vs. Full View

In Data View, you have two options to see the changes after applying a new mapping or editing data with rule boxes.

  • Live Preview: This shows you up to 1000 products for each stage. Live Preview refreshes the Data View automatically if you make any changes to your data through new mapping or rule boxes.

  • Full View: This shows you all products for each stage. You need to refresh the data updates in Full View manually. Alternatively, your site processes the changes through scheduling or a manual trigger of Import/Export.

You can toggle between the Live Preview and Full View:

  1. Go to Data View from the site's main menu. The platform highlights the active view.

  2. In the top ribbon, select Live Preview or Full View.

    Active preview mode

Refresh Data View in Full View

Data View doesn't automatically show your latest changes if you are in the Full View.

To manually trigger an update of Data View:

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

  2. From the top ribbon, select Refresh next to the Live Preview.

Download products directly from Data View

You can download products from Data View into a CSV file.

The CSV file lets you check certain products without downloading an entire export feed.

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

  2. In the top ribbon, expand the Download drop-down menu.

  3. Select the number of products you wish to download.

  4. The platform downloads a CSV file to your computer.

    Download a CSV file from the Data View

Note

The Download button downloads every column you see in Data View. You can blend in columns to include them in your download, or vice versa for excluding columns.

Download more than 10,000 products

The platform lets you download a maximum of 10,000 products. To download more products, take the following steps:

  1. Go to Export A/B from your site's main menu.

  2. Select Add Export.

  3. Enter Blank Export in the search field.

  4. Select Add for the Blank Export (empty) export channel.

  5. A window appears, allowing you to modify the export channel name and hide unconnected attributes in the intermediate column that you can find in Dataflow.

  6. Select Add to continue with the export channel setup.

  7. Go to Dataflow from your site's main menu and select your Blank Export channel in the upper left drop-down menu.

  8. Connect only the columns you want to download and ensure the columns don't contain any skip rules.

  9. Expand the Download CSV drop-down menu at the top ribbon and uncheck all exports except your Blank Export.

  10. Select the Download CSV button in the same drop-down menu.

    Download blank export

Filter your products according to conditions

To view specific subsections of your products, apply filters. For example, filter out the products by particular categories or select only skipped products.

When adding a filter, the top ribbon shows the number of products matching the filter.

Use the Product Quickfilter

Check the Product Quickfilter to filter out all, exported or skipped products:

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

  2. In the toolbar on the right-hand side, select the filter icon.

  3. In the Product Quickfilter section, choose All, Exported, or Skipped.

    All, Exported, or Skipped products in the Product Quickfilter.

Add filter

To search for products that meet a specific condition, add a filter. You can apply filters in two ways: in the common toolbar or directly on a column.

Note

If you add multiple filter conditions, they work on an AND logic, which means that Data View displays only products meeting all conditions.

If you save your filters as segments and select multiple segments, these conditions work on an OR logic, which means that Data View displays products meeting the conditions of any segment.

Filter from the toolbar

To add a filter from the toolbar:

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

  2. In the toolbar on the right-hand side, select the filter icon.

  3. Scroll to the Add Filter section.

  4. Select the column you want to filter in the first drop-down menu.

  5. Select the condition in the second drop-down menu. For example, contains.

  6. Enter a search term or choose from the column values.

  7. Select Add.

  8. See the filtered results in Data View.

You can see an active filter as a green button on the top ribbon.

Add filter

Apply a filter directly on a column

Alternatively, you can apply a filter on a column directly:

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

  2. Select the Filter button on the desired column. The Add Filter section opens, and the selected column name appears in the first field.

  3. Select the condition in the second drop-down menu. For example, contains.

  4. Enter a search term or choose from the column values

  5. Select Add.

  6. See the filtered results in Data View.

    A filter on a column

Save filters as segments

You can save your filters as segments and enable them instead of entering all the conditions again.

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

  2. Apply a filter. For that, see the previous section.

  3. Enter a name for your segment in the Segment name field.

  4. Select Save as.

  5. The segment appears under the Available Segments section for you to select in the future.

    Available segments

Rename segments

To rename a segment:

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

  2. In the toolbar on the right-hand side, select the filter icon.

  3. Select the necessary segment in the Available Segments section.

  4. Edit the segment's name in the Save as Segment section.

  5. Select Save.

Edit a current filter condition in a segment

To edit existing conditions in the segments:

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

  2. In the toolbar on the right-hand side, select the filter icon.

  3. Select the necessary segment under the Available Segments section.

  4. Edit a filter condition in the Add Filter section.

  5. Select Save under Save as Segment.

Add a new filter condition to an existing segment

To add new conditions:

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

  2. In the toolbar on the right-hand side, select the filter icon.

  3. Select the necessary segment under the Available Segments section.

  4. Select a new filter condition under the Add Filter section.

  5. Select Add.

  6. Select Save under Save as Segment.

Preview your Google Merchant Center or Amazon Marketplace feed

To preview how your products look on the Google Merchant Center or Amazon Marketplace:

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

  2. Select your Google Merchant Center or Amazon Marketplace export in the drop-down menu on the top left-hand side.

  3. Go to the side toolbar and select the Amazon or Google icon.

    google_mc_preview.png

Preview images created by the Image Designer

You can edit your products in Image Designer directly from Data View.

To learn about Image Designer and how to create dynamic product image campaigns, see Image Designer.

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

  2. Go to the side toolbar and select the Image Designer icon.

    Image Designer in Data View