Skip to main content

Data View - New Version (legacy document)

With our October 2017 release the new version of our Data View was available as a Beta version. Since April 2018 it is the standard version and since July 2018 it is the only available option combining the features of Data View and Data Edit.

Main differences to the legacy version

The Data View is no longer be a solely informative feature, where you can filter and have a closer look at your data, but you will also execute your data optimizations there - this was only possible in Data Edit before. You can add boxes in the same way it is possible in the Dataflow: Through a sidebar that will open up on the right side of the screen.

Top Navigation

6149d76c01c3e.gif

Change the stage you want to work on by clicking the dropdown arrow and selecting either Import, Intermediate or one of your channels.

Live Preview shows you the first 1000 products of your Intermediate and channels so you can see the impact of changes right away. If you want to update it manually, click Refresh.

Last Run shows you all product that are part of your feed and the state they had during the last run - this can either be a refresh of the full amount of products or the last export. If you want to update it manually, click Refresh.

Download will download the current view of products as a CSV. You can define the number of products you want to export in the preview file by clicking the button.

Current Users

Figure 1. users
users


The icon in the top right corner indicates if other users are working in the site. When hovering over the icons, the names of the other active user will be shown.

This feature makes you are aware that other users are working on the same data as you and you have the chance to prevent your changes being overwritten.

Toolbar

6149d7703a090.gif

The sidebar on the right contains multiple tools for filtering, analyzing, visualization and editing of your data. You can open it by clicking the small icon on the top right.

Filter

Figure 2. filter
filter


The Product Quickfilteroffers preconfigured views for allproducts, exported products and skipped products.

If you want to look at products with a certain characteristic, you can use the Add Filterfunctionality. It gives you the columns of the current stage in the top dropdown, a variation of different operators and a text field for search terms. By clicking the symbol next to the search term field, you will see all values that are present in the selected column. You can add multiple conditions by adding more filters, they will be creating an and-condition - only products meeting the conditions of all filters will be shown.

If you want to save the filter as a Segment, you need to enter a segment name and click "Save Segment". They can then act as preconfigured filters or be used when applying rule boxes to the products within the segment only.

All segments on the current stage can be see under Available Segments.

Filter with Or-Condition using Segments

Figure 3. video
video


To filter with an or-condition, you can create different segments for the single conditions and then filter using the segments. All products that are meeting the requirements of segment A or segment B or segment C will then be shown.

Analyze

Figure 4. video
video


The analyze functionality gives you a breakdown of how well your different attributes are meeting the requirements of the export channel. By clicking on the name of the column you get an overview of the different tests that the contents run through. Clicking on the pie chart will filter for the affected products in the left section of the Data View.

Single columns can be analyzed by clicking the Analyze button underneath the column header.

Figure 5. Image
Image


You can download the Analysis in CSV form by clicking Download Analysis.

In case you don't want to apply the analysis on products that are skipped on Intermediate or Export level, activate the checkbox for Ignore skipped products in analysis:

Views

Figure 6. video
video


You can customize which columns you want to see in the left part of the Data View by activating the eye symbol - green meaning it will be shown, grey meaning it will be hidden. The dropdown on top has preconfigured views for displaying all columns, none and the default setting (showing all template columns, but hiding the ones starting with three underscores). You can save the current settings by clicking Save as new view in the dropdown and adjust already created custom views by clicking Save changes.

You can display all columns with tracking information relevant for the channel you are working in by choosing Toggle Traffic Columns from the dropdown.

The order of columns in the Data View can be adjusted by drag-and-drop. Grab the column by holding the symbol on the right and drop it in the desired position. This will not affect the position in the export file, but only adjust the visualization in the Data View. If you want to adjust the order of columns in the actual file, follow the instructions in Add export channel.

You can activate the Before/After View by activating the checkbox above the filter field. This feature will only work if you selected an ID Column in Data Sources. If activated a column with a before version of your data will be shown when applying or removing new boxes to your feed:

Figure 7. BeforeAfter
BeforeAfter


Edit

Figure 8. video
video


You can add rule boxes by clicking the name of the column you want to optimize and choosing the desired box from the dropdown. It opens in the slim view per default, but you can switch to Large View by clicking the button next to the Save icon. These views are the same ones as in Dataflow.

After adding a box, click Save and the Preview on the left side will refresh automatically. Once you edit an Intermediate column the Savebutton will show a warning if the attribute is used in any of your export channels:

Figure 9. image
image


To open the Edit feature for a certain column directly, you can either click the Edit button underneath the column name, click the plus icon in one of the cells in the column or right-click inside a column with your mouse. This will open a window with all our rule boxes grouped by category as well as the toolbar on the right.

Figure 10. video
video


Single Product Edit

Precondition: To use this feature, please get in touch with your client partner or reach out to

With the Single Product Edit functionality you are able to edit attributes for single products if a rule-based approach is too complicated here. Simply click on the pen icon appearing in the product attribute you want to adjust and enter the desired content.

Figure 11. singelineedit
singelineedit


Edited products will be viewed in light yellow in the Data-View.

When you click on the pen icon in an already edited product attribute, you will see the original value and an option to restore it. Under Audit you can see when and by whom the latest change was done.

6149d794cb913.png.

Important:The Single Product Edit will overrule all other rules set on the level where the change has been made. If a single product has been edited on export level, none of the rules applied to that column will change the given attribute for that column. If a single product has been edited on intermediate level, all rules set between intermediate and export will also affect the edited values.

Designer

Figure 12. designer
designer


The Designer feature loads our Image Designer, so you can make adjustments to your templates directly in the Data View.

Channel Preview for Google Shopping and Amazon Marketplace

When accessing the Data View for Amazon Marketplace and Google Merchant Center channels the right navigation bar will contain an additional icon. Click on the magnifying glass symbol and your products will show up in the way they will be displayed in Amazon...

Figure 13. CPA
CPA


... Google Shopping...

Figure 14. CP
CP


... and Google Ads.

Figure 15. CPADS
CPADS


Channel Readiness & Optimization Report

When in export view, you will find a button called "Overview" right next to the Live Preview and Full View that provides you with two Reports:

  1. The Channel Readiness Report under "Readiness"

  2. The Channel Optimization Report under "Optimization"

While "Readiness" covers everything that is required to have your items listed on the selected export channel, "Optimization" shows you what is needed but conditional to have a perfect feed that brings the best results.

Channel Readiness Report

Products ready shows you how many of your products are ready to be exported. Channel ready shows you the percentage of your overall readiness, based on your channel requirements.

Figure 16. readiness
readiness


Channel Optimization Report

Switching to Optimization will show you a report on the status of non-mandatory attributes and to what degree they are optimized.

Figure 17. optimization
optimization