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
Is this case they use the 'is not in list' because the rule is 'include when...'
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.