How to create a content writing keyword database in 2 hours | Jocelyn Steward | Skillshare

How to create a content writing keyword database in 2 hours

Jocelyn Steward, Teaching all that I can

How to create a content writing keyword database in 2 hours

Jocelyn Steward, Teaching all that I can

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
19 Lessons (1h 53m)
    • 1. New

    • 2. 1

    • 3. 1

    • 4. 1

    • 5. 2

    • 6. 3

    • 7. 3

    • 8. 3

    • 9. 4

    • 10. 5

    • 11. 6

    • 12. Activity5

    • 13. 7

    • 14. ACT

    • 15. 8

    • 16. Use

    • 17. 9

    • 18. Course

    • 19. Bonus

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

Content writing is becoming an important field in today’s business. Businesses need solid content to maintain and improve their ranks on search engines. Individuals are discovering opportunities as freelance content writers. Companies are now adding more full-time content writers to their workforce. 

The course combines understanding content writing and a hands-on activities on how to use the tools you already have and other important tools, Google Trends and Quora, to develop a keyword database that you can then use within your own niche.  I work with you through 5 important steps on how to create a database.  You will use a real example on how to easily create over 40 keywords and over 10 future content topics to use for yourself or your business.

The course is especially relevant for individuals who are interested in content writer but are not sure how to get started.  The course provides a system that I have used to develop top-notch content for myself and for others.  Individuals in web writing, content writing, copywriting, content marketing, business owner, entrepreneurs, and freelancers will find the information relevant and easy to follow.  You can walk away in less than 2 hours with sufficient topics to write a month’s worth of high-quality content.


Meet Your Teacher

Teacher Profile Image

Jocelyn Steward

Teaching all that I can


Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.



1. New: welcome to how to create a content writing keyword database in two hours. I'm your instructor, Dr Jocelyn Stewart. I'm an educator who enjoys helping people become better writers, including content, academic, scientific and S. E O. Cut Writing is becoming an important field in today's businesses. This is his neat, solid content to maintain and improve their ranks on search engines. Individuals are discovered opportunities as freelance content writers and companies are now adding more full time workers content writers to their workforce. So then, what's the problem? Many people just don't know how to do it isn't that they're not smarter. They don't want to learn. It's just we haven't really been taught how to do this. So in this course I'm gonna tell you how to get started with some solid foundations to be a content writer. This course has four sections. We provide some solid foundations that are needed, so the first section is introduction to the course. You understand what exactly content running is. You will understand the skills needed for content writing. You'll learn consequent high quality, high value content and you receive information on compensation. How long it takes to create solid content last, you receive important tips that I have found many content writers need. Section two is about actually creating the database. This part, of course, has seven hands on activities to create your database. It is what I used to create content for myself. Others and how I trained people took it started. You will find it easy, understand topics to walk through a stat on how to creature he weren't database Section three is finishing the course. This part of the chorus provides final steps on how to store the data base for quick access and learn how to use the database for a few drying. Section four is a bonus section. I've included a bonus section about a particular area of S CEO writing, and it also includes a bonus activity. In addition, there are 11 quizzes for you to test your knowledge. I look forward to getting started and I welcome you to how to create content writing Cure database in two hours, Banks 2. 1: welcome to how to create a content writing keyword database in two hours. Have your instructor for the course, Dr Jocelyn Stewart, and this is part one introduction, lecture, herbal and introduction. So again, welcome to the course. Taken this course, I'm sure you have some interesting content writing. Content running is becoming an important field in today's businesses. Businesses are needing to write solid content to maintain and improve their ranks on search engines. Individuals, artists govern opportunities as freelance content writers and companies are now adding more full time content writers to their workforce. So then, what is the problem? Many people just don't know how to do it. It isn't that they don't want to learn or that they haven't. Are there just not good at it? It's just that you're just never talk on how to do it, so this course will actually help you to understand ah, lot about content writing. I'm actually get started on proper ways of doing content writing. So let's talk about the course description. In two hours or less, you'll learn the fundamentals of content writing who go through seven activities to develop a keyword database, and then we'll discuss your final steps or your next steps for creating your own content writing. So here's the outline. For the first lecture, we'll talk about what is content writing. Why is there a need for content riders? What skills do you need to become a content writer? How do you find my niche? Its content writing in S E O. Writing the same thing. What are the benefits of content writing? How much do content writers make and how long does it take to write good content? And finally, some tips to getting started? I'm Dr Jocelyn Stewart. I'm a published author with publications in top tier journals. I just people How to Become Content Writers and How to Write s CEO Friendly articles teach people how to create websites that are CEO friendly. I am Austin musician and a college professor that reads hundreds of pages of content we weekly by. Backgrounds include music, higher education, teaching, training and health care management. So let's get started. So what? Its content writing content writing is writing of information that is used in a variety of forms. Blog's social media like Facebook Instagram people's content on Web pages, reports, email newsletters, research papers and books. What I find is that people have a tendency to write in sort of two realms. They other right in, like English 101 type of paper or they write very scientifically research papers and constant writing is kind of smack in the middle is not as formal as scientific writing and as technical. A scientific writing and is not a swarm was English one or one, but it does combine a lot of their same practices that we talk about. The tone is a little bit more casual, and it actually has to speak a lot more to the audience in which you're writing towards. So the question is, which one is the most popular form of content writing out there? If you said blog's, then give yourself a round of applies. That is absolutely correct. So why do you need this course? And why do you need to understand content writing? So content writing isn't opportunity as a new career or as a freelance, or people who have blog's focus only on content, and then people have businesses are finding that they need to have content. So if this is something you're interested in, doing it is a good idea to know how to do it. If you're a business or blawg content drives people to your website and then good content keeps people longer interacting in creating more business for your actual website in your actual business. So what skills do you need to be a content writer? So the most important skill, of course, is to have good writing skills that includes grammar, spelling, readability and using active voice versus passive voice. Also get this active voice versus passive voice, which is probably the one thing that most people struggle with the most when they're writing content. Writing most people right and passive voice at the voice simply means that the subject of whatever you're talking about is the one that's actually doing the work, and you put that person as the person that's doing the actions. So, for example, let's look at two sentences. The lying the lion attacked. The village versus the village was attacked by a lion. So which one is active boys in which one is passive voice? If you said the 1st 1 the wine attacked the village than that is correct. And how do we know well, the person is doing the action is the subject of the sentence. The village isn't doing anything there, the one that's having something done to them. So that's passive voice. Active voice is the lion. The lion is actually attacking the village. Therefore, that is the active voice. The next key skill. Then usedto happen or a person to have his research abilities. One of the things that is important when writing content is to be able to find good keywords. Do you have solid out links? Outbound links that are linked to your website? Knowing how to search for keywords, which we will use extensively in this class is important, but also to know what are good websites. How do you find good information? The next thing is to write quickly within 24 sometimes 48 hours. You need to write Ah, good amount of content for people, and we'll talk about that relationship between quickly writing and how it returns your finances and better rewards for your money knowing how to write to the audience audience. Whether it's scientific parents, college kids are humorous. All have to be taken into consideration when writing the content understanding the knowledge of the field you were writing about, and this is about understanding your niche. We'll talk about that a little bit later. So being able to understand and right towards something that you know something about, and we'll talk about how that's going to be important when you go about writing your papers and how it results in higher compensation for you and then ability to generate ideas, you need to be able to generate ideas, because sometimes you'll be given a task. It's very broad and very not very specific, and you'll be required to go and find a particular topic or write a paper with very little Teoh very little instructions on the actual topic. So how do you find my niche? I'm not a lot of different groups on Facebook, and I find this question to be asked about a lot. So the 1st 1 is if you're already a blogger, if you have a company, you probably already know your nations what you're doing now. And if you aren't in just discovering, I would do the following things. I would think to myself if you're going on a job interview and they gave you the freedom to talk about anything that interests you. What would you talk about? Maybe you want to talk about pets, Children, vacation, food, movies, music, travel. Maybe we'll talk about personal struggles. Relationships. Health are your hobbies. Next thing you want to do is narrow that down a little bit. So choose one that you have a tendency toe that speaks to you more than others and think about how you can narrow that down. So let's say, for example, will talk about pets. So this is my kitten or that was her as a kid, not Sophie. I have cats. I don't have dogs. So if I wanted to talk about pets, I would talk about cats. I don't have birds or fish. Have durables. My dogs have cats. Maybe I won't talk about my five cats talking about what it's like to live with the cats, that having a home with Mullen war with more than one cat. Talk about introduction, new cats in your home, how they shed hair hairballs. Let her cat food. Emotional support. Finding the rat cat sitter and pet safety don't feel you have to be one expert at one thing , so Let's say, for example, you actually like to talk about cats. You like to talk about vacations. It's okay to combine those two together, and in actuality, you might be able to hit a right or topic a writer audience. And it's also nice because you can connect more things and write more interesting things. So, for example, let's say you want to talk about vacation. You might want to also right article about when it's like to prepare for a vacation. When you have a cat or have multiple cats with five cats, I'm not able to take them to a kennel. So I have to have a cat sitter to come to my house. What are some things that I look for? When I look at Hi, I'm a cat sitter. What is that actual cost? What are the things that they dio? How's it as it stressful for cats and such so again? Don't feel like you have to be all of anything, and don't feel like you have to be to mirror of a niche, keep your options open and start talking about things that you like. You can stop there, or you could know it down even further. Right? So maybe you want to talk about litter and a particular brand of litter, and maybe you want to reach out and get some kind of endorsements or affiliations with a person, A company that does litter. So the question I have 2nd 1 that's often asked also is is content writing in S E o writing the same thing? No, they were not so content. Writing is the backbone of S C o writing S E. A writing means search engine optimization, and it is the icing on the cake to make the content stand out and search engines like Google, yahoo and being so now have that wonderful cupcakes at the top. We have the icing. Think about it. Most of us, except for when I was a child, I probably don't want to eat. Just icing are just icing is not very good. People want the cupcake along with the icing, But the icing is really what makes the cupcake really stand out. Most people don't like having a cup cake without icing on it. If you can do both, that is the absolute best. So s e a writing include things like having a catchy title doing long when key toe long tail keywords, including graphics in your in your post. Whether that's videos, infographics pictures means those sorts of things. How long the content is whether or not is 1000 words versus 2000 words those outbound links , the quality of the outbound links and keywords optimization. Do you have enough keywords in your article? Do you have too many keywords? Are the keywords related? Are you doing things that appear spamming spanning? Those are all those important things those rs CEOs. If you can do both, that is the best. So we're actually going to focus a little bit R S E o. But mainly we're gonna look at content writing. I'm flying one time to ask me to make her content on her website s CEO friendly. When I looked at her website, she had about 500 words of content across her entire website. I told her there's nothing to make Seo friendly because there's just not enough content. You have to have something on there for me to make s e o friendly. So at ends the lecture part one lecture, one part one. I see you back for a part two 3. 1: Hi. I welcome back to the course. So in the previous lecture, we discussed what is content writing skills needed to become a constant writer, how to find your niche and the difference between content writing and S e o writing. So what are the benefits of content writing? Well, what if you're writing for yourself? You get to reduce your costs. Some people outsource those two people, other freelancers, and that's perfectly fine. But for some small businesses, it makes more sense to do it in house. But I understand as a small business owner myself, there is a lot of time that has to be done for love. Other things. Sometimes writing just takes the back seat. And if you don't have the skills of how to do content rating, it may take up a lot of more time than what you normally would expect. And if you're writing for others, well, that's a great thing. You have a new career, different opportunities for you. And there's also free lens opportunities, ways that you can earn some side money. The last thing is, content running isn't going anywhere. So for people who are doing it as a business you're going to have to learn how to do it, because it's gonna be very important for you. It's still gonna be important for you and then for those that are going out for for career or freelance opportunities. That's great, because that means there is going to be opportunities for you in the future. So now we get to the part that people really want to know about. How much is a content writer make? So that was that are doing this. As for their own businesses, this will be you might think of. This isn't very relevant to you, but it's going to be important. If you decide to hire somebody, you need to know what the standards in regards to compensation. And as a content writer, you want to know the standards as well so you can be adequate, adequately compensated for your work. Sievers's vault. There are no standards competence. Compensation varies greatly. It depends on how long the content is. The areas of writing so more technical scientific does command more money and the experience of the person, the information I provide. It's just a viewpoint that I found off some Internet searches. Please don't think of this as the all in all standards across all content writing. This is only for ah, few websites that I found off the Internet. There's only for the United States of America. So if you're doing other may be different depending on the location where you are, how much the company is, how big the company is. So but I thought that this was a fairly decent good amount of standards to talk about when you look at content writing. So how are content writers pay? They could either be pay per hour. So, for example, $10 an hour that could be paid per project, so you might have five articles you need to write. You are maybe pay per word, such as 4000 word document, or you can make get this as a full time job, such as The average I have found was about $40,000 per year. The most common way that people are paid is per word. That means that you're gonna be paid up a certain amount of money per word of the content. So let's look at Hemmings an example again. This is one source and may not represent your area, and it varies. I've seen as low as $25 I've seen is that was $5 for Ah 1000 word article and I've seen as high as $100 even higher than that. And this is just again. This is one area and may not be relevant to you. All right, so let's look at this. So this article looked at, How much do you writers? How much his company compensate writers per 1000 word? And that is for just one article, and they separated amount by tears. Five being the lowest here with just a non native speaker. And we look at it and they said they pay people seven cents per word. So that 4000 word article that means that person is compensated $70 tear fours people that are fairly new and they get on average 10 cents to 20 cents. So about $200 per article. And then it goes on. More professional you are, the more you get paid up to $300. Professionals with a little bit more solid reputation. What? They've been doing it for a while or they have a lot of content out there can get paid $500 and then more of your experts might get a dollar and 50 cents. And that is, um 15 $1500. So how long does it take to record contact? Right, So you want to do this? A freelancer or you want to do this for yourself? So how long is it gonna take you? So another study found that 1000 words takes about, on average, 2 to 4 hours to write. So 38% of the people that were studied I found that it took them 4000 words 2 to 4 hours again is this is just standard You might fall into other categories. 46 hours, eight to plus. And then, of course, if you were a stellar person, you could write 1000 words. And again, this is a good content in less than two hours. So let's take this all together because you read this and most of us understand compensation per hour. Even if you're a salary person and you make a certain amount of salary per year, most people still kind of understand they don't know how much money they make per hour, but they understand because they'll often times most people had a job where they earned compensation per hour. So let's look at this. So I table this where I looked at the time, doing the lowest time to the highest amounts of time and looking at it per tear per 1000 words. And then I just did a little simple math and said, for example, for Tier five burning $70 for 1000 words. If the person wrote in two hours they would be able to complete this, they were able to earn $35 per hour. That's pretty good for a person who's just starting. Remember, this is a non native speaker. Then we got a lot when we go all the way up to $8 the eight hours and as you can tell, the more time it takes you, which is pretty obvious. The less compensation per hour you would get so that person would now Onley receive $8.75 per hour. And then let's go all the way to tear one, because that's the one that we strive. Teoh, the one we want. So a tier one person who makes 1000 $500.1500 dollars per article. If they were to write that in two hours, that would be $750 per hour. But if it took them eight hours to write it, it would be $187.50 per hour. So we want to not only created content, but we want to create it faster because the faster you write, the more money you make, the better you aren't writing the content, the more money you can make two things again, the faster you right, the more money you make, the better you write, the more money you make. So you see, there are two important variables and all of this. And so this course will help me to get started faster and get past a big barrier that most people have when they're trying. Teoh start their content running. We're going to get you some keywords in some platforms and some ideas to get you going so you can actually write a lot quicker, a lot faster. So again, we want to make sure that you know when you're thinking about this. Also, as you're taking on a job, think about how much work it ISS. If they are offering something that's $500 you go. Wow, that's great. And it takes you eight hours to do it. 62. Um, I think that number 60 to 50 is is pretty, pretty good. Plus will get tear for $200 for eight hours. $25. Now again. Still pretty good. It's above what the minimum wage is on the United States of America. Definitely lower than what it is where I live. Okay, that's the end of lecture one, part two. 4. 1: This is part three of the first lecture introduction to the course and the previous lecture you learned. How much do content writers make? How are content writers paid, and how long does it take to write good content? So the next part is, what do you need to know before we get started? Four tips for you to get a started with writing a content. My first tip is right about a topic you know about. It is very tempting to write for something that is trendy are pays better, but in the long run, the compensation won't match the pain. If you don't know a good amount of knowledge behind the topic, you'll spend too much time researching the topic. The more time you have to learn about the topic and research, the lower your rate per hour will be. And that is what we talked about in the previous lecture. How do you optimize amount of money that you earn from content writing? So let's look in a particular case. Let's say I just threw out a number just because it's easy toe work with Let's Say you charge on average $25.4000 word article. Someone approaches you about writing an article about light bulbs, and they're going to pay you $100 for 1000 more article. Say you don't know very much about light bulbs are you? Don't even find a very interesting because it's outside your niche. Don't really like it. You take four hours to write 1000 word article about light bulbs. Let's say instead you're able to write one. It takes you one hour to write 1000 word article about your niche. So let's think about that. Four hours, $400.1 article and that same four hours you could have written four articles, and in essence, in the end, you get the same amount of money four times. 25 is $100. So you go Well, you know, that's not so bad. Last thing about some other things. One is the quality of work will probably be not as great as if you were. If you were doing it in your niche, let's say instead also made you get charged. Different rates. Maybe you get $25.50 35 $40 for four articles in your niche, so now it's $150 over four hours, and therefore you may have earned. In that scenario, yes, she would have earned more money. You also have a higher reach, four articles and a lot more than one article you have. It's not as painful writing something about something that you don't enjoy. Researching can be not very pleasant. If you're writing for yourself, you now have four articles to post on your website versus one. Now you can take those four articles, post them once a week, and you now have content for a full month versus one week. So again, it's very tempting to write about something because they're paying more. Or maybe you just haven't found anything at this point in time. Things maybe a little slow, whatever the case may be, and it's very tempting to just to go ahead and write something. But as hopefully as I've demonstrated to you that writing in your niche is much better than writing something outside of your niche, even if it pays more, second tip is to be realistic. If you're starting off, don't think you can write an article in two hours and earn to that earned $1000. You may do it. You may not. We don't know. You may have to start smaller and work your way up. Content writing should be considered more like a job. In any job you have, the more experience you dio and you have longer. You work on it, the more time it takes to gain that experience. But in the end, the more money you will actually make Tim three speed. Honest. I say Too many people claim they can do more than they can deliver. Make sure if you're a freelancer. Review the requirements Don't state more than what you can. Dio. Don't state that you can deliver something faster. Does state that you're going to be an S e o expert when you're just a content. Not just but you're only writing for content. Make sure the quality of work is top notch. The worst thing that can happen is in the end you spend more time working on something, or maybe you don't do the quality of work and then you have to go back and revise it because the person isn't satisfied with the work. You provide it. Maybe because it's outside of your scope of knowledge or your capabilities of whatever process you're at in your career. The worst case, the very worst case, is that they can cancel the contract if you're working as a freelancer. Well, now you spent hours working on something and you don't have anybody to deliver it, Teoh. And therefore you haven't earned any money. The fourth tip is work on your craft. Make sure that when you're talking about when you've decided on a niche that you stay up and read upon the content. So you understand what things are going on in the current news. If you're slow at typing you, speech recognition. If you have some issues with grammar, go back and review things like get a grammar book, find e mails that will send you some grammar tips on a weekly basis, those sorts of things. So let's summarize what we've learned. So you've learned all about content writing. We talked about the skills we needed. We talked about finding your niche. We differentiate between SCL writing and content writing. We talked about the financial money aspects, which is great, and we ended it with some great tips. Now you're a crazier keyword database. Now we'll go to Part two rational to start creating that keyword database. The next up is seven activities that you will do to get prepare for high quality content writing. You will learn how to identify keywords from a phrase of words, and we'll start with our first activity, which is to create a keyword list in just one minute, see in a bit. 5. 2: welcome back to how to create a content writing keyword database in two hours. This is part to creating the keyword database thistles. Lecture to developing your initial keyword list again, I'm Dr Jocelyn Stuart, your instructor for the course. It's time to review. Let's talk about what we learned in the first lecture in the first part of the course, we talked about content writing. We talked about skills that are needed. We talked about finding your knees, the difference between S CEO and content writing the money aspects. And then we ended with four tips before you get started with content writing. So let's talk what we're gonna learn in this lecture. We have two objectives. One is to identify keywords from a phrase of words. And then we'll start with our first activity, which is to create a keyword list in one minute. So let's look at identifying key words. For a phrase of words. Remember that first part in the lecture that says a good content writer knows how to generate ideas? You may find that some requests are very general, such as Will you write me an article about using music to fall asleep or they may be very specific, such as Bright Me, an article that says 10 reasons why you should be using music to fall asleep. I choose the topic using music to fall asleep because I think most people have used music to fall asleep or you at least understand the concept of using music to fall asleep. So let's think about a scenario you have been approached to create 1000 word article using the term using music to fall asleep. And that's what we're going to be using for the entire rest of the course as our activities . So the first step in content writing is to create a list of key words we will use to write the article. And that's what the whole activities were going to dio. So how do we go about doing that? We're gonna do multiple activities throughout the rest of the course while creating this course, I completed the activities using the same steps as we're going through. So then you will get to see how it is done organically. You and I will have different results, and that's okay. So our first activity is to create a cure list in one minute. So the first thing we need to dio is identify the key words from the phrase using music to fall asleep. So what are the key words that we should be focusing on when we develop a keyword list in order to write this paper music and asleep? Right. Great. The next thing we need to do is we need to prepare pretty simple stuff. We don't have much to dio. We just need to open up a word document and or Google dogs. So the presentation, the end of this presentation, what I'd like you to do is open up a new were documented Google docks. Whatever you prefer to use, start a one minute timer, then right down any word that is related to those particular to keywords music and asleep. All right, great. We're ready to get started. So we're going to talk about we did an activity. We have a phrase using music to fall asleep. We identify those phrases. So now we're going to go into our first activity again. Created a keyword list in one minute, open a document, set a timer from one minute, write down all the words you can think of that are related to music and asleep. So you at the next presentation in one minute 6. 3: welcome back to how to create a content writing keyword database in two hours. I am Dr Justin Stewart, Mrs Lecture three. Apart to expanding your keyword list. Part one. So let's review Lecture to which was about developing your initial key worthless. So we identified keywords from a phrase of words using music to fall asleep. We used music and sleep, and you had your first activity creates a keyword list in one minute. So in this lecture, we're going to look at your developed keyword list. We don't talk about something called keyword stuffing, and then we're going to go to our second activity, which is using up the source to expand your initial keyword list. So how did you dio with your first activity? Did you find it hard? Remember that when you do this for your own work, you'll be writing about something you are interested in. It will be much easier for you to do the one mid activity. Even if you got a few things down best perfectly fine. We just want to get started and understand how this process works. So before we actually look at the results of your first activity, let's talk a little about keyword stuffing. So keyword stuffing refers to the practice of loading a Web page with keywords or numbers, an attempt to manipulate a sites ranking and Google search results. You want to avoid this because if you dio do keyword stuffing, you'll be penalized. And so peculiar. Stuffing just means that, let's say, for our keyword phrase, music and falling asleep. We have music and asleep. And let's just say that you just have music, music, music, music, music everywhere, every other words music, music, music and what we used to see was way at the bottom of a webpage. It would just have those keywords music, music, music. So what would happen was Google would say, Hey, look, all of these this Webster particular blawg post or website whatever the case may be, talks a lot about music, so we should actually ranking higher bill realizing that was manipulation. So what people do now is that you use different keywords to describe whatever it is you're talking about. So we avoid putting in on those keywords of music, music, music. We look at other terms that we would use for music. That's very similar. That someone might understand is related to music. So, for example, when we look at the key words, we're not talking about cake. You're talking about music. So it might be sounds might be tone, those sorts of things songs. So that's why we do avoid keyword stuffing. So that is why not only do we do this exercise to get our key worthless going for our own writing, but we also avoid this penalty that we don't. We don't like to be penalized by Google because it takes some time Teoh to recover from it . So we're gonna limit the number of key words that were used. And if you use any of the S e o optimization, um, programs will tell you Hey, you've used too many keywords thing about using less of these keywords. We're gonna use similar keywords like again music sort of music. We're going to use tone song so sorts of things. So let's comparative. It's so again. I did this when I first created this lecture, created the course, and I came up with the following not gonna read a mall and can read sleep, music, classical. And I think I combined the two together Medication. Natural, fast, cheap, convenient, relaxing nature sounds. You might find it easier to do one of the other one. You might decide. I'll do a minute of music and then a minute of asleep, I was able to develop 16 again. We're not gonna have the same keywords, and that's okay. We just want to get something down and get us toe. Start working on this activity so we can create our own keyword database when you are working on your own papers. So we got our keywords. Now we're gonna do our second activity. We're gonna use it the source to expand your initial keyword list. We're gonna do this in two parts. The first part is we're going to expand music. So when using the online the Saurus, we're gonna find neck he words that are not in the original list. And then we're gonna add keywords that actually develop during your search, like key words that come to your mind that you go. Oh, wow. You know, I didn't even think about that. So that ends. Lecture three in part one. Please watch the video showing you how to dio the source and not meet you back for a lecture. Three part two 7. 3: Hi, everybody. And welcome to the course again. Thanks a lot for joining me. So let's just get started with looking at the next part of our activity. So if you remember, we did our results. And for the first activity, these are the key words that we that this is just our freestyling. Just writing down a smoke just began related to those keywords of music and asleep. So the next thing I'm gonna do is we're going to use at the sorest something online for us toe add in those keywords because we want as many keywords as we can. So as we read these papers that you could have a lot of resource is at your fingertips. So I just went to Google search and put in the source here at the top. And then this came up the source dot com just perfectly fine to use. Okay, so we're just gonna start to the source for our first keyword, which was music. So he just hit their music and then we come up with a whole bunch of more keywords. This is great. This is helps us out. Some of the key words Might we minor you have some, we might want to go ahead and at in, and there's actually a whole lot right. We have some other things done here. We have words that made it happen in the top, like Melody Song, Seeing Tune, Rhapsody, romance, those sorts of things. But just we don't overwhelm ourselves within society words. Gonna look at the top part. So what I want you to do then is go through and look at your original one, and you're just going to add in some more keywords into ad in your additional keywords. 8. 3: welcome back. So you looked at the video. So how they use the saurus online to look at the keywords for music. All right, so let's look back again when we came up with So these were the key words that originally, um, Adams are these Look, he works. That added in based off of what I found on the original one that I did when I look at the keywords for tha saurus and I also looked at added in some other ones that I thought were kind popped in my head There, actually somewhere down in the list like romantic, was a little bit further done lists, but again, you and adding a lot don't want to add on to much. But, you know, you could always link it somewhere like on a page. As you're creating a document to say, I'm going to go back and look at this little bit later, or if in the future I needs more keywords, she could easily go there, or you can just add a mall in and then just worry about the rest later. But we don't want overwhelmed you so less is he. But which is the few parts of the top. All right, so here we go. Let's recap. Let's discuss the things that we talked about That. All right, so we discussed keyword stuffing. This is basically why we're doing this. To make sure that we don't try to seem we call spammy to Google. We worked on the first part of the activity activity to we used with the source. Expend your initial key, wordless using music novel. Next lectures. Want to go into the next activity, and we're gonna use So the source again to expand on the next key word that we had, which was asleep. Okay, See you in a bit. 9. 4: Welcome back to how to create the content writing keyword database in two hours. Okay, welcome back. We'll start with lecture for expanding your keyword list. Part two sauce. Review What we do whenever lecture three. Expanding your key Wordless part one. The first thing we did was actually talked about keyword stuffing. Remember, keyword stuffing is what we want to avoid. This is where you put the same keywords in throughout the your entire content to try to make Google make your any other search engine to rank higher. So that was either done by putting in key works at the bottoms of putting in music, music, music, music, music, music, music all the way around or are just putting in music all throughout the entire actual paper. So what we did was we learned how to get around that by using some words that are very close to music but doesn't appear what we casually call things as being spanning. So we did that through activity to we use of the sores to expand your initial keyword lists , which was music. So those again were the down the bottom is what we haven't melody opera piece tune. So As you see, those are relevant to music. I'm not using the exact term music, not just music's or anything of that nature, but this way we can add in content and we don't appear spamming. Next thing you're going to do is you're just going to do the same thing using the second keyword, which was asleep again. So I'm just gonna go online, use your online the sore ISS. We're gonna use the word keyword asleep, and then you're just going to write down those words that you think are relevant to asleep . Then also, if there any other words that you like that seem to develop, you're going to at those in as well. All right, now we'll see you back of the next lecture where we actually will create our first version of our keyword list for our pretend article using music to fall asleep using the key words music. Honestly, Okay. Seeing a bit, go ahead and work on Activity three 10. 5: welcome back to how to create a content writing keyword database and two hours again, I'm daughter Jocelyn Stewart. This is part two continuation, creating the keyword database and now, like sure fives about creating version one of your key word database. Let's review election for lecture for where we expanded our keyword lists are Part two where actually we're looking at asleep. We also looked at the part one, which was about music. So in this lecture, we're going to resume brief resume review my results from Activity three, where we use of the saurus expand your initial keyword list. That was part two. We're going to go to Activity four, which is create version one of your key word database. So here are the key words that I found using the online the Saurus that were about asleep. So I had catching some Z's crash. Dozing, dreaming noticed that these also have a lot more of phrases versus just words, and that makes sense. You know, we do have a lot of little phrases that we like to use when we're looking at sleeping. Also, this is going to be helpful depending on the audience that you have So, for example, if you have a very casual audience, you would use terms like catching some Z's getting some shut eye out like a light. If you are probably doing something of paper that's a little bit more scientific or has a more professional tone about it, you would probably use things like sleep sleeping. You might even use snoring. So this helps out a lot when you're thinking about the audience that you're writing to as well again. I added in words that relate to the assignment, just like we did with music to falling asleep and then didn't remember at any other words or phrases that come up and added them. They're such a sleeping like a baby wasn't in the original top list. So let's go on to Activity five, which is you're going to create version one of your key word database. So just in those few steps that we did, it gave me 46 key words of a can use again. We're going to avoid that keyword stuffing in the paper, and so your database is gonna look just similar to what we have here on the right upper right hands that we have our keywords, music and asleep had the original terms that I included keywords to have for for both music and asleep. I have the key words that I found using the the source for music. And I have the key words that I found using this the source for asleep. So now what you just gonna need to do is just created a word document and have all your keyword list on there. We'll talk about other ways in which you can create a more, more complex database later on in our last section of third section. So next we will use version one of our key worthless to create headings for your sample article using music to fall asleep. Okay, so go ahead and finish out activity for just going and make a tight a document where you actually have all those keywords listed. Okay, seeing a bit by 11. 6: I'm Doctor just Lynne Stewart. And this is how to create a content writing keyword database in two hours. Welcome back. What's finished? We're close for more than halfway there. So this is lecture six, organizing keywords into a sample content writing article. Okay, so our last lecture we looked at doing we looked at what we spow NDA When I did the activity three for the part two. Being asleep only worked on activity for which is create version one of the key word database. So we're just gonna work on continuing with our activity. So this is activity five going to use version one of your key word database to create headings for a sample article. Yea. So we've got our keywords down. Now. We're going to get some key headings in so we can actually start writing an article. So how do we do this? So we're going to organize the existing keywords into headings. So here are some content writing things. We need one. Make sure you have a heading called introduction Conclusion. Now, you may not actually have that listed when you actually write the paper. Most of the time, when you're writing content, you don't write introduction and conclusion you might have. It might be just a part of introduction. That's just the very first top of the paper. And, um, not actually a tireless has introduction, but a lot of people forget that part. So we want to make sure that we actually do have an introduction. Teoh the article, the paper, whatever it is that we're writing and we need to have a conclusion as well, just people tend to forget those two parts. We're going to make sure that when you do write those, those main keywords are in the introduction and in the conclusion The other thing is, have your main keywords listed in at least one other heading and out the paper. The other thing is add on additional keywords if you feel it's coming to you again. So as you're going through this activity and have a video to show you how it's done, if you start saying, Oh, you know what, I really think this could go well here again. Start adding. And there's keywords. That's the whole point of this is that you're creating a database, so they're starting things that's just gonna come up that you may have not found in, um, the other activities. Also, what you want to do is, as you add them on, highlight them. So you know you've used them. Okay, So for Activity five, you're gonna use the version one of your key word database to create headings for your sample article, half a separate video for you to show you how I did it. Then after that, we're going to use something else. We're gonna use Google trends to find even more keywords to boost the relevance of your articles. All right, so go ahead and get started on Activity five. Watch the video and be interesting to see what you come up with. And I'll meet you back here for the next lecture by 12. Activity5: Hi. Welcome back. Thanks again for joining me, continuing with the course. So for our next activity, what we're going to do is we're going to the keywords that we developed. I'm actually create some headings for our paper so we can actually go about writing something. Sets That's what we want to do. We want to do that. Content writing this. Let's go ahead and start looking at what that's gonna look like. So here, again, here is our full keyword list that we've made up for that, um that that sample paper that we're gonna start writing, which is using music toe to fall to help fall asleep. You said with a couple of things of that. So first of all, you want to make sure you have an introduction in the conclusions. That's definitely writing. So we're just gonna write something really simple. We're gonna write introduction and then going direct conclusion, and then our main keywords are two key words, which is music and asleep. Need to be both in the introduction and conclusion. So we'll just put those in there and then to make things easier will just go ahead, highlight them, knowing that we've used us. Now what you going to just do is just qualitatively look and see. What sort of trends are you? Are you seeing? How can you group up keywords into something that makes some sort of sense? Don't have to worry about whether or not it's correct or not. We're just trying to get these keywords down into something a little bit better or easier for us to use when we actually write that particular article. So looking at this, I would say some of the things I could look at would be type of music, right? Because remember when we looked at those first he works with this at that the source. We said there were certain things that we wouldn't want include, like rock music. It's probably not going to be very relevant for falling asleep. Some people it might be, but most people don't particularly like Well, I don't I don't So we'll just say that, Um, while innocent people think about falling asleep, they're thinking about soft music. Quiet. Look, have another key word I didn't we didn't even use soft, so let's look at adding those in so we can just title this this heading as types of music, and you can daughter on anything else. She could add types of music to fall asleep, and then you would go through and say, Well, where? What are the types of music that would follow into this Canada gory Use a classical, add that in not, say focus a type of music, right tech. And then the next thing you want to do is, um, talk about something about sleep, cause remember, we want have those keywords also in the subheading. At least one time. We don't want overstuffed this stuff. And this is what we're talking about using these keywords, right? We're using terms that are associated with music better associated with falling asleep, but we haven't overstuffed our paper with it. So it doesn't look speaking you to Google, which would then help. That would actually give us some negative from things that Google does to your website and and search. Okay, so we have types of music, and you just sort of just think to yourself. Um, what else could we talk about? Um, we could talk about Oh, she this just hateful while as you're doing this and I'm doing this organically with you, so you understand that it's it's not always really fast, but the best thing about it is once we get it done, then when we start to write this paper, it will be a lot easier. So maybe just say tirelessly engines. So must they benefits? Uh, sleep okay. Sleeping thusly might be considered sort of relevant. The same and just really seems on how the CEO program that you use well, take it. Sometimes it's considered very similar, like music versus Muse like, for example, musician versus musicians. Sometimes the essence and stuff are very similar, and they'll consider the same. So we're just going to Dio are Let's talk about this. You see benefits asleep so fresh you'll hit that will dio crushed waken dio. But if it's asleep, uh, released tension. So I actually added in these two together that originally had and that's really what you're gonna do is you're just going to start creating keywords. He worked phrases that going to be used as your headings, which will then use to write. So let's get back to the original version when I came up, wouldn't see what I docked. Okay, so what I did it all. I got lots of different things, so I got benefits asleep again. You might need to go back and double check to make sure that we might need to change this to asleep just to make things a little bit better for the S E O. But for right now, I think just sleep is going to be OK, So I ended it with introduction benefits of sleep. But if it's a music again, the types of music, how will you feel using music? And some of these are not gonna fit, like, 40 weeks. That probably doesn't fit very well with this in this heading as I think about it. But we're not gonna worry about it right now. We're just trying to play some things in there and then a lot of key words that you are not going to use all these keywords. But again, we're trying to get as much information as we can. So when we write your paper, it will be much faster. And then there are some things. Look, more stuff came out when I started Teoh, Look it, think about things more keywords started coming to my head right. So when I think non medication was up here at the top, right, so non medication was up here and then just thinking about it, I started to say to myself, What kind of medication? Ambien. Over the counter? Sleeping pills? Melatonin. So I don't think that you can't make changes. You can add stuff. You could move stuff around, and then we have our conclusion. So now we have our headings. So we have now a lot monkey worse than we started with. We started out with just a few. We added into more than we added in a few more. So this was going to have to be a really great article for us toe. When we actually write it that it will have, um, like keywords in them. The keywords be relevant. It won't look like we're stuffing this paper with with a bunch of key words like putting, sleep, sleep, sleep, sleep, sleep. That's what it means when they say stuffing. So, for example, you might say introduction and it might say something like, You can use music to go to sleep. You would fall asleep faster if you use music, sleep and music helps music. The sound of music helps to you to fall asleep. You will feel more rest ful if you use music to fall asleep. So that's keyword stuffing, and we don't and they don't like that. So the other thing on talk about is the fact of not I'll stop there so I'll finish that right there again. Thanks a lot for joining me again. Hopefully you're learning something, and hopefully it's not too painful. I know it's tough, and sometimes it's hard, but, um, you will get through it and, um, you'll be much better writing great by 13. 7: welcome back to how to create a content writing keyword database in two hours. Again, I'm not a Jocelyn Stewart. This is lecture to using Google trends to ad trending keywords. Let's recap review what? We went over in lecture six, which was organizing keywords into a sample content writing article. So you used activity five Teoh, create version one of your cure database and what you created head headings for your sample article for this lecture, you're going to review the results from Activity five and they were going to go into Activity six, which is using the version one you developed and headings created for your sample article and news Google Trends to find additional keywords to boost the relevance of your article and that'll be version to So what are we gonna do? Activity six First ball. We need to know what is Google trends. So Google Trends is the search feature that shows how often a search item is entered into Google search engine. In a given time, we'll talk a little bit more about that. So free activity six, we're going to use the version one and the headings created for your sample article. We're going to use gold Google trends to find additional keywords to boost the relevance of your article. So here's an example of what Google trends look like at the top has some graphs, some regional information and have some terms and not actually dub another video in which I'll go over it much more in detail. But basically we use Google trends to basically find what is actually trending today. If you want to talk about a topic, this is a excellent example of what a graph looks like. Talks about the interest over time, and you can change the time in which it is interest. So if you look at this school of this red line down here, let's say this is your topic that you're writing about you finding it's not very trending, but you're sort of interested in. It's in your niche that all of sudden you start seeing a spike, and this spike means that for whatever reason, there are more people searching for this particular topic. Then that gets you excited and say, Hey, let me go ahead and go back when you start writing. Some articles are riding some block post about this because it actually is very interesting , and it might actually gave me some traffic to my website. And when the blue one blue has got some peaks into it and down peaks and down. And there's all sorts of reasons why holidays, you say peaks different times of the year. You see different peaks, things that happen in the news. You see all different types of peaks, so there's just a lot of reasons why. But it's a good way for you to understand. What are people looking at and how to add things onto? Make my content more relevant. Okay, so I have an activity that we do, and I have a separate video that shows you how to do it. Sorry, cat. We discuss Google trends, and we're going to go ahead and complete activity six. I'll show you how to do it. And Activity six is going to great version two of our key word database using Can you work trends? Google trends. After that, after you watch the video and creature database using keyword Google trends, you'll use Cora to refine papers that we are writing and then find new topics for future articles. Okay, see you at the next video 14. ACT: Welcome back again. So goingto Activity six, we're going to use Google trends to find what are some trending topics relevant to our keywords. And it's just one of the tools that people use. There's lots of areas to use, uh, trends and find keywords, and we like to use them because, really, all those other places really just use Google Google trends. And and because Google is a large search engine that people use, it's just a very relevant thing to you. So what we're gonna do is we're actually going to just go to Google trends, put in theirs keywords and see what it looks like, what it comes out with. Okay, okay, so I just put in Google trends into my Web browser. All right, we're just going global trends and it comes up. It's very easy looking nothing too crazy or not, and I'll just get a little brief overview. What it tells you is one is what are some training? 10 things that are taught happening on that point time. United States just won the World Cup. Um, Taylor Swift, Kim Kardashian. Those sorts of things were acting. Worry about that stuff, right? Yeah. So the easiest thing to do is just actually put in that phrase that we're going to you. So we're going to use using music to fall asleep. Just put that in. We'll see what happens. Oh, no. There isn't anything. So you think Oh, my goodness. What in the world do I do? Well, not problem. You have so many ideas in your head instead of adding in that phrase, let's see if we can just cut it back a little bit. So let's use instead we will use music and asleep. It's no sleep. Right. Okay, there we go. Now we see some things that are going on, but then we still have nothing. That was really Give us some information. Oh, no. Now what do we do? We go back and say What? ISS? What was the thing that I talked about? Asleep. Maybe asleep isn't the term we need to use. Maybe it's just sleep. So let's change that to music and sleep. Now we're getting somewhere. Hopefully scroll down. They're ago. Now we got some stuff. Awesome. I haven't go much into this, but really briefly, What this does is that it shows you some interest over time, right? So we're right here. It's actually about the 7th July. Okay, so there's a there's values, Remember? Reckon we'll worry about it, but you can see things go up and down. It's been sort of study. It's a little bit of a down. Maybe it's starting to go up a little bit. Maybe people are just interested in sleeping better in summer. I don't know. We're not worried about that. At least is not something down here way would like things that are light, like on the top, because that means that people actually searching for those things and we want to have content that people are searching for. So Google will actually put us almost pages and people look and then it tells you some areas that people are searching for that particular keywords that again, not going much into this information would just to show you what this information is about . But what we're looking for its this down here, which is our actual keywords that we're going to use. So we would then go back again and start adding in those keywords that maybe we didn't have before like, for example, fatigue, medical conditions, Christian music. I know that wasn't on my list and being music, musical genres, memory, feeling, we don't have any other source of things, and then it gives us up to 19 topics. Wow, there's a particular song. Thunder, Things like that Depression moves. Maybe we can act that in about how people who don't get enough sleep can suffer from, maybe suffer from depression. We want to make sure to back it up with the right data. Um, jungle sounds thunder eight. Those nature sounds. A lot of people is full sleeping, and there's piano, musical instrument noise, maybe reducing of noise. Anyone? I find some topics that are just really not relevant or it may be too much for really don't want to have it on there. So, for example, Thunder Song by Imagine Dragons. I may not put that on there because it's in a year or two. That's probably not going to be very relevant, and it just happens to be there because of the song Thunder. And people like to listen to thunder sounds when they fall asleep. So this is a key word that I may not use in my search, and then we see some other stuff. What it says, Hey, look, you know what? People are also searching forcefully music to sleep and relax. So maybe relaxation might be something that we use in there, and you can actually I'm click on that and see what those trends are as well. But even this is up. There's nothing there. Right? So it looked like there 1st 1 was the one that was interesting. Interesting enough. I actually does this. Did the search earlier during the day, and there were different keywords. So it it happens very much, or gangly over time as well that things change and you can actually make it even a little bit shorter. You say Well, what you're looking at in the last hour. Shorter you have it. The harder it is they have all the way from 2000 force. You can see sort of the organic how it's doing since 2000 and four. But I think just the original one that we had it was past 12 months is sufficient enough to give us information. So let's stand back over here. So the first time we did it, we to retrieve no data, which is fine. We just needed to make things a little bit different. We changed the music in this leak again. We got enough. Just We need to have music and sleep that gave us some works at only the stuff that's relevant. So, for example, when I first did this a few hours ago, it had apnea as number one. So now we have something completely different. Which iss, um, let's go back Music. We just wanted to, you know, music. It's sleep then that music to sleep music. And so you notice how it does make a difference how you sort of put those words in. I don't know why this is good. Such Oh, forgot to issue from mystical 12 hours, 12 days Now do something different. We have nightmares and autism, but we still have fatigue that Greek. So if you start manipulating the stuff, you do get different information, but definitely something that I did not have in there. I believe I didn't have fatigue, but I didnt have ambient music. We talked about thunder, but other things problem I had to is they started. So I started looking at these keywords. R e m sleep started to come in. That and the original. There were other keywords that weren't very relevant. Like, for example, Mac Book was in there. I wouldn't have anything about a Mac book, but you never know, right. You may be able to have that in there, such as to avoid disturbing your sleep. Don't play the music on your Mac book, Play it on. Maybe your, um, your sound system. Or if you have an Alexa or something like that. So what's the ways in order to do that? So that's Google trends. It takes some time to get used to it, understand how the keywords work, but it gives you even more relevant stuff. So when you write, those articles view, these are words that are actually popping up in people's key works Sarge's. And if people are popularly talking about our actually searching about it on the Internet, then Google's want to rank that article lot higher. And then that's going to give you that ranking score the Arab eyes, looking for when they're writing their content, or creating the blog's or their websites or anything like that. So that's another tool for you to use to look for some current trends and add it in and less at again. Avoid that keyword stuffing we've got now some extra stuff with violins, musical instruments. Gaskell, the first time had Christian music. So again, this is just another tool for you to use when you're looking up. New keywords to add for your papers or your articles or your blocks or here articles or something. All right, thanks. Seeing my son. 15. 8: This is how to create a content running keyword database in two hours. Lecture eight. Using Cora to create future article space on the keywords provided again. I'm not a Jocelyn Stewart. Let's get going. So review of lecture seven. We discuss Google trends. My Google trends helps us define whatever keywords are trending in the Google search. Consoles were completed. Activity six, which is create version two of our key word database using Google trends. So for this lecture, we're going to understand how to use Cora and Core will help us to the refined the paper were writing and find new topics for future articles. And we will do Activity seven, which is used the initial keyword to find and create future articles from Cora. So what does Cora core is a Q and A or question answer website, where you can ask questions to the community and get answers, obviously, to find what people are talking about. It gives things to us as a question format, which is a very S CEO friendly way of writing, and I'll help you to drive traffic to your website. But answering questions on core and linking it to the article and I sure how you to do that on the next lecture? Video. So what is it that we're going to do now? We're going to use initial keywords to create future articles off a Cora. When use keywords to find questions, people are asking about fine additional keywords or phrases to use. Better refine existing headings create future articles, because that's what we want to do. We want to create this database databases, help us the right faster from a writing faster gets its more money and then drive traffic to your website. Okay, so do recap we discussed Cora. We talked about how to do activity seven to use the initial keywords to find and create future articles from Gora. On the next, we will finalize the chorus. Wrap everything up. I'll talk about what you need to do with your database. Okay, We're almost there. 16. Use: Hi, We're almost there. This is our last activity for this particular course. So this activity is about using Cora to better get us some more ideas on more keywords that we can use headings toe actually include and actually to look at different articles that we might be able to write in the future. So let's look at Cora again. I'm just using Google manages, typed in core at the top. And that was the 1st 1 I had. So it was just open it up and see what it looks like. So I'm already on Cora and actually do answer some questions on Cora and has some little things that are about myself, that kind of topics that I tend to write about follow. And so here's some requests for me to answer some questions and some notifications. But if you go here, all you need to do is ask the same sort of thing. So we'll just dio using music to help to fall asleep, to follow asleep, fall asleep. Okay, now what it does, it gives us all these questions that people have asked about that particular topping where people have a lot of information that people rather answer questions and you can see let's go to the top. So here's the question up here. What kind music do you use to fall asleep or concentrate? It's got seven answers, and you just click on it and actually gives some feedback in some information from people that have done it. Okay, now, when you're going for actually getting this information for either doc tickly read the answers. But let's say there's a topic that you just maybe there's heading section that you're just sort of stuck on. You don't know what else to talk about. It might be a good idea to go on here and look at what are some things that people do actually answer about. So what do you do with this, then? As you say, Okay, well, I want to take this question, and I'm actually going to write that question into my database. So what kind of music do you use to fall asleep or concentrate? Well, maybe take off the concentrate. So what type of music do you do? You use to fall asleep? All right. And then we could just go down, and you see, sometimes they're just not very relevant. Why can't you wear hoods and a plaster and vast mother relevant question? Can tire soldiers always fall asleep? You know, made. Maybe that's something you want to put down. Maybe you do have an interest in military or fatigued people who are very fatigued or something like that, or stressful situations. Remember, having those niches are also about looking at how you can expand your topic to talk about different things. So the more you able to talk about and write about different areas, the more outreach you'll actually get. So you could just keep going down and write stuff. How do I fall asleep in one minute or less? I will go back to How do I fall sleep and one a minute or less. Okay, so there we go. We just keep going down until you just get tired of actually and certain they're sort of reading all those questions and then house stuff like, What is the scientific evidence again? Something's Or maybe not. May Mandel's relevant that you might be surprised you might be able to use them. The other thing. I won't go much into very much of in this particular course is that you can link articles and Cora to help you drive traffic to your website. How this works is that core does not allow you to link to your website. When you answer the question up in your profile, you can have links to your website. What it does allow you to do is linked to an are cold that's relevant to that particular topic. So let's see here we got 36 answers wondering if there may be an article in here. Let's go down and you can actually comment back and see if we have an article. Them starts to go down. All right. So he linked here to something. Um, probably not the best thing to link to people. That's not your particular website. It's better to link to your website. This may be one. Let's go down. Let's go down. Oh, this was not done correctly. So we'll keep going down. I want to find one. No. So this is wrong. So don't ever do this And core. Don't ever put something that has nothing to do with the topic. This is some. This is probably some sort of link he trying to dio don't ever do that, you will actually get banned from chorus. Don't do that. But you see, how is the person's credentials on there again to keep trying? We're gonna find one. Find more helpful. Look you going? Oh, here we go. This is one hopeful it. No, he did it to em. Is it OK? But you can sort of see what he's talking about, what he does. So this person actually wrote an answer. And when he wrote an answer, he limped it to this article. Don't link an article. That's not yours. So what the person would be better off doing now is okay to do this because you're linking it to an actual article that's relevant to the actual topic. And that's perfectly fun. The batter thing to do is link it to your article that you wrote. So after you've written this article, let's say this is your blawg and you've written the article. What you then do issue right down a response, and then you link up the actual question actual block post that you have. So let's just assume that this is not a natural block post. Let's say assume this is a block post. So we go back up, I'm gonna answer Pretend I don't want to answer the question. So else I want to answer it has my credentials on it. Say blah, blah, blah, blah, blah, blah. I'm not gonna post it blah blah. Now what I can do is highlight it. Look here, and I then link, put it in a footnote and I add it, And then when it posts, I don't want to post because it's not correct. It will actually lead to the actual article. So now, person, if it's your website, then they can go to that website. OK, so we're going to, um we're actually going to just release this. Let's do I guess we can just go out and hopefully just goes away. Okay, So how do you then use it? Us Go down and again. Thes questions change. These were not the same questions that were in there before, So these were the questions that I had, but that had it. What is the best way to falsely? Quickly, Falsely, faster? How many's could happy fall asleep at night? Eccentric Such a Then what I do is say OK, why don't I take this particular question, and sometimes it's just to rewrite it based off of what I am running about. So what are the best ways to fall asleep quickly? My topic instead is how to use music to fall asleep quickly. Same thing, right? Very, very relevant. Um, are sort of plays on the word. So how to use music, fall asleep faster and sleep better. What could help me fall asleep at night? Hey, um, you can use these as your headings. This is a good one is music and effective long terms a women. Now, this is mine. I've switched them up. Okay, so I'm sorry. Me, I remember this. Let me hide like this. Okay, so this was the actual question that was a little bit earlier. Is it possible to manipulate brain waves to be able to fall asleep faster? Right. So I didn't particularly like that one, but I did say I'm maybe we'll write samosas how music affects brainwaves to help you to fall asleep faster. Now, if I'm a little short on keywords or content in my original paper, I might actually go and find some information about brain waves. But even better yet, Still, this could be a completely new article. Let's say my niche. This is my blawg. I am a sleep psychologist, therapist or sleep behavior disorder or something like that, and my blog's about sleeping. I may have a completely new article that talks about using music to affect the brain waves , happy to fall asleep faster. So not only now do I have a possible new heading our new section, My Peeper. I also have new papers that I could write in the future. Look about this one. I'm 15 and I can't fall asleep. Fall asleep until two AM What do I do to help me fall asleep faster? Instead, I wrote this as can music help teenagers fall asleep faster So as hopefully you can see where the trend is going, you start building and start building and start building because this is what we want. We want you to go and when it's time for you to start writing, have a whole bunch of keywords and questions and ideas already in a procession. So it doesn't take you as long to write the content, and you actually have more ideas for you to write. Content for your blocos. Remember, write about things, you know, write about things that are going to be quick and easy for you, Dio. And doing these sort of exercises will help you to create databases that you can then use in order to create content a lot quicker and faster. And, of course, if you are doing this as a freelancer, then you would be able to make a little bit more money. Yeah, and that's what we want. More money. Right? Okay. Thanks again. This is our last exercise by 17. 9: how to create a content running keyword database in two hours. I'm not the best student. This is Heart three. Finishing the course Lecture nine course wrap up. So let's recap our last lecture we discussed Cora. We talked about what it was, what it did. It's a Q and A. We actually looked at how use Cora and we actually went through and that some possible future topics based off a Cora and we did our final activity, which is you use the initial key work for the article. Define and create future articles. Offic aura. So today or this lecture, we're going to review the steps to create a database and discussed new steps for for the discuss the next steps for your content writing so steps and creating the database. We'll just pull it all together. You can we have your keywords that you initially came up with their the keywords from the source. We have Google trends, and we have Cora, and you have a choice of however you want to put it together. Whatever you're comfortable with, you can put it in a spreadsheet. Just keep it in a word document are actually creates more toward a database using like access. I do have an example of how I would create the database listed as a resource in the course , and I just used Excel. So now it's your turn. Now what do you do? You got all this? Let's talk about. Go back to your niche. Think about what you want to write about. Repeat everything that we did. This is exactly how I do when I actually write my own content or help people to write content or review content. Look up. Other keywords Add more if you want to. The saurus Google trends, Cora And then, um when you do right, you have Elissa keywords you use and then you want to use to keep miss list the keywords that you didn't use and this way we're going to avoid duplicate content. So what happens is when you use duplicate content across the wet across your brow across your website, Google doesn't like that and I'll flag it and say, Hey, you know, you have different duplicate content. You just have the same thing. But using these keywords actually help us to make sure we don't have duplicate content that looks like we're actually bring some new stuff over. No, we're writing new stuff. Don just repeating the same stuff over and over again and then use those keywords when you're creating hash tax for social media. It's very easy now to do that. If you have the key words available for you, so then I want what we do. Well, you keep them somewhere safe. You can put them in a folder on Google Drive or your computer. So we've gone through this and Recep, you know west the benefits of the class. Hopefully, you understand some things. Let's see, you've done a big chunk of work having keywords, having a lot of keywords, and we saw that we didn't get all of them, that we decided to just stop at some point. You know what you can write about So you have some ideas. Things are probably in your head. You can create your content a lot faster. Did you have those keywords to pull from there when you go for a job interview and they ask you how how do you do it? You can say, Oh, I do it by doing X Y z. I start by organically looking things up. I use Google trends. I use Cora, and then it's just a facet. Fantastic opportunity for you to become a better content writer. Or if you decide that you actually do want to do this for a living. So these are some resource is for you to help you out. So so long for now. Now go forth and right. I do have two more videos for you. One is a rep for the course and then have a more bonus for us about long tail keywords. 18. Course: Well, that's it. We're done is not really exciting. I think it iss Hopefully you learned some things that I was able to teach you a few things about how to create keywords, create a database, how to find you. School trends defined the things that people are talking about how to use, um, Carod to find some future topics to talk about. And this will help you to be able to write content faster and also to help you to write better content and more content. So then what do you do? So certain things just really depends on how you prefer to create a database, for example, the easiest way to do it. I will not use this weight. It depends on what you like. You could create a new folder in on your computer and just call it, um, topics underneath. You block topics, and then you would put the version Teoh and then the core document in those particular things. And you have it. Another thing you can do is actually do create a database where you can use excel, or you can use access. And then what you would do is you could take those those keywords and actually list them all out and you would maybe list them out. If you were using Excel, you could do to different tabs and say, You know, um, using the the actual assignment are the article that you're writing using music Doubt. Fall asleep. You say I use thes keywords and then I didn't use these keywords. And what happens is thumb when you use keywords more than once and you use them sort of heavily in your in your on your blawg or your website. Google comes back and says, You got you have duplicate content and so it likes you toe have, like fresh content because the thought is when you copy and paste the blogger over and over again and look like you, you're writing stuff. So Google does like it. Our search engines will just like it if you have new content, so you would take and say, Well, I didn't use these keywords. So my next article that I write relevant to something about music or sleeping, they have those keywords that I haven't used yet, so it doesn't look like I'm having duplicate content. The other thing to do is use those keywords when you writing your social media posts when you're now going to promote those your block post and you're going Teoh, use those for social media. It's so you could mind, you know, hash tag line asleep. Hash tag, um, insomnia. So all of those keywords now you have you couldn't directly create them overthrew using hashtags. And of course, there's more things about, you know, hashtags and things like that that we don't go into. But anyway, that you can get things out quicker and faster. It will be easier for you. And in addition, if you are using this for you're your own self, what do you are using it for freelance work. Now you have keywords to use for the next time somebody comes to you about that particular topic. Let's say you really like talking about that. That's a list of keywords, so you don't have to keep doing this over and over again, and you can write a lot quicker and faster. So if somebody comes back and says, maybe you focused on non sleep as music is being a non medication and then so maybe you talk. You kept that core document you wrote something about on the side about teenagers or something. Now somebody ask you. Hey, I see you write about, you know, sleeping and Musee. Can you write about teenagers and sleeping in music and go? Yeah, sure. So I have those keywords available for you, and then now, with skills that you have is easier for you to go and find those keywords a lot quicker and maybe what you had before and then so on. The other thing is that now you're able Teoh have a systematic way of talking to people. If you're applying for a job, you're trying to this full time Or if you're trying, Teoh create ah, business for yourself. Or if you're trying to bid on on a contract or something that people want to ask. Well, how do you go about how would you go about finding or doing this work? And you would say I would organically, you know, decide on some key words. I would then go, and I Google trends to find the relevant keywords. Then you score out stuff like that. So when you actually talk about resource is that you use first just saying Oh, yeah, I know how to do it. Yeah, that gives you some credibility behind yourself and be incredible means more money. And we want to have more money. I really and hope you enjoy it. This this course enjoy creating it. I love teaching people about ways in which they can better themselves and make more money and, uh, maybe keep things more in house. If you're a small business than you're struggling with up, you controlling costs, outsourcing. This could be quite expensive. If you do it well, if you know how to do it, then maybe you can outsource a few other things, like maybe just the graphics or something like that. So I hope you enjoyed it. And hopefully also you sometime again in the future. You're more than welcome to reach out to me. If you want to just give me some feedback or whatever. Thanks again. Bye. 19. Bonus: this is out to create a content running. He were a data base in two hours. Your bonus lecture. This is about an S e o tip. That was really important. I thought you should know about which is about long tail keywords. So what exactly is long tail keywords? Long tail keywords or phrases which are very specific to whatever you're selling are writing about. And what happens is they helped to lower the competition and won't give you a good example of what we're talking about. So this basically says that you give a lot of detail about what you're writing about or what you're selling, whatever the case may be, so that the more you kind of make that key were expand out, the less other people are using those thing he works to describe their goods or services, whatever they're selling. So what's like, for example, that you sell running shoes? Also, you sell athletic shoes and a person goes on the internet and they say, you know, I would us always want to run a marathon, and they know any could choose whether don't exactly know what shoes they're gonna get. So then maybe they first start off with saying running shoes. And then they have off roading, shoes, triathlon shoes, shoes with little toes on him. And then they go. You know what? That's a really that's not getting what I want. So they start. What are the best shoes for running marathons? This is similar to what we had talked about Cora. That might even go. They might even go further. And there's a best beginning shoes for running marathons. They might talk about best brands, colors, pricing, female, and then they decide on one and they go back. They say I want the best peak shoes for female beginning marathon runners. Okay, so let's look at how this looks on the screen. So we have this, um, graph here that actually talks about basically this long term. Keep long tail keywords. So if we're up here at the top, top left corner of the actual that here Rio So I wasn't going through. This is high competition in low conversion. That means that there's a lot of people who talk about those those things. They're very genetic. So it's athletic shoes, marathon shoes, Nike shoes, things like that. Now, the more you actually get specific into what type of shoes were talking about your selling . Whatever the case may be, the competition's lower. And that means you have a higher conversion Mean that more people will go to your website. You More people would buy your goods or services, and, um so if you look down here, the bottom Havel pictures like some generic shoes, right? And then you have something like, Oh, those really looked like running shoes. So they're pink. They may look like running a marathon shoes on Musharraf. They are. They are specific types. So whatever the case may be, the more specific you are, the better it is for you to break. And that's what we want. We want to rank or, you know, if you're not ranking, you want to provide content that is in that long tell keyword realm seven bones exercise for you. I'm gonna play a song for one minute, and I want you to write long tail keywords for a topic using music to fall asleep so you can go back through your old Just think about the things that you came up with when we talked about music and falling asleep. We've done a little bit of this already, but let's just say what you come up with. Just how could you take any part of our keywords where we have music asleep? And how could you write something some keyword phrase to make us understand to Vegas rank better to make us rank higher if we're going to change the end to a long term now I'm gonna play a song for one minute and then I'll get back to you after the one minutes up and then we'll just go over my answers and we'll see what we're talking about. Okay, okay, let's see how you did. So let's go back again. Music and falling asleep. So are looking at music to help us to fall asleep. Let's look at this one top 10 classical music songs to have you to fall asleep. So where is the long tail part? On this? It is classical. We talked about classical and its song, so you can sort of think about like some adjectives and way to describe it, something that would make people go to your website because they're looking for classical music gold songs to fall asleep so they're wanted that they may ask. Think about the Kora. What air? Someone? What are the top classical music songs? Happy Fall asleep looking another one. And remember, years don't have to be the same. We're just going to try Teoh, just looking at an activity. How to do this unique music that helps you fall asleep fast. What are the long tail keywords on this unique and then fast right, because some people like falling asleep. But are people really want to fall asleep fast and then unique? Right? It's, um so instead of just classical music or what are some things other people are using? Or is it some kind of music Not in your in your culture or something like that? We don't know. I was playlist 20 rock music songs that will help you fall asleep. Remember, that was one that came up, were actually discomfited, and I said, I rock music. No one's gonna listen that fall asleep, right? So maybe you say I was wrong. You know, there's a lot of rock soft rock music, a lot of great ballots that wouldn't probably help people to fall asleep. Music the most natural cure to help you fall asleep. It's the most natural cure, right? We talked about, uh, how we want to avoid things like Ambien and sleeping pills and stuff like that. That's what. Be nice to having trouble falling asleep. Put down the sleeping pills and listen to music instead. Right? So this would get people who were looking at not taking sleeping pills. We will be looking at people who wanted to listen to music. We wanted to target people who are having trouble falling asleep. So this would be a very good long term long tail key. Were because we're hitting a lot of different words and adjectives that describe what we have going on. Okay, so we recapped. You learned about long tail keywords and try to incorporate those more into your work as you go forward and you actually start doing your writing. Thanks again to help you enjoy this bonus content.