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.
View users working currently on the same data
To see if other users are working on the same data:
Hover over the user icon in the right corner of the top ribbon and see the names of other active users.
Check the changes in Data View with Live Preview or 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 their attribute values
To view specific subgroups of your products, apply filters in the filter menu. For example, filter out the products by particular categories or select only skipped products.
Use the Product Quickfilter
To see all or only exported or skipped products use Product Quickfilter available at the intermediate and export stages.
Go to Data View from the site's main menu.
Select the intermediate stage or choose the needed export from the drop-down menu on the top left.
In the right corner of the top ribbon, select the menu icon.
In the Product Quickfilter section, choose All, Exported, or Skipped to let Data View display the desired products.
Add a filter
To search for products that meet a specific condition, add a filter. Filters are available at all stages in Data View.
You can apply filters in two ways:
In the top-ribbon menu, as shown on the screenshot in red.
Directly in an attribute column, as shown on the screenshot in pink.
Add a filter from the top ribbon menu
Go to Data View from the site's main menu.
Select the needed stage or export from the drop-down menu on the top left.
In the right corner of the top ribbon, select the menu icon.
In the Add Filter section, select the attribute you want to filter in the first drop-down menu.
Select a filter option in the second drop-down menu.
Note
The passes test and fails test options are only available at the export stage and only for the activated exports, and they are absent at the import and intermediate stages. Selecting either option allows you to filter out the values that pass or fail the analyzer test in the selected attribute. Then, in the drop-down menu below, you must choose the analyzer test for that attribute to filter for a specific test.
In Search term, enter a value or use the menu icon at the end of the field to choose one of the values of this attribute.
If needed, add another value by selecting Add one more and entering the desired value in the newly added field Or. You can remove the additional value by selecting the x icon.
Select Add.
It takes some time for Data View to refresh and show only the products that have the desired values in the chosen attribute. You can see a summary of your applied filter in the section Current Filter.
To restore the original Data View displaying all products, remove the applied filter by selecting the x icon in Current Filter.
You can see an active filter as a green Filter button in the top ribbon.
If you add filter conditions in both Product Quickfilter or Add Filter sections, they work as AND, meaning that Data View only displays products meeting all the set filters. You can save your selected filters as a segment.
If you create multiple segments and select more than one segment in Available Segments, these filters work as OR, meaning that Data View displays products that meet any of the set filters in the chosen segments. The same logic persists when you apply a rule box to multiple segments.
Apply a filter directly in an attribute column
Go to Data View from your site's main menu.
Select the relevant stage or export in the drop-down menu on the left.
Select Filter in the attribute column where you want to add a filter.
In the Add Filter menu on the right, verify the selected attribute in the first drop-down menu and choose the desired filter option in the second drop-down menu.
Note
The passes test and fails test options are only available at the export stage and only for the activated exports, and they are absent at the import and intermediate stages. Selecting either option allows you to filter out the values that pass or fail the analyzer test in the selected attribute. Then, in the drop-down menu below, you must choose the specific analyzer test you wish to asses.
In Search term, enter a value or select the menu icon at the end of the field to choose one of the values of this attribute.
If needed, add another value by selecting Add one more and entering the desired value in the newly added field Or. You can remove the additional value by selecting the x icon.
Select Add.
It takes some time for Data View to refresh and show only the products that have the desired values in the chosen attribute. You can see a summary of your applied filter in the section Current Filter.
To restore the original Data View displaying all products, remove the applied filter by selecting the x icon in Current Filter.
If you add filter conditions in both Product Quickfilter or Add Filter sections, they work as AND, meaning that Data View only displays products meeting all the set filters. You can save your selected filters as a segment.
If you create multiple segments and select more than one segment in Available Segments, these filters work as OR, meaning that Data View displays products that meet any of the set filters in the chosen segments. The same logic persists when you apply a rule box to multiple segments.
Save filters as segments
You can save your filters as segments and use them instead of entering all the filter conditions again.
See Use segments to apply rule boxes to specific product groups to create, edit, and delete a 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.
