WEBVTT
X-TIMESTAMP-MAP=MPEGTS:132000,LOCAL:00:00:00.000

1
00:00:00.800 --> 00:00:03.800
Now let's move on
From our dashboard, it's mine

2
00:00:03.800 --> 00:00:06.800
love? Connect spreadsheet to
it And pull All Those

3
00:00:06.800 --> 00:00:10.500
doctors for our
dashboard. We are using

4
00:00:10.500 --> 00:00:13.600
here. The cat changed
Of name by what

5
00:00:13.600 --> 00:00:17.400
I saw it's Lux Túlio
okay For you

6
00:00:17.400 --> 00:00:18.900
take a look, the
What is a city

7
00:00:18.900 --> 00:00:22.700
Fruit can put in
Google the first ones here

8
00:00:22.700 --> 00:00:27.800
Results here basically that's it
From here oh, it allows

9
00:00:27.800 --> 00:00:30.000
You create this deck
Board you don't need

10
00:00:30.000 --> 00:00:32.800
It's free, okay? It's
just that you have

11
00:00:32.800 --> 00:00:34.800
What to have a source
of Data where do you

12
00:00:34.800 --> 00:00:37.900
Go get this data to
record The Handsome One,

13
00:00:37.900 --> 00:00:40.600
right? And our
source Of data in

14
00:00:40.600 --> 00:00:43.900
The moment is the
spreadsheet, right? Did we see

15
00:00:43.900 --> 00:00:46.800
This is where it changed
Give a name to you

16
00:00:46.800 --> 00:00:51.200
This is Lucas tum
Dot Google.com it

17
00:00:51.200 --> 00:00:54.800
You're going to show up here
okay? I had already caught it

18
00:00:54.800 --> 00:00:58.200
Here is the dashboard,
but Not here for you

19
00:00:58.200 --> 00:01:00.000
They will show up at
first thing you.

20
00:00:59.900 --> 00:01:04.900
Make the spreadsheet connected first
From taking the dashboard to

21
00:01:04.900 --> 00:01:07.300
Guys are going in here
In the studio, okay? Vem

22
00:01:07.300 --> 00:01:10.800
This is data source,
right? What is our source

23
00:01:10.800 --> 00:01:14.800
of data in Portuguese,
Let's create a new one

24
00:01:14.800 --> 00:01:18.900
What year data source,
I don't have anything here

25
00:01:18.900 --> 00:01:21.800
He will ask for them
Simple registration things

26
00:01:21.800 --> 00:01:32.400
And who leaves Brazil
Brazil this is Marconi's name

27
00:01:32.400 --> 00:01:38.200
of the company accepts and It's
still good. I don't want to

28
00:01:38.200 --> 00:01:44.900
Get nothing good, all
right Here we have

29
00:01:44.900 --> 00:01:47.200
Data bridge numbers
That we can

30
00:01:47.200 --> 00:01:51.000
Take it from Dado Zé
Google is Google Analytics

31
00:01:51.000 --> 00:01:57.800
there's a plethora of things
here, Oh. Then get a doctor.

32
00:01:57.800 --> 00:01:59.600
from Facebook, right?
hath some others.

33
00:01:59.900 --> 00:02:03.800
The game is paid is it
in The case here we are

34
00:02:03.800 --> 00:02:05.900
Are you going to use the
chip here What are the spreadsheets

35
00:02:05.900 --> 00:02:09.500
just click here, Can
you give it a name

36
00:02:09.500 --> 00:02:18.700
this is Supermed on
Facebook, beauty? Then we

37
00:02:18.700 --> 00:02:22.100
Will you authorize or
ours Studio look. Our date

38
00:02:22.100 --> 00:02:27.000
Studio Connecting this Spreadsheet
is just a click away

39
00:02:27.000 --> 00:02:29.500
Authorize here it will
Ask us to do it

40
00:02:29.500 --> 00:02:33.000
The login, choose the
our account. Remembering that

41
00:02:33.000 --> 00:02:36.800
The account that has
Access this spreadsheet here

42
00:02:36.800 --> 00:02:38.700
It looks like several planets
that I already have it on

43
00:02:38.700 --> 00:02:41.300
My account and me I
have my spreadsheet

44
00:02:41.300 --> 00:02:43.500
Here oh, she was All
the data that

45
00:02:43.500 --> 00:02:46.800
I was filling out in class
It's past, okay? Everything is fine

46
00:02:46.800 --> 00:02:50.400
This is where this
dashboard spreadsheet. Then I'll go

47
00:02:50.400 --> 00:02:54.500
Choose it here here
Go ask. What are the

48
00:02:54.500 --> 00:02:56.100
Abbas Ali Que Nous
So do you want

49
00:02:56.100 --> 00:02:59.300
Do we have videos
with Fish advertisement we can

50
00:02:59.300 --> 00:02:59.800
work.

51
00:02:59.900 --> 00:03:03.400
Separately, okay So I'm
going to start here how

52
00:03:03.400 --> 00:03:08.500
The leader is already
there Here put here there

53
00:03:08.500 --> 00:03:14.600
I will connect the
connector Here, okay? And he

54
00:03:14.600 --> 00:03:18.400
I brought all the
Columns are

55
00:03:18.400 --> 00:03:22.400
The name of the columns
Beautiful ad campaign like this

56
00:03:22.400 --> 00:03:26.000
It's here it's in the
case Here in the announcement,

57
00:03:26.000 --> 00:03:30.100
right? What print campaign
cancer he caught here,

58
00:03:30.100 --> 00:03:33.000
right? Because the
We caught him

59
00:03:33.000 --> 00:03:37.700
Say right? I'm floating
Here is the announcement and

60
00:03:37.700 --> 00:03:40.600
Ad title everything
Here and here he

61
00:03:40.600 --> 00:03:42.800
The type of Field
that is

62
00:03:42.800 --> 00:03:45.900
your text type, if How
did you get it here

63
00:03:45.900 --> 00:03:47.900
A date is the type
of Milk that

64
00:03:47.900 --> 00:03:51.300
It's important to us To
be able to move there in

65
00:03:51.300 --> 00:03:55.300
south-east. I'll board us
The telephone is needed

66
00:03:55.300 --> 00:03:58.400
Here you got it
right And this

67
00:03:59.800 --> 00:04:03.200
The number of lines
What do we have there

68
00:04:03.200 --> 00:04:06.500
There are so many
records, Just explaining more

69
00:04:06.500 --> 00:04:08.900
Or less like how
What does this look work

70
00:04:08.900 --> 00:04:12.600
I study here, okay? TO We
have already created it. I'm going

71
00:04:12.600 --> 00:04:14.700
Stay here on the
icon Zinho to return everything

72
00:04:14.700 --> 00:04:18.500
What do we already
have Facebook metrics leader,

73
00:04:18.500 --> 00:04:24.800
I'm going to quickly do
the second here. I clicked there

74
00:04:24.800 --> 00:04:28.400
select here from this board,
I'm going to make fish rolls

75
00:04:28.400 --> 00:04:36.600
Same thing with tile
Doctors Facebook will do it

76
00:04:36.600 --> 00:04:44.600
This connects for everyone
Here, okay? Look brought it

77
00:04:44.600 --> 00:04:48.500
All fields too Same
thing, but

78
00:04:48.500 --> 00:04:52.400
He's about to come back
I'm going Do them all here.

79
00:04:59.800 --> 00:05:18.100
Beauty. This is the The last
one is so I clicked here

80
00:05:18.100 --> 00:05:21.400
I already have the
five Meters from here to

81
00:05:21.400 --> 00:05:23.700
5 Tabs from mine
spreadsheet, right? If

82
00:05:23.700 --> 00:05:27.300
Deal with separate doctors
Okay, now that the

83
00:05:27.300 --> 00:05:29.100
We already have everything That's
it from here we go

84
00:05:29.100 --> 00:05:32.000
Will open ours Dashboard
tocomlink from him here

85
00:05:32.000 --> 00:05:33.900
Some people already have
to Duplicate it, right?

86
00:05:33.900 --> 00:05:38.000
Click here it will
Open at this time

87
00:05:38.000 --> 00:05:40.200
We can't do it use,
right? What is

88
00:05:40.200 --> 00:05:43.200
Just as if it were a
template, right? Then

89
00:05:43.200 --> 00:05:44.400
You already see that
There's already one here

90
00:05:44.400 --> 00:05:46.900
So there is the logo
of company, right? you

91
00:05:46.900 --> 00:05:49.800
Can you change colors
also. If you want

92
00:05:49.800 --> 00:05:52.900
type everything. You can do
it Here it is in English

93
00:05:52.900 --> 00:05:55.300
That my computer lives
In English, right? Then

94
00:05:55.300 --> 00:05:59.400
But it has all the
doctors here basically.

95
00:05:59.800 --> 00:06:02.800
Here it is connected with
Another spreadsheet, okay? To us

96
00:06:02.800 --> 00:06:08.700
It will stay here it
is one Copy and now

97
00:06:08.700 --> 00:06:11.200
It's here oh, conversions. So
let's fill it all in

98
00:06:11.200 --> 00:06:18.300
he says he already
knows. What are the sources

99
00:06:18.300 --> 00:06:20.100
of data and I used
And he's asking

100
00:06:20.100 --> 00:06:21.900
Which one will I go
Use right? Like me

101
00:06:21.900 --> 00:06:30.000
I'm getting a copy
De ovinho fanpage se

102
00:06:30.000 --> 00:06:35.200
Was a friend of mine
missing other ads, right? What

103
00:06:35.200 --> 00:06:43.900
He has no one here
Adjust ads here to

104
00:06:43.900 --> 00:06:47.500
Try to identify any
one there just click here

105
00:06:47.500 --> 00:06:51.300
In a report, he will
Take a copy there

106
00:06:51.300 --> 00:06:57.700
to our account of
studio. We can

107
00:06:57.700 --> 00:06:59.700
Give a change the
name here.

108
00:06:59.700 --> 00:07:03.500
Actually it is I'm going
to click on the visualization

109
00:07:03.500 --> 00:07:06.400
In edit do you want
It's already ours

110
00:07:06.400 --> 00:07:11.300
I know that I can
Close here fine.

111
00:07:11.300 --> 00:07:14.600
There's not much here
Something for us to move

112
00:07:14.600 --> 00:07:17.100
here, actually. TO We
are going to change the

113
00:07:17.100 --> 00:07:22.400
Name, right? I will leave
That's how to put Facebook

114
00:07:22.400 --> 00:07:27.100
This is just for us
It's here. Did you pull

115
00:07:27.100 --> 00:07:30.800
The doctors who are
There in ours ours

116
00:07:30.800 --> 00:07:33.400
Spreadsheet, that's all
I am everything from

117
00:07:33.400 --> 00:07:39.400
There then here it
is Two leaders of which

118
00:07:39.400 --> 00:07:40.600
What is the date
that he It's pulling

119
00:07:40.600 --> 00:07:44.700
This is where we You
can choose here if

120
00:07:44.700 --> 00:07:48.600
We want this one
Year it falls it will

121
00:07:48.600 --> 00:07:51.300
update for this year. Then
This year there are 89

122
00:07:51.300 --> 00:07:54.200
books, right? I will
Pull just for today

123
00:07:54.200 --> 00:07:59.300
Or from yesterday
more Easy how Zinho

124
00:07:59.300 --> 00:07:59.700
2.

125
00:07:59.700 --> 00:08:05.200
It is in March at Moment
of the video put on day

126
00:08:05.200 --> 00:08:08.400
29, just for us See
the cars

127
00:08:08.400 --> 00:08:14.700
Everything is beating on
On the 29th, a dispute,

128
00:08:14.700 --> 00:08:20.000
Let's confirm that only
That's right on the 29th

129
00:08:20.300 --> 00:08:24.200
There's a limit, right?
Here you will have

130
00:08:24.200 --> 00:08:28.200
a repeated one, right?
Mas It's already beating and

131
00:08:28.200 --> 00:08:33.900
Announcement on the 29th From
this one here, leave me

132
00:08:33.900 --> 00:08:38.300
See here on the 29th
there was Several announcements day

133
00:08:38.300 --> 00:08:43.500
29 which is the
three Latest investments here

134
00:08:43.500 --> 00:08:49.900
Hossomaki 119 Conversita Banging
119. So everything is fine

135
00:08:49.900 --> 00:08:54.500
Everything connected, right some Songs
from that one there are

136
00:08:54.500 --> 00:08:59.400
More generic Aparecida das
people. Okay but him

137
00:08:59.400 --> 00:08:59.600
already

138
00:08:59.700 --> 00:09:04.800
Conversions everything amount of conversions
that occurred on the 29,

139
00:09:05.100 --> 00:09:07.500
I'm going to leave it
here Of the year to stay

140
00:09:07.500 --> 00:09:14.800
Easier for us See
beauty and what

141
00:09:14.800 --> 00:09:16.700
Kill us do we have
Here in the north those

142
00:09:16.700 --> 00:09:19.600
that has already connected to
spreadsheet now. Let's go to

143
00:09:19.600 --> 00:09:23.400
personalization part. What
That you can exchange

144
00:09:23.400 --> 00:09:25.500
Here where is the
free The spreadsheet is ready

145
00:09:25.500 --> 00:09:28.500
Let me close this
Here you will use more

146
00:09:28.500 --> 00:09:32.800
What can we
customize here. hereto

147
00:09:32.800 --> 00:09:34.700
There is no button for
Save is it up to us

148
00:09:34.700 --> 00:09:37.700
Move something a little What
does it already save automatically

149
00:09:37.700 --> 00:09:40.400
It's here you can
Put on the logo of

150
00:09:40.400 --> 00:09:42.800
your customer or your
Really a wolf, right? you

151
00:09:42.800 --> 00:09:47.400
Do you want to use just
select It will always appear here

152
00:09:47.400 --> 00:09:50.600
Here on the side,
okay So if I want

153
00:09:50.600 --> 00:09:53.900
Change this image only
click here and select

154
00:09:53.900 --> 00:09:57.200
One on my computer
OK? Or if it has

155
00:09:57.200 --> 00:09:59.300
A link in the image
to people.

156
00:09:59.700 --> 00:10:04.200
Then change the image well
Don't worry, just select change. If

157
00:10:04.200 --> 00:10:06.700
do you want to add
new images Here, we have

158
00:10:06.700 --> 00:10:08.800
the image only
option So we

159
00:10:08.800 --> 00:10:12.700
Can you upload another image
of the computer, if the

160
00:10:12.700 --> 00:10:15.500
Do we want to change
them Color the titles here,

161
00:10:15.500 --> 00:10:19.300
Imagine that I didn't I
want to say no to her.

162
00:10:19.300 --> 00:10:21.900
I want you to show up
there. Say here that I know

163
00:10:21.900 --> 00:10:25.800
There it is playing
a Order, right? Mas

164
00:10:25.800 --> 00:10:29.100
when you select here
You will see that

165
00:10:29.100 --> 00:10:30.900
It will select
everything Once

166
00:10:30.900 --> 00:10:33.400
You don't have the flu
here, You're going to have to

167
00:10:33.400 --> 00:10:36.800
Click again ready Then
he selected only the

168
00:10:36.800 --> 00:10:40.500
understanding and here the
Can we exchange one

169
00:10:40.500 --> 00:10:43.500
Gymnast who is shopping
that are an e-commerce.

170
00:10:43.500 --> 00:10:47.100
So you want to take
There in the spreadsheet you

171
00:10:47.100 --> 00:10:52.200
From spreadsheet to this
this automation, okay? I

172
00:10:52.200 --> 00:10:54.600
I did the basic part, I
I am not the manager of

173
00:10:54.600 --> 00:10:57.600
Traffic, okay? I got it
there with some managers the

174
00:10:57.600 --> 00:10:59.600
key metrics, who
works.

175
00:10:59.600 --> 00:11:03.900
Men's important piece others Metrics
other conversions to work with

176
00:11:03.900 --> 00:11:08.100
with service it's different,
right? So it's fine

177
00:11:08.100 --> 00:11:11.600
personalised. You guys are going
in Lying about it with dad

178
00:11:11.600 --> 00:11:14.900
In the community with
all world, right? And the

179
00:11:14.900 --> 00:11:17.000
People are leaving this from
here on as complete as possible,

180
00:11:17.000 --> 00:11:19.800
right? So if I
Change here I changed the

181
00:11:19.800 --> 00:11:26.100
Name of purchases
purchases Select us again

182
00:11:26.100 --> 00:11:27.600
See that we can you
change the color,

183
00:11:27.600 --> 00:11:31.300
I don't know, I don't
like it of that color. I

184
00:11:31.300 --> 00:11:38.100
I want to use green
exchange Is the size here? hath

185
00:11:38.100 --> 00:11:42.000
Everything here here then
In this case it's just

186
00:11:42.000 --> 00:11:44.700
a text, right? Just
one Read Bauzinho that

187
00:11:44.700 --> 00:11:49.600
Call and here yes
Down it here America

188
00:11:49.600 --> 00:11:52.100
How does it work If
you select any

189
00:11:52.100 --> 00:11:55.700
Doctor who sells something
Spreadsheet in the data by

190
00:11:55.700 --> 00:11:59.300
It works like this,
if You select it will

191
00:11:59.300 --> 00:11:59.600
ask.

192
00:11:59.600 --> 00:12:03.200
Data source folks You can
exchange them here at all

193
00:12:03.200 --> 00:12:06.200
the data sources
What did we choose

194
00:12:06.200 --> 00:12:08.000
There then there I didn't
I want you to show up

195
00:12:08.000 --> 00:12:12.000
Here doctors than
He's rich, I want

196
00:12:12.000 --> 00:12:16.400
What do you get from
the advertisement Then choose advertisement, it

197
00:12:16.400 --> 00:12:18.800
Will bring them all
advertisement fields here

198
00:12:18.800 --> 00:12:23.400
All those columns are fine
From the back here and

199
00:12:23.400 --> 00:12:26.800
Already filtered by date
It's up to us

200
00:12:26.800 --> 00:12:31.600
Pick it up at halftime
From here and here there are

201
00:12:31.600 --> 00:12:33.900
All the fields there
That we can

202
00:12:33.900 --> 00:12:37.500
use. So I don't know
what Engagement here was

203
00:12:37.500 --> 00:12:41.200
o the amount of
Doctors that I want

204
00:12:41.200 --> 00:12:45.100
He's going to drink
this Time interval a

205
00:12:45.100 --> 00:12:47.500
amount of engagement that
Teve will bring it here

206
00:12:47.500 --> 00:12:51.400
OK? This tank is
just Kill then, him

207
00:12:51.400 --> 00:12:54.100
It all added up here
by 2 From 23 and

208
00:12:54.100 --> 00:12:57.800
Brought it here for
us If we need it

209
00:12:57.800 --> 00:12:59.600
Change the type that

210
00:12:59.600 --> 00:13:03.300
Just click here the
Can we put how

211
00:13:03.300 --> 00:13:07.700
currency here too. Deixa
I'll get Brazil here

212
00:13:07.700 --> 00:13:19.200
What is R$ 1 in
Brazil, Brazil, ok

213
00:13:19.200 --> 00:13:21.000
Imagine that from here
it was a metric that

214
00:13:21.000 --> 00:13:24.400
We picked it up
Reais and so on

215
00:13:24.400 --> 00:13:28.100
Can we type this one
Is the whole spreadsheet okay? hereto

216
00:13:28.100 --> 00:13:30.300
Everything is a field
that Can we change

217
00:13:30.300 --> 00:13:36.000
This information is also there
here on the table. wanna

218
00:13:36.000 --> 00:13:38.300
a conversion table I
want a campaign of

219
00:13:38.300 --> 00:13:41.600
ad just edit here,
Okay it's okay

220
00:13:41.600 --> 00:13:44.500
Really force it, okay? Nope
I am no Expert unit

221
00:13:44.500 --> 00:13:46.500
Studio, but I went It
works and I did this

222
00:13:46.500 --> 00:13:49.700
Try Word, okay me I
played Altinho the

223
00:13:49.700 --> 00:13:53.400
Others, I found a little
Outdated and it looks good

224
00:13:53.400 --> 00:13:57.400
customized for your customer.
If you want it has

225
00:13:57.400 --> 00:13:59.400
Three pages late are
ready now.

226
00:13:59.500 --> 00:14:03.100
These are the doctors
There are general announcements, right?

227
00:14:03.100 --> 00:14:06.800
You stop by him Go
to page 2.

228
00:14:06.800 --> 00:14:10.100
What do we have that
spreadsheet of his,

229
00:14:10.100 --> 00:14:12.800
Right they are the
Facebook registrations that

230
00:14:12.800 --> 00:14:15.600
I registered here He
brings it here too.

231
00:14:15.600 --> 00:14:22.300
Everything is fine. you
Can you also type and

232
00:14:22.300 --> 00:14:25.500
Here is the last one
that the general metrics of

233
00:14:25.500 --> 00:14:29.600
page, right? What audience how
many followers. How many likes

234
00:14:29.600 --> 00:14:32.900
Do you think it is
what it was The audience, right?

235
00:14:32.900 --> 00:14:37.000
And I didn't even
say it That already saves

236
00:14:37.000 --> 00:14:40.100
Automatically you just have to click
Here I have seen it already

237
00:14:40.100 --> 00:14:43.400
Can you see how Your
client I eat

238
00:14:43.400 --> 00:14:45.600
You went to send it to
Is anyone here? So I have

239
00:14:45.600 --> 00:14:50.200
That you can call Up
here there is

240
00:14:50.200 --> 00:14:53.300
Quietly view all
Doctors, so filter here

241
00:14:53.300 --> 00:14:57.800
If necessary, I want
See her until

242
00:14:57.800 --> 00:14:59.200
the 15th of March.

243
00:14:59.500 --> 00:15:04.100
It updates everything everything
Automatic in real time, okay

244
00:15:04.100 --> 00:15:09.100
Very practical it is
in Next classes, I'm going

245
00:15:09.100 --> 00:15:10.700
Give an idea of How
can you put

246
00:15:10.700 --> 00:15:12.600
Is it inside yours
okay? But here it is

247
00:15:12.600 --> 00:15:15.300
Free mind for you
Use for you to send

248
00:15:15.300 --> 00:15:17.500
for your customer. You
who are a manager

249
00:15:17.500 --> 00:15:19.300
Of frogs, there are
several Customers just click

250
00:15:19.300 --> 00:15:22.900
Here to share, right?
The tea you can

251
00:15:22.900 --> 00:15:26.100
Give your Gmail His,
okay? AND

252
00:15:26.100 --> 00:15:29.200
Only he will have
this one Access okay? Or

253
00:15:29.200 --> 00:15:32.000
You can leave it
free here in public. Só

254
00:15:32.000 --> 00:15:33.600
That everyone will
go see his music,

255
00:15:33.600 --> 00:15:37.200
right? How do you have
information Of people it's not

256
00:15:37.200 --> 00:15:39.700
cool. If I do That
and it also has

257
00:15:39.700 --> 00:15:41.400
a link here, if Do
you want to send it directly

258
00:15:41.400 --> 00:15:43.600
for him. And then
you You can stay here

259
00:15:43.600 --> 00:15:45.900
Then you send this
one link to it,

260
00:15:45.900 --> 00:15:48.800
Does he have access
to 10 Colors, if he

261
00:15:48.800 --> 00:15:51.100
Do you want to see the
songs From yesterday of the month

262
00:15:51.100 --> 00:15:56.200
Compare everything he can
using this dashboard. Espero

263
00:15:56.200 --> 00:15:57.700
That they liked the
Class and even