What is the views:upvotes ratio for clickbait?

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/317024/what-is-the-viewsupvotes-ratio-for-clickbait/

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select top 100 postid as [Post Link]
     , datediff(d, convert(date,p.creationdate), v.creationdate)  days
     , count(*) [up_down]
     , (datediff(d, convert(date,p.creationdate), v.creationdate) + 1.0) / 
       count(*) [days/votes ratio]
     , sum(case when votetypeid = 2 then 1 else 0 end) upvotes
     , sum(case when votetypeid = 3 then 1 else 0 end) downvotes
     , p.viewcount
     , p.viewcount / sum(case when votetypeid = 2 then 1 else 0 end) [views/upvotes]
from votes v
inner join posts p on p.id = v.postid 
where votetypeid in (2,3)
and p.posttypeid = 1 -- Q
group by postid
        , datediff(d, convert(date,p.creationdate), v.creationdate)
        , p.viewcount
having  datediff(d, convert(date,p.creationdate), v.creationdate) < 2

order by (datediff(d, convert(date,p.creationdate), v.creationdate) + 1.0) / 
       count(*) asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results