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

1
00:00:01.000 --> 00:00:03.300
Cool, now let's go
For our Lord you

2
00:00:03.300 --> 00:00:05.600
We're not going to take
the spreadsheet, let's get the

3
00:00:05.600 --> 00:00:08.000
Next step is already
finished that part of Facebook,

4
00:00:08.000 --> 00:00:11.500
Right here in ours
Check list here we

5
00:00:11.500 --> 00:00:14.100
The same thing that We
are going to do it

6
00:00:14.100 --> 00:00:16.400
get the finished spreadsheet,
right? Where will it be

7
00:00:16.400 --> 00:00:20.100
Stored all of these
metrics just click here, the

8
00:00:20.100 --> 00:00:24.900
Do we have access to
Spreadsheet OK she made

9
00:00:24.900 --> 00:00:26.600
If I didn't have it
you can Delete the data that

10
00:00:26.600 --> 00:00:29.400
It has but it doesn't change
And don't turn it off now

11
00:00:29.400 --> 00:00:34.800
The columns, okay? because
It's already scheduled here

12
00:00:34.800 --> 00:00:38.400
to be in those columns.
Then I'll show you how

13
00:00:38.400 --> 00:00:41.800
You can also create
columns with custom metrics

14
00:00:41.800 --> 00:00:44.700
Are you too? Then
the We have here the

15
00:00:44.700 --> 00:00:46.700
Their column, right? Saint
The evils that come

16
00:00:46.700 --> 00:00:51.200
On the side form we
have Doctors from Fanpage, right

17
00:00:51.200 --> 00:00:55.100
from the Facebook page
Followers like and close

18
00:00:55.100 --> 00:00:59.900
Here on the page too
of followers and likes.

19
00:00:59.900 --> 00:01:03.700
Who is a man and At
what age is everything

20
00:01:03.700 --> 00:01:07.200
Here too, are all
The metrics the question

21
00:01:07.200 --> 00:01:11.600
From the announcement show to
take This thing here question

22
00:01:11.600 --> 00:01:15.100
From then on is there a
date What advertisement. What is the

23
00:01:15.100 --> 00:01:18.300
set of ads? hath
Everything is here too

24
00:01:18.300 --> 00:01:21.600
and also the part of
Video listened to and

25
00:01:21.600 --> 00:01:25.900
conversion too, okay? TO
We will fill in

26
00:01:25.900 --> 00:01:28.900
All of this from here
with metrics and but first

27
00:01:28.900 --> 00:01:31.000
We are going to double
Is this spreadsheet okay? You

28
00:01:31.000 --> 00:01:33.200
You won't have access
to move it. Then

29
00:01:33.200 --> 00:01:35.900
Do you guys go here
at Which failed ISO files

30
00:01:35.900 --> 00:01:39.000
Portuguese and make a
Copy or make one

31
00:01:39.000 --> 00:01:43.000
Copy in Portuguese and
Click here, let me

32
00:01:43.000 --> 00:01:47.300
Click here put the
Name there of yours

33
00:01:47.300 --> 00:01:52.400
spreadsheet, Bangladesh spreadsheet, a
Something like that select

34
00:01:52.400 --> 00:01:54.600
Folder inside your
Google Drive for you

35
00:01:54.600 --> 00:01:57.600
Go copy she's okay
click here on

36
00:01:57.600 --> 00:01:58.300
make a copy.

37
00:01:59.900 --> 00:02:03.400
To load Remembering that
you have to check if

38
00:02:03.400 --> 00:02:07.100
Are you connected now
or n 8 n

39
00:02:07.100 --> 00:02:10.200
with your spreadsheets. Tá
I'm going to use that

40
00:02:10.200 --> 00:02:14.500
Right there, then I'll go
Test it now if I

41
00:02:14.500 --> 00:02:16.500
I have a connection with her
I'm going to take the day

42
00:02:16.500 --> 00:02:19.800
Here, okay? If you
No it didn't mess with

43
00:02:19.800 --> 00:02:22.400
The spreadsheet still makes
the Alignment classes there

44
00:02:22.400 --> 00:02:27.000
creating from Google,
how Create and save

45
00:02:27.000 --> 00:02:29.900
Data in a spreadsheet,
okay? Because here it goes

46
00:02:29.900 --> 00:02:31.400
To be all kind of
Okay, but already

47
00:02:31.400 --> 00:02:33.600
It must have done
those credentials on Google.

48
00:02:33.600 --> 00:02:37.000
I'll come back here on
8 Year will I go

49
00:02:37.000 --> 00:02:42.000
Add the module of
Google sheets or not,

50
00:02:42.000 --> 00:02:47.400
right? What to do
the Read grandpa select, mine

51
00:02:47.400 --> 00:02:50.500
Cadence here. Leave me
See if it's already there

52
00:02:50.500 --> 00:02:53.200
Put on Pelo Ai Dia
Here which is more

53
00:02:53.200 --> 00:02:58.400
Quickly and I'll read
it. So it seems that

54
00:02:58.400 --> 00:02:59.700
It's okay now
recovering.

55
00:02:59.900 --> 00:03:08.100
Put something here Test it
in English and I'll go

56
00:03:08.100 --> 00:03:11.400
Ask him to read This
spreadsheet, let's see

57
00:03:11.400 --> 00:03:15.200
If he has it he me I
brought the line here

58
00:03:15.200 --> 00:03:20.500
From the test so ok
now Are you connected with

59
00:03:20.500 --> 00:03:22.100
him. Let me see
Where does she

60
00:03:22.100 --> 00:03:28.600
It was taken here
paid Here, okay? Duplicate spreadsheet.

61
00:03:28.600 --> 00:03:30.500
Let's go to ours
Step by step now

62
00:03:30.500 --> 00:03:34.300
Let's create the credentials
All those tokens that

63
00:03:34.300 --> 00:03:36.800
We took the Let's go
here okay

64
00:03:36.800 --> 00:03:40.200
So I think that We
have Froakie

65
00:03:40.200 --> 00:03:42.600
to welcome leaders
Facebook form

66
00:03:42.600 --> 00:03:46.200
What are we going to
use The token, DF

67
00:03:46.200 --> 00:03:49.400
If I'm not mistaken
Token diet for

68
00:03:49.400 --> 00:03:52.300
Get a doctor from
advertisement video, see? Conversion to

69
00:03:52.300 --> 00:03:54.900
We are going to use
user token and

70
00:03:54.900 --> 00:03:57.700
Here on pages a We
are going to use

71
00:03:57.700 --> 00:03:59.100
Page token, okay?

72
00:03:59.800 --> 00:04:04.700
Let me open this one From
here on 113 in it here

73
00:04:04.700 --> 00:04:08.300
Just for us to open
I'm going to block him

74
00:04:08.300 --> 00:04:11.400
A new credential, now
I will open it here

75
00:04:11.400 --> 00:04:18.200
I'm going to put the
name from our ep. AND

76
00:04:18.200 --> 00:04:20.900
This one here will
be the Toquinho DF Bom

77
00:04:20.900 --> 00:04:26.800
You put it because I
will Pull here too. Nossa

78
00:04:26.800 --> 00:04:30.600
Paste it here, he is Asking
for UFC at the bottom, Curitiba,

79
00:04:30.600 --> 00:04:32.800
Have we already
saved here, right? What

80
00:04:32.800 --> 00:04:37.800
At the beginning the
key secret of the application.

81
00:04:37.800 --> 00:04:41.500
I'll paste it here
and We also have

82
00:04:41.500 --> 00:04:43.600
an app token Here we
are

83
00:04:43.600 --> 00:04:47.400
Do you want an otorrino DF necklace
What are we going to see if

84
00:04:47.400 --> 00:04:52.800
Is it okay beauty?
Esse Tea is already created

85
00:04:52.800 --> 00:04:56.000
Or created, leave me
Open here that I

86
00:04:56.000 --> 00:04:58.800
I already wanted to
give one Play here.

87
00:04:59.800 --> 00:05:05.100
Here I will create
Another new car here here

88
00:05:05.100 --> 00:05:07.700
It will be the token
of user, which user

89
00:05:07.700 --> 00:05:14.800
That's it, isn't it? hereto
Same thing to put that

90
00:05:14.800 --> 00:05:18.200
The name of F right
at The Board

91
00:05:18.200 --> 00:05:25.200
Or with a day The
user saved it's done

92
00:05:25.200 --> 00:05:29.300
Okay all right, I'll
go Close right here, now

93
00:05:29.300 --> 00:05:32.000
I will also create
Token uncle who is it

94
00:05:32.000 --> 00:05:37.800
Down there, right? Já
Stay safe here. hereto

95
00:05:37.800 --> 00:05:39.300
Do you see that we
You can select the

96
00:05:39.300 --> 00:05:42.300
user token, only
What for these metrics

97
00:05:42.300 --> 00:05:44.900
From the page it will
Ask for the ringtone go

98
00:05:44.900 --> 00:05:47.600
End up giving it will go
It's going to make a mistake

99
00:05:47.600 --> 00:05:50.000
And say what he
wants The token of

100
00:05:50.000 --> 00:05:52.200
page, right? Then the
We are going to create

101
00:05:52.200 --> 00:05:59.700
Also same thing mesh
Board or who gives?

102
00:05:59.800 --> 00:06:04.600
Page And then I'll
leave it Copy what day

103
00:06:04.600 --> 00:06:08.200
I just put the Token
preview that

104
00:06:08.200 --> 00:06:13.400
It's beautiful, so we
have All token tokens

105
00:06:13.400 --> 00:06:15.700
From rap page of
Users are already

106
00:06:15.700 --> 00:06:19.100
Connected here is more
a little thing. To us

107
00:06:19.100 --> 00:06:24.300
I have one here
Settings are not here

108
00:06:24.300 --> 00:06:27.400
Also that's not Will
you use more so

109
00:06:27.400 --> 00:06:29.200
Child with R$ 200
and You have to help

110
00:06:29.200 --> 00:06:31.800
The data, right night
So you don't have

111
00:06:31.800 --> 00:06:35.700
What to keep swapping
in all spreadsheets. Aida

112
00:06:35.700 --> 00:06:40.900
Spreadsheet also counts
from Announcements Things Me

113
00:06:40.900 --> 00:06:44.100
I made it easier for
you Fill it in here okay

114
00:06:44.100 --> 00:06:48.300
then accessing settings
here, Do we have

115
00:06:48.300 --> 00:06:51.700
Ep, in case you are
In the most recent and

116
00:06:51.700 --> 00:06:53.700
It will end up making an
error Why did I do it on

117
00:06:53.700 --> 00:06:55.800
version 16 so if
You're at 17,

118
00:06:55.800 --> 00:06:57.800
Do you switch here
to 17, okay?

119
00:06:59.700 --> 00:07:03.000
There too. You will
Need your ID

120
00:07:03.000 --> 00:07:06.500
Tell me the ad,
okay? Then you can access

121
00:07:06.500 --> 00:07:08.900
Tell me about the advertisement, You
are going to type it here

122
00:07:08.900 --> 00:07:12.800
Your account from
this Spreadsheet account

123
00:07:12.800 --> 00:07:20.300
spreadsheet, do you already have
one Here it is that I

124
00:07:20.300 --> 00:07:23.200
I'm going to go to
the spreadsheet Here, we will go

125
00:07:23.200 --> 00:07:25.800
later on here, We
have one

126
00:07:25.800 --> 00:07:30.000
Interval of from which
What date, what is

127
00:07:30.000 --> 00:07:31.600
Time interval a Guys
who are such crap

128
00:07:31.600 --> 00:07:35.300
Here in the Daleste
case You are right

129
00:07:35.300 --> 00:07:36.900
It's the last seven
Days we can

130
00:07:36.900 --> 00:07:40.300
Get from the last 30
Days we can

131
00:07:40.300 --> 00:07:44.100
Pick up the cell phone
from specific year or date,

132
00:07:44.100 --> 00:07:46.300
right? Then I'll go
Talk a little more

133
00:07:46.300 --> 00:07:48.700
about those metrics here.
Leave the seven days

134
00:07:48.700 --> 00:07:51.800
Not to stay too long
Delayed too and here

135
00:07:51.800 --> 00:07:53.900
We also have the
Peixe Aí Qué

136
00:07:53.900 --> 00:07:59.300
I'll pick it up here
we had done that.

137
00:07:59.700 --> 00:08:06.500
It's for you to take
Also here is the account of

138
00:08:06.500 --> 00:08:09.200
Announcement, let me
show For you where

139
00:08:09.200 --> 00:08:17.300
I need to log in
manager of licenses faster

140
00:08:17.300 --> 00:08:20.400
Good to get the ad
account. Then

141
00:08:20.400 --> 00:08:22.600
We just need to log
in The settings of

142
00:08:22.600 --> 00:08:26.700
Deal well pages or The
page gives an account of

143
00:08:26.700 --> 00:08:29.500
advertisement, right? Select
the Ad account that

144
00:08:29.500 --> 00:08:32.500
Do you want the
metrics and copy that code

145
00:08:32.500 --> 00:08:35.300
100 is up to you
From the ad copied

146
00:08:35.300 --> 00:08:41.600
Put it on then, all
right The settings here already

147
00:08:41.600 --> 00:08:44.800
They're done, aren't they? you
You can use this here

148
00:08:44.800 --> 00:08:48.000
More than once it is
Spreadsheet already done

149
00:08:48.000 --> 00:08:50.200
also. Let me pay She here
we are going to do it

150
00:08:50.200 --> 00:08:53.300
A test on the of
Form now for

151
00:08:53.300 --> 00:08:56.700
Let's see if Toquinho
worked out I'll go

152
00:08:56.700 --> 00:08:59.700
Open here for us
can.

153
00:08:59.700 --> 00:09:04.900
Click here right to
Listen and here in ours

154
00:09:04.900 --> 00:09:08.400
Up panel. TO Guys
come here Webhook

155
00:09:08.400 --> 00:09:12.800
What do we want
Received the books of

156
00:09:12.800 --> 00:09:16.900
Form below, where We
wrote ourselves

157
00:09:16.900 --> 00:09:19.800
here's a test, But
only us

158
00:09:19.800 --> 00:09:27.400
submit this test and
Wait Ready it's arrived

159
00:09:27.400 --> 00:09:30.600
Logically everything will arrive here
Messy, isn't it? I will

160
00:09:30.600 --> 00:09:33.100
explain in the next
class, How does it work

161
00:09:33.100 --> 00:09:36.500
All this bunch of
Help that arrives and

162
00:09:36.500 --> 00:09:39.000
We are already collecting
them Data and save

163
00:09:39.000 --> 00:09:41.600
in the spreadsheet as well.
Beleza so see you next time.