EliteWriter
Level 3
Write the reason you're deleting this FAQ
PPC is promoted as being a cost effective online marketing option. Its benefits are often highlighted, especially the fact that it gives you results quickly, the traffic is of a better quality, and you can track conversions.
However I strongly believe that if a PPC campaign is carried out on its own it is not going to be that effective. SEO is still important, even though it may seem to bring in results rather slowly. But you cannot do PPC forever, if your budget is limited. What do you think? Should PPC be used on its own or as a complement?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| 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='10217' | 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='10217' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='212316' | 1 | SELECT * FROM seoclerks.members WHERE USERID='212316' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=212316 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=212316 | /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=10217 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=10217
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10217' 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='10217' 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=40052 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=40052
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=40079 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=40079
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='10217' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='10217' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='10217' AND status='1' AND (question like '%Do agree PPC complement own?%' OR question like '%agree%' OR question like '%complement%' OR question like '%own?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='10217' AND status='1'
AND (question like '%Do agree PPC complement own?%' OR question like '%agree%' OR question like '%complement%' OR question like '%own?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='1139' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1139' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='51299' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='51299' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='6319' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6319' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='76087' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='76087' 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=10217%' 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=10217%'
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='19821.png' | 1 | SELECT 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='311920.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='311920.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 |
TommyCarey
I do it this way because the PPC will bring in instant traffic since I'll be paying for my placement at the top. SEO will bring in quality traffic in a few months since it's not an over night type of branding and marketing.
For the PPC I'll try to set it up so I can advertise through just one platform like Google for 3 months. This way I'll have enough time to let the PPC campaign run and bring in sales while I'm also doing the optimization along side it. Sometimes I can't afford to do the 3 months so I'll have to budget for 1 or 2 months. I can stretch my budget to the full 3 months that I like, but it usually doesn't have the same affect as if I have a bigger budget and can pay a little more each day. I will definitely boostrap my profits, and that always helps since I'm backing all my projects personally and not getting any funding from an outside source. Boostrapping is basically starting up a website or business and barely paying yourself, or not paying yourself at all, and putting all the profits right back into the company or website in order to build even quicker. A lot of people do it, and if it's done right it can yield some pretty amazing results down the road.
As for the SEO side of things. I'll usually begin my campaign after I have the PPC campaign set up just because the PPC campaign can pretty much run on auto pilot for the entirety of the first SEO campaign. Kind of like a set and forget type of thing but you have to log in a couple times a week to check it lol
So I say yes to running both at the same time, if you can afford it. Set up your PPC campaign first and then run your SEO campaign.
Thanks,
Razzy Depending on my budget, I like to run a PPC campaign right when I start my SEO campaign. I do it this way because the PPC will bring in instant traffic since I'll be paying for my placement at the top. SEO will bring in quality traffic in a few months since it's not an over night type of branding and marketing. For the PPC I'll try to set it up so I can advertise through just one platform like Google for 3 months. This way I'll have enough time to let the PPC campaign run and bring in sales while I'm also doing the optimization along side it. Sometimes I can't afford to do the 3 months so I'll have to budget for 1 or 2 months. I can stretch my budget to the full 3 months that I like, but it usually doesn't have the same affect as if I have a bigger budget and can pay a little more each day. I will definitely boostrap my profits, and that always helps since I'm backing all my projects personally and not getting any funding from an outside source. Boostrapping is basically starting up a website or business and barely paying yourself, or not paying yourself at all, and putting all the profits right back into the company or website in order to build even quicker. A lot of people do it, and if it's done right it can yield some pretty amazing results down the road. As for the SEO side of things. I'll usually begin my campaign after I have the PPC campaign set up just because the PPC campaign can pretty much run on auto pilot for the entirety of the first SEO campaign. Kind of like a set and forget type of thing but you have to log in a couple times a week to check it lol :D Back to the SEO... I'll do my campaign how I always do it and not deviate or ramp up to early. Doing this will go well with the PPC campaign since I'll already be getting traffic that is sharing and loving my website. So when Google sees that I'm getting talked about online they'll more than likely jump my rankings. And when my SEO campaign starts to kick in I'll get an even bigger boost. So I say yes to running both at the same time, if you can afford it. Set up your PPC campaign first and then run your SEO campaign. Thanks, Razzy
Are you sure you want to delete this post?