Write the reason you're deleting this FAQ
When it comes to putting up new websites and trying to make money from them, the method of ranking and banking for upcoming TV shows doesn't get talked about much. It doesn't get talked about much because it's not an instant cash flow because you might have to work for 6 months prior to the show coming out in order to make some cash off of it when it does launch. This isn't an easy thing to do actually, and most people think it is. It takes a lot of work and preparation before you will see any profits coming into your account.
I've done stuff like this in the past and it does work well, but you never know if you're going to be successful and I think that's why people don't normally do it. You'll see websites that target hundreds of tv shows, but you don't see many websites dedicate themselves to a specific show because it could be a limited market. Well, it is a limited market but you don't know if that market is going to be massive or just a few people lol. If you talked to me 10 years ago and I said I was going to start a website or blog and write about a TV show that focused on smart nerdy people living together and they never really get the girl, would you be interested? What if I told you that hundreds of millions of people would be watching this in 2017 and the people on the show would be some of the highest paid actors in the world? Well that show was big bang theory and I never set up a website or blog about it and I kick myself whenever I think about it lmao 
How do I figure out what is a good show to target?
Well it's unpredictable to know what is going to be a good show that will go 23 seasons and what show will flop after just 1 season. You may love what the flopped show is about, but the majority might not like it at all. If you want to play it safe you can go onto Netflix and look over the shows and movies that were filmed specifically for Netflix and no where else. You can then get an idea of what is popular and cherry pick the upcoming shows based on the Netflix trends.
I say to do the Netflix trick because they make these shows based on what people are already watching and rating. Netflix already knows their show is going to be a hit before it launches because the majority of their users are already saying what they like lol
Follow the trends and it will be easier to figure out what to target.
You can see what Netflix has already launched here:
https://en.wikipedia.org/wiki/List...buted_by_Netflix
I would sort them by what isn't aired yet so you can get in early and get a massive amount of content up and running about the show prior to it going live 
Now what I like to do after I get info from Netflix is go over Wikipedia and cherry pick from this list: https://en.wikipedia.org/wiki/Cate...elevision_series
You will have data from Netflix on what is popular and you can cherry pick from that Wikipedia page to see which fits the mold of success 
In Conclusion:
You'll need to have a strategic game plan when it comes to something like this because you'll be working for 6+ months before you actually start seeing some money. The "Rank and Bank" method is always thought of to be a quick game, but that's not always the case. Put some tweaks on this system and come back to let us know your results 
Remember to follow me!
https://www.seoclerks.com/user/Razzy
Thanks!
Razzy
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT 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='22887' | 1 | SELECT 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='22887' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='19821' | 1 | SELECT * FROM seoclerks.members WHERE USERID='19821' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='43' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='43' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=19821 | 1 | SELECT 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=22887 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=22887
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22887' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT 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='22887' 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=118043 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=118043
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=119577 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=119577
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=142599 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=142599
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=150653 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=150653
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='22887' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='22887' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='22887' AND status='1' AND (question like '%Rank Bank upcoming TV shows%' OR question like '%Rank%' OR question like '%Bank%' OR question like '%upcoming%' OR question like '%shows%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='22887' AND status='1'
AND (question like '%Rank Bank upcoming TV shows%' OR question like '%Rank%' OR question like '%Bank%' OR question like '%upcoming%' OR question like '%shows%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='707' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='707' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='147' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147' 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 1 | 1 | SELECT 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=22887%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=22887%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * 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 asc | 1 | select * 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 asc | 1 | select * 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='134.png' | 1 | SELECT 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='589438.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='585810.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT 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 asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
Cristian
Short answer: Because if it does turn out fine for you, it may be a gold mine!
Just think about it, if I ever knew about Game of Thrones 6 months before it was launched! But then again, I would probably have thought the movie itself will be weak since most of the actors were unknown and Boromir, well let's just say Lord of the Rings was his best movie.
I think you need to be a fan of the book before the movie comes out. This way you will have all this knowledge you can write about and produce quality content ahead of time. So yeah, if you have a favorite book and you just seen a movie about it will be made at some point in the future, start investing time into a fan based website with lots of content and movies news. There is a good chance you will strike a gold mine once the movie is out and hopefully will be a huge success. I always wanted to do something like this, but as you said the fact that I needed to work now and see a profit a few months later doesn't quite work for me. I need money now, not in six months and I also have the clients willing to pay me now. Why should I spend time on something that might or may not work? Short answer: Because if it does turn out fine for you, it may be a gold mine! Just think about it, if I ever knew about Game of Thrones 6 months before it was launched! But then again, I would probably have thought the movie itself will be weak since most of the actors were unknown and Boromir, well let's just say Lord of the Rings was his best movie. I think you need to be a fan of the book before the movie comes out. This way you will have all this knowledge you can write about and produce quality content ahead of time. So yeah, if you have a favorite book and you just seen a movie about it will be made at some point in the future, start investing time into a fan based website with lots of content and movies news. There is a good chance you will strike a gold mine once the movie is out and hopefully will be a huge success.
Are you sure you want to delete this post?