Product Update - Field Conversions
by Ben Culpin, on Oct 21, 2019 9:55:05 AM
A significant change to the WakeupData platform comes in the form of an entirely new addition to the import stage: Field Conversions.
These now allow the user to make alterations to their feed prior to exporting the data, using straightforward expressions to make multiple changes by creating an extra field.
What are Field Conversions?
This is an addition to the import overview in the WakeupData platform. Alongside the addition of the Change Log in imports, this is part of a number of changes focused on improving the platform's usability.
Stated shortly, Field Conversions let you create new data fields based on the data you have already imported.
What's the advantage of this?
Instead of making changes to every single export for every sales and marketing channel, you can make changes once here - saving hours of time.
You don't have to wait for import to re-run for changes to be applied. Field Conversions are applied automatically.
Crawling a website to extract data can is frequently used later for multiple exports. With an optimization required, or error present in the feed, you now don't have to change all exports one-by-one but can do it in import stage.
There are multiple ways in which Field Conversions can be put into practice, ranging from the simple to the more complex.
No single way is the 'right' way to use them, and the feature has been designed to be flexible for any number of different use cases.
We've outlined a few possibilities below, but keep your eyes out for forthcoming explainers and Use Guides which will go into more detail:
- Field Conversion Use Case 1 - The imported feed has a mistake in the product titles
Every title at the end says: 'Discount Week 36'
Rather than changing every export to correct the titles, a single expression in Field Conversions can create a separate field (or replace the current product title field if needed) which removes the unwanted text from titles.
This will produce correctly formatted titles upon the next run of the import.
- Field Conversion Use Case 2 - Filtering incorrect values
You could use Field Conversions to set up an expression which filters out all the product GTINs of an incorrect length (e.g. only 8-9 characters instead of the 12-13 required).
Those products with correct GTINs can then be added to every export - instead of applying this change manually to each channel export.
- Field Conversion Use Case 3 - Calculate Discounts
Calculate discount price by creating a field which removes list price from sales price. This separate field then shows how much customers are saving.
- Field Conversion Use Case 4 - Calculate Sales Margins
Calculate sales margins and filter out all products with less than 10%. This separate field of higher margin products can then be used for specific promotion in certain exports.
- Field Conversions Use Case 5 - Creating a new, required field
Creating a new field (e.g shopname) saves stress - it could be dangerous to edit your existing field upon the next re-import (e.g. using the remove expression would take away more each time).
- Field Conversions Use Case 6 - Filtering low-stock from feeds
By applying expressions to the 'stock quantity' field of an import, field conversions could be used to assign values to stock levels from 1-5.
Those products with a stock level below 3 could then be filtered out of the import (and thus all exports) to avoid running out of stock.
We've provided a whistle-stop tour of just some of the ways that the new Field Conversions feature can add value to your feed marketing efforts.
If you want to get a more complete overview of what has changed and how to fully utilize all the features at your disposal, please don't hesitate to book a meeting with one of our Customer Success Managers below.
In the coming weeks, keep your eyes out for more news and content in the latest of a long line of changes to The WakeupData feed management tool.