Optimize your feed with Google Spreadsheet lists

Posted on February 21, 2018 by Monica Axinte

optimize-feed-Google-spreadsheet-lists.png

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.

 

in-list-url-gif.gif

 

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.

product-is-in-list-1.png

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.

in-list-url-google-sheets.png 

Step 2. Make the document link publicly shareable so that DataFeedWatch can access the document.

is-in-list-url-public-sharing.png

 

Step 3. Create your rule and paste the public URL in the "is in-list" condition.

rules-is-in-list-url.png

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. 

exclude-unrelated-products (1).jpg

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:

  1. Create the list of products on sale using their IDs as common denominator;
  2. Create a custom label for the products on sale and upload the URL in DataFeedWatch;
  3. 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.

They make a combination of a product feed, a Google Spreadsheet with url (status code) checker, a list with ID's of products with a 404 status code and the is in list (spreadsheet) function of DataFeedWatch. 
 
With this structure they kill several birds with one stone:
  • 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
 
The Google spreadsheet they connect, includes an actual imported DataFeedWatch product feed and url checker.
Next they connect the list of broken URLs with the is in list function of DataFeedWatch. 
 
exclude-broken-urls
Is this case they use the 'is not in list' because the rule is 'include when...'
 
Erik van der Linden, Online Marketeer at Invest Online, says:

''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.''
 
I hope this will give you enough information and insights.

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: 

Once again, a simple, yet efficient functionality that offers lots of flexibility.  

Download

 

About DataFeedWatch

DataFeedWatch is data feed optimization and management software that enables merchants on Magento, Shopify, Volusion3Dcart, 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.

Posted in: Features & Functionality

Written by Monica Axinte

Monica Axinte is the VP of Marketing for DataFeedWatch.
Find me on:

Related posts

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 ...
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 ...
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 ...
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 ...

Share This!

Subscribe to Email Updates