Original subtitles

Google Merchant Center and catalog upload

In this lesson we will see

how to upload the feed within Google Merchant Center

and how to configure it to get it ready

for our Google Ads campaigns.

Go for it.

Once you have all the data of your products

entered in the feed, we upload it to Google Merchant Center.

If you remember well, first we need to upload the feed

to a platform other than Google Ads

before creating our ads.

We do it step by step.

Directly I look for Merchant Center here and I enter this link.

I just have to hit Start

and here it will ask me to log in and put my email.

Once logged in, if you go down,

you can enter the first data to configure this platform.

Here he asks me

where do I want customers to process their purchases,

whether it is on my website or in my physical store.

The power of Google Merchant Center

And having a catalog means that you don't need to have a website.

You can even show your ads within Google placements

and take them to your physical store.

In this case, SantaFixie, my e-commerce, is a website,

therefore, I select this option.

In addition, it asks us if we want to use

other tools or if we use them.

In this case, it is not, so we move on.

In this section he asks us

if we want to receive emails,

it can be for new functions, novelties,

or "feedback" from Google support.

We may be interested, so we click both,

and finally, accept Google's terms of service.

Once we have the Merchant Center account created,

we have to validate our domain so that Google understands

that this Merchant Center account will be linked to our website

and only we can own it, this is very important

because it won't let us do anything else if we don't do this step.

This is done from the key.

Let's go to Company Information,

a Website, we put our domain,

our web URL, and you will see that it appears here

Unverified and Unclaimed, which is what we have to do.

There are three options to do so.

One is directly a code that we put within the web.

We can do this by sending it directly to the programmer,

if we have someone to help us,

or do it through Google Tag Manager,

or do it through Analytics.

Surely, if you already have e-commerce, if not,

it would be nice if you configured it, have the Google Analytics

to be able to visualize data,

make sales reports, traffic

and a lot of information that this program gives us

and that you surely know.

It is quite a simple way.

Once you click, you will directly Verify website.

for that you have to have the email with which you created

Google Merchant Center account

is with which you have to have access to Google Analytics,

with permission to edit.

In addition, it is written here.

Then, if you have Google Analytics already installed on your website,

Well that's correct, you don't have to do anything else.

Here it already tells us that we have to verify the website.

All the configurations that we can make

within Google Merchant Center

we can access them from this cogwheel.

Account access.

This is the email with which I have accessed,

but, if I need other users to also manage this account,

For example, someone I work with or an agency,

I just have to add the user from here.

When I add the user, I can give him different accesses,

standard or administrator.

This is the greatest power a user can have,

so keep in mind who you give what access to.

Also, in the lower block, you can select

what kind of notifications or emails you want to receive.

I find this Product Data Alert very important,

since, if you have any problem with the products,

This user will receive an email alert.

You will not always be managing Google Merchant Center,

you don't have to come in every day,

therefore, these emails are usually very interesting.

We add user and we already have it.

The following important configuration

It is the information of the company.

The first thing I have to do is enter the URL of my company.

In the next tab we can go to Information about your company,

and put the data.

Another of the most important settings

And, in fact, it is mandatory, it is the one for shipments and returns.

It is an attribute that we could include within our feed,

from our spreadsheet,

but, for not being repetitive, we do not put it there,

when we can put it in Google Merchant Center,

which is much simpler and more complete.

Let's go to the + button,

to create a new shipping service.

We can put "standard shipping",

and then if we have express shipping, we can create the same.

In this case, I do it for Spain and in euros.

Next.

Here we select the deadline to place an order.

That is, for the transport time

be it between two and four days, or whatever you have on your website,

Monday to Saturday is shipping,

that order has to be made before 15:00.

This is an example. If you do it after 3:00 p.m.,

it won't come to you in two to four days,

If not, it will be three to five, because it will happen the next day.

In this case, it would be Central European Standard Time.

If you want to select the preparation time, correct,

If not, nothing happens.

We advance.

Here we can select the type of shipping cost that we will have.

Is it a free shipping from a specific amount?

Is it always free shipping? According to the range of amounts?

Between 50 and 60 is one thing or another.

Or a flat fee. It is always 2.95.

Well whatever.

In my case, it is a free shipping if it exceeds a specific amount.

In this case, free shipping is from 49 euros and costs ...

I am going to put the maximum value so that Google does not get angry, 4.95,

since I don't know if someone is going to buy the small or the medium box,

Well I put the most unfavorable.

It has a charge of 4.95. We give it to save.

We correct that everything is correct

and I can add another shipping service,

for example, express shipping,

in which instead of taking two to four days, it takes one.

I'm going to move on.

The following important configuration

is to be able to link the accounts

between Google Merchant Center and Google Ads.

We go to Linked Accounts.

As you know, upload the catalog within Google Merchant Center

does not allow us to advertise.

First we will have to link Google Merchant Center

with Google Ads, which is where campaigns are actually created.

Here we have two options:

create a Google Ads advertising account,

or link one we already have.

This depends on whether you have already worked with a

or do you work with her,

you just have to go to Link account

and put your Google Ads customer ID.

This ID can be found next to the name of your account.

I'm going to copy this code and go to Google Merchant Center,

Link account, send request,

and now it tells me: "It is necessary to confirm it within Google Ads".

Therefore, I go back to Google Ads, and I go to Settings,

Linked accounts.

Here we can find an option that says Google Merchant Center.

I give Details.

When I go into this configuration,

I see that the SantaFixie account needs to be linked.

I give View details and approve.

As you can see here, the link status is active,

therefore, we already have the Google Ads account

linked to Google Merchant Center

and we will now be able to create campaigns within Google Ads.

The next point is the one we were waiting for,

that of being able to upload our catalog,

how well we have created previously,

in Merchant Center.

We go to the product menu and here we can do it in several ways.

Or we add product to product, which is what we do not want,

although, if you want, I'll show you a little what it would be like.

You will see that everything will sound to you, because, as we have seen before

all the attributes that a product has,

It will be very easy for you to understand what Google is asking you.

Country of sale and language.

The GTIN, UPC, EAN ... Do you remember we saw it?

Here we would have to add it.

Then the ID, our own, of our company.

The title, the brand, the description, the link,

And all this we've seen before

Then price and availability,

that you already remember that they are also mandatory,

as well as the description,

because, as you can see, we have already created it in the other configuration,

therefore, we don't have to add it here.

All the attributes that we see here are the mandatory ones

and we are interested in putting as much information as the better,

therefore, we will do it the other way,

That is why we prepare the feed for that.

We go back and we are going to upload several products at the same time.

See various methods.

We selected the language, the country we had already identified.

We continue and here we see that we have different options.

First I'm going to put the name of the feed,

and we have several ways to upload the catalog.

Good for Google spreadsheets, which is what you've been creating,

and then there are other options that are more automatic.

To upload it with the module,

if you are interested, you can do it from this option,

which is scheduled feed collection.

If you click to continue, this module will give you a URL.

You have to put the URL here and you have it.

However, we have created a Google spreadsheet.

Therefore, we select this option.

We give it to Continue, and here it will ask us to log in,

because our spreadsheet is inside Google.

We put our email and password again.

In this case, two options appear:

generate a template with Google spreadsheets

or with Google Spreadsheet,

or select a spreadsheet that we already have made.

As we have already created it previously in another video,

what we have to do is select the one we already have.

Perfect. Now we are going to create an upload schedule.

This means that every time we do

some modification of the feed, for example,

some product that has changed from stock,

that I had before and now I don't, or one that I didn't have and has come back,

a price change ...

Anything we can touch

within the spreadsheet or Google spreadsheet

we can get it back.

Then the feed will be retrieved. In this case, I will put it daily,

and I want him to recover at 05:00.

That is, if I make a change at 05:30 in the feed,

until 05:00 the next day you will not get that change back.

It is important that, if you make a lot of changes,

you can recover it daily.

If not, it can be weekly or monthly.

Monthly I do not recommend it very much because it is every so often

and there may be many changes in your products.

If you sell a lot and you run out of stock

it is important that you keep it updated.

So it is better for you to put it daily

and get it back in an hour

in which you do not have a lot of traffic on the web.

05:00 or 06:00 are good hours.

Once the feed uploaded,

you see we have here the name of the feed, SantaFixie,

shipping method is spreadsheets.

Even if we open it, we can access our Excel.

When was the last time you got on it, etc.

The most interesting thing here is to go to the diagnostic tab

and to be able to see all the errors that we could have.

For example, if we have not entered the correct EAN

or we are missing some URL, some image is too small,

then we can make modifications.

I'm going to show you some diagnostic example

so you can identify it.

The good thing to have seen in previous lessons

all attributes is

that, when you go here to the Diagnosis tab,

you will be able to understand perfectly

what are your missing attributes

and what are the wrong ones.

If not, it is very difficult.

For example, as you can see, I have gone to another account with another feed,

which has some rejected items.

If you see the upper stoplight of this graph,

we see the colors of active items,

those that are about to expire,

those that are pending because we just uploaded them

or the rejected items.

Here 32% of the articles that we have uploaded within the feed,

they are rejected for some reason.

Let's see what they are.

For example, we see that the GTIN is not correct.

There are several items, and we can see how many there are,

that do not have a correct GTIN.

Some don't have the availability attribute set right.

Let's see examples.

We enter into any of the products

that is wrongly available,

and we search why.

Attributes rejected.

Here we see that availability sets zero.

If you remember, when we saw the attributes

on the official Google page,

we see that the format of this attribute

It has to be in_stock, out_of_stock, preorder or backorder.

In this case what comes? A zero. Therefore, it is wrong.

Here we would have to put out_of_stock, if it does not have stock.

And so we could go analyzing

different product diagnostics,

until leaving the feed with as many active articles as possible.

The more rejected items we have,

of worse quality will be the feed,

so the performance of the campaigns

it can affect you too.

We will try to ensure that the feed always has all the articles in green.

Now that we configure the catalog in Google Merchant Center

and we have linked with Google Ads,

In the next lesson we will see how to create a campaign on Google.