The ‘’is in list’’ functionality, a long-time favorite of our customers, just got a new facelift. Until recently, you could only create list-based rules in DataFeedWatch by uploading these lists of products from your computer.
Now, you can provide the URL location of a file with the list of products you want to use when creating feed optimization conditions.
This makes the ''is in-list'' feature even more valuable for the marketing teams where more people collaborate on the same feed. If a list needs an update, everyone that has access to it. can update it in a Google Document. And the updated version will be processed daily.
So, let’s take a look at how this works and when can you use it in your feed optimizations.
How does ''is in-list'' with a URL work?
Do you have a list of products that have little in common? These products don’t share similar attributes, so creating rules for each of these products would be just too cumbersome.
Nothing to worry about. We've got you covered with the ‘’is in-list’’ feature. As mentioned above, uploading lists of products to be used for creating feed rules was already available for quite a while.
We enhanced it, and, today, users can use Google Sheets to create rules by copy-pasting a publicly shared link in the ''is in-list'' condition. Let's see, step by step, how to use it:
Step 1. Create your Google Sheet document with the IDs of the products, based on which you want to create a given condition.
Step 2. Make the document link publicly shareable so that DataFeedWatch can access the document.
Step 3. Create your rule and paste the public URL in the "is in-list" condition.
Step 4. If you need to update the list of products just update your spreadsheet.
Step 5. We will download daily (or multiple times a day, depending on your settings) the list from the URL before each master feed processing. This will make it so much easier to make conditions based on dynamically changing lists.
When to use ''is in-list'' with URL?
If you want to exclude products from the feed that are unrelated
Let’s say you sell pharmacy products and every time you check Google Merchant Center you see unrelated products that are disapproved or require attention.
Instead of going crazy by creating a loooong list of IF conditions, just add the IDs of the products risking disapproval in a Google Sheet and upload it to DataFeedWatch.
Create custom labels for distinct products
Let's say you want to create a flash-sale and rotate the products that are on sale weekly. You need to:
- Create the list of products on sale using their IDs as common denominator;
- Create a custom label for the products on sale and upload the URL in DataFeedWatch;
- Update periodically the products that are on sale directly on your Google Drive.
Automatically exclude products with 404 URLs
Our customer, Invest Online, one of the leading advertising agencies in The Netherlands, is using the ''is in list'' to avoid traffic on broken urls via Google Shopping.
- broken urls in our product feeds
- deliver users on a not working or wrong webpage (they also check 301 and 302 redirects on producturls, but not always exclude these products)
- wasting spend for traffic in our Google Shopping campaign on products with a 404 url
- warnings or disapprovals in the Google Merchant Center
''In the specific case I’m happy to say that we don’t have broken urls and so no products excluded. For some accounts we have avoid unnecessary costs and or incorrect measurements.
For now it's unfortunately not working for shops with big(ger) product feeds, cause the restrictions of the import function in Google Spreadsheets.
The unique solution of this combination is a daily check of product urls and automatic excluding by DataFeedWatch.''
There you have it, a few ideas to get you started using this new feature. Of course, there are many other ways to use the lists of products in your feed optimization rules.
We can get inspiration for previous posts in which we covered other ways to use the lists:
- Regular Expressions made easy with '’is in list (regexp)’’
- Exclude a list of products from your feed
- How to apply rules to a list of products
- How to exclude products from your feed the right way
Once again, a simple, yet efficient functionality that offers lots of flexibility.
DataFeedWatch is data feed optimization and management software that enables merchants on Magento, Shopify, Volusion, 3Dcart, BigCommerce, WooCommerce, OpenCart, VersaCommerce, and numerous other shopping carts to optimize their product data feed for Google and 1000+ Shopping Channels in 50 countries. The most intuitive and easy data feed management and optimization tool on the market. Free trial and live demo available.