Thank you for coming. I'll be talking about how to make your own little transaction across multiple servers using just Python and Postgres. So let me introduce myself. That's me. My background is chemical informatics. I worked on software for drug discovery. Then I co-founded machine learning startup. Then I worked for Twisto financial startup. I was there since it was about 20% company until it was sold. I helped it scale up technically across multiple countries. And now I work for a company called Monitora. We do media monitoring. And again, it's a small company, mostly Czech Republic, Slovakia. And we are working on building a worldwide product. So that's what I do mostly. I help companies to scale up from a small startup to a major company on the technological level. And with my wife, we are also organizing courses mostly for people who want to learn programming but who do not want to become programmers. So in Monitora, what do we do? We scan the internet. We watch for news, for printed news, for online news, social networks, and so on. So we can answer the question, what do they write about me as if I'm a big company, a politician, whoever? We can give you the top news from today. We can perform analysis on the articles. On the back end, it means we need to do a lot of crawling. We do OCR, a lot of interesting tech. The deduplication of articles across the web is an interesting problem. We do a lot of machine learning to recognize what the article is about, to be able to summarize it. We search large amounts of texts. And what is interesting in this company is that we are a small team. At the moment, it's six people on the back end. And we want to remain a small team as we build a worldwide product. Currently, we are looking for one DevOps person. So if anyone is interested, what scale are we talking about? At the moment, we are mostly Czech Republic and Slovakia, partially Germany and other countries. And we have more than six terabytes in a Postgres database. And we are aiming for 50 times or 100 times more to be able to scale it to the whole world. So for this, we use a distributed database. So we want to scale it horizontally, because that big server would be possible but a bit unwieldy. We chose Citus. It's a Postgres extension. You can put only some tables to the distributed mode. So you have clear migration path from your existing Postgres database. But some of the more complex joints between the tables, which are on different servers, might be limited. And I like to understand how the technology I use works on the deeper level. So here, we will be doing something similar to what Citus does, but implementing it by ourselves. So let's build a toy example. Let's build a piggy bank. We will have some users with their accounts. Each account has a balance. And we want to be able to safely transfer money across the accounts. But because we are a piggy bank, we do not lend money. We do not allow overdrafts. So we want to be able to move money and not lose any. But we will be making it distributed across multiple servers. So first, we need to decide how we will distribute the data themselves. So for this, we can use the sharding approach and just make the same table structure on every worker server. So we have here two servers. And each of them has a table of accounts with their balances. But each server stores only half of the data. And how do we decide which server should store which row? We will simply take a hash of the account name and take some operation that will deterministically decide where to put it. So in Python, we will do it this way. We define what shards do we have, which workers should they be placed on? We define a helper function. We call it worker for account. And this function will take a name of the account and return the ID of the worker or ID of the shard. And there is another helper function. Just it's called SQL. And it will just take a name of the worker or ID of the worker and SQL commands to execute on that worker. It will come in handy later. I'm not showing the implementation for the second function. There will be a link to the code if you want to play with it at the end. So first, we want to put some money into account. We want to create an account for a person. That's easy. We just need to know which worker manages that account. And we want to route the insert query to the right worker. That's fine. We know the hash function. We know which worker it is. So it's a matter of this single server. Now we want to do an operation which spends multiple servers. For example, we want to know how much money people have at our bank, so how much money we might be forced to pay if they come and ask for their money. So yeah, again, that's kind of easy. We just list all of the workers that we have. And we go across the workers, ask them for their sum of the balances, and just report it. That's fine. OK, so that's fine. Case closed. We can go home. We have our big bank across multiple servers. But what if one of the servers fail? I will be talking mostly about what happens when something fails, because that's why we do transactions. So one of the workers went kaboom. And we cannot longer connect to it. That's bad. We lost half of our data, because we have two workers. How do we deal with that in Postgres? We can do a replication. Just a standard tool for Postgres database. We replicate data from one server to another. And we do it independently for each of the shard workers. So when one of the servers fail, we have some mechanism to route the traffic to the other one. It can be a proxy. It can be a virtual IP that moves. It can be a DNS name that allows us to say, OK, hey, this is the worker one. The worker one is now on a different server. There are standard tools for Postgres that do it. We use Patroni, but if you use Kubernetes, there is a crunchy Postgres operator. Or Patroni also has Kubernetes support. So this is something that you'll probably want to do, because if you have multiple servers, there is a higher probability that at least one of them will fail. But it's a problem that can be managed. Short diversion, the CAP theorem. Just raise me your hand, who has never heard of CAP. OK, so it's a theoretic theorem, which says that in case of network partition, some of the servers cannot reach the other servers. Maybe the network fails somewhere. Maybe they are just too busy. Some of the servers cannot talk to all the others. You have to choose between either consistency of your data or availability. Because if you cannot reach the other part of your cluster, that means that either you stop and wait until you can reach them, because they may have newer data than the part you can reach. Or you say, oh, well, we know some. Maybe all the value of the data. So we can serve it from the part of cluster we know. So there are a lot of trade-offs and a lot of places where you can decide if you want to lean more towards the consistency or more towards the availability part of the problem. For example, when we are doing replication, then we can do either synchronous or asynchronous replication. If we are making replicas synchronous, that means that we will need to wait until all the replicas have confirmed that they have the data which we are writing. So that means if the replica fails, we need to wait until we know that either it fails for good or until it recovers. And at that moment, we cannot continue writing. So that means we are more towards the consistency part. Or we can make asynchronous replicas and we are more available. If you are interested more into this topic of distributed systems and these trade-offs, there is Jepsen.io. It's a company by Cal Kingsbury, the person who is very knowledgeable and has very accessible talks and blog posts about this topic. So OK, so we made a replica. And now we can add an assumption or two to our piggy bank. So in order to be able to build the distributed transactions, we will make the assumption that the node, the server, doesn't lose the data it committed. Once you received a confirmation of a commit, or the database commit, it will be never lost. And if some node will fail, it will recover eventually. Maybe from a replica, but it will recover. So we will rely on these assumptions. OK, so this is our function to transfer money from one account to another. The accounts may be on a different service. So we will need to find a worker for the destination account. We add the money that we transfer. We need to find the worker for the source account. We need to subtract the money that we transfer. It's fine, right? What could go wrong? Nothing, no. Unless the server fails. So yeah, we added money to one account, and the other account didn't get debited. Because yeah, we get an exception in our Python code, but the data is already written. So we do not do anything and just lose money. This could happen also when we would want to transfer a larger amount of money than the balances. Because here, in the bottom part, the database constraints that we say that the balance must be always positive, it would fail. So here, we would lose money. So how can we do it better? In plain Postgres, if you would have just one server, you would insert begin and commit to wrap those two commands in the transaction. And it either happens all the way or doesn't happen at all. And this is something what we want to do across the service. Luckily for us, Postgres has a feature that supports exactly this use case. We want to prepare the transaction across all the servers. We want to know that it will succeed. The servers should guarantee us that they have the data, they will not lose them, and that the transaction doesn't violate anything, and it will safely commit. So once we have this confirmation from all the workers that are part of the transaction, we commit them all, again, sequentially. So the function that we have would work like this. For each of the servers, we will create a transaction. We will execute our SQL code, which is relevant to that particle server. And we will append this transaction to a list of transactions to commit in the second step. So it's fine, right? Works. If we didn't get any exception, we go and go over the list and commit everything. If something went wrong, we roll back those transactions that we have. Fine, right? What could go wrong? Yeah, something can go wrong. So what if we fail? Remember, we have a list of transactions in the memory. And the code, the computer, where we run this Python code, can fail at any time. Again, there may be a bug in our code. The computer may catch fire. So these are four discrete steps. So we have three places where we can fail. And because the database guarantees us that the transaction will safely commit, that means that it still holds the locks. So for example, if we change the balance, we cannot. And we called this prepare commit on one server. Then we cannot modify the account from any other transaction at all. So if we fail after the first prepare, that means that this account on that server will be locked forever. And we will not be able to touch it until admin comes and unlocks it for us. So what do we do? How do we fix this problem? Well, we, who manage the other servers, have to be a database as well. We have to remember what we did. And in each of these steps, we have to be able to recover and continue. So yeah, we will extend the assumption that the nodes don't lose committed data and that don't fail forever, including the coordinator node, including us. Even though we are not storing any data for the piggy bank, we need to store some data regarding the distributed transactions. Yeah, this first part is something that I have been talking about already, that there is a problem that the transaction may take longer time than you are used to. So from the moment you have made some change on one of the servers, until the moment that all the servers have made their work and you are committing the prepared transaction, all your locks that you hold in the transactions are still locked. So you cannot, you have to wait for them. And if the coordinator does not serialize the access or does not do something clever with regards to the transactions, the changes on those different servers may be visible not atomically. Because as you see, when we have these steps that we commit the prepared transactions, there is no way to do them at one moment. We can guarantee that they will either be applied all or none of them, but we cannot guarantee that if someone goes directly to that worker server and asks it for the state that it will be synchronized with the other workers. And again, this is where we touch the CAP theorem. We can let the clients do this without the synchronization. And they might get not consistent view of the database. Or we can handle this somehow in the coordinator and make everyone go through the coordinator and somehow serialize the access. So this is all for the talk. Thank you for listening to me. There is a link to the example code that I was showing. You can play with it. I can do a show demo now. And if you are interested more in that, find me here in the hallway after the talk, or maybe here in this room, because I think there will be no talk after that. And I can go through it with you in more detail. So I will just show a small demo. How does it work? Oh, actually, are there any questions at this moment? I may answer the questions now. OK, yeah. So the question is that we are handling sharding at the application level and replication at the database level. So why not delegate sharding to the database level? Actually, this is what we do with Citus. There is this tool called Citus, the extension to Postgres. And you interact with it with plain SQL. So it makes some tables that look like they are there, but they are just empty. And it passes the SQL queries and passes them on to the other servers. That's what we are doing. But somebody had to write it. The database is an application as well. So here I am just making a toy example with Python, how we would do it. But what we are actually using in production looks like a database. But there is an application code doing exactly that. Yeah, so the question is, I'm not sure if I understand the question, so I'll try to repeat it. So the question is, how do one shard know about the other? And how do I make a transaction happen at all if the shards don't know about each other? Yes. Yeah, that's where the coordinator comes into play. The coordinator knows about the shards. And the coordinator is the one who says, OK, this shard, please subtract the money. OK, this shard. Please add the money. OK, so everything is fine. This shard, commit it. This shard, commit it. There was a question. So the question is, how to make a consistent view of the database across all the transactions? I'm not sure how this actually works in Citus. It definitely takes some logs by itself. So it excludes some transactions from the others. I am not sure at which level exactly. Because on the most strict level, you would have to serialize all the transactions one after another. But you can be more clever to wait only for the transactions that conflict with each other. Or you can just let it be and accept that at some point, some of the data might be inconsistent. I am not sure how exactly this works in Citus. But you, as an engineer who would be developing this kind of system, you have the possibility to make different trade-offs and decide for yourself. Depending on if the application can tolerate it or not. So yeah, if you let it to the developers, there may be a ton of bugs, yes. But if you're architecting a system, you need to know what kind of inconsistency can it tolerate because consistency at all costs is slow, very slow. For example, in our case with the online articles, we do not care that much about consistency between the different articles themselves. We do care about the consistency between an article and its related metadata. So we care about the consistency in some pockets of the database. So for us, if we are consistent within one chart, it's actually usually OK for most of the operations. It's OK. In our case, as the media monitoring campaign, we do not usually need this inconsistency across the charts. For some cases, yes, but they are rare. Yeah, we prefer to be able to do. Yeah, I would be happy to discuss with you. We avoided several things. OK, any other questions? Yeah, yeah, this is exactly how it works. The coordinator, basically here, the coordinator remembers what it did, stores it in a database table. And if it fails and boots up, first thing it does, it looks at the transaction log and goes clean up the transactions that should not be there and commits the transaction that should be committed. Yeah. So the question is whether you have one access point through one coordinator through all the databases. You have to go through some coordinator. Again, depending on your trade-offs, how much consistency do you need? The coordinator may be itself distributed. If you do not need that much consistency and you want higher throughput, you can have a distributed coordinator. But if you want more consistency, you go through one coordinator. This is not about Citus. This is about the problem spacing in general. If you want more throughput, you can get it with more coordinators. You need to have some place which knows about the charts and is able to coordinate them. But it doesn't have to be a single one if you do not need to synchronize a realizable point of view to the database. And the case is architecture. We're thinking about keeping as simple as possible. First, then making your developers thinking about how it should work and before. Great, huge problem. Yes, so try to do by our one piece sharpening approach. So the question is? Maintenability. Uh-huh. So the question is about maintainability. You talked about the question. Yeah, yeah, so you say that this approach is not maintainable. Yeah, I agree with you that this approach is not maintainable. And this is not Citus. What I was showing, the Python code, this is my demo here for you. It's about 100-line Python script that implements distributed transactions with a two-phase commit. And it's on GitHub and you can play with it. This is not Citus. Citus is something that you install into your Postgres. And for most part, it behaves the same as the tables were behaving before. It has some limitations. It cannot process some of SQL queries. It cannot enforce some of the foreign key constraints, for example. It cannot, for example, enforce a unique constraint across charts. But for the application developers, it looks like any other SQL table. So the question is whether we should not use a lock for locking the user balance. Not really, because when we use this kind of SQL query, where we use balance equals balance plus something, this is atomic. And as soon as you do it, the row is locked. This is how Postgres behaves. Uh-huh. Uh-huh. Uh-huh. This is why we are doing these two phases. That first, we try to do the operation at all of the servers. We do not commit. We just prepare. Uh-huh. Yeah. Yeah. After? Uh-huh. Yeah. So if we do just prepare transaction, the other users, if you run Postgres in read committed serialization level, then if you do just prepare transaction, that the change is not visible yet. It's visible only after you commit prepared. But the commit prepared, because you do it across multiple servers, itself, is not at, you cannot do it automatically. Just you cannot do it. There is no way. So if you need to maintain a consistent balance, a consistent view of the balances across all the system, you have to serialize it in the coordinator. Yeah, for coordinator, well, here in this case, in case of this small demo, the question was whether we use event sourcing approach or something different. You can look at the code. There is no event sourcing. We just log the transaction. Well, if you look at the code, it's four Python functions. They are just called directly.  So we are able to reconstruct it. So yeah, you can tell it's event sourcing in some way. If you are interested more in that, I'll be here for some time, because I do not want to compete in the launch queue. So I'll be able to show you the demo itself. OK, so one last very quick question. Yeah. So the question was where we thought about using Mongo and something that is horizontally scalable by design, as opposed to Postgres, where the horizontal scalability is bolted on. Actually, yes, we thought about using Elasticsearch as the primary source for the data. But there are two proponents with that. One is that we already have quite a big application, which is written using Postgres in mind, several years old, and so on. But the bigger problem is that these databases, like Elasticsearch, they are not well optimized for relation data. Originally, I thought, let's move everything to Elasticsearch, because article entity has some restructure. It's a document, after all. Not really. You have authors. You have new sources. You have a lot of metadata, which are highly relational. It surprised me, actually, how much relation like this. We have like 500 tables. And it's much easier to work with a SQL database. So instead, we evaluated Citus as the extension of Postgres and two Postgres-compatible solutions, which are horizontally scalable from day one. It was Cochroach and TugaByte. All of the three are cool. If anyone has any more questions, I think you can find it outside. So thank you.


And I just, I just, who rides like that? And if you put like, I don't know, DS game card things in it, you can get memories back. So I quit. This is mental torment and I'm not participating. Fancy seeing you here! So a few weeks ago, I had the realization and something was stirred up in my memory that Kenneth Dill and Kylie Jenner wrote a book once. They actually wrote a book. They published a book at the height of dystopian fiction times and yeah, it exists. I posted a tweet about it and it soon became apparent that a lot of people had forgotten about this and remembered it too. And I thought, well, well, if this is getting this reaction, I've got to read it. Oh, good. I mean, it is on script for free, but because I'm me, I wanted the physical version. So look what we've got, ladies and gentlemen! I wanted to learn firstly more about who actually has written this. And it soon became apparent there are a lot of hands working in this mess. Kendall and Kylie Jenner are obviously the authors on the front and then when you turn in, you have Ann Elizabeth Kilvyn-Roman with Maya Sloan. So, Elizabeth was Kylie and Kendall's handler, so basically like the person who managed them. And Maya Sloan is an author, an actual author. Also in the acknowledgements, Kylie and Kendall say, we want to thank our entire big family for always being so supportive, especially our mum, the most amazing mumma jet ever. You make all of our dreams come true. Someone, I mean, can the PR team not do a better job of writing these? Kendall and Kylie couldn't even write their own acknowledgements. They couldn't even write their own acknowledgements. Now, because I am a professional, I've done a lot of research for this book. I watched a lot of interviews of them talking about the book. Firstly, at their book signing, they look so miserable to be there. So if you're miserable to sign the book, how should I feel about reading it? During a 20-minute interview, which they're there to speak about the book, they speak about the book for about one minute, and they basically say that they had an idea for a movie. They were just chatting and they had an idea for a movie and they decided to make it into a book. We just thought of a movie idea and then we were like, why not put it into a book? We love action, we love stuff like that. Yeah, what kind of movie do you like? I mean, we're really into everything, but we just had thought of something that would be fun for us to write. Something different, something that someone wouldn't expect from us. Obviously, Chris Jenner saw a dollar sign. And in another interview, this isn't specifically about this book, this is about the sequel. It's a series of little short videos they've done on both Kylie and Kendall's YouTube channels. And it becomes clear to me that at least Kylie made an effort to know what this book is about because she'll say things to Kendall that are key to the plot or about these characters. And Kendall will have no idea what she's talking about and have to pretend like she did know what she was talking about. Olivia, because Olivia is like, she has heightened senses. She can tell when people are coming in around her. Okay, let's change parents. Kylie makes effort in these videos to actually, you know, she's read the synopsis, she's read the key facts about the characters. Kendall has just waltzed on it and hoped for the best. I also ran up on some interviews and some articles about the book and how this book came to be just so I could kind of understand what I'm dealing with here. So, along with Elizabeth Kilburn-Roman, who if you remember is the other author of this book, they created a broad two-page outline. You're right. Need a bit of space, I'm not so kind. You're right. Yeah. Create a two-page outline for this 340-page book. Describing the futuristic tale about two girls with superpowers who are secretly twins, Sloane was hired to execute that vision using Kylie and Kendall's inspiration for the book's protagonist. The sisters took her along with them to New York Fashion Week and let her hang out in their hotel room while they texted their friends. This is the worst idea I've ever had. And then, and then, and then, Miss Liz, Miss Liz, the co-author of this book, is here to step up for the girl. She says, while Sloane actually wrote the book, Elizabeth took pains to emphasise the girl's involvement. They had numerous Skype and FaceTime sessions with Sloane, she said, and the groups all marked up drafts with extensive notes. If someone proves your book, they haven't written it. You know, if someone checks it, they're not the author. I went into this book with a clear mind, and I think we should just get into the reading it because... Oh! Oh, God. Yeah, let's just get into it because I don't think I can say any more here. And I hope you enjoy pain. Hello. So I am about to start Rebels City of Inja by Kylie and Kendall Jenner. I still can't believe I'm doing this. It's a nice picture of them on the back. Yeah, today we're going to the football, and so I think I'll have quite a lot of time to read it in the car. I don't know what expectations to have because it isn't really written by them. I don't know if it's actually going to be that bad, or if it's just kind of going to be like 2013 YA fantasy. I don't know whether it's going to actually be as bad as I'm thinking it is, or whether it's kind of just going to be average. So I'll check back in once I have some more concrete thoughts on what it's like. I'm 50 pages into it. You can see that. 50 pages into it. I don't even know where to start. Okay, it's not great. It's really not great. Okay, first point of action. I feel like I've laboured through 200 pages. I'm like, how am I only on 50? And then here's the thing, here's the thing. The way that this is written is whack. Like it's a really weird style of writing. So in this, the way it's written is like loads of tiny short sentences. So it will be one of the characters and she'll be like, I'm on my horse. It was my mother's and she's the best horse ever. And people make the mistake of thinking that she's white, but really she's ivory and people don't know what a difference that makes. And I'm riding her through the fields and she's never gone faster. Or something like that. And each of those is a different sentence. And I just, I just, who writes like that? I, no one writes like that. No one, and it's horrible to read. Maybe I could understand it if one of our, because we follow, it's two perspectives. We're following Lex and Livia. And I can't even tell you which one is which, hang on. One's living underground in like the secret caverns and believe she's an orphan. I think they are orphans anyway. Okay, that's Lex. I was gonna get it the wrong way round.  Okay, so I can understand it if maybe one of the girls was written like that. To show something about her personality. I don't know what. Don't ask me, but do you know what I mean? If it was a stylistic choice for one of the girls. No, the whole book is just like that. And it's so bad. It's so bad. A lot of the book, I'm not sure where it's gonna go yet, because this is dystopian, remember. It's very genetics based. So like, I think the girls have like perfect genetics. I think their dad engineered genetics or something to do with that. But then a massive part of it as well is like everyone genetically altering themselves, like getting their lips bigger. How's the tea? See, I think their skin pulled back, getting the sparkle put back in their eyes. I mean, are we surprised? No.  So maybe we're seeing some projection. I feel, I would say, I feel like they're writing about what they know, but I don't think it's them writing. But then my next point is, okay, you weren't a billionaire at this point in time, but you were a rich gals. You cannot pay someone who can write to write your book. Like, come on now. Come on now. You must have had so many people knocking at your door going, sis, I want to write your book. And then you pick the one that writes like this. Fools. Fools. I'm going to try and read. I mean, this book, it's only, what? Let's be serious here for a second. 340 pages. So I could try and get a good way through it. Oh, it's just bad. It's just bad. It's just bad. I don't want to read it. So I've read some more. I'm now on page 113. It's gone to the point where I've had to start tabbing it. So I've started tabbing it. Bear in mind, I have never tabbed a book before. I thought maybe the first book I'd tab would be a reread of a favorite book. You know, it'll be a really nice experience. Here it's just to remember all the things that annoy me. The writing for Livia is better than the writing for Lex. Lex is the one who was originally an orphanage under the surface level of the earth.  And it's so bad. Like things, things just keep happening. Right.  And then there'll be a page break and they'll be like, now none of us could act the same ever again.  And I have to go back and read it again. I'm like, okay, I see how that could be like a big thing. But it's just, and like Carrock, she meets a guy that she ends up being best friends with. He's going to be a love interest. We all know where this is going. But she meets him and like he takes her off to his most secret treasured place. Like after I've never spoken before. It's just so bizarre. I was writing like, does she know him already? Is this actually when their first meeting? It's so confusing. The Livia sections, slightly better. She's on the top of the earth, on the posh islands or whatever. Training to be like a woman in society. Because apparently in the future, we just go back to like Jane Austen period. And it's not as terrible. I'm not highlighting sections as much going low or what. I think there was a board meeting with the actual writers, with Kendall and Kylie, and they sat them down and they thought, okay, what elements would you like to be in this? What dystopian future society elements should be in it? And I think everyone was just shouting ideas out. Everyone was just throwing ideas about. And instead of, you know, instead of narrowing those ideas down, the writers just went and go, right, we've got to write anything that Kendall and Kylie say. So let's just put everything in it and not make any sense. So there's so many elements to this book. And I'm only 100 pages in and I keep saying, like I feel like I've struggled through a whole book, but at the same time, nothing's happened. We haven't actually got to anything yet. We're still in their past. There's this whole business of the archives where people have a card slot in their wrist. And if you put like DS game card things in it, you can get memories back. But it's like never delved into.  Some people have none of their memories stored. And if you cross the society, you, like if you like mess up, right, I think the prison equivalent is you are sent to the archives to like be a shadowed person forever. But it's just so, it's just so bizarre. And then there's a guy who has a device that he can paint sounds with, never explored. What else is there? The whole business of the upper ground and underground thing is still confusing to me. Half the time, I don't know where we are. We spent a third of the book in the past, just learning about who the characters have been up till now, which could have been, this could have been 30 pages. This could have been 30 pages.  And I don't know if there's going to be explanation for why. I just, I just hate it. I just hate it. Okay, so the book's making me ill. I've been ill for a couple of days and I haven't wanted to read this. I just haven't wanted to read it. Look at it, it's so sad. So I finally got two thirds of the way in. I honestly don't feel like anything has happened in the past third. And you know that's bad. You know that's bad when I thought nothing happened in the first third, but no really nothing happened in this third. Like, nothing, nothing. You know the blurb. You know the bit that tells you about the book. Some books spoil a bit for you ever. I'm two thirds in and I've literally only got up to the end of the blurb. So I finally read the blurb, which I didn't because I didn't care enough. I would have known everything that had happened in this book up until now. I could have just read that because it wasn't even like, okay, we went into their backstories. We went into their history, but it wasn't even like their history and backstories were interesting. They're boring. Hi guys, sorry I couldn't hack that. I'm sorry, you knew I couldn't. That's probably where you got the idea from. So I quit. This is mental torment and I'm not participating. That's gross. Okay, where was I? Yeah. Okay, oh my god. Okay, we're gonna go like this. So yeah, their histories of backstories aren't interesting. I'm literally like reading off the red nose reindeer. I spoke a bit before about how a lot of this doesn't make sense and it feels like they've just thrown random stuff together. It still feels like that. There are terms being introduced right now that I think you're supposed to believe are just normal terms like, air girl. Oh, she's definitely from the air talking about someone who's from the higher levels. But like that hasn't been used in the rest of the book. That hasn't been said before. So it's like the author thought of it, thought of the term two thirds into the book and then go back and add it in anywhere else after they thought of it, which is what you should do.  You should have seen my face when Livia, the one who lives like in the islands, the top islands, when her emergent school was, which is supposedly when a woman finds a mate and like all the guys come and they pick her. So I just thought she was gonna get dressed up in a nice dress. She's had all this etiquette training. I was like, okay, fine, whatever. But no, she has to get on a pedestal and spin and pose. Like get thrust like 60 feet up into the air, I think, and spins really fast and has to strike poses. And this is what makes her attractive. Very strange. I don't get it. And there's no reason for this. Sorry, I shouldn't get so loud, but there's no reason for this. There's no reason for this. And what else? Oh, it looks like the girls might fancy the same guy. They've both kissed him. They were his first and second kiss. So that's an interesting choice for the love triangle. Are we, is he gonna end up with both of them? Honestly, I can't emphasize this enough. Most of these tabs are me highlighting something and going, what is going on? What is going on? Because I can read like two pages and not understand what's going on or where I am. There's never any place setting. We just move from place to place. And I can't imagine what this place looks like. I have no reference for where we are, for any scene. And I'm done with it. I'm so done. Like I should be reading books I enjoy. And yet I'm putting myself through this. Is it worth it? So I took last night to collect my thoughts. It's so bad. I give it one star. There was a point, maybe 50 pages into this. I thought, maybe I could give this two stars.  But as the book went on, it just got worse and worse. So to collect my thoughts, we're gonna have a few sections here. So the first is weirdest relationships in the world. We had a guy called Kane, who we spent like the first 150 pages of thinking that him and Lex were gonna get together. They were training at like the special ops academy together. They were like best friends, but like a relationship. He thought it was gonna turn into that. But he's so weird. He's so strange. He's a psycho. So I've spoken before about his machine that paints sound like just thrown in. Doesn't really ever have that big an impact on the story. Don't know why it's there. He paints her laugh. Like he gets her to laugh and paints it. And she's like, wow, promise me you'll do that again. And he goes, just wait, he said, to like paint your scream. No, no way. Definitely no. Not a chance. Nope, never, no way. Bearing in mind, they're like 12 at this point. So sexual tension, maybe not the best idea. He has to leave. He's been hired for an assignment. We don't know what it is. He kisses Lex, says, I just wanted my first kiss to be with someone I cared about. And then we find out he has been hired to assassinate Olivia. Bear in mind, we never really find out by whom or why he was hired to assassinate Olivia. Like, we just, just, that doesn't matter anymore.  And they like fall in love in the 10 seconds they're together. And so for the rest of the book, suddenly we switch and he's into Olivia. There's never any discussion of how weird it is that he first spent years of his life with Lex and then spends 10 seconds of his life with Olivia and suddenly like, sorry, Lex. And then towards the end of the book, Lex is like rightfully getting upset that the guy she, oh, I didn't mention, she risks her life. That's how her and Olivia met because she heard that Cain was in trouble and she risked her entire life. Like she was about to die for this boy. She was about to die for that. She was about to die for it. And then he's like, sorry, I spent 10 seconds of your sister and now I like her. And then at the end, Lex is rightfully getting upset. She, okay, I can't find the exact thing I'm thinking of, but she basically keeps saying on multiple occasions, oh yes, it's great I've met my sister, but she isn't going to stop me from getting what I want. I can do what I want. Let her be upset. And it's like she has no compassion for this girl. I don't understand. I don't understand. So anyway, the girl's relationship is very weird. They never grow close. Like it's just so strange. It's so strange. There's never any relationship development. Number two is just that the book has no identity. Like, Cis doesn't know who she is. Cis thinks she's a mix and I touched on this before. They've just trapped loads of stuff in that they think is a dystopian novel. She's a mix of every YA dystopian novel out there.  Honestly, I have never read a book where I could not envision it before. Like we'd be in high speed chases and I'd be like, are we in like a city? Are we in pipes? Because they would mention that I'm going through pipes. Are we in like the desert? I had no idea where we were. For most of this book. The locations change fairly frequently, especially towards the end. But they're like never explained. They're never detailed. They're never like... It's I just, I've never, it makes it impossible to read the book because I think if you can't, for me anyway, if I can't visualize a book in my head, I'm like, okay. I can't, I'm just reading words on the page. I'm not following a story if I can't visualize it in my head. I just, I've never read a book that bad. I've never read something that bad at actually setting a scene. They're just like, yeah, we're on a rig now. And they'd jump down onto the rig, but then the rig would be above everything else. I'm like, how is this even possible in terms of gravity and locations? And I just don't understand for me. The biggest, the biggest disappointment of them all was structure. Who is she? Who is she? Who is she? Who is she? Who is she? Where did you find her? The story doesn't start until like 70 pages from the end. It's like they came up with the story, the full story. Bear in mind there's a second book. And it's likely split the story in half. So this book doesn't have a beginning, middle and end. It has a beginning and half of a middle. And so I have no resolution for anything I read. I have no resolution. Nothing has been resolved. The characters have not grown. How are they so bold to think that everyone's going to read the second book? And I just, no one writes a book like this. If you write a series, each book still needs to have a beginning, middle and end, like any book. So basically, I read this book for nothing because I got nothing out of it. I didn't even read a story. If I want to read a story, I have to read the second book, which I'm not going to do. And also bear in mind the woman who wrote this doesn't write the second one. So any seeds she plants, which I don't think they were very granted, but like anything she had planned isn't going to happen in the second one. So on Goodreads there's a review saying, I only want to read this so I can have the satisfaction of saying that Kim's sex tape had a better plot and a more powerful climax. And honestly, sis, that's right. That's not a lie. It did. And I want to make it clear. I didn't come into this wanting to hate it. Like I didn't care. I might have loved it. And then it would be like a shocking that I loved it. I came into this with open mind. I kind of wanted to like it. But then I can't believe I put myself through that. I've got 60 books sitting there that I actually wanted to read. And I just spent one important day reading this. Well, I hope you enjoyed the video. Okay, I'm going to go. Thanks for watching if you've made it to the end. Let me know down below if there's any other celebrities that wrote awful books that you would like me to read because I don't value myself evidently. So even though this has been torturous, I kind of want to put myself through it again. I hope you've enjoyed the video. I'm going to go cry in a dark corner. And I hope you're well until I see you next. I won't be. Okay. Okay, bye. It's the worst.


La la la la la la… La la la la la la… This very body is soil. My body, your body, everybody, is just soil body. The magic of soil is it turns death into life. Depleted soils will not quench the fire of hunger. Unquenched hunger can burn the very world. This is a generational responsibility. Save soil, let's make it happen.


recently is starting to change but you know when we first started this quarantine stay at home thing realtors were not essential escrow was essential title was essential but the realtor was not how how does it even make sense how do you how do we even get to escrow if they don't have the realtor yeah right that was my whole thing and it was like I had buyers in escrow at that moment in time and you know the other agent and I just we spoke about it and he's like you know if you want me to I'll give you one day code so the buyer can get in with you know because she was doing a couple of extra inspections but he said as far as I'm concerned you know and so I went I let them in we did social distancing you know it was myself it was there was a couple buying but it was just the wife and then the person doing the inspector inspection and 99% of the time he was outside so I mean and we were all wearing masks you know we all had gloves all that all that happy stuff and you know you just you do what you got to do to make it work you know my listing in barstow I did a virtual open house ended up with four offers countered them all asking for highest and best wow hold them before you respond we're going to get you on a walk through so we got them into the house and it was tenant occupied by the way they walked through they responded with their highest and best an escrow will close at the end of this month that was the tenant had to be given 60 day notice wow one I've got one coming um out in hellendale hellendale where's that ever driven to Las Vegas yeah you know when you're going up interstate 15 you down the top of the home pass you hit D street in victorville you get off D street and you head west wow out between victorville and barstow because you can get to barstow that way too um those out in the middle of nowhere but it is a resort golf community 27 hole golf course tennis courts basketball courts swimming pools and two lakes stocking fish equestrian center oh let's see david I do not want listings up there yeah I know right yeah the one that's come to me I take them because my 82 year old parents live in apple valley which is right by victorville so Uncle Sam will let me write off my mileage to check in on my mom and dad I'm not insane I'm really not a crazy woman but but help me get more clients and followers down here please yeah and and that's my whole thing you know and and what I was trying to really you know bring up you know a few minutes ago just as far as me consulting with you guys since 2016 that that as I left mortgages I just knew I wanted to help you guys because I just seen I just seen a missing you know link I seen a hole in the market there because when it comes to social media and and then and then the light bulb even went on even more when I started requesting you guys so today if you look at my personal page over here and I'm going to give you context of where all this is coming from and why yes the advice I'm going to give you it's going to be basic it's going to be powerful and it's going to be 100 percent based on what I see and what I know it's none of the stuff is theory or my opinion on how you should market this is what I I see what's going on in your industry and and and again majority of them are missing the boat so but but I also want to make clear that this stuff is basic like this stuff is super basic and that's also where I found my niche is teaching guys these basics because every agent is coming online looking for that next deal looking for that next buyer looking for that next seller looking to capture some type of lead and and again what I'm what I'm saying is that before we even get there there's basic steps that need to be implemented on these pages before anyone even takes you seriously yeah because on social media no one knows you so the same way you're on this call wondering who the heck David is I'm on the call wondering who the heck Jill is like I don't know you either that's social media so unless we have our pages what we call optimized and just updated to really show some credibility most people are going to just fly by if they're going to scroll through scroll through scroll through and we're just another agent that they can choose from so here's what happened in 2016 if you look at this friend list over here I started because I knew we can only have five thousand yep I knew that I wanted to start helping you guys I knew that from a marketing perspective let me turn up my my light here from a marketing perspective I also knew well it was a question I had to ask myself how was I going to get ahold of you guys like was I going to cold call every agent and just pitch services or was I going to you know doorknock because obviously here in San Diego there's an office or there used to be an office on every corner right there was an agent everywhere especially out down here in the south bay there's an agent everywhere oh it there still is right there still is right so I was like man what am I going to do am I going to reach out to my existing network and all of a sudden pitch all these agents that I close deals with for their clients pitch and marketing services was I going to do that like I didn't want to be that guy so what I did in 2016 is I literally started removing all of my real friends off of Facebook like my mom my brother my in-laws my cousins my real friends that I went to school with because you can only have five thousand so I started reaching out to to the couple hundred people that I actually knew and I said hey I'm going to start building a business and I need this spot I need you to move over to my Instagram because I have other plans with this personal account so long story short Jill what I did in 2016 is I started requesting real estate agents so when you look at this friend list today every single one of them is an agent okay every single one of them every single one of them except for my wife which is this one right here Malina but a five thousand friends four nine nine nine are agents and so the reason why I'm telling you that is because since 2016 I've literally been seen how thousands of agents are marketing their business and so that's where I came up with all this and I ended up writing a book about it in 2018 it's the social real estate agent five steps to implement on social media to capture more leads and build your personal brand fast I wrote a book about about this and I narrow it down to five steps because as you follow thousands of people you start to see patterns and habits of how they're posting on social media but when you follow thousands of people Jill that literally all have the same job you really start to see some things so I'm I'm seeing how everyone by the thousands is posting their listings how they're posting posts in their open houses how they're posting how badass they are how they have you know how they'll have have your house listed by tonight and have it closed by tomorrow I'm seeing it all and so long story shorter I just came up with these five steps because everyone is online looking for that next lead but they're missing the basics and as I see thousands of pages they're missing the basics and so this is what I highly highly highly recommend that you do and I'm gonna and I boiled it boiled it down to five basic steps and so this will be a quick call because it's just these five steps and once I show them to you they'll make sense and and so unless we really kind of take these steps seriously no one on social media is going to really take you seriously because again no one knows you so here's here's where I would start to to to to touch on what you mentioned help you help you get more leads help you find more people in this area right that's what it's all about here's where it starts though it starts on this personal page we have our personal page and then we have our business page which we'll get to okay right here this is the most important page because this is where you're connecting with the most people Jill and David connected on her personal page as you connect with more people around the around the you know whether it's around San Diego around the country whatever as you connect with more people on Facebook there is this friend list however many friends you have over here it doesn't even matter as that list goes up as you scale that friend list up and the only reason why you would scale it up is because you're building a business if you weren't building a business you'd be fine with 150 friends that you actually know I care right like because but because and this applies for every platform Instagram LinkedIn Facebook whatever as we take that friend count up 95 plus percent are not going to know you so just like Jill and David doesn't know each other it is it's that way for 95 percent of your friends and so with that being said there's information here that we absolutely need to show this is this is what I call step one so as I come to Jill's page and again this is after seeing thousands of real estate agents pages this is where I came up with it I came to everyone's page I'm like wait a minute they're pitching their listing they're pitching their open house but let me look at their page and it's in from a marketing perspective this is just what stuck out I'm like man if branding and credibility is everything in real estate because I know I know when I was in mortgages I had my face I had my license number I had my phone number I had that on everything business cards flyers whatever branding is everything in mortgages and I know it is in real estate so so that's where I came up with this I'm like wait a minute the basic brand is missing I don't know this person they're not showing me much information but yet they're telling me about the real estate business over here and so this is what I've seen on thousands of pages right here in the intro we have a ton of information missing so as people come to this page for the very first time I can look at the image and automatically professional family woman she looks like she's amazing she looks like she's outgoing I can assume a ton on just images alone but again because you're building a business there needs to be some links right here so here's step one I come across Jill's page and she's showing me this right here real estate broker associate at compass former real estate at pacific and then studied studied lists from followed I come across candy's page and candy's showing me a link straight to her business page not her brokers so not only do 95 plus percent of these friends not know you but 95 percent of these friends are not in the business right now unless you're recruiting like a like a kw or an exp and they're out out there you know recruiting actually recruiting other agents unless you're recruiting then I would assume that the majority of your friends are not in the business therefore they do not know that this is not your page so god only knows how many of these friends actually clicked on compass the genuine people actually genuine friends people that want to support Jill they're clicking on that link they're coming over here they're liking the page when that does Jill absolutely no good so I see it by the thousands basic basic stuff so again candy there's a link straight to her business page she doesn't have her broker link anywhere she doesn't have a former broker link anywhere it's simply a link to her business page and that is the first impression because again as I land here I can look at the image and automatically assume whatever first impression but the links are going to direct me to where that business owner is at and so now today we're now in this quote-unquote social media world we're now building our business online this is what's important the business page link to your business page and then down here as you can notice as you notice instagram twitter pinterest linked in her website address now she doesn't have all those links listed because she's a social media butterfly and she knows all about twitter and she's posting every day on pinterest no she simply has it up there for the branding she has it up there for the credibility I come to candy's page I don't know candy from Jill I don't know them from John but she's showing me a little bit more and and and here's what you need to know as a business owner every past client every existing client every future client you will ever close escrow on is literally on one of these platforms facebook instagram twitter pinterest or linked in unless they're in their late 80s they may not be right if they're in their 80s I'm even I'm even somewhat willing to bet that your parents in their 80s may even be on facebook just so they're in touch with you actually no they're not so I'm glad I didn't bet but nine out of ten times that would be the case the 80 year old parent encouraging them so they can see grand their grandchildren stuff on facebook there you go that haven't won that one yet yeah you will eventually and they will cave in eventually because yes they want to be in touch with you they want to see pictures they want to see pictures of the grandchildren if there are any grandchildren that's why even 80 year olds are here yeah but but anything in between the age of let's just say you're dealing with your first time home buyer at the age of I don't know 25 from 25 to 80 they're on one of those platforms so all you need to know from a business perspective is where is my audience my audience is on social media and David's telling me they're on one of these five facebook instagram twitter pinterest linked in so all I need to do as a business owner is at least have them active have them listed on my personal page here and go the next step further and get everything matching one name for all if it's Joe Eastman realtor okay I need Joe Eastman realtor on every platform basic stuff basic basic stuff I think I've got that I think I've got that already linked in instagram pinterest your .com so although you have a compass website what a lot of people do is they have their broker's website and they have a link and they're promoting that link and that link will be a long one Jill Eastman . compass .com like it's a long link right we don't want to brand that we want to brand Jill Eastman realtor .com and when you my website because it's Jill I Jill . it's Jill Eastman Jill Eastman okay so that's the main Jill Eastman realtor okay whichever one you want to go with I'm just suggesting yep the brand with everything well it makes sense right that's step one that's step one and and again after just seeing thousands of pages I'm like wait a minute you guys are all missing the basics and then and even with your page over here you you actually have more than most like most all come to most pages most agent pages and there ain't nothing here and I'm like dang where is your credibility like I don't know you let me show me a little bit more because here's the reality although Jill may spend all her time on facebook as she takes this friend count up how does she know that david doesn't spend the majority of his day on linkedin yeah she doesn't know that had she had her link there I would have clicked on it out of automatically connected with her on linkedin and because I'm comfortable there I would have messaged her there yep and you better hope you get that message especially if it's about buying and selling real estate they come they come directly into my phone right exactly so let's just get them listed over here that's that's step one and then and then not only is that the first impression because it's the very first thing I see right when I land here but also if I want to dig in and see more about Jill I'll obviously click about yeah and then what you're showing me right here is January 31st if I come to candy's page I want to dig into her and say okay what is she about I'll click about and rather than just seeing November 4th I'm seeing twitter pinterest linkedin instagram her website address so so what you want to do is keep in mind that people today are going to literally follow you on social media they're going to message you on social media before they ever pick up the phone and call you yeah that's where we're at today you and I connected on facebook we messaged on facebook we're on a call today and I don't even know your phone number yep right so that's where the communication is at and and if we can get people to follow us on their favorite platform it's a good way to still stay connected with them and and be be top of mind should they ever need us in the future yeah that's step one basic personal page now let me let me pull up your business page what's your business page jilliesman realtor okay so step one also comes a little bit further and it comes to this personal or to this business page over here as well so here's here's the last part of step one as we list everything on the personal page we're going to also come over here to the about section and list everything right here so good job on the on the dot com you got the jilliesman dot com now let's just finish it up actually here's okay so here's here's what i'm going to say first of all take out the phone number no one needs to see your number okay hold on second this is what i'm referring to i already see a mix match we got the user and everything i'm saying when it comes to these names is the user name the at not the title so you could title it whatever the heck you want it's the at sign that i'm referring to that's the username so i'm already seen a mix match we got jilliesman realtor for the username which is what i'm saying customized for everything one name for everything and then we got a different dot com yeah so we're gonna have to we're gonna have to go with one or the other that's just what i'm suggesting you can do whatever the heck you want but i'm just suggesting you know i mean like let's use one name for all yep you know so and i'll i'll show you how to get the dot com like you can keep this jilliesman dot com just to have but you can also get jilliesman realtor.com if that's what you want to go with and i'll show you how to get it for a buck so it's not going to cost you much at all so this is where you want to list everything so i should see right here more info like if i go to if i go to candies this her business page if i click about and i scroll down all i'm seeing is hedge properties hedge properties hedge properties hedge properties hedge properties and this is linked in and Pinterest down here but i don't know why the icon isn't showing but instagram twitter her website address her email everything is one name yeah basic stuff jill basic stuff and i'm just telling you i see by the thousands no one has that basic step down and that hurts their credibility it hurts what we call social proof and it just hinders the ability to even look like a real person you know so that's what people are looking for is that basic those basic links here's step two so that that's step one okay list everything personal page business page here's step one as i'm telling you every single friend except for one is my actual wife okay when you follow that many people you start to get notifications you start to you start to just obviously see the patterns what as i mentioned but just like you over here on your timeline as any of your friends come over here and they click like they share it they comment you get a notification yes because all the minor agents my notifications all day dana invited you at least invited you leslie invited you yajara sally marni every single day all day i get an invite to like a real estate agents page because that's all my friends are real estate agents so when i come to their page this light count is the first impression so i'm telling you since 2016 i've literally spoken to agents about this exact topic since 2016 i've helped hundreds of agents since 2016 i've spoken to about this topic to thousands of agents since 2016 joe i've literally looked at tens of thousands of facebook business pages when it comes to real estate agents in this country i've seen tens of thousands because all i do is i click and then i go i go look at someone's page and i come here and i'm telling you 99.999 percent have anywhere from 300 to 400 likes and every single like 99 percent of them came from inviting our friends on our personal page but the reality about social media whether it's facebook linkedin instagram whatever as i mentioned as you scale that number up not only do the majority of them not know you but the majority of them are going to live across the country you're not going to have thousands of friends here that are all in san diego right you're not there they're going to be from all over the place and that applies for every platform so what we're doing is we're clicking invite to all these random people to get them to like our page and at the end of it all you'll be lucky if you even reach 400 like this other you know gal over here that's going to take you just just to click invite to every new friend that comes aboard to take it to to from 265 to 400 that's going to take you the next seven months and at the end of it all 99 percent of this light count don't even live in the area right and so two big big problems with that is the fact that as you post as anyone post two things facebook is only showing it to one percent of that light count so only one percent of your 265 or only one percent of the 400 that she has here marnie only one percent is actually seen it number two problem is they're all across the country yeah so that's why whenever you post anything you'll very rarely see engagement no one's clicking like because again no one's seen it or they're across the country and they don't care about that listing right they're not in the market but it's kind of a catch 22 because what do we do here's step two you have to run a simple facebook ad to take that number up so i come to your page i see 265 i come to marnie's page i see 400 i go to jason's page i see 100 99 of you guys have a couple hundred likes but then i come over to candy's page and i see 3500 i don't know none of you guys but when i look at that number i automatically assume that she's the queen yeah yeah because she's got more people following that's all it is it's perception i don't know candy from jill i don't know if she just started i don't even know if she's close to her first escrow i don't know nothing about no one this is social media but i look at that number i automatically assume that she's the one to follow so i come over here i like her page and now she has my attention all because of a stupid number yeah and and here's the deal candy three months in the business jill 15 years in the business yeah but no one knows that yeah right that's social proof and so step two is simply running a facebook ad to take that number up and you don't need you don't necessarily need to go to 3500 i'm telling you right now 99 of you guys have 300 so if you just if you just ran a simple facebook ad and took that to 1200 yeah you're better off than 99 of agents none of your none of your agents even encompass in san diego even have over a thousand likes on their page i'm willing to bet and the only ones that normally do is is the actual corporate page so compass the actual business page they probably have tens of thousands because every agent's following the page but as far as independent agent or even independent broker like there's no one that even has a high number i seen i seen them all and so that's step two that is the first impression all we want to do is when people land here they need it needs to be oh wow that's so important it's not even funny that's why i call it step two step three is when you simply let me see if you have any any okay this right here is this you or this male this is male this is me dressed up as male i gave a speech in my toast master's group on wednesday and i thought what the hell i i'm all gussied up in this outfit i might as well do my san diego market report maybe people laugh i freaking love this you have i'm telling you listen to me clearly i've spoken to thousands of people as i keep repeating 99% of you guys fear the camera the fact that you have the nuts to even do this you're ahead of 99% of agents excuse the language but i have no other way to say no no yes it is what it is i've got a sailor mouth like even i have on television in interviews i've done radio interviews no give me this camera i love it right it's just when i see this stuff i get fired up because after speaking to so many 99% of them are not willing to do this the 1% checkmate you've already won now here's step three every agent will take some type of content whether it's a video whether it's a listing whether it's an open house and they put it up on social media and as i spent the last 15 minutes talking about no one cares because every one of our followers are all across the country that's why when we post something very few are going to engage very few we're going to get even very few views like how many people even viewed it let's see six people viewed it so you posted 20 hours ago to your defense it's i mean it's only 20 hours ago but it's still six views your step three rather than just posting it you absolutely have to start running this as an ad you have to you have to have to have to this is step three you have to run this as a facebook ad and target san diego the only people that need to be seen this are people in san diego that is it but the ultimate strategy is to run one like this every single week so rather than having to post every day on all these platforms rather than having to think you have to keep up with posting on your facebook page the heck with all that the only thing you need to be doing is putting up one single video per week and running it as a facebook ad that is step three and i'm talking about it's a step because it's a religion it's literally a religion i need you to run this facebook ad every week as if it was your religion that is the answer to your question earlier how do we get more attention in our local area it's that if you can run this to mission valley or wherever you're farming and you target that local area and it's a new video every week every every friday we go live with a new video and we're running an actual ad that's when you take over jill that's when you take over the heck with social media i need to focus in on a target and the only a target market and the only way i can do that is with a facebook ad and i'm convinced that there's absolutely nothing offline you can do that would be better and that would be less and that would be as as as cheap yeah there's nothing there's absolutely nothing not your direct mail not your door knocking not your flyers nothing zero there's absolutely zero today for you to for you to run a video like this a verbal visual video and get thousands of people in that local market to see it for a few bucks is unheard of yeah but it's a weekly thing you have to commit weekly and that's why i always tell people and i truly truly mean this from the bottom of my heart if a person has to go get a part-time job if you have to have a part-time hustle if you have to sell something on the internet if you have to have a weekend garage sale to free up a couple hundred a month to be able to put these ads out every week you're gonna have to do that that's where we're at you have to do that and and and i also tell people that if you need to cut on starbucks cut your expenses if you need to stop going out of so many you know so many days a week to dinner stop doing that whatever we have to do to cut expenses to be able to put a facebook budget out to target our local market we're gonna have to do that because it's not organic posting posting like this is not going to get us anywhere this could be on linkedin this can be on instagram whatever it's not going to get us anywhere we have to target that local market and and i also tell tell my friends i'm like hey the reality is is the fact that because one thing that people think is that it costs so much here's the reality on the cost rather than six views 20 hours ago we would have had 600 views 20 hours ago and we would have spent maybe about three bucks and those would have been 600 views all in mission valley literally we would have spent about three bucks literally Jill like it's not even funny and so i i i also say all the time to run this as a as a weekly ad because that's what i'm pitching step three it's not just running one ad it's running one every week but the cost let's break down the cost if i spent five bucks a day that's 35 bucks a week to get thousands of people in my local area to see that video if i took you to lunch today Jill i'd spend more than that yeah especially if i took you out to shop somewhere in shelter island if i took it if i took it in my one of my favorite favorite favorite restaurants which is island prime oh yeah if i took you there for lunch i'm spending 50 60 bucks just for lunch so that's why it blows my mind on how most realtors are still tippy toying trying to boost posts when it's like no man like you need to run one every week because it's pennies compared to what you can possibly make so that's how you take over video running every week to your farm that's it i can end the call right here and if you were to take that and implement that you would win you would completely dominate the market that's step three weekly video ad whether you're talking about a market update whether you're talking about a listing whether you're talking about an open house this weekend whether you're giving away a seller guide mo a lot of people love that talk about talk about the process and here here's what i want you to jot down if you are jotting down anything here's what i want you to jot down if it's not a market update if it's not a video on a listing or an open house then 99 of the time it's going to be a video three minutes of Jill breaking down the process of buying or breaking down the process of selling so we're going to educate the seller or we're going to educate the buyer you're going to pick one don't don't try to be all over the place yep one at a time one at a time so the month we're going to educate and it's so if i'm saying weekly ad i'm saying weekly video four ads a month this month we're going to drop four videos and if we don't have a listing that's fine we're going to drop four videos one a week and it's going to be on the topic of selling because we're shooting for listings yeah and so it's Jill on video for three minutes educating me on the process of selling and here's what you're going to do okay so it's either buyer or seller we're going to educate we're going to choose one topic but here is the call to action because everyone will come on video if they do and they'll just they'll just say what they say but there's no real call to action if anything they're saying hey comment below or they're saying hey message me if you have any questions it's not a real hardcore call to action at the end of the video let's say we're focused on actually let me just ask you are we focused on buyers or sellers choose one sellers okay perfect so this is a three minute video on educating me on sellers on selling on selling maybe maybe maybe tips on on increasing the value before i sell maybe maybe maybe maybe giving me three minutes on what the difference is because i know a lot of people are probably confused what's the difference between hiring an agent versus trying to list my home for a sell by owner maybe give me three minutes on the benefits of hiring an agent that's education based yeah so so my point is is that one topic weekly and at the end of the video there's a call to action and here is step four so the weekly video that's step three step four is your call to action hey guys and by the way because here's here's the way the ad looks as anyone runs an ad on facebook in the news feed whether we're scrolling through on our computer or whether we're scrolling through on an actual phone we're scrolling through seeing what our friends are up to seeing what everyone's posting and then all of a sudden we come across a sponsored ad this is a facebook ad dream firms running a facebook ad that's step three the facebook ad step four is when i click on learn more so in your video at the end the very last let's just say 10 seconds here's what your pitching here's the call to action you educated me on the process of selling but now it's time to give me something you gave me education that's one but i want something else we have to entice people and this what what i call bait as you capture leads on the internet you have to give in order to receive so a great thing for you guys to be giving is a seller guide yeah a pdf a simple brochure right so at the end of your video you would say hey guys and by the way click learn more it'll take you straight to my web page this is here's an example it'll take you straight to my web page where you can download your free 2020 seller guide this is going to give you the top 10 simple tips to raise a value of your home before selling yep it's free i'll also send you a step by step plan to getting started they come over here they click the one button they enter their name and email this page is a landing page you don't need a website we need a web page this is what i call step four so if an agent is running an ad they're all they're doing is expecting people to comment or if i ever click on learn more they're taking me to their fancy website where on your fancy compass website there's nowhere to capture a lead right right so i need to take them so i'm telling them in my video hey guys click learn more because i have a free pdf that i want to give you this is the 2020 seller guide it's going to give you this this and this and this it's going to educate you on the process of selling download your free copy now click learn more this is step four david yeah i appreciate you don't know how i appreciate how much information you're giving me god bless you jill and i was with you step one step two step three and part of this is my attention span part of this is some things that i just learned yesterday about myself my brain and how i process and don't process information mm-hmm i'm gone okay i can't take it in and part of it's what's going on probably in another three to six months as i get the brain things corrected oh hey i'll be great but there are some things but let me ask you okay what would you charge me to get get me through step one where everything matches because trying to copy the links and do that happy horseshit i i'm like deer in the headlights my eyes glaze over i'm i got you i got you it's better i get help than torture myself to try to get it done i know i need to get this done i got you and here's where and i appreciate you more than you can possibly imagine you have no idea here's where we start okay that was a ton of information let's dumb it down and here is the next step step one is listing all those links i can easily do that for you i'm not going to charge you nothing to do that step one i can easily list those links step two i want to take this 265 to 2600 that's step two yeah that's where we start so here's my whole proposal you just pay for the ad whatever your budget is whatever it don't matter five bucks whatever whatever your budget is you pay for the ad i'll run it for you i'll list everything for you but you're gonna owe me a good review i can do that let's start there after we get step one everything listed as we get this number up to the 2000 mark i'll have a handful of emails that go out where we can connect again and then we'll start talking about lead capture ads okay but for now let's just get that light count up let's bring some life to the page perfect now what what do you what before i ask that question the my website is going to need to have i think it's the domain name shift to jill easman realtor let's see if that's even available so let's go to go daddy really quick just to see if it's available yeah mine is with go daddy although it's hosted by my website company yes yes so jill easman realtor.com okay so jill easman realtor.com let's see if that's available awesome so normally it's 1199 but if i go through and get the coupon let me see if i can let's see if i can if i can google search for a discount on this because as i mentioned in the beginning i'm going to show you how to get it for a dollar let's see if i can so if i go to google and i type in cheap domains i should see there we go there's the 99 cent go daddy so now if i come in here to try to register it now i should be seeing an offer there we go 99 cents so that's for the first year after that then it's i think it then it's then it goes to the 1499 per year okay but at least for the first year we can get it for a buck that right there is our winning name yep so i can easily register that for you and then and then get all the links listed for you i can list them on the personal page i can list them on the business page and i can have that ad started tonight you just let me know what our budget is for the ad and this is a one-time ad it's not an ad we're going to run every month like we're going to run this ad one time that's step two and then after that we'll talk again in the near in the near future hopefully in the next week or two whatever whenever whenever you're ready but the next step which is step three is taking these videos to capture local leads that's what i want to talk about with you next yeah yeah so in the meantime let's get step one let's get step two what's our budget for an ad let's just look at it for the month let's look at it for one ad what can we put towards it and i'll kind of give you an idea of how many likes let me let me think about that as i'm going through my day today and i'll message you tonight perfect with that budget perfect perfect and you kind of base it off a daily budget either based off of five bucks a day six dollars a day ten dollars a day whatever like if you went five bucks a day for the month that's a hundred and fifty dollar budget so look at it look at it by day and it's normally about five bucks a day so for example if you put five bucks a day and that number we ran that uh that that number would be at 1500 in the next week or so on a five dollar a day budget yeah so you just let me know you just message me later on i'll be able to i'd like to start the ad later tonight so just try to message me sometime maybe before 10 p.m. and i can still start it tonight okay yeah um you know what let's just do the five a day normally when i boost my posts i keep it to about like three dollars a day and i only go like four or five days yeah we're gonna we're gonna go the whole month so whatever you want to do joe and and again that's a one-time ad but but at five bucks a day this number would go through the roof and that's all you would need we turn that ad off then whenever you're ready we start step three and we start branding those videos to san diego beautiful okay so i just need a card give me whatever card i can use for the ad and i'll email you an actual receipt of the ad as well okay yeah give me a minute take your time well you can say take take my time because you don't have to be to lojoya until noon but i've got another call i need to be on it ten you got eight minutes yep yes i do yeah you know it's just interesting especially now that i understand more because what i've found out is going on with my brain you know i would take on these projects and then it's like i can't i get them started i can't keep it and nothing happens so it's like okay jill be smart about this from this point on jill just like you study real estate i study social media marketing so from this point on i am your man don't worry about none of this stuff you got a question you message me yeah you need something done i'll update it whatever the heck you need reach out to me lean on me for this type of stuff because anybody this because this whether whether someone has something going on with their mind or not but this stuff is overwhelming for everyone okay unless you have a natural aptitude yeah yeah or they have the patience you learn it and right now when i see it as a temporary but i have some things that are making it difficult for me to learn this kind of stuff so why i need to be doing this now why wait as i'm making the changes to get the brain working better no just let's do this now do you need like user names and passwords to be able to change on my pages yes so all i'll need to do is login and once i'm done i'll have everything linked i can literally have everything linked as fast as you send me everything so if you send me all your passwords tonight for linkedin for instagram for facebook take your time i don't want to rush you at all so if you have to send to me today later on that's fine if you have to send to me this weekend that's fine but the moment you send it to me i'll have them updated within a few minutes and then you can change your passwords after that okay you mean do me a favor message me your your email because i don't know if i feel comfortable sending that in messenger no for sure for sure i will no nothing in messenger i'm gonna we're gonna email everything yeah so you need username and password yes for all the accounts yes just so i can log in change the name for everything to match and that's it yeah god i don't even know yeah it might take you a little while to think of everything so so don't worry about that don't rush on that in the meantime i can still the most important is logging into facebook so i can start the ad if you got to take your time with linkedin passwords and all that just get that to me over the weekend okay got it um are you ready oh yes yeah it's a visa okay four eight one


Hey guys, it's Anna from CalTV Entertainment and today this star right here is gonna be deciding my weekend plans Okay, so I printed out this map right here of the Bay Area and we're gonna throw the dart at it and wherever the dart lands We're gonna be traveling to okay. Let's do this Okay, take two.  This is the one. It looks like we're going to Oakland baby. Let's go I'll just I'm gonna tell you what I love about Oakland so much the fact that it is extremely diverse There's about every single nationality here that you could imagine. I mean everybody is here So there's always somebody to talk to there's always somebody that you can relate to so you're never really alone in your own culture It's like the home of the Black Panther Party the home of activism historically So if you had 24 hours like in Oakland, what would you recommend that I do? I would say you should go to the cemetery up at the top of Piedmont Avenue First thing I would say is go to Lake Merritt because it's very fun to walk around and ease your mind I guess Boba going around finding good food spots and when we was little and stuff We will always come out here and come to the lake and they just started back the lake fest So that was a really nice thing the riots for Martin Luther King That was an incredibly Memorable I was eight years old when that happened the Black Panther Party for self-defense was founded on my birthday October 15 1966 founded by dr. Huey P Newton and Bobby Seale as a self-defense group Everything from the sick of cell anemia research was founded by the Black Panther program The fact that children eat breakfast in schools for free was also founded by the Black Panther program among other many things It was super fun getting to spend some time in Oakland getting to talk to the cunts people that live here and understand the history behind it I would definitely recommend that you guys come and check it out. This is Anna reporting for Cal TV entertainment and I'll see you guys next time