4

Please login or register to vote for this query.

(click on this box to dismiss)

Highest hitrate non-CW questions, (presumably) what questions are viewed the most per time unit from Google searches.

Q&A for those who study, teach, research and apply economics and econometrics

-- Highest view rate for newer questions (non-Community Wiki).
--
-- Highest hitrate for newer non-CW questions, (presumably) what questions 
-- are viewed the most per time unit from Google searches.
--
-- It is essentially "Highest view rate questions (non-Community Wiki). [4]" 
-- (<https://data.stackexchange.com/stackoverflow/query/120907/>) with a 
-- filter (on question age).


SELECT TOP 150
    p.Id as [Post Link],
    p.Id as [Post ID],
    Score as [Votes],
    ViewCount as [Views],
    DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) as Age,
    p.ViewCount / (DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) + 1) as [View rate],
    p.Tags as [Tags]
FROM Posts p
WHERE 
    -- On Stack Overflow there were 100 non-CW 
    -- posts with more than about 28,000 views.
    p.ViewCount > 3000 AND 
    
    -- Field CommunityOwnedDate is absent for non-CW posts.
    p.CommunityOwnedDate is null AND 
    
    -- Minimum view rate
    p.ViewCount / (DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) + 1) > 10 AND 
    
    -- Question age filter (only include ***newer*** 
    -- questions - about two years old or younger).
    DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) < 700 
                                                             

ORDER BY [View Rate] DESC

fork query

edited sep 5 21 Peter Mortensen (resurrected)

created may 23 11 Peter Mortensen