You are viewing a single comment's thread from:
RE: Marketing experiment for business sector. Resteem this post for a chance to win 100 SBD. All upvote proceeds donated.
I also tidied up the main query that returns all valid resteemers, this now has a count column:
SELECT
ROW_NUMBER() OVER(ORDER BY r.timestamp ASC) AS Resteem#,
('@' + r.account) as Username,
r.timestamp as Timestamp
FROM
Reblogs r(NOLOCK)
INNER JOIN
Followers f(NOLOCK)
ON r.account=f.follower
WHERE
r.author IN('bycoleman')
AND r.permlink IN('marketing-experiment-for-business-sector-resteem-this-post-for-a-chance-to-win-100-sbd-all-upvote-proceeds-donated')
AND f.following IN('bycoleman')
ORDER BY
r.timestamp asc
e.g.:
Thank you Carl,
This marketing plan would not even have the 53 resteems if I had not gone out and engaged VERY actively with new users (introduceyourself) and very new posts in bitcoin and cryptocurrency I replied with honest and useful comments and garnered far more followers than the resteem effort on its own.
Part of my summary and detail write-up on this marketing test will use a query that identifies those who I contacted first vs those that just found me.
Preliminary findings show paying directly for resteems has little or no real value and the effectiveness of a resteem fades quickly after 36 hours or so.
Of course you knew all of this. :)
Part of the reason I resteemed this post in the first place was to give it even a fighting chance - I have over 2000 followers and influence that is disproportionately large considering my relatively small stake of SP; I have a lot of high stake followers and my position as @curie community rep and regular top Curie curator make me punch outside of my weight class. This type of "contest" is pretty despised here on Steem, for good reason, and I was reasonably sure this post couldn't overcome that. Interesting experiment nonetheless.
Finally got the summary findings written if you are interested.
https://steemit.com/promotion/@bycoleman/marketing-experiment-for-business-sector-150-sbd-contest-summarized-results
You are correct. On its own without me continuing to engage the community with useful replies, it would be nearly worthless to an individual. However as a business entity, it may still have significant worth.
Yes, I know that you have earned the right to be a @curie curator and from what I see, you have done a great job.