Google Ads Optimization Tricks: How to Consolidate ALL Your Shopping Ads Data

Regina: 00:00:11

Hi everyone, Regina here with Starter PPC.

2

: 00:00:13

I'm going to quickly show you how you can

see the data from all of your shopping

3

: 00:00:18

ads all in one place and add them all

up and get some totals, some averages,

4

: 00:00:25

because I know that this is the most

important data and Google just doesn't

5

: 00:00:29

quite provide it to us in a clear way.

6

: 00:00:31

And summarized way.

7

: 00:00:33

So I'm going to show you how

it's pretty easy to get it.

8

: 00:00:35

It just takes a few extra steps.

9

: 00:00:37

This is an account that sells, high

end furniture, and we're spending

10

: 00:00:40

most of the money on shopping ads.

11

: 00:00:43

And I'm going to show you how I've even

found that, that information, because even

12

: 00:00:47

though we're running, some PMAX campaigns,

some standard shopping campaigns, some

13

: 00:00:51

dynamic display remarketing campaigns.

14

: 00:00:54

It doesn't quite show me how much

money is being spent on what network.

15

: 00:00:58

And what I want to know is, are we

spending the majority of the money

16

: 00:01:01

on shopping ads and marketing?

17

: 00:01:02

Because we have high end products with

very small budgets and we want to make

18

: 00:01:06

sure we're, putting most of it on the

shopping network because the shopping

19

: 00:01:09

network is very bottom of funnel and

bottom of funnel is the place to start.

20

: 00:01:13

When you're small, guys, you

want to start at the bottom and

21

: 00:01:16

move up to the top of the funnel.

22

: 00:01:17

So people that are looking at

shopping ads, those are the people

23

: 00:01:20

that are looking at products.

24

: 00:01:22

They have their wallet in their

hand, and they're the most ready

25

: 00:01:24

to buy compared to people that are

looking for example, video ads.

26

: 00:01:29

Outbound video, people

that are totally cold.

27

: 00:01:32

and you just want to warm them up to the

brand that would be very top of funnel or

28

: 00:01:36

people that are looking for, in this case,

there's no how to type searches for high

29

: 00:01:41

end furniture, maybe people who are like

how to make your own high end furniture.

30

: 00:01:45

But even then they wouldn't

really be a good market.

31

: 00:01:47

These are very expensive products.

32

: 00:01:50

the first thing you're going to want to

do is pull up your time window, of course.

33

: 00:01:54

and then make sure your campaign

status is all, you just want

34

: 00:01:57

to see all the campaigns that

spent money in that time window.

35

: 00:02:01

And you want to make sure you don't

have any other filters pulled up.

36

: 00:02:03

And I'm a total hypocrite because

I have one pulled up right now.

37

: 00:02:06

and then what you're going to want

to do is click over to products.

38

: 00:02:08

Very important.

39

: 00:02:09

Make sure you clicked over

to products from the all

40

: 00:02:11

campaigns view with no filters.

41

: 00:02:13

If you have filters filled up,

your products view is going to

42

: 00:02:16

be filtered by those filters.

43

: 00:02:18

and if you clicked on a campaign

before going over to products, you're

44

: 00:02:22

only seeing data from that campaign.

45

: 00:02:24

make sure, that you understand.

46

: 00:02:26

How Google is going to filter depending

on the order in which you click

47

: 00:02:30

on things inside of the account.

48

: 00:02:32

here we have a list of

all like 700 products.

49

: 00:02:36

and it says these metrics are

calculated from your shopping and

50

: 00:02:38

your performance max campaigns.

51

: 00:02:40

Got it.

52

: 00:02:40

Cause those are the only

campaigns that are actually

53

: 00:02:42

showing, on the shopping network.

54

: 00:02:43

And when Google says products,

it actually means shopping ads.

55

: 00:02:47

if you scroll to the bottom, it

does not total anything for you.

56

: 00:02:51

if you want to know what's the

average cost per click, no idea.

57

: 00:02:54

If you want to know, how much

was spent, in total on these

58

: 00:02:57

products showing shopping ads.

59

: 00:02:59

No idea.

60

: 00:03:00

can't total it here.

61

: 00:03:01

So you have to click download.

62

: 00:03:03

when you click download, it's going to ask

you, what do you want to download it into?

63

: 00:03:06

My preferred favorite is Google Sheets,

but you can download it however you want.

64

: 00:03:11

make sure that when you click on

Google Sheets, you sit and you wait

65

: 00:03:14

for the Google Sheet to be populated

because it's going to show you a little

66

: 00:03:17

pop up at the bottom of the screen.

67

: 00:03:19

Actually, let me do it right now

and show you guys how it works.

68

: 00:03:21

Google Sheets.

69

: 00:03:22

Hi there.

70

: 00:03:23

Quick interruption.

71

: 00:03:24

Do you know the main thing that

prevents small business owners from

72

: 00:03:27

getting their Google ads account into

a position to grow and scale budget?

73

: 00:03:31

A lot of businesses, especially

those that are just starting

74

: 00:03:34

out, have limited budgets.

75

: 00:03:35

And so because of this, they're turned

away by most ad agencies because most ad

76

: 00:03:39

agencies have minimum budget thresholds

that they're willing to work with.

77

: 00:03:42

So what happens is the business owners

end up learning Google ads themselves.

78

: 00:03:45

And the problem with that is

that most of the advice online is

79

: 00:03:49

geared towards larger accounts.

80

: 00:03:50

And the advice doesn't have any of those

strategies or tricks that can kickstart

81

: 00:03:54

the algorithm into giving a small

account a leg up over larger competitors.

82

: 00:03:59

So it often just doesn't work.

83

: 00:04:01

And the business just ends up

losing money month over month.

84

: 00:04:03

If this sounds familiar,

starter PPC can help.

85

: 00:04:06

We offer Google ads management services

that are designed for accounts that

86

: 00:04:09

have between 1000 and 5, 000 budgets.

87

: 00:04:13

Because all of our clients are just

starting out, we've come up with ways to

88

: 00:04:16

keep our management fees significantly

lower than most agencies, because

89

: 00:04:20

we know that every dollar saved on

management fees just goes towards

90

: 00:04:23

the ad budget, which is going to help

the algorithm gather speed and power.

91

: 00:04:27

So if you're serious about growing your

business and you'd like a team of Google

92

: 00:04:29

ads experts to help you without breaking

the bank, check us out at starter PPC.

93

: 00:04:34

com.

94

: 00:04:34

Okay.

95

: 00:04:34

Back to the video, download

and it says preparing report.

96

: 00:04:38

You have to stay here while I was

preparing the report because it's going

97

: 00:04:41

to show you a popup when, the sheet's

going to be ready and then you're going

98

: 00:04:44

to want to click open sheet from here.

99

: 00:04:47

I don't even know if this sheet exists

anywhere, probably does, but it's

100

: 00:04:49

going to be lost somewhere in your.

101

: 00:04:51

In your Google drive.

102

: 00:04:52

All right.

103

: 00:04:52

So you click open sheet.

104

: 00:04:53

It opens in a new window, all of this

data and then you can start to create

105

: 00:04:58

some formulas to see some averages.

106

: 00:05:00

So I've already done this.

107

: 00:05:02

I cleaned it all up, right?

108

: 00:05:03

So I'm going to freeze these top two rows.

109

: 00:05:07

I created this blank row so

that I could start totaling.

110

: 00:05:10

And then I made some formulas like some

equals the summary of all of these.

111

: 00:05:14

That's going to show me how many

impressions did we spend on the shopping

112

: 00:05:18

network so far, or did we show, cost,

this is really what I wanted to get to.

113

: 00:05:22

How much money have we spent on the

total, in totality for shopping ads?

114

: 00:05:27

I summarized this column and that

tells me, okay, out of the total

115

: 00:05:32

that we spent on the account, minus

this amount of money, which we've

116

: 00:05:35

spent on products, meaning shopping

ads, there was only 271 remaining on

117

: 00:05:41

non shopping ads that we've spent.

118

: 00:05:43

So that's actually a good thing.

119

: 00:05:45

This is a great ratio right now,

since we were very limited by budget.

120

: 00:05:48

I want to spend at least 80 percent

of the budget on shopping ads.

121

: 00:05:52

So it's working.

122

: 00:05:53

yeah, I can get an average cost per

click, average click through rate.

123

: 00:05:57

I can, sort by which products

were spent, spent the most, which

124

: 00:06:01

products have really high CPCs.

125

: 00:06:03

And this is a great way

to do some deep diving.

126

: 00:06:05

And then from here, you can go back

into your account and say, okay, I

127

: 00:06:10

think I want to, lean into a certain

type of product because we haven't

128

: 00:06:16

really spent much on that product.

129

: 00:06:17

And I think it's going to work better

than the products that have sold.

130

: 00:06:21

there's various ways to do that.

131

: 00:06:22

And we'll have to save that video for

another day, you might want to readjust

132

: 00:06:25

the budgets and lean into certain

categories of products, so that you can.

133

: 00:06:31

Manipulate, which products are showing

and, make the products that Google's

134

: 00:06:36

just wasting money on show less.

135

: 00:06:38

All right.

136

: 00:06:38

So I hope this has been a quick

and helpful video to see your

137

: 00:06:42

total shopping network data.

138

: 00:06:45

Thanks for watching.