Thought about making this video to make it a little bit more clear.
00:07
yeah.
00:08
So this is a data clean table, if you didn't see it already.
00:13
So I wanted to update the lifecycle stages, for the CRM for HubSpot because, because lifestyle stages were all wrong and we want to email clients separately and want to find them separately of course.
00:29
So what I did is we have here Clanton, this is Dutch for clients and I got another table with the clients.
00:44
So what I did is I looked up the clients from this row for, via the root URL and because this has results, this means that people are clients.
00:56
Totally 121 people in this table.
01:01
so first what I did is I changed this life cycle stage column to customer I looked up in HubSpot.
01:12
If this is the right code, this should be the right code for amending the life cycle stage.
01:20
This didn't work.
01:23
so I tried it another way.
01:26
and instead of using the column lifecycle stage like I did here, I use the other option.
01:39
And this is the drop down option for amending the life cycle stage.
01:46
So I tried these two options.
01:48
It said should be updated correctly.
01:51
but unfortunately when I take a look inside of HubSpot, it still says X customer, ex customer was the previous life cycle stage which I amended here and changed also via the drop down.