Now let's move on From our dashboard, it's mine
love? Connect spreadsheet to it And pull All Those
doctors for our dashboard. We are using
here. The cat changed Of name by what
I saw it's Lux Túlio okay For you
take a look, the What is a city
Fruit can put in Google the first ones here
Results here basically that's it From here oh, it allows
You create this deck Board you don't need
It's free, okay? It's just that you have
What to have a source of Data where do you
Go get this data to record The Handsome One,
right? And our source Of data in
The moment is the spreadsheet, right? Did we see
This is where it changed Give a name to you
This is Lucas tum Dot Google.com it
You're going to show up here okay? I had already caught it
Here is the dashboard, but Not here for you
They will show up at first thing you.
Make the spreadsheet connected first From taking the dashboard to
Guys are going in here In the studio, okay? Vem
This is data source, right? What is our source
of data in Portuguese, Let's create a new one
What year data source, I don't have anything here
He will ask for them Simple registration things
And who leaves Brazil Brazil this is Marconi's name
of the company accepts and It's still good. I don't want to
Get nothing good, all right Here we have
Data bridge numbers That we can
Take it from Dado Zé Google is Google Analytics
there's a plethora of things here, Oh. Then get a doctor.
from Facebook, right? hath some others.
The game is paid is it in The case here we are
Are you going to use the chip here What are the spreadsheets
just click here, Can you give it a name
this is Supermed on Facebook, beauty? Then we
Will you authorize or ours Studio look. Our date
Studio Connecting this Spreadsheet is just a click away
Authorize here it will Ask us to do it
The login, choose the our account. Remembering that
The account that has Access this spreadsheet here
It looks like several planets that I already have it on
My account and me I have my spreadsheet
Here oh, she was All the data that
I was filling out in class It's past, okay? Everything is fine
This is where this dashboard spreadsheet. Then I'll go
Choose it here here Go ask. What are the
Abbas Ali Que Nous So do you want
Do we have videos with Fish advertisement we can
work.
Separately, okay So I'm going to start here how
The leader is already there Here put here there
I will connect the connector Here, okay? And he
I brought all the Columns are
The name of the columns Beautiful ad campaign like this
It's here it's in the case Here in the announcement,
right? What print campaign cancer he caught here,
right? Because the We caught him
Say right? I'm floating Here is the announcement and
Ad title everything Here and here he
The type of Field that is
your text type, if How did you get it here
A date is the type of Milk that
It's important to us To be able to move there in
south-east. I'll board us The telephone is needed
Here you got it right And this
The number of lines What do we have there
There are so many records, Just explaining more
Or less like how What does this look work
I study here, okay? TO We have already created it. I'm going
Stay here on the icon Zinho to return everything
What do we already have Facebook metrics leader,
I'm going to quickly do the second here. I clicked there
select here from this board, I'm going to make fish rolls
Same thing with tile Doctors Facebook will do it
This connects for everyone Here, okay? Look brought it
All fields too Same thing, but
He's about to come back I'm going Do them all here.
Beauty. This is the The last one is so I clicked here
I already have the five Meters from here to
5 Tabs from mine spreadsheet, right? If
Deal with separate doctors Okay, now that the
We already have everything That's it from here we go
Will open ours Dashboard tocomlink from him here
Some people already have to Duplicate it, right?
Click here it will Open at this time
We can't do it use, right? What is
Just as if it were a template, right? Then
You already see that There's already one here
So there is the logo of company, right? you
Can you change colors also. If you want
type everything. You can do it Here it is in English
That my computer lives In English, right? Then
But it has all the doctors here basically.
Here it is connected with Another spreadsheet, okay? To us
It will stay here it is one Copy and now
It's here oh, conversions. So let's fill it all in
he says he already knows. What are the sources
of data and I used And he's asking
Which one will I go Use right? Like me
I'm getting a copy De ovinho fanpage se
Was a friend of mine missing other ads, right? What
He has no one here Adjust ads here to
Try to identify any one there just click here
In a report, he will Take a copy there
to our account of studio. We can
Give a change the name here.
Actually it is I'm going to click on the visualization
In edit do you want It's already ours
I know that I can Close here fine.
There's not much here Something for us to move
here, actually. TO We are going to change the
Name, right? I will leave That's how to put Facebook
This is just for us It's here. Did you pull
The doctors who are There in ours ours
Spreadsheet, that's all I am everything from
There then here it is Two leaders of which
What is the date that he It's pulling
This is where we You can choose here if
We want this one Year it falls it will
update for this year. Then This year there are 89
books, right? I will Pull just for today
Or from yesterday more Easy how Zinho
2.
It is in March at Moment of the video put on day
29, just for us See the cars
Everything is beating on On the 29th, a dispute,
Let's confirm that only That's right on the 29th
There's a limit, right? Here you will have
a repeated one, right? Mas It's already beating and
Announcement on the 29th From this one here, leave me
See here on the 29th there was Several announcements day
29 which is the three Latest investments here
Hossomaki 119 Conversita Banging 119. So everything is fine
Everything connected, right some Songs from that one there are
More generic Aparecida das people. Okay but him
already
Conversions everything amount of conversions that occurred on the 29,
I'm going to leave it here Of the year to stay
Easier for us See beauty and what
Kill us do we have Here in the north those
that has already connected to spreadsheet now. Let's go to
personalization part. What That you can exchange
Here where is the free The spreadsheet is ready
Let me close this Here you will use more
What can we customize here. hereto
There is no button for Save is it up to us
Move something a little What does it already save automatically
It's here you can Put on the logo of
your customer or your Really a wolf, right? you
Do you want to use just select It will always appear here
Here on the side, okay So if I want
Change this image only click here and select
One on my computer OK? Or if it has
A link in the image to people.
Then change the image well Don't worry, just select change. If
do you want to add new images Here, we have
the image only option So we
Can you upload another image of the computer, if the
Do we want to change them Color the titles here,
Imagine that I didn't I want to say no to her.
I want you to show up there. Say here that I know
There it is playing a Order, right? Mas
when you select here You will see that
It will select everything Once
You don't have the flu here, You're going to have to
Click again ready Then he selected only the
understanding and here the Can we exchange one
Gymnast who is shopping that are an e-commerce.
So you want to take There in the spreadsheet you
From spreadsheet to this this automation, okay? I
I did the basic part, I I am not the manager of
Traffic, okay? I got it there with some managers the
key metrics, who works.
Men's important piece others Metrics other conversions to work with
with service it's different, right? So it's fine
personalised. You guys are going in Lying about it with dad
In the community with all world, right? And the
People are leaving this from here on as complete as possible,
right? So if I Change here I changed the
Name of purchases purchases Select us again
See that we can you change the color,
I don't know, I don't like it of that color. I
I want to use green exchange Is the size here? hath
Everything here here then In this case it's just
a text, right? Just one Read Bauzinho that
Call and here yes Down it here America
How does it work If you select any
Doctor who sells something Spreadsheet in the data by
It works like this, if You select it will
ask.
Data source folks You can exchange them here at all
the data sources What did we choose
There then there I didn't I want you to show up
Here doctors than He's rich, I want
What do you get from the advertisement Then choose advertisement, it
Will bring them all advertisement fields here
All those columns are fine From the back here and
Already filtered by date It's up to us
Pick it up at halftime From here and here there are
All the fields there That we can
use. So I don't know what Engagement here was
o the amount of Doctors that I want
He's going to drink this Time interval a
amount of engagement that Teve will bring it here
OK? This tank is just Kill then, him
It all added up here by 2 From 23 and
Brought it here for us If we need it
Change the type that
Just click here the Can we put how
currency here too. Deixa I'll get Brazil here
What is R$ 1 in Brazil, Brazil, ok
Imagine that from here it was a metric that
We picked it up Reais and so on
Can we type this one Is the whole spreadsheet okay? hereto
Everything is a field that Can we change
This information is also there here on the table. wanna
a conversion table I want a campaign of
ad just edit here, Okay it's okay
Really force it, okay? Nope I am no Expert unit
Studio, but I went It works and I did this
Try Word, okay me I played Altinho the
Others, I found a little Outdated and it looks good
customized for your customer. If you want it has
Three pages late are ready now.
These are the doctors There are general announcements, right?
You stop by him Go to page 2.
What do we have that spreadsheet of his,
Right they are the Facebook registrations that
I registered here He brings it here too.
Everything is fine. you Can you also type and
Here is the last one that the general metrics of
page, right? What audience how many followers. How many likes
Do you think it is what it was The audience, right?
And I didn't even say it That already saves
Automatically you just have to click Here I have seen it already
Can you see how Your client I eat
You went to send it to Is anyone here? So I have
That you can call Up here there is
Quietly view all Doctors, so filter here
If necessary, I want See her until
the 15th of March.
It updates everything everything Automatic in real time, okay
Very practical it is in Next classes, I'm going
Give an idea of How can you put
Is it inside yours okay? But here it is
Free mind for you Use for you to send
for your customer. You who are a manager
Of frogs, there are several Customers just click
Here to share, right? The tea you can
Give your Gmail His, okay? AND
Only he will have this one Access okay? Or
You can leave it free here in public. Só
That everyone will go see his music,
right? How do you have information Of people it's not
cool. If I do That and it also has
a link here, if Do you want to send it directly
for him. And then you You can stay here
Then you send this one link to it,
Does he have access to 10 Colors, if he
Do you want to see the songs From yesterday of the month
Compare everything he can using this dashboard. Espero
That they liked the Class and even