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.

in #steem • 7 years ago

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.:

7 years ago in #steem by
$0.39
  • Past Payouts $0.39
  • - Author $0.29
  • - Curators $0.09
1 vote
Reply 4
Sort:  
  • Trending
    • [-]
     7 years ago (edited) 

    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. :)

    $0.00
      Reply
      [-]
       7 years ago  

      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.

      $0.00
        Reply
        [-]
         7 years ago (edited) 

        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.

        $0.00
          Reply