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.