Your Facebook product feed doesn’t have to be an automatically generated XML file. You can also create (and manage) it using Google Sheets. Here’s how!
Facebook’s Dynamic Product Ads are one of the most effective ad formats for e-shops, as you can automatically target people who are already interested in your products. To create Dynamic Ads, you need a Product Catalog and Product Feed (to feed it). However, it’s not necessary for your Product Feed to an XML file. You can also create it using Google Sheets! Here’s how!
How to create a Facebook Product Feed
If you’re familiar with Facebook Dynamic Ads, you will know that a Product Feed is a file that includes information about the products you want to advertise dynamically. It needs to contain several specific fields, and there are rules you should follow.
You can create your file in CSV, TSV, or XML format, and you don’t necessarily have to use an automated process to create it or update it – although that is useful if you’re managing many products.
You can also simply use Google Sheets. Open a new spreadsheet in Google Sheets, and follow the steps below, adding several fields:
Id – In column A, you will enter your product’s alphanumeric code, according to which you can identify the product.
Availability – In column B, you signify whether a product is in stock, out of stock, on sale, or available for order or preorder.
Condition – Column C defines the status of your product, whether it is new, used or refurbished.
Description – In column D, include a product description of up to 5000 characters.
Image_link – Enter the product image URL you will use in your ad in column E.
Link – Paste the product’s URL in column F.
Title – In column G, write the title of the product.
Price – And in the final column H, enter the price and currency code of the product.
Then, click on… “File,” “Publish to the Web,” then Sheet1 or current sheet. Select values (.csv) separated by commas and click on “Publish.”
You can now use the link that is generated for your Facebook Dynamic Ad campaigns.
Before you do so, though, don’t forget to use Facebook’s Feed debugger to make sure the feed is OK. There you go! So simple!
If you have a small e-shop, creating a feed using Google Sheets should be a sufficient solution for you. But if you are a big e-shop that works in more countries or regions, you will need more than one feed, as you will need to work with multiple ad formats, use multiple currencies, and language variations – and adapt your advertising strategy accordingly.
You might also like
More from Experts Talk
The Top 5 Stories On Social Media This Week
A new musical could soon come to life on TikTok, WhatsApp users are flocking to Signal and Fiverr will run …
The Top 5 Stories On Social Media This Week
Save the date, Twitter is bringing back verification this January. Oh, and it shut own Periscope too. How was your …
3 Courses To Help You Create Better Video Content For Your Ads
Here are three free Facebook Blueprint courses to help you take your content to the next level.
The Top 5 Stories On Social Media This Week
Tamagotchi never dies, 2020 in one word and a new test for 3-way live streams on Instagram. How was your …
The Top 5 Stories On Social Media This Week
Twitter does Twitter best, Salesforce bought Slack and Apple could be working on a matte black MacBook. Are you ready?
Finding Your Way Forward: Five Key Social Trends for 2021
Henk Campher, VP of Corporate Marketing and Head of Social Impact at Hootsuite, looks at five important social trends that …
Hootsuite CTO Ryan Donovan’s 2021 Social Media Predictions
In this article, Hootsuite CTO Ryan Donovan discusses advancements in social commerce, the growing privacy battle, and more 2021 social …
3 Courses To Help You Get Started With Facebook And Instagram Insights
Here are three Facebook Blueprint courses to help you get useful information from insights on how your business is performing …
5 Tips To Make The Online Shopping Experience Easier
Here are 5 questions to ask yourself to help you make the online shopping experience easier for shoppers.