All language subtitles for 04 - Qué es un feed atributos obligatorios.eng

af Afrikaans
sq Albanian
am Amharic
ar Arabic Download
hy Armenian
az Azerbaijani
eu Basque
be Belarusian
bn Bengali
bs Bosnian
bg Bulgarian
ca Catalan
ceb Cebuano
ny Chichewa
zh-CN Chinese (Simplified)
zh-TW Chinese (Traditional)
co Corsican
hr Croatian
cs Czech
da Danish
nl Dutch
en English
eo Esperanto
et Estonian
tl Filipino
fi Finnish
fr French
fy Frisian
gl Galician
ka Georgian
de German
el Greek
gu Gujarati
ht Haitian Creole
ha Hausa
haw Hawaiian
iw Hebrew
hi Hindi
hmn Hmong
hu Hungarian
is Icelandic
ig Igbo
id Indonesian
ga Irish
it Italian
ja Japanese
jw Javanese
kn Kannada
kk Kazakh
km Khmer
ko Korean
ku Kurdish (Kurmanji)
ky Kyrgyz
lo Lao
la Latin
lv Latvian
lt Lithuanian
lb Luxembourgish
mk Macedonian
mg Malagasy
ms Malay
ml Malayalam
mt Maltese
mi Maori
mr Marathi
mn Mongolian
my Myanmar (Burmese)
ne Nepali
no Norwegian
ps Pashto
fa Persian
pl Polish
pt Portuguese
pa Punjabi
ro Romanian
ru Russian
sm Samoan
gd Scots Gaelic
sr Serbian
st Sesotho
sn Shona
sd Sindhi
si Sinhala
sk Slovak
sl Slovenian
so Somali
es Spanish
su Sundanese
sw Swahili
sv Swedish
tg Tajik
ta Tamil
te Telugu
th Thai
tr Turkish
uk Ukrainian
ur Urdu
uz Uzbek
vi Vietnamese
cy Welsh
xh Xhosa
yi Yiddish
yo Yoruba
zu Zulu
or Odia (Oriya)
rw Kinyarwanda
tk Turkmen
tt Tatar
ug Uyghur
Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated: 1 00:00:02,519 --> 00:00:09,560 What is a feed: required attributes 2 00:00:09,560 --> 00:00:11,840 In this lesson we will see what a data feed is 3 00:00:11,840 --> 00:00:13,359 and the attributes that compose it 4 00:00:13,359 --> 00:00:15,840 in order to fully maximize our campaigns. 5 00:00:15,840 --> 00:00:19,520 We see it. 6 00:00:19,520 --> 00:00:22,399 A good feed is the key to your e-commerce campaigns. 7 00:00:22,399 --> 00:00:23,680 The feed is a file 8 00:00:23,680 --> 00:00:26,840 where we have all the information about our catalog products. 9 00:00:26,840 --> 00:00:29,600 As you can see, it can have different formats: 10 00:00:29,600 --> 00:00:31,760 XML or spreadsheet. 11 00:00:31,760 --> 00:00:33,759 The spreadsheet is still an Excel 12 00:00:33,759 --> 00:00:36,560 with rows and columns where the first row 13 00:00:36,560 --> 00:00:39,680 corresponds to the information that Google and Facebook need. 14 00:00:39,680 --> 00:00:42,200 We are going to call these data attributes. 15 00:00:42,200 --> 00:00:43,479 Every next row 16 00:00:43,479 --> 00:00:46,439 are the data we have for each product. 17 00:00:46,439 --> 00:00:48,720 I show you in a real example that I have already done. 18 00:00:48,720 --> 00:00:50,799 Don't worry, throughout the lesson 19 00:00:50,799 --> 00:00:53,080 we will create one together little by little. 20 00:00:53,080 --> 00:00:56,200 As you see in this Google spreadsheet 21 00:00:56,200 --> 00:00:59,520 I have all the attributes that are easily recognizable, 22 00:00:59,520 --> 00:01:02,919 Well, here, for example, we have the title of the bicycle, 23 00:01:02,919 --> 00:01:05,800 the description, the link of that bike. 24 00:01:05,800 --> 00:01:10,160 If I click here I can access this particular bike. 25 00:01:10,160 --> 00:01:14,160 Then I have the URL of the image, it is here. 26 00:01:14,160 --> 00:01:16,480 I copy the url, put it here. 27 00:01:16,480 --> 00:01:22,800 I have the price, its availability, the brand that it is, etc. 28 00:01:22,800 --> 00:01:26,879 The feed in XML is another format that the advertising platforms 29 00:01:26,879 --> 00:01:28,279 they can also read. 30 00:01:28,279 --> 00:01:31,160 In this course, for simplicity, we are going to create a product feed 31 00:01:31,160 --> 00:01:34,839 in a Google spreadsheet like the one we have seen. 32 00:01:34,839 --> 00:01:36,360 You will be very happy to know 33 00:01:36,360 --> 00:01:38,199 that this feed example that we will create 34 00:01:38,199 --> 00:01:42,440 It will be used to make ads on Google, Facebook and Instagram. 35 00:01:42,440 --> 00:01:46,040 In this lesson I will teach you all the required attributes 36 00:01:46,040 --> 00:01:47,279 so that both platforms 37 00:01:47,279 --> 00:01:49,879 are able to collect this information. 38 00:01:49,879 --> 00:01:52,000 The importance of understanding these attributes 39 00:01:52,000 --> 00:01:53,519 is given for two reasons, 40 00:01:53,519 --> 00:01:55,800 each more important than the other. 41 00:01:55,800 --> 00:01:58,120 On the one hand, the more information the feed has, 42 00:01:58,120 --> 00:01:59,440 of higher quality will be, 43 00:01:59,440 --> 00:02:02,720 and this will greatly help the performance of your campaigns. 44 00:02:02,720 --> 00:02:04,559 On the other hand, catalog campaigns 45 00:02:04,559 --> 00:02:07,480 or specific campaigns for e-commerce, 46 00:02:07,480 --> 00:02:09,479 they don't work like other Google campaigns, 47 00:02:09,479 --> 00:02:12,360 where you buy the keyword that represents your business, 48 00:02:12,360 --> 00:02:15,679 but your products will appear in the Google search engine 49 00:02:15,679 --> 00:02:16,880 according to the correspondence 50 00:02:16,880 --> 00:02:18,720 of the search carried out by a user 51 00:02:18,720 --> 00:02:21,080 and the information you have in the catalog. 52 00:02:21,080 --> 00:02:23,039 Let me explain with an example. 53 00:02:23,039 --> 00:02:25,559 If you have an online store for ceramic products 54 00:02:25,559 --> 00:02:29,080 and a user Google "handmade ceramic mugs", 55 00:02:29,080 --> 00:02:31,440 but you have described your product in the catalog 56 00:02:31,440 --> 00:02:33,880 as "vessels of artisan earthenware" 57 00:02:33,880 --> 00:02:36,279 it is possible that you could lose sales opportunity, 58 00:02:36,279 --> 00:02:38,199 since Google won't show your ads 59 00:02:38,199 --> 00:02:39,759 or will show you much less 60 00:02:39,759 --> 00:02:41,960 for not being as relevant as other competitors 61 00:02:41,960 --> 00:02:43,720 that yes they are using the words. 62 00:02:43,720 --> 00:02:46,639 This is why it is very important to use keywords 63 00:02:46,639 --> 00:02:49,720 and describe the product in the most common way possible. 64 00:02:49,720 --> 00:02:52,199 For this there are several tools that help you to know 65 00:02:52,199 --> 00:02:54,199 the search volume of the "keywords". 66 00:02:54,199 --> 00:02:57,080 I leave you some platforms in Lesson Resources. 67 00:02:57,080 --> 00:02:59,039 First I would like you to understand well 68 00:02:59,039 --> 00:03:02,199 the procedure for this product feed that we will create 69 00:03:02,199 --> 00:03:04,839 become so cool image ads 70 00:03:04,839 --> 00:03:06,279 that we saw at the beginning. 71 00:03:06,279 --> 00:03:08,759 Later I will give you many tips on how to enrich 72 00:03:08,759 --> 00:03:10,360 the data of each product 73 00:03:10,360 --> 00:03:12,320 to appear in Google locations 74 00:03:12,320 --> 00:03:15,600 as many times as possible in the most profitable way possible. 75 00:03:15,600 --> 00:03:17,600 As you can see, here we have our CMS, 76 00:03:17,600 --> 00:03:21,479 which would be the PrestaShop, Shopify or WooCommerce you use. 77 00:03:21,479 --> 00:03:22,639 This is the platform 78 00:03:22,639 --> 00:03:26,800 where you manage your products and the sales that you surely know. 79 00:03:26,800 --> 00:03:29,639 Then we will upload our catalog to Google Merchant Center, 80 00:03:29,639 --> 00:03:32,080 what is the platform we have in the middle 81 00:03:32,080 --> 00:03:34,960 before creating the ads in Google Ads. 82 00:03:34,960 --> 00:03:37,440 Once we create the campaign with the catalog, 83 00:03:37,440 --> 00:03:41,720 We will appear in the different Google networks and locations. 84 00:03:41,720 --> 00:03:44,320 With Facebook it happens very similar. 85 00:03:44,320 --> 00:03:47,240 Within our Business Manager we have a section 86 00:03:47,240 --> 00:03:49,320 which is called Commerce Manager, 87 00:03:49,320 --> 00:03:52,039 then we will create the campaigns within Facebook Ads 88 00:03:52,039 --> 00:03:53,080 and thanks to this, 89 00:03:53,080 --> 00:03:56,440 our ads will appear on Facebook and Instagram. 90 00:03:56,440 --> 00:03:58,960 There are several ways to upload our products. 91 00:03:58,960 --> 00:04:01,559 We can do it one by one, which is what we want to avoid, 92 00:04:01,559 --> 00:04:04,279 that's why I'm going to show you an alternative to do it. 93 00:04:04,279 --> 00:04:07,279 We can also upload our products through a module, 94 00:04:07,279 --> 00:04:12,119 which is a bridge that extracts from your platform, 95 00:04:12,119 --> 00:04:15,080 Prestashop, WooCommerce or the CMS you use, 96 00:04:15,080 --> 00:04:18,239 the catalog information and gives you a URL, 97 00:04:18,239 --> 00:04:20,399 that you can then put inside Merchant Center 98 00:04:20,399 --> 00:04:22,679 or the Facebook e-commerce manager. 99 00:04:22,679 --> 00:04:24,040 But paid. 100 00:04:24,040 --> 00:04:27,959 You can also hire a programmer to create a feed for you 101 00:04:27,959 --> 00:04:31,040 and you can directly upload that URL that he has created for you. 102 00:04:31,040 --> 00:04:32,760 To be a little more independent, 103 00:04:32,760 --> 00:04:37,000 I will teach you how to do it with google spreadsheets. 104 00:04:37,000 --> 00:04:38,600 The first thing we have to understand 105 00:04:38,600 --> 00:04:41,559 are the attributes that make up the feed. 106 00:04:41,559 --> 00:04:45,279 There are two types: mandatory and optional. 107 00:04:45,279 --> 00:04:47,880 Without the mandatory ones we cannot create the campaigns. 108 00:04:47,880 --> 00:04:49,600 I will explain them one by one 109 00:04:49,600 --> 00:04:52,720 and, in addition, I will give you enough tips to improve them. 110 00:04:52,720 --> 00:04:54,279 The first one is the title. 111 00:04:54,279 --> 00:04:57,959 As you can see, it is what appears after the image. 112 00:04:57,959 --> 00:05:00,440 It is very important to add the keywords 113 00:05:00,440 --> 00:05:03,720 that most represent your business in the first 60 characters, 114 00:05:03,720 --> 00:05:05,600 because later it is cut. 115 00:05:05,600 --> 00:05:07,799 Although they are cut, the color and size 116 00:05:07,799 --> 00:05:10,359 it may be interesting to add them later, 117 00:05:10,359 --> 00:05:13,279 because Google can interpret that it is a relevant result 118 00:05:13,279 --> 00:05:15,519 for the user who has searched with size and color. 119 00:05:15,519 --> 00:05:18,440 The more information you put in the title, the better. 120 00:05:18,440 --> 00:05:20,959 Of course, we cannot add any promotional text, 121 00:05:20,959 --> 00:05:25,119 no capital letters to show emphasis or words in other languages. 122 00:05:25,119 --> 00:05:29,519 Also, in Resources I will leave you some recommendations that Google passed 123 00:05:29,519 --> 00:05:31,079 because, for each sector, 124 00:05:31,079 --> 00:05:33,480 titles can be made differently. 125 00:05:33,480 --> 00:05:36,959 Google gave some recommendations that I find interesting. 126 00:05:36,959 --> 00:05:39,640 The next attribute is the description. 127 00:05:39,640 --> 00:05:42,160 It is very important that you use keywords here 128 00:05:42,160 --> 00:05:43,440 because it will help SEO. 129 00:05:43,440 --> 00:05:47,160 Keep in mind that it will not be better if you repeat the keyword a lot, 130 00:05:47,160 --> 00:05:49,880 but you name it in different ways, shapes, 131 00:05:49,880 --> 00:05:51,920 or add as much information as possible, 132 00:05:51,920 --> 00:05:54,679 since many people can not only search for "bicycle", 133 00:05:54,679 --> 00:05:58,119 which does not have many synonyms, but the design it has, 134 00:05:58,119 --> 00:06:01,959 by color, size, by many other variables. 135 00:06:01,959 --> 00:06:04,279 In the end you have five thousand characters maximum, 136 00:06:04,279 --> 00:06:07,519 that surely you will not arrive, because there are many. 137 00:06:07,519 --> 00:06:09,959 If you don't have very developed descriptions, 138 00:06:09,959 --> 00:06:13,959 you can add the title or other attributes that we are going to see. 139 00:06:13,959 --> 00:06:16,279 The product link is very difficult to understand, 140 00:06:16,279 --> 00:06:19,279 since it is the link that the product will go to. 141 00:06:19,279 --> 00:06:23,480 Product link is a required attribute 142 00:06:23,480 --> 00:06:25,119 and Google should track it. 143 00:06:25,119 --> 00:06:27,079 We cannot put the Robots.txt. 144 00:06:27,079 --> 00:06:31,320 You have to try to have as few redirects as possible. 145 00:06:31,320 --> 00:06:34,320 The link in the image is the most main image, 146 00:06:34,320 --> 00:06:36,640 where the product is seen in the best possible way. 147 00:06:36,640 --> 00:06:38,880 To be able to add different images 148 00:06:38,880 --> 00:06:42,239 where we will have details, we will have another different attribute, 149 00:06:42,239 --> 00:06:44,119 that we will see in the next lesson. 150 00:06:44,119 --> 00:06:47,959 Images with a model work better than without a model. 151 00:06:47,959 --> 00:06:49,079 Therefore, above all, 152 00:06:49,079 --> 00:06:52,160 if you work with textiles, clothing or fashion 153 00:06:52,160 --> 00:06:54,320 it is interesting that you use models. 154 00:06:54,320 --> 00:06:55,359 In addition, it is important 155 00:06:55,359 --> 00:06:57,839 that the product is neither too far nor too close. 156 00:06:57,839 --> 00:07:02,160 Google recommends that it occupies between 75% and 90% of the image. 157 00:07:02,160 --> 00:07:04,559 Then we have the price and availability. 158 00:07:04,559 --> 00:07:07,079 The price of the feed is very important 159 00:07:07,079 --> 00:07:09,359 that matches the one on the landing page. 160 00:07:09,359 --> 00:07:11,679 Remember that, if you have a discounted price, 161 00:07:11,679 --> 00:07:14,320 the one you have to put in this price attribute 162 00:07:14,320 --> 00:07:16,839 is the actual price, the higher. 163 00:07:16,839 --> 00:07:18,920 It is not necessary to include shipping costs, 164 00:07:18,920 --> 00:07:21,880 this is another attribute or a separate setting. 165 00:07:21,880 --> 00:07:25,559 On the other hand, there are four ways to show availability: 166 00:07:25,559 --> 00:07:29,480 in stock, out of stock, pre-ordered and pending receipt. 167 00:07:29,480 --> 00:07:31,359 The difference between these last two 168 00:07:31,359 --> 00:07:33,160 is that in the advance order 169 00:07:33,160 --> 00:07:37,079 that product has never been in stock in our online store. 170 00:07:37,079 --> 00:07:40,640 However, the pending receipt is a product that was, 171 00:07:40,640 --> 00:07:44,359 You ran out of stock in the store and you will receive it again. 172 00:07:44,359 --> 00:07:47,720 Therefore, you have the option to display it within the catalog, 173 00:07:47,720 --> 00:07:49,320 so they can buy it 174 00:07:49,320 --> 00:07:52,440 and, when you have it in the warehouse, you can send it to them. 175 00:07:52,440 --> 00:07:56,359 This attribute, ID, is the internal own identifier, 176 00:07:56,359 --> 00:07:59,000 that is, it is how you name this product 177 00:07:59,000 --> 00:08:01,839 with its own numbering, internal to the business. 178 00:08:01,839 --> 00:08:03,519 It is unique for each product 179 00:08:03,519 --> 00:08:06,519 and it is the same for different countries and languages, 180 00:08:06,519 --> 00:08:08,000 because, if you sell a bicycle, 181 00:08:08,000 --> 00:08:11,239 It is the same to sell it in Norway as in Spain. 182 00:08:11,239 --> 00:08:15,239 It is the same product, therefore it has the same identifier. 183 00:08:15,239 --> 00:08:18,160 These identifiers are very important. 184 00:08:18,160 --> 00:08:21,239 I wish they had explained them to me when I was starting out, 185 00:08:21,239 --> 00:08:24,839 because they can be confusing if they don't explain it to you in a simple way, 186 00:08:24,839 --> 00:08:28,640 however, when you meet them, they don't have that much difficulty either. 187 00:08:28,640 --> 00:08:30,920 Actually the attribute name is GTIN, 188 00:08:30,920 --> 00:08:34,599 but GTINs can be named differently. 189 00:08:34,599 --> 00:08:37,039 For example, in North America they call them UPC, 190 00:08:37,039 --> 00:08:42,880 but out of there, they call them EAN, in Japan they call them JAN, 191 00:08:42,880 --> 00:08:47,200 and for books it is used all over the world and is ISBN. 192 00:08:47,200 --> 00:08:49,599 I have normally been working with EAN, 193 00:08:49,599 --> 00:08:52,159 because I haven't worked with North America that much. 194 00:08:52,159 --> 00:08:54,840 The EAN is a code that the supplier passes to you. 195 00:08:54,840 --> 00:08:56,359 If you work with suppliers 196 00:08:56,359 --> 00:08:58,359 surely, when the product arrives, 197 00:08:58,359 --> 00:09:01,640 you have a barcode and underneath there is a numbering. 198 00:09:01,640 --> 00:09:03,000 This would be the EAN. 199 00:09:03,000 --> 00:09:07,961 When we don't have GTINs, none of the ones we see here, 200 00:09:07,961 --> 00:09:10,280 because we are the manufacturers, 201 00:09:10,280 --> 00:09:12,719 we have to use brand and MPN, 202 00:09:12,719 --> 00:09:14,840 it is mandatory to use both. 203 00:09:14,840 --> 00:09:18,479 The MPN really is a code that you can make up too. 204 00:09:18,479 --> 00:09:22,559 It has to be different from ID, but since you are the manufacturer, 205 00:09:22,559 --> 00:09:24,520 It is as if you are your own provider. 206 00:09:24,520 --> 00:09:28,119 This has no difficulty because you will already have your own brand, 207 00:09:28,119 --> 00:09:31,000 Or, if not, you can put the name of the web. 208 00:09:31,000 --> 00:09:35,919 Finally, I show you this attribute, there is an identifier, 209 00:09:35,919 --> 00:09:37,719 because Facebook will ask us to. 210 00:09:37,719 --> 00:09:40,320 If not, when we upload the feed on the platform, 211 00:09:40,320 --> 00:09:41,760 it will give us some error. 212 00:09:41,760 --> 00:09:43,400 That is why I wanted to explain it to you. 213 00:09:43,400 --> 00:09:45,840 Actually, this attribute is only used 214 00:09:45,840 --> 00:09:48,679 if we do not use a brand, GTIN, or MPN, 215 00:09:48,679 --> 00:09:51,400 but it is not usually normal. 216 00:09:51,400 --> 00:09:54,640 Here you can see all the attributes we have seen. 217 00:09:54,640 --> 00:09:59,799 As you can see, I have only put here the attributes and here the products. 218 00:09:59,799 --> 00:10:02,200 These attributes have to be in English. 219 00:10:02,200 --> 00:10:05,080 For Google it could be in the language we prefer. 220 00:10:05,080 --> 00:10:07,559 However, Facebook only supports them in English. 221 00:10:07,559 --> 00:10:09,440 So as not to have to do them twice, 222 00:10:09,440 --> 00:10:12,479 it is best to do them in English directly. 223 00:10:12,479 --> 00:10:14,159 As you can see, you have some attributes 224 00:10:14,159 --> 00:10:17,080 that I have identified and put in orange. 225 00:10:17,080 --> 00:10:18,520 This is because they have to continue 226 00:10:18,520 --> 00:10:21,400 the format that Google specifies us. 227 00:10:21,400 --> 00:10:23,239 Notice. 228 00:10:23,239 --> 00:10:24,880 If I go to this page, 229 00:10:24,880 --> 00:10:27,080 which is called product data specification 230 00:10:27,080 --> 00:10:29,159 and that I have left you in the resources, 231 00:10:29,159 --> 00:10:35,919 I can search for "availability", which would be the availability, 232 00:10:35,919 --> 00:10:37,320 and tells me how it has to be. 233 00:10:37,320 --> 00:10:39,239 It has to be written strictly like this: 234 00:10:39,239 --> 00:10:42,679 in_stock, out_of_stock, preorder ... 235 00:10:42,679 --> 00:10:46,320 So here we would have to put the underscore. 236 00:10:46,320 --> 00:10:50,719 This is the only reference Facebook is going to complain about, 237 00:10:50,719 --> 00:10:53,679 because with Facebook there has to be a space here, 238 00:10:53,679 --> 00:10:54,960 as you see here. 239 00:10:54,960 --> 00:10:57,200 So when we put it into Google, 240 00:10:57,200 --> 00:11:01,919 we will put it with the underscore, and, when we upload it to Facebook, 241 00:11:01,919 --> 00:11:04,320 we will change the underscore for a space. 242 00:11:04,320 --> 00:11:06,479 On the other hand, the price has to be 243 00:11:06,479 --> 00:11:12,239 with the point and two decimal places and the currency that it touches. 244 00:11:12,239 --> 00:11:14,200 As you see it here. 245 00:11:14,200 --> 00:11:19,039 The syntax of the euros has to be per ISO 4.217. 246 00:11:19,039 --> 00:11:21,159 This we have nothing more than to search for it in Google 247 00:11:21,159 --> 00:11:24,599 and we put the coin as they tell us. 248 00:11:24,599 --> 00:11:27,039 On the other hand, the identifier exists, 249 00:11:27,039 --> 00:11:30,919 in English it is "identifier exists", we put all "yes", 250 00:11:30,919 --> 00:11:37,320 because in all of us we have the brand and the MPN, which is here, 251 00:11:37,320 --> 00:11:40,400 or the EAN. 252 00:11:40,400 --> 00:11:44,520 As you can see here, these items do not have EAN, 253 00:11:44,520 --> 00:11:46,039 because they have MPN. 254 00:11:46,039 --> 00:11:47,719 It turns out that they are bicycles 255 00:11:47,719 --> 00:11:49,719 that we manufacture internally. 256 00:11:49,719 --> 00:11:54,359 These bikes are so cool that they have no supplier. 257 00:11:54,359 --> 00:11:57,159 Therefore, I do not put anything in EAN, I leave it empty, 258 00:11:57,159 --> 00:12:00,320 but, yes I put MPN and mark. 259 00:12:00,320 --> 00:12:02,799 It's our brand, SantaFixie. 260 00:12:02,799 --> 00:12:06,119 In the rest I also put a brand, because they also have a brand. 261 00:12:06,119 --> 00:12:13,080 So you can create different rows with all your products. 262 00:12:13,080 --> 00:12:15,080 Now that we saw what a data feed is 263 00:12:15,080 --> 00:12:16,840 and the required attributes, 264 00:12:16,840 --> 00:12:18,440 in the next lesson we will see 265 00:12:18,440 --> 00:12:23,799 the most interesting optional attributes. 21042

Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.