Money For Nothin, Chicks For Free Just Like Google Shopping Actions

“Money For Nothing” was a smash hit from the mid-1980’s by the group Dire Straits.

As the story goes, the lyrics were inspired when a member of the music group overheard the comments from a delivery driver in the back of an appliance store as he watched a MTV music video.

The delivery driver’s comments included the classic lines from the song, “what are those, Hawaiian noises?…that ain’t workin”, and of course “money for nothing and chicks for free”.

Of course, those who know better realize the hard work needed for any performance especially a music video production.

I bring mention this song not only because it is one of my all-time favorites, but because last week Google announced that Google Shopping Actions would now be free for advertisers.

If you missed it, the announcement will affect those advertisers who have already either enrolled or have begun the enrollment process into Google Shopping Actions. For those retailers, Google Shopping Actions will now substantially reduce or even eliminate their fees.

Here was the important part of the email that many advertisers received last week:

Announcement sent from Google on 7/23/20

For those not familiar with the program, Shopping Actions are created using merchant listings inside Google Shopping. Within these listings the final payment transaction takes place through Google and Google takes a percentage of the sale rather than charging per click.

Earlier this year, I dedicated an entire article to Shopping Actions, which you can read here if interested – Google’s Shopping Actions – Changing The Landscape.

As a quick summary of that article, before last week’s change, Google would charge merchants 12% – 15% to process an order through Google Shopping. Once Google processed the payment, they would send merchants the order information through the merchant’s Google Merchant Center account.

To be eligible for Google Shopping Action, merchants would apply for the program and control their eligible product listings through Google Merchant Center.

Merchants participating using Google Shopping Actions have two options

First – you can enter their your payment processor and pay 0% commission. This will need to be done by February 21, 2021 to continue to serve ads using Google Shopping Actions.

Second, continue to use Google’s payment processor through 2/21/21 and pay a flat 5% commission.

Although good news for existing Google Shopping Action customers (either active or who have started the process); the Shopping Actions program is now closed until further notice for retailers who have not yet applied.

What is now available to all retailers is the ‘free’ clicks inside Google Shopping that Google announced in April of this year.

If you don’t know what the free clicks, check out this article – It’s Back To The Future With Google’s Free Shopping Ads.

However, the free clicks are just like that rock band getting their money for nothin’ and their chicks for free. Although, it looks quick and easy to take advantage of this free traffic, it is still going to take a work.

Free clicks and paid clicks inside of Google Shopping as well as Shopping Actions clicks are all determined by which products a merchant uploads into their Google Merchant Center account.  

The process of opening a Merchant Center account and submitting products to Google Merchant Center is where many advertisers especially those new to using Google Shopping may get confused.

It is also where I can help. I have dedicated the first section of my new book, Make Each Click Count Using Google Shopping, to properly configuring Google Shopping. Right now, you can immediately download the book for $5.96 and make sure you get started with the proper foundation.

In addition, I have recently created a new Facebook Group, Make Each Click Count Facebook Group. It is FREE to join and will give you immediate access to myself where I can answer any questions regarding the setup of your merchant account.

Click Here to request to join the Make Each Click Count Facebook Group.

In fact, there are some questions others have asked in there that might be useful for you to check out as well:>

Remember To Stay Safe & Keep Healthy,

Looking for More Information on Google Advertising?

Check out the all new The Academy of Internet Marketing (www.theacademyofinternetmarketing.com), the premier online marketing destination trusted by small to mid-sized eCommerce businesses serious about substantially growing their online sales. In addition, The Academy of Internet Marketing includes exclusive access to me, author of the Make Each Click Count book series.

If you have the dedication and are ready to take your online sales to the next level, then The Academy of Internet Marketing was created for you. It provides the tools in the form of knowledge of what works today. Join us and discover for yourself what makes us special. Together we will grow your business!

Happy Marketing!
Andy Splichal

ABOUT THE AUTHOR

Andy Splichal is the founder of True Online Presence, author of the Make Each Click Count book series, host of the Make Each Click Count podcast, founder of The Academy of Internet Marketing and certified online marketing strategist with twenty plus years of experience helping companies increase their online presence and profitable revenues. To find more information on Andy Splichal, visit www.trueonlinepresence.com or read The Full Story on his blog, blog.trueonlinepresence.com.

Populating Merchant Center with Proper Data

After your Merchant Center has been approved and you have completed the appropriate settings for shipping, tax, etc. it is a critical time. A time that will play a major part in determining your success using Google Shopping. It is time to create your plan for populating your product data inside Merchant Center.

You will soon discover that having well formatted data is going to be essential in order to properly segment campaigns inside the Google Ads interface.

Updating Product Data in Merchant Center

To get started you need to submit the products to Merchant Center that you want to have eligible to appear in Google Shopping. When submitting your products, there are four options:

Google Sheets – You make all of the changes manually to the product data using a Google Sheet. These changes are automatically applied to your account once uploaded.

Schedule fetch – You host a data feed file on your website and schedule a time for Google to fetch updates from the file. Once the fetch occurs, Google applies updates to your products in Merchant Center.

Upload – This is the most common. With this method you keep the file and schedule a regular upload into your merchant center using SFTP, FTP, Google Cloud storage or a manual upload.

Content API – The Content API for Shopping enables merchants to automatically upload product listings using an API connection.

The Process of Submit Products

Unless you have just a handful of products that rarely change in terms of inventory and pricing it typically is not viable to manually create and update a product feed.

The good news is that there are many 3rd party Data Optimization Companies that specialize in getting data from your website to Merchant Center. The bad news is how do you know which data optimization company is a good fit for your company and for your needs.

The better a data optimization company is the easier they are going to make the process for merchants of taking data in their website and easily customizing that data into Google’s different fields.

Here are currently the different fields that are supported in Google Shopping. Not all the fields below are required, but the more fields that you populate the better Google is going to be able to match your products to relevant customer searches.

Being able to populate all or at least as many of these fields as possible is why using a 3rd party data optimization company is usually an essential addition to your Google Shopping efforts.

Image if you have 5,000 products and after spending hours creating your initial upload you need to make changes to just a couple of these fields. It would take a long time, right?

Changes can be done using a data feed optimization company in a matter for seconds or minutes instead of hours.

Most fields are not required. Only 13 fields are currently required to have products approved in Merchant Center for non-apparel items and 20 fields are required for apparel items.

Note, some of the required apparel fields are only required in Shopping Actions not to be approved in Google Shopping. For information on Shopping Actions see my article – Google’s Shopping Actions – Changing The Landscape.

Choosing a Data Feed Optimization Company

Now that you have discovered why it is a good idea to partner with a data optimization feed company, how do you select which company is right for your business?

Typically, the price of this service can range from twenty dollars to hundreds of dollars per month so choosing the right company is going to depend on a few things:

  1. Are you planning on using the data feed company to send your product feed to other comparison-shopping engines other than Google Shopping? Since Google Shopping is the largest comparison-shopping engine, typically all companies are going to have this feed well structured. The difference with the more expensive companies usually will be in how well they can structure the feeds going to other Shopping portals.
  2. How does their system allow you to manipulate your data feed? The main purpose of using a data optimization company is to be able to easily populate your data feed. No matter what company you select there will be a learning curve; however, make sure you get a full overview as learning how to manipulate and submit your feed is essential.
  3. Make sure you know how the company charges. Some data optimization feed companies charge additional based on how many products you have. Once you reach a certain number of products the monthly charge may start increasing.
  4. Support is key. There is going to be a learning curve. Make sure whatever data optimization company you select offers full support in helping you get started as well helping with questions maintaining the health of your data feed moving forward.
  5. Make sure you can easily review your feed. As time passes, you are going to want to be able to export your feed. With some data optimization companies that use an API, I have found that this is not possible.
  6. Don’t sign a long-term contract! There are so many data optimization companies out there that don’t require a long-term commitment. There is no reason to be locked into anything other than a month-to-month agreement.

Working with Your Data

Once you have selected a data optimization company, the first step is importing your products into their system. It is within the data optimization company’s system, that merchants will format their feed and manipulate the data populating as many of the fields above as possible.

Remember, the more fields you populate the more effective Google will be in matching your products to related customer inquiries.

Also, start thinking about how it makes sense to segment your products. Google provides the custom label fields in order to help their advertisers segment their data.

The custom label fields serve no other purpose in your data feed other than to organize your products, so feel free to enter whatever data you want that will better help you segment your campaigns.

For more information on custom labels including ideas on how to effectively use, check out my article – Segmenting Product Data – Develop Your Plan With Custom Labels.

Submitting Your Feed

Assuming that by now you have already claimed and verified your Merchant Center and have completed your tax and shipping settings the last piece of completing your merchant center is submit your first product feed.

To begin submitting your first data feed you will need to navigate under Products in the left-hand menu to ‘Feeds’ and then click on the blue plus button under Primary feeds.

Next, you will select your country of sale, the language for the content of your feed and the destination in Google that you wish your products eligible to appear. As a default Shopping ads are checked, for information on how to have your products eligible to appear in Shopping Actions see my article – Google’s Shopping Actions – Changing The Landscape.

Then, you will name your Primary feed and select the input method. The input method is going to depend upon your data optimization company, but most likely will be the Upload option.

If you select the upload option, you will enter the name and type of file exactly as it will appear coming from your data optimization company. In order to be successfully processed, this must be exact.

In addition, you can upload your new file manually on this page to test if it will be accepted.

Now that your feed is created there are a couple more items that you will need to format before your feed will be successfully submitted.

First, you will need to provide your data feed optimization company the ability to connect with your Merchant Center account. To do this you will need to provide them with your Merchant Center SFTP or FTP login credentials. To find these credentials, click on the wrench icon in the top tool bar and choose ‘SFTP/FTP/GCS’ under ‘Settings’.

Depending on how your partnered data optimization company connects, this is where you will be able to find the needed credentials.

The last thing that generally causes an initial feed to fail is the merchant not selecting their ‘Default currency’. This is the type of currency used to sell products included in the feed.

In order to select, click on your feed name and click on settings. Under ‘Default currency’ you select your correct currency and save.

That’s it. Your feed should now be successful submitted into Google Merchant Center. Google can take up to 72 hours to first process and approve your items, so you will need to be patient. Soon you will be ready for the really fun stuff – setting up your campaigns inside the Google Ads interface!

Final Word

Creating your Merchant Account and formatting your corresponding data feed is going to take some work. However, given that products advertised in Google Shopping are producing some of the highest returns on investment it is most likely worth the work.

As competition grows for advertisers using Google Shopping, it is going to take more than just sending a partially developed data feed and bidding the same for each item in Google Ads in order to be successful.

However, by fully developing your plan with your data feed you will gain an immediate advantage over your competitors.

For those of you with a large number of product offerings or product offerings that change frequently it will be essential to partner with a solid data optimization company. Use the list above in this article to determine the right fit and don’t delay. Customers are out there actively searching for your products and you want to make sure they can find you!

Related articles –

There Can Be No Google Shopping Without A Google Merchant Account
Segmenting Product Data – Develop Your Plan With Custom Labels
Using Supplemental Feeds in Merchant Center
How Segmenting Google Shopping Campaigns Can Boost Profitability

Looking for More Information on Google Advertising?

Check out the all new The Academy of Internet Marketing (www.theacademyofinternetmarketing.com), the premier online marketing destination for small to mid-sized e-commerce businesses serious about substantially growing their online sales plus exclusive access to me, author of Make Each Click Count, The TOP Guide To Success Using Google AdWords.

Complete Access To The Academy of Internet Marketing For $1

If you have the dedication and are ready to take your online sales to the next level, then The Academy of Internet Marketing was created for you. It provides the tools in the form of knowledge of what works today. Join us and see what makes us special and together we will grow your business.

If you are ready to take your online advertising to the next level, I welcome you to take a trial. It only costs $1 for access.

Happy Marketing!
Andy Splichal

ABOUT THE AUTHOR

Andy Splichal is the founder of True Online Presence, the founder of The Academy of Internet Marketing, author and certified online marketing strategist with twenty plus years of experience helping companies increase their online presence and profitable revenues. To find more information on Andy Splichal, visit www.trueonlinepresence.com or read The Full Story on his blog, blog.trueonlinepresence.com.

Positive Keywords – A Better Way To Control Unwanted Searches

Unwanted Searches

One of largest obstacles in achieving profitability for many advertisers using Google Shopping is the presence of unwanted keyword searches. Even profitable Shopping campaigns are not immune to wasted ad spend due to the nature of Google Shopping.

With Google Shopping the advertiser does not select their keywords as they do with their Search campaigns. Instead Google uses their proprietary algorithm to match a user’s Google search with an advertiser’s product ad. In order to match an advertiser’s product ad to serve inside Google Shopping results, Google uses a combination of keywords found in each product’s title and its product description. Then, Google uses a real-time auction based on an advertiser’s bid compared with other advertisers’ bids who have matching products to determine which order (ad rank) items appear in Google Shopping.

For the most part, this works well for advertisers as the keywords in the title and description determine when a product is eligible to appear, and the amount of an advertiser’s bid determines the order.

It also saves time for advertisers. Once a data feed is approved in Google Merchant Center, products can begin running inside the Google Shopping platform within minutes.

In fact, it is so easy to launch a new Google Shopping campaign that it can be quite dangerous in terms of budget for the novice Google marketer.

For those advertisers wanting to optimize their campaigns for profit, the most effective tool in being able to eliminate unwanted searches is the proper use of negative keywords – see my article ‘The Art of Adding Negative Keywords‘.

Negative keywords can be applied at the ad group, campaign or multi-campaign level with the use of a negative keyword list. However, properly optimizing with negative keywords by using the search terms report can be a never-ending task of find and remove with the constant discovery of new unwanted search phrases.

A Better Way

For accounts that have products that are highly brand oriented there is an easier way to eliminate approximately 80% of unwanted search terms without the constant adding of negative keywords.

Interested?

It is called Positive Keywords.

One of the most effective strategies that I use for many of my private clients who are brand centric, this strategy relies on a couple of things:

  1. The Proper Segmenting of Google Shopping Campaigns.
  2. The Use of Priority Settings.

Properly Segmenting Google Shopping Campaigns

With best-practices, Google Shopping campaigns should be subdivided just like you do with Google Search Campaigns meaning into a subset of like products. Since Google Shopping products rely on your data feed being supplied to Google Merchant Center this is going to take some advanced planning and correctly implementing that plan when formatting your Merchant Center feed.

However, by properly segmenting your campaigns advertisers will be able to more easily control unwanted searches with negative keywords as well as be able to better optimize bids for product ads based on historical data.

For additional information on optimizing product bids plus a FREE download, see my article ‘Effectively Optimize Google Shopping Based on Your Past History, Nothing More’.

Properly Using Campaign Settings

When configuring a Google Shopping campaign, Google allows for the use of priority settings of high, medium and low. Priority settings like the name implies takes priority over bids in determining which product Google serves from an advertisers account.

The priority settings kick-in if either the same product is in 2 different campaigns or if 2 different products in 2 different campaigns have a title/keywords that matches a Google search query.

Here is a quick written illustration:

Campaign A has a Priority Level of Low and contains product XYZ with a bid of $0.50.

Campaign B has a Priority Level of Medium and also contains product XYZ with a bid of $0.05.

Google is going to always display the product XYZ from Campaign B with the bid of $0.05 instead of from Campaign A even though the bid for the same product is 10X higher in Campaign A because of the priority level setting.

For detailed information on formatting your Priority Settings, read my article ‘Knowing Your Priority Settings in Google Shopping’.

The Positive Keyword Strategy

Here is how the priority keyword strategy works.

I set a product group containing many related products typically products grouped by manufacturer brand to high priority at a very low bid, say $0.01 in an initial campaign – Call it Campaign A.

Then, I create another campaign containing the same products at either medium or low priority and use a significantly higher bid, say $1 – Call this Campaign B.

Within the high priority Campaign with bids set at $0.01 (Campaign A), I add negative keywords for the branded terms as well as other high converting search terms.

What this does is allow Campaign A to filter out keyword searches with the use of negative keywords at a bid of $0.01. The keyword searches that direct to Campaign A are typically keywords with a low chance of converting.

Thus, this strategy allows only high-converting, brand specific traffic to be eligible to serve product ads in Campaign B. This greatly increases the conversion rates, CTR and overall profitability of Campaign B allowing you to increase bids and increase your Search Impression Share.

Now Campaign A, with its bid of $0.01 will still get a small bit of traffic and some of that traffic may even convert. When a keyword term converts in Campaign A, you can view the ‘Search’ terms report located within the ‘Keywords’ link on the left menu to add this keyword as a negative keyword to Campaign A. When you add a keyword negative to Campaign A, it will allow future searches for that converting keyword to be passed through to Campaign B.

This strategy works well to significantly improve the conversion rates and the CTR, which also will increase the quality score of products ads in Campaign B. Increasing the quality score of products ads will work to benefit advertisers by helping lower their average cost-per-click regardless of bid.

A product ad with a high-quality score often may be shown in front of a competitor’s PLA ad in Google regardless of bid, thereby increasing overall profitability even further!

Google regardless of bid, thereby increasing overall profitability even further!

Non-Theoretical Example

One of my private clients sells t-shirts and hats and one of their biggest selling brands is John Deere. For there John Deere Shopping campaign, we have found that keyword search terms containing John Deere convert while there are hundreds of other search terms that do not or at least do not profitably.

Therefore, by using the Positive Keyword strategy we can filter out all keyword searches that do not contain John Deere from the John Deere Campaign.

Campaign A – We will name ‘Positive Strategy – John Deere’ and add all John Deere product ads to this campaign with a bid of $0.01 and set the priority level to high. We will then add the negative keywords as a phrase match “John Deere”.

Campaign B – We will name ‘John Deere – Standard’ and add all John Deere product ads to this campaign with a bid of $0.50 and set the priority level to medium.

Since both campaigns have the same products all Google searches where these products would be eligible to appear will be sent to the Positive Strategy – John Deere campaign unless those searches contain the keyword term “John Deere”.

Positive Strategy – John Deere campaign has a bid of $0.01 which allows us to filter out all the unwanted keyword searches that we were receiving non-specific keyword searches from John Deere – Standard at the cost of $0.01 per click!

With the positive keyword strategy in place, John Deere – Standard will now receive traffic from search terms ONLY with the term John Deere in them including terms such as ‘John Deere Hat’, ‘John Deere Shirt’, Etc.

See how it works!

Last Word

Using Positive Keywords is most effective when advertising brand centric products or with enough historical data for an advertiser to absolutely know which keyword search terms do and which do not convert.

By using Positive Keywords an advertiser needs to make sure they are not eliminating substantial traffic that has the potential to generate significant profitable sales.

In addition, advertisers need to make sure all steps are properly completed when setting their priority levels, bids and negative keywords. If there is an error in the way settings are configured, the Priority Keywords method will not have the desired results.

You also will want to monitor your Positive Keyword campaigns for conversions as you will want to add to negative keywords in the Positive Strategy campaign if the campaigns receives a conversion.

Finally, even after Priority Keyword method is running properly it will still be necessary to monitor the keywords driving traffic and most likely continue to add negative keywords to your main campaign, just not as many:>

Looking for More Information on Google Advertising?

Check out the all new The Academy of Internet Marketing  (www.theacademyofinternetmarketing.com), the premier online marketing destination for small to mid-sized ecommerce businesses serious about substantially growing their online sales plus exclusive access to me, author of Make Each Click Count, The TOP Guide To Success Using Google AdWords.

If you have the dedication and are ready to take your online sales to the next level, then The Academy of Internet Marketing was created for you. It provides the tools in the form of knowledge of what works today. Join us and see what makes us special and together we will grow your business.

Complete Access To The Academy of Internet Marketing For $1

If you are ready to take your online advertising to the next level, I welcome you to take a trial. It only costs $1 for access.  

Happy Marketing!
Andy Splichal

ABOUT THE AUTHOR:

About The Author - Andy Splichal

Andy Splichal is the founder of True Online Presence, author and certified online marketing strategist with more than a decade and a half of experience helping companies increase their online presence and profitable revenues.  Find more information on Andy Splichal visit www.trueonlinepresence.com or at his read his blog, blog.trueonlinepresence.com.

Using Supplemental Feeds in Merchant Center

Most often one of the least understood pieces of advertising using Google Shopping is the continuous updating of product data to Google Merchant Center.

Far too often I have found when reviewing a retailer’s Google Ads account, they setup the Merchant Center; linked it to their Google Ads account and then never or almost never looked at it again. These accounts are often riddled with product disapprovals and inaccurate information.

Although your bidding optimizations are going to take place inside your Google Ads interface, it is critical to keep the data in your Merchant Center up to date. In addition to being accurate, there are tools that savvy Google advertisers use to effectively managing product data.

One of my favorite tools that I use for my private clients is the use of supplemental feeds.

Getting Started Using Merchant Center

Before you can begin advertising using Google Shopping, you need to first properly configure your Google Merchant Center.

For those new to Google Shopping, properly configuring your Merchant Center includes verifying and claiming your store, setting up tax and shipping information and of course submitting products.

For a complete review of all the initial steps along with the ongoing reviewing of errors and disapprovals that are sure to happen once you have submitted your products, review my article – There Can Be No Google Shopping Without A Google Merchant Account.

However, this article is written for those who are already running an approved product feed and wish to customize the feed without making changes to the original feed.

If that doesn’t quite make sense, no worries? I am about to explain.

Merchant Center Feeds

When uploading your products into Google Merchant Center, you will use the feed section of your Merchant Center account. This section is split into two sections: Primary Feeds and Supplemental Feeds.

The Primary Feed section is where you send the primary feed. The primary feed contains all the data that advertisers use to list and optimize their Google Shopping campaigns formatted into a delivery method that Google accepts.

There are quite a few options for an advertiser when submitting their primary feed.

First, you need to select your country of sale, then the language and finally the destination of where you want your products ads to be eligible for display. The options include Display ads, Shopping ads, Shopping Actions (when activate) and Surfaces across Google.

Next, you name your primary feed and select how you are going to provide the feed to Google.

Options for providing the data to Google include:

  1. Using Google Sheets – Merchants create a Google Sheet to hold the data and manually update the sheet as needed.
  2. Schedule a Fetch – Merchants host the feed on their own server and schedule a regular time for Google to fetch the feed from that location.
  3. Upload – (the most common used) – Merchants typically using a 3rd party data optimization company to automate and format the data along with scheduling a regular send.
  4. Content API – (the second most commonly used) – Also typically done through a 3rd party data optimization company. This method transfers the data through an API connection directly into merchant center.

Once you decide on how to get the data to Google, you then need to name the feed and create the initial feed. Some of the settings such as the Default Currency setting will need to be properly specified in order to have the feed approved by Google.

Supplemental Feeds

Once your primary feed is up and running with products being approved, advertisers may feel the need to update data for a subset of the products in the feed without updating the entire primary feed.

If that doesn’t quite make sense again, no worries. I am about to again explain.

For the example below, I am going to demonstrate using a supplemental feed to exclude some of the products from being eligible to appear in Google Shopping ads.

Besides being able to exclude items, you can update products using a Supplemental feed for any of the over 50 fields supported by Google Merchant Center.

Supplemental feeds are particularly useful to merchants with thousands of products that are being submitted when they only want to edit a subset of those products. Using a Supplemental feed allows information on a large feed to be overwritten with data in a smaller, easy to manage Supplemental feed file.

One of the ways I use supplemental feeds for my private clients is to exclude a small subset of products from being eligible to appear in one of the four supported shopping channels – Display ads, Shopping ads, Shopping Actions (when activated) or Surfaces across Google.

Other times a Supplemental feed may be useful is when it is not possible to map custom labels for some reason inside a primary feed or for that matter any of the other 50 supported fields that need to be changed for a subset of the primary feed.

In this example, I’m going to use a supplemental feed to make some products ineligible to appear within Shopping ads using a Google Sheet.

Creating a Supplemental Feed

The first step is inside Merchant Center to navigate to Products, then Feeds and click on the blue ‘Add Supplemental Feed’ link.

You will then name the feed and select the method for which you would like to submit the data to Google Merchant Center. For this example, I’m going to use Google Sheets.

Google Sheets is like Excel; however, instead of storing the file on your computer it is stored under Google’s cloud storage. Google sheets therefore do not take up any storage room and best of all Google sheets are absolutely free to create, use and modify. A Google sheet simply attaches to the same Google account that you use when accessing your Google Ads Account.

In order to create a Google Sheet, you first will want to name your Supplemental feed with a name that helps you recognize the purpose of the feed and then choose how you would like to deliver the data to Google.

Then, you will select whether you want to generate a new Google sheet or select an existing Google sheet.

Since I am creating from scratch, I’m going to select a generate new Google sheet and click on continue.

You will then want to select the primary feed that you will want to override data in with the new supplemental feed and select continue.

Google will then automatically create your supplemental feed along with a link to open the feed.

Once you open the Google sheet using the blue ‘Open’ link under in the Input method the Google sheet will open, and you can manually add data to the file.

When adding data, you will want the first row to be the header row. This row should contain id in the first column (this is what Google will use to match the data in your supplemental feed with the data in the primary feed). The next columns will be the header for the supported fields that you want to override in the primary feed using the new supplemental feed.

For this example, I am using Excluded_destination in order to tell Google that certain items should not be eligible to appear inside Shopping Ads.

Note, in this example, I’m overriding only one field, excluded_destination, but you can override multiple fields at the same time using a supplemental feed. In order to do so, you need to add additional columns, where the header row contains the field you wish to override with the data underneath.

After the Google sheet is saved for the Supplemental feed to take effect, you are going to have to go back to your feeds and click on the Supplemental feed you just created.

Once opened, you will need to click on the ‘Fetch Now’ link in the upper right.

Once you click the Fetch Now link, Google will import your data and override product data in the original primary feed. Give the feed a few minutes to populate and you should see how many records were successfully populated.

As you can see above, all 27 items that we added were successfully populated!

Checking That Everything Is Working

In order to check to see if that the Supplemental feed has taken affect, you will want to click on ‘All products’ link in the left tool bar and then you can filter by one of the ids in your new Supplemental feed.

If you click on the item, all the details for this item as stored in Google Merchant Center will display.

For the purpose of our example, we can see right near the top that the item no longer is appearing on Shopping ads. However, if you changed other fields in the primary feed, you will need to scroll down on the page to see how different fields are now being displayed.

That is it. Congratulations you now have another highly effective tool for being able to quickly manage the data in your Google Merchant Center!

Last bit of advice

Knowing how your Google Merchant Center pulls in product data is essential to gaining a huge leg up on your competition. Although, all the bidding is done within your Google Ads interface, only products that are approved in your Merchant Center will become eligible to appear in your Google Shopping campaigns.

If you are not checking your Google Merchant Center often, you could be doing yourself a real disservice in terms on not monitoring new disapprovals and other issues that will inevitably arise within Merchant Center.

Providing strategically formatted data to Google Merchant Center makes it much easier to control product listings and allows for the best chance for success using Google Shopping.

And now that you know how to quickly control a subset of your products using a Supplemental feed, you have an effective way to manage your products including showing which products are and are not eligible to appear within different channels.

Looking for More Information on Google Advertising?

Check out the all new The Academy of Internet Marketing (www.theacademyofinternetmarketing.com), the premier online destination for for small to mid-sized e-commerce businesses serious about substantially growing their online sales. Plus exclusive access to me, author of Make Each Click Count, The TOP Guide To Success Using Google AdWords.

Now included within The Academy of Internet Marketing is a video tutorial detailing the creation up a supplemental feed as described in this article.

If you have the dedication and are ready to take your online sales to the next level, then The Academy of Internet Marketing was created for you. It provides the tools in the form of knowledge of what works today. Join us and see what makes us special and together we will grow your business.

If you are ready to take your online advertising to the next level, I welcome you to take a trial. It only costs $1 for complete access for 2 full weeks.

Happy Marketing!
Andy Splichal

Complete Access To The Academy of Internet Marketing For $1

About The Author

This image has an empty alt attribute; its file name is Author2.jpg

Andy Splichal is an online marketing strategist  with more than a decade and a half of experience helping companies increase their online presence and profitable revenues. Although this blog focuses on driving profitable traffic through Google AdWords, True Online Presence offers additional services for lead generation as well as other proven marketing strategies customized for each client.