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 • 6 years ago

Thank you @Carlgnash for this information and the work you have put into the query and of course for electing to donate back to the new users. This attitude is what makes Steemit so very special today and will allow it to even more so tomorrow!

6 years ago in #steem by
$0.00
    Reply 6
    Sort:  
  • Trending
    • [-]
     6 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.:

    $0.39
    • Past Payouts $0.39, 0.00 TRX
    • - Author $0.29, 0.00 TRX
    • - Curators $0.09, 0.00 TRX
    1 vote
    Reply
    [-]
     6 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
      [-]
       6 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
        [-]
         6 years ago 
        $0.13
        • Past Payouts $0.13, 0.00 TRX
        • - Author $0.13, 0.00 TRX
        • - Curators $0.00, 0.00 TRX
        3 votes
        Reply
        [-]
         6 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
          Loading...

          Coin Marketplace

          STEEM 0.20
          TRX 0.13
          JST 0.030
          BTC 63060.85
          ETH 3455.18
          USDT 1.00
          SBD 2.51