Salesforce Marketing Cloud Unsung Heros

0

Please login or register to vote for this query.

(click on this box to dismiss)

SFMC-focused users with more than 20 zero-score answers, ordered by ratio of zero to non-zero score.

Salesforce

Q&A for Salesforce administrators, implementation experts, developers and anybody in-between

select
  x.*
  , u.Reputation
  , u.location
  , u.id  from (

    select a.OwnerUserId [User Link]
    , sum(case when a.Score = 0 then 0 else 1 end) as [Non-Zero Score Answers]
    , sum(case when a.Score = 0 then 1 else 0 end) as [Zero-Score Answers]
    from Posts q
    inner join Posts a on a.Id = q.AcceptedAnswerId
    where 1=1
    and exists (
       select pt.tagid
       from posttags pt
       inner join tags t on pt.tagid = t.id
       where pt.postid = q.id
       and t.tagname IN ('marketing-cloud', 'ampscript', 'ssjs')
    )
    and a.CommunityOwnedDate is null
    and a.OwnerUserId is not null
    and a.OwnerUserId <> isnull(q.OwnerUserId,-1)
    group by a.OwnerUserId
    having
    sum(case when a.Score = 0 then 1 else 0 end) > 20

) as x
inner join Users u on u.Id = [User Link]
order by ([Zero-Score Answers]+ 0.0) / ([Zero-Score Answers]+ [Non-Zero Score Answers]+ 0.0) desc

Enter Parameters

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