SEOClerks

10 YouTube Marketing Tips and Tricks



Write the reason you're deleting this FAQ

10 YouTube Marketing Tips and Tricks

Hey there everyone!

I recently had a client hire me to optimize their YouTube videos, which I thought was second nature, but I guess not.

Well, their lack of knowledge lead me to write this up for everyone 10 YouTube Marketing Tips and Tricks It basically covers a few things that I did with their videos in order to help them get natural views, likes, comments, shares, etc.

Enjoy! 10 YouTube Marketing Tips and Tricks


1. Optimization: First off you should always start with the tool directly available to you through Youtube. Now I'm not talking about advertising, I'm more referring to your titles, descriptions and keywords that are specific to your video. Do the proper on page optimization of your video and it will go a long way.

2. Call To Action: Get people to click, like, rate and comment by using call to actions (links) in your video or descriptions. You can pull people pretty easily to your website with a well placed link.

3. Friends and Family: One way to get your initial boost is to advertise your new video to your friends, family, colleagues and customers/clients. I don't normally do this, but for a new YouTuber this might be the best way to get a few views and likes on the video.

4. Get Social: Take advantage of Facebook, Google+, Pinterest and Instagram. Make business profiles on those platforms and be active. You can pull traffic to your YouTube video this way and the people clicking through are already interested so they'll probably like and/or post a positive comment.

5. Your Website: Add your YouTube video to your website. Even if you only get a few visitors a day, week or month it's still a good idea to have it on there.

6. Newsletters: If you have a newsletter already going out to your clients, friends, colleagues, etc. Be sure to add the URL of your new YouTube video for them to check out. Bigger lists will obviously show better results, but you never know who will share you links if they see it in an email.

7. Get Indexed: By getting your channel, and videos, indexed in the search engines you'll be increasing the chances of obtaining views, likes, comments and shares.

8. Printed Material: If you own your own company and you have printed material for it, be sure to add your YouTube channel URL on the documents so people can check it out. You won't see a huge ROI on this, but it will help a little. And since the URL of your YouTube channel doesn't take up much space, it will be easy to add to all your documentation.

9. Paid Traffic: Try out PPC (pay per click) advertising through Google, Yahoo!, Bing and Facebook. These platforms, especially Adwords (Google), can bring in loads of traffic in a short period of time. And if you're not in a difficult niche, you can pay much less per click.

10. Hiring Someone: If you have the funding, try hiring a good marketing company to help you advertise all your videos and tweak the on page optimization of the videos in order to get the best outcome. Hire them for SEO (Search Engine Optimization) and see if they will help you out with your YouTube videos. Doing it this way should save you a few bucks.



Those are a few little tricks you can do in order to get traffic to your YouTube videos 10 YouTube Marketing Tips and Tricks
Not all of these tricks are free, but they all will help 10 YouTube Marketing Tips and Tricks


Thanks for reading!

- Razzy

Comments

Please login or sign up to leave a comment

Join
idealmike
Great tips Raz! They're something we can all do on our YouTube videos. One of them asks more questions than it answers though. Tip 7 getting indexed. Getting your videos and channel indexed in the search engines will increase its chance of being returned in the search results both on the main search page and on the videos tab too in Google search results. But how would you advise and recommend people to actually go about getting their videos and channels indexed? Of course, some of the other tips you've gave will help with that such as sharing it on social media and on your own site and other sites you might have such as your Web 2's. But other than that, what ways can you suggest for getting your videos and channels indexed in Google?

That touches on something else actually. Your YouTube channel. It's a URL and a webpage like any other. You can do SEO on your YouTube channel URL but a lot of people don't and overlook it! If you already have a big channel with a lot of subs and your videos are doing great there isn't really need to do that but it can still help. But if you're not and you're a new YouTube channel, it could be worth SEO'ng your YouTube channel URL the same way as you might your actual main website URL.

Some ways to SEO your YouTube channel might be;
  • Building Web 2.0 sites and linking to it with an anchor text you're trying to rank it for.
  • Building social bookmarks to it from all the top social bookmarking sites, SU, Reddit, Scoop, Delicious etc etc.
  • Building social signals to it such as Facebook likes, shares, tweets, pins, etc etc etc.
  • Building links to it from high authority sites, guest posts, even link directories etc etc.

What other ways can you suggest to index and SEO your YouTube channel URL? 10 YouTube Marketing Tips and Tricks



Are you sure you want to delete this post?

TommyCarey
Basically I would treat the channel like the homepage of my website and each video would be a sub page 10 YouTube Marketing Tips and Tricks

I'll take the same steps as I would with my own websites when I'm running an SEO campaign. I'll build some good high quality backlinks to my channels page and a few more to each video I have that is live.

The great thing about a YouTube channel is that they can increase in the rankings pretty quick since YouTube is owned by Google and not as many people focus on building backlinks to their channel and videos like they would their own website.

I've noticed that videos will rank a little better than the channel page because the videos are optimized for a single keyword where as the channel page is more broad and can't target every keyword at the same time. So this means your video pages will actually be bringing in more traffic than you homepage. This is kind of the opposite of what a website generates. People will usually share a homepage or just type the URL out of a website they enjoy, and then share it. When someone is on YouTube they can't just say "Hey, this video on YouTube was pretty awesome!" and then share youtube.com lol. We all know to share the URL that shows up in the address bar because YouTube has a ridiculous amount of videos on it and if we tried searching for a specific video it could take us months to just come close to what we were looking for lol 10 YouTube Marketing Tips and Tricks



Are you sure you want to delete this post?

MusicMoguls
Yea you got a point about the index thing like you know if you take the time to set up your channel and video index it will definitely increase its chance of turning up in the search engines and I feel this could greatly compliment things especially with marketing involved you know you have to reach out to a lot of people when marketing and if you could have things set up were it is in your favor come Search results time then hey why not you know you have to take full advantage of every thing to better your self



Are you sure you want to delete this post?

anwebservices
Hey Razzy, thanks for great tips. Yeah it's important to do SEO and marketing for YouTube videos, when it comes to video video views, web traffic and monetization. Couple weeks ago i seen some stats that YouTube is second place on internet where people performing search for anything, so it can be huge traffic driver to websites too, and that's why it's important to follow your tips so your video can rank higher in YouTube search, but also in Google search as well.



Are you sure you want to delete this post?

EliteWriter
Totally agree with you anwebservices. Those were great points Razzy and I do hope that those who do not make good use of YouTube will be enlightened by this post as it is a really an untapped resource to get a lot of traffic. Many seem to forget about the impact videos can have and end up focusing solely on written content, and that is a pity, because in reality most people prefer to watch a short video than reading an article. Ranking well in YouTube should be one of the main goals.



Are you sure you want to delete this post?

MusicMoguls
Yea I agree these are the types of tricks and tips that people should really take in consideration to take advantage of , just as you mentioned I know too many people that forget about the impact that videos actually do have on people and I feel that more people need to take advantage of this type of marketing cause it could really be a door opener for certain people there are always those people who are looking to branch out and for those of us that are not involved with YouTube I suggest them to take your advice into consideration



Are you sure you want to delete this post?

idealmike
Just a couple weeks ago Abid? YouTube has been the 2nd most visited website on the Internet for over a decade now mate. It's Google first, then YouTube, followed by Facebook, Twitter, LinkedIn, Instagram, Reddit and then the rest. You can check Alexa's top sites list. And Wiki has a list of most popular websites too. Unfortunatley SEOClerks isn't on the list but maybe one day, just maybe. 10 YouTube Marketing Tips and Tricks



Are you sure you want to delete this post?

anwebservices
I meant second place where people perform search for anything, not by number of visitors ;)



Are you sure you want to delete this post?

idealmike
Same difference Abid lol 10 YouTube Marketing Tips and Tricks



Are you sure you want to delete this post?

Lynne
Oh well I learned something new. I knew Youtube search was popular but I never knew it was the second place where people search.

I know that I have been using Youtube search often the last year or so, yes most likely the second place I look.

In fact if I am looking for an explanation of how to do something it is often my first place to look now. I love listening to an explanation and seeing how it is done at the same time.

I have started doing a few how to's on Youtube and I really enjoyed it.



Are you sure you want to delete this post?

idealmike
Yeah it just goes to show how video is the leader and may even replace Google one day. Not even YouTube knew that it was going to be as big as it is but what site does. Yeah I love how to's. Anything that shows me how to do something without having to read an essay on it first. The written version is still valuable though. Sometimes I prefer that instead of the video as it doesn't move lol 10 YouTube Marketing Tips and Tricks



Are you sure you want to delete this post?

Lynne
Yeah my kids teacher at day care thinks I am a little batty. I collected my daughter from school one day last term and she tells me she is oh so sorry but my daughter somehow got Prestik (Blu Tack) stuck in her hair.

My response was "Brilliant, I hope it was a big lot of it right?"

My mind is thinking oh I can do a brilliant how to video when I get home. I was struggling to come up with my next content and suddenly my problem is solved for me.

I see my daughter's hair and I am please as punch to see that yes there is a good amount stuck in there. Enough to be clearly visible with my webcam.

Oh the life of a blogger. And yes I usually do a written blog and embed my video too.



Are you sure you want to delete this post?

MusicMoguls
You tube second huh? I believe it what is he first ? Any way I agree web services these tips are all great and it is also great that some one took the time to mention marketing tips for you tube I know some of us on SEO have you tube accounts and are even video bloggers of some sort so with that being said this huge traffic driver that is you tube can really make a difference in a lot of cases especially in the day and age were the Internet has taken control of so many things in the world



Are you sure you want to delete this post?

Cristian
Really great information Razzy, Thanks!
But having a website may not be a good idea. I'm a real big youtube fan and I'm subscribed to a lot of popular Youtubers and I've seen this time and time again: they start a website but eventually fail to earn money out of them because people are not interested in websites, they want video content.

Anyways just an idea, maybe it is more important for Youtubers to create video content and focus on that instead on turning their energy on something that has a low chance of success.



Are you sure you want to delete this post?

idealmike
How can you say having a website might not be a good idea just because other people fail with it? I get what you're saying that most people want to watch video content today but having a website can be very beneficial in more ways than one. Not just because you can put your videos on it and create great content around it but because you can use it as a tool to reach more people, collect more subscribers (both to your YouTube channel and email newsletter) and in many other ways it can be useful as well. Plus it's not hard to setup and run a website, it basically runs itself. It's one of those things that is better to have and not need than it is to need it and not have it if you know what I mean. Plus if you do good keyword research and have a good domain name and get good rankings and traffic for your site through SEO and promotion of it, it can go on to become an incredibly powerful entity and can be monetized and earn more money in the long run. If those people are failing time and time again then it's because they don't know what they're doing and they give up on the first hurdle! Just my opinion. 10 YouTube Marketing Tips and Tricks



Are you sure you want to delete this post?

MusicMoguls
You do make a point I know earlier I said that you tube might just be the user friendly one most people fail because they are not up to getting the work that needs to be done, done . And that simply won't do it can be a pain just starting up but unlike a you tube channel were you just post videos your right about the website it does come with more options and more opportunities than YouTube does and I think with the right hands on the steering wheel you would be able to drive your self to greatness



Are you sure you want to delete this post?

TommyCarey
Mainly the website would be to generate a sale or two from people clicking through from YouTube. But the main reason for a website to put your videos on would be to target different keywords 10 YouTube Marketing Tips and Tricks You can rank your video for keywords that aren't in the title or description because you can type up whatever you want on your website 10 YouTube Marketing Tips and Tricks The page itself will rank, not the video. But that's the beauty of this because you can pull people from different traffic sources and get them to your YouTube video where they will watch, give you a thumbs up or possibly become a follower 10 YouTube Marketing Tips and Tricks



Are you sure you want to delete this post?

MusicMoguls
Yea you are definitely opening your variety of clientele when working from a web site then having to actually work with you tube directly , I see what you are saying but before any of that goes down I do recommend getting your tube really established and making sure that you have a good amount of subscribers and people following you before you move you work on to a different platform so that you feel some what secure then start the website take over by taking advantage of pulling people from different traffic sources and bringing them back to your page



Are you sure you want to delete this post?

MusicMoguls
You do have a point Cristian to simply just up and convert from you tube to a web site is sort of a back step in a way especially if your video numbers are looking consistent and good , using you tube and running a website are two different things things one of those things has a lot more responsibility then the other to be honest you tube is the more people friendly option and I can also agree with what you said about people wanting to watch videos we are in a visual age were most people just don't take the time to read



Are you sure you want to delete this post?

Lynne
Bring it on Razzy! That is great advice and I am making use of almost all of those except paid traffic, printed material and hiring someone. I don't make use of any printed material so this would be a bit of a waste for me I think. Hiring someone? Well people ask me how to optimize Youtube videos so I think I am doing a pretty good job on my own.

I am going to get into paid traffic again soon and I am really looking forward to seeing how that affects my Youtube channel traffic and subscribers rate.

Oh and Razzy here is a great one to add... one on one contact. I have gotten quite a lot of views from people I meet on a day to day basis. I've had people ask what I do and I always add in that I do Youtube and people usually find this interesting and very often look me up and then engage with me on Youtube.

Don't underestimate the marketing you can do just talking to people and slipping in bits and pieces here and there.



Are you sure you want to delete this post?

MusicMoguls
Hey Lynne you are going to have to let me know how the paid traffic goes for you , personally I would hold off on getting any paid traffic just cause you do not want to risk distorting your you tube numbers you know it could raise flags when people see an over night success it raises questions not saying that you are doing anything wrong but I think there are still plenty of other forms of marketing to get your traffic to where you actually want it to be before having to spend unnecessary money and anything that saves money I'm on board with



Are you sure you want to delete this post?

ajlancer
Hi Razzy Thanks for your excellent sharing about YouTube marketing tips and tricks. I really love to do all your explained points. I am very much know that channel optimization is most importance parts for getting search results. And before publishing video, you need to do some importance things which many channel holder does not know. Which you mentioned call in action and friends and family parts. I mostly used this method before publishing video. And this method really working for excellent search result. Your rest of the all pointes really helpful to getting excellent result for search engine.

Regards by Ajlancer



Are you sure you want to delete this post?

MusicMoguls
I agree man optimization is key and the way razzy goes in to explaining it makes it loud and clear, before even publishing your video you have to make sure everything is how it needs to be and every thing is in order publishing your video wrong could result in huge set backs as far as how your video will be searched found etc to avoid that I recommend to make sure you thoroughly double check every thing in optimization after of course taking razzys great advice and doing what you have to in making sure your video is taken care of



Are you sure you want to delete this post?

Corzhens
I agree that optimization will definitely give your Youtube video the means of gaining more traffic. In our experience, the keyword has been a big help with the traffic since Youtube watchers are now used to searching for videos. For example when you want to listen to the songs of 1980s then search it and Youtube will give you a list of videos. And if your video falls under that classification with the right keyword then your video will be displayed there for the benefit of the searcher.



Are you sure you want to delete this post?

MusicMoguls
I like how you mentioned to get social, yes razzy man there are too many people that only do half of the math what I mean by this is that they will put so much time and effort in to perfecting there craft , great video, optimization all that good stuff but then after they that they just sit on it really no moves being made they are letting the video take care of it self and that is not how it should be get social get out there and shove your video down every ones throats lol so to speak



Are you sure you want to delete this post?

Order Now
Process Time: 2.4529449939728

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='18484'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='18484'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

SELECT * FROM seoclerks.members WHERE USERID='19821'1SELECT * FROM seoclerks.members WHERE USERID='19821'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM categories_faq WHERE CATID='42'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()

SELECT * FROM seoclerks.members WHERE USERID=198211SELECT googleplus_profile FROM seoclerks.members WHERE USERID=19821

/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=18484 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=18484 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18484' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='18484' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102443 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102443 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102496 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102496 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102549 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102549 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102365 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102365 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102398 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102398 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102551 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102551 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102455 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102455 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102456 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102456 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102458 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102458 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102465 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102465 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102469 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102469 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102472 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102472 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102550 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102550 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102401 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102401 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102457 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102457 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102554 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102554 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102498 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102498 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102555 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102555 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102553 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102553 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102422 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102422 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102557 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102557 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102448 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102448 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102558 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102558 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=154377 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=154377 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102560 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102560 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='18484'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='18484'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='18484' AND status='1' AND (question like '%10 YouTube Marketing Tips Tricks%' OR question like '%YouTube%' OR question like '%Marketing%' OR question like '%Tips%' OR question like '%Tricks%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18484' AND status='1' AND (question like '%10 YouTube Marketing Tips Tricks%' OR question like '%YouTube%' OR question like '%Marketing%' OR question like '%Tips%' OR question like '%Tricks%') -- ORDER BY RAND() LIMIT 15

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM seoclerks.members WHERE USERID='10775' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='10775' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='1177' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1177' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='7' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='7' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='17031' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='9' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18484%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18484%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * from categories_software order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

SELECT * FROM seoclerks.members WHERE USERID='272.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='19821.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='139192.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='139192.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='254580.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='212316.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='306632.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='134.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='4987.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

select * from categories_faq order by name asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.2970191SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,400.2970190.297019
0.1905851SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.1905850.190585
0.1079451SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 24754 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Safe Traffic Adsense%' ) LIMIT 40.1079450.107945