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
Go to Data View from the site's main menu.
Customize the number of products you wish to see 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:
Go to Data View from the site's main menu.
Choose the stage or an export channel you wish to view in the drop-down menu on the top left-hand side.
Customize the visibility of the columns in Data View
You can choose the columns you want to see in Data View.
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the eye icon.
Select the eye icons next to the column names to make them visible or invisible.
Change the order of columns in Data View
To customize the order of the columns in Data View:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the eye icon.
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:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the eye icon.
Expand the drop-down menu by selecting the blue arrow at the top of the toolbar.
Select Display All Columns or Display None.
Display tracking columns
To display all columns related to tracking, toggle the tracking columns on and off:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the eye icon.
Expand the drop-down menu by selecting the blue arrow at the top of the toolbar.
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:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the eye icon.
Check or uncheck the 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:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the eye icon.
Customize any column visualization settings.
Expand the drop-down menu by selecting the blue arrow at the top of the toolbar.
Select Save as new view.
Give your view a name.
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.
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 shows you up to 10.000 products for the Import stage and 1000 for the Intermediate and Export stages. With Live Preview activated, the platform refreshes the Data View automatically if you make any changes to your data through new mapping or rule boxes.
Full View 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:
Go to Data View from the site's main menu. The platform highlights the active view.
In the top ribbon, select Live Preview or Full View.
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:
Go to Data View from the site's main menu.
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.
Go to Data View from the site's main menu.
In the top ribbon, expand the Download drop-down menu.
Select the number of products you wish to download.
The platform downloads a CSV file to your computer.
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. But you can select the specific columns only and download more products with the help of Blank Export. To download a CSV file with the products in the selected columns, take the following steps:
Go to Exports from your site's main menu and select ADD EXPORT.
Select Blank Export (empty) in the gray banner.
Go to Dataflow from your site's main menu and select your Blank Export (empty) channel in the top-left drop-down menu.
Connect only the columns you want to download and ensure the columns don't contain any skip rules.
(Optionally) Go to Data View and ensure you added all the necessary columns.
Go to Exports again and, in the Upload column, change Off to On for your export template.
Select the cogwheel icon (⚙) next to the added export template.
Select
Productsup Serverin the Add Destinations drop-down list in the Destination section.Select Export this export at the top-right corner of the page. Alternatively, the platform exports the file at the next scheduled run.
Scroll down to the Filename section and find your export feed link. Select it to download the feed.
Note
If the file is red after the end of the processing, reload the page.
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:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the filter icon.
In the Product Quickfilter section, choose All, Exported, or Skipped.
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:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the filter icon.
Scroll to the Add Filter section.
Select the column you want to filter in the first drop-down menu.
Select the condition in the second drop-down menu. For example, contains.
Enter a search term or choose from the column values.
Select Add.
See the filtered results in Data View.
You can see an active filter as a green button on the top ribbon.
Apply a filter directly on a column
Alternatively, you can apply a filter on a column directly:
Go to Data View from the site's main menu.
Select the Filter button on the desired column. The Add Filter section opens, and the selected column name appears in the first field.
Select the condition in the second drop-down menu. For example, contains.
Enter a search term or choose from the column values
Select Add.
See the filtered results in Data View.
Save filters as segments
You can save your filters as segments and enable them instead of entering all the conditions again.
Go to Data View from the site's main menu.
Apply a filter. For that, see the previous section.
Enter a name for your segment in the Segment name field.
Select Save as.
The segment appears under the Available Segments section for you to select in the future.
Rename segments
To rename a segment:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the filter icon.
Select the necessary segment in the Available Segments section.
Edit the segment's name in the Save as Segment section.
Select Save.
Edit a current filter condition in a segment
To edit existing conditions in the segments:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the filter icon.
Select the necessary segment under the Available Segments section.
Edit a filter condition in the Add Filter section.
Select Save under Save as Segment.
Add a new filter condition to an existing segment
To add new conditions:
Go to Data View from the site's main menu.
In the toolbar on the right-hand side, select the filter icon.
Select the necessary segment under the Available Segments section.
Select a new filter condition under the Add Filter section.
Select Add.
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:
Go to Data View from the site's main menu.
Select your Google Merchant Center or Amazon Marketplace export in the drop-down menu on the top left-hand side.
Go to the side toolbar and select the Amazon or Google icon.
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 Create and apply custom image templates.
Go to Data View from the site's main menu.
Go to the side toolbar and select the Image Designer icon.
