Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.
Sign up to join this community
Hi
I see StackOverflow questions like :
Excel/VBA to check if a row exists
and I am tempted to reply with :
" You could run a query such as
'SELECT COUNT(), COL1, COL2 FROM A GROUP BY COL1, COL2 HAVING COUNT() > 1'
using my Excel Add-In QueryCell. See www.querycell.com "
Would this be appropriate or spammy ? On the one hand it's relevant, on the other it's a blatant plug for my commerical product ?
Cheers
I say that if it is a relevant answer, then post it.
You might want to put a disclaimer, but I don't see anything wrong with it. And if others don't like it, it won't get voted up.
Just to pipe up before anyone else mentions it :)
If it's relevant and will help, I think that's fine. I've referred people on SO to C# in Depth before, and others on SU to Google Sync.
I would think of it like this: I don't think it's any more wrong to refer to your own product than to refer to anyone else's. If the answer would be okay if someone else posted it, it's okay for you to post it. If it wouldn't be useful if someone else posted it, you shouldn't post it either.
Basically it's about the answer rather than the person.
(Having said that, I do usually try to include a disclaimer if I have any personal involvement, just to avoid charges of trying to do sneaky advertising.)
I'd agree with everything Jon said - but it would also depend on the numbers; if every answer you post is a plug for your product, there is a chance you will get flagged as spam - and possibly even astro-turfing.
But within reason as long as the posts are on-topic (and not the sole reason for your SO existence), then great! Another possibly-helpful answer.
Being clear in your disclosure will help; people can often tell when you're affiliated with a product, and based on the usual responses people prefer openness.
I would suggest you put links in cautiously. Take a step back, look at what it looks like to the person you're helping, and decide if it really is helping them, or you are just plugging. Where ever you would put your link, consider seeing your compeditors link in the same place and see how you like the idea.
If you come along trying to fit your link into questions, you'll almost certainly come off as being spam to the user.
The text you posted above as-is I would consider spammy initially, but I'd be likely to check your post history first and see if you have a penchant for self promotion.
If it was obvious your account existed here with more than 20% purpose being to link to your site, I'd be inclined to go through and delete links in your answers, and report you :).
I would down-vote that answer if I saw it attached to that question. And probably flag it as well.
The guy didn't ask for tools or add-ons. He asked for help with his VBA code or a built-in formula - your answer provides neither. So your code falls into pretty much the same category as the "Use jQuery" answers on JavaScript questions, or "Use Firefox" on IE questions... Except that those products are at least widely- and freely-available, while yours would presumably need to be bought and installed for every machine where the spreadsheet would be used.
In short, it's bordering on unhelpful at best, and stinks of self-promotion / spam at worst.
Now... If you were to provide a good solution to his problem according to the parameters he outlined in his question (a VBA script) and then suggest your add-on as an easier way of accomplishing similar things in the future, that would look a lot better.
BTW - for quick and accurate answers to this and other thorny ethical dilemmas, you might consider investing in Shog's Magic Question Appropriateness Eight-ball, a revolutionary tool developed and sold by yours truly. Now on sale, get 15% off the normal purchase price - that's 100% guaranteed accuracy at 85% of the usual cost! Limited time offer, void where prohibited and in Quebec. "Guaranteed accuracy", "accurate answers", and "revolutionary tool" trademarks of Shog's House of Goodness, and do not indicate a binding promise of accuracy or usefulness. Contains substances known to the State of California to cause blindness and paranoia in laboratory programmers.
As mentioned in other answers:
If the poster is asking for an answer involving code, then you should provide a code related answer.
If the poster is asking about third party tools that do XYZ, and your product does those things, then absolutely! Tell them about it!
A fairly good metric would be to consider someone who had NO financial involvement in the product. If they would consider it to be a good answer to the question, then you can consider posting it, if they would consider the product placement to be irrelevant and/or completely useless to the task at hand, then you should not be putting it in there.
Lastly, because the community does not tend to tolerate spammy behaviour (even well intentioned) I would suggest that you err on the side of not putting in advertisements. Or at least choosing better questions to advertise it.
I've worried about the same thing. I have occasionally recommended an open-source framework I wrote and maintain, and have received a few downvotes seemingly just because I mentioned it. I think that proper plugs can be fine if they're in context and actually helpful.
I try to only link to it if it relates to the question (e.g. the asker is wondering how to implement something that my framework does), and I always try to answer the question before plugging my own work. I respect others' right to disagree, but I'm a firm proponent of appropriate code reuse. It's sure hard to reuse something if you don't know about it.
I'm mostly active in the Objective-C and Cocoa tags, and a huge chunk of the questions are only because the asker isn't familiar with the APIs. It's quite frequent that people try to do something that the framework does far better and more efficiently than home-grown code. Would we really suggest that it's bad form to point out a library or tool that can make things much easier, particularly if it's open-source?
I think a lot of people are too quick to classify an answer as "astroturfing" regardless of the merit of the answer. Perhaps only "famous" programmers are allowed to suggest their own code? I would hope that people would give the answer a chance rather than rejecting it out of hand. Happily, I think most SO users are reasonable and will vote based on whether an answer is truly helpful, not just based on whether the answer includes a reference to something the author wrote.
