Are you looking for a free Periscope Data t-shirt?

Hey everyone! Welcome and thanks for joining!

If you're looking for a free t-shirt, please make a post or reply *with a datset, SQL snippet or something analytics related*, and add a photo and title with company to your account.

Then shoot me a private message or fill out this form.
https://goo.gl/forms/OU5DccFCDpR3fSzX2

Thanks and talk to you soon!
Sean

7replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • select

        freetshirt

    from anythingforswag

    where tshirt_size = "Large"

    Like 2
  • 🙂

    insert into freeTShirt (name,lastName,company,city,country,size)
    VALUES ('Javier','Cárdaba','BaseTIS','Barcelona','Spain','XXL')
    Like
  • Here is the form — once you have a post, title and pic :)

    https://goo.gl/forms/OU5DccFCDpR3fSzX2

    Like
  • Some handy snippets for calculating NPS and accuracy.

    [nps]

    ((promoters/total ) - (detractors/total))

    [nps_var]

    ((1 - [NPS]) ^ 2 * promoters/total + (0 -  [NPS]) ^ 2 * neutral/total + (-1 - [NPS]) ^ 2 * detractors/total)

    Suggested Usage:

    select
      npsdate
      , total as sample_size
      , [NPS] as nps
      , (sqrt([NPS_VAR]) / sqrt(total))  as moe2
      , (sqrt([NPS_VAR]) / sqrt(total))  as moe
      , [NPS] - (sqrt([NPS_VAR]) / sqrt(total)) as moe_lower
    from
      (
        select
          [created:aggregation] as npsdate
          , count(1)::float as total
          , count(
            case
              when recommend <= 5
                then 1
            end )::float as detractors
          , count(
            case
              when recommend > 5
              and recommend < 9
                then 1
            end )::float as neutral
          , count(
            case
              when recommend >= 9
                then 1
            end )::float as promoters
        from
          your_nps_survey_table
        group by
          1
      )
      as respondents

    You can use moe_lower, moe and moe2 to show error bars on results. Make moe_lower the same color as the background.

    Like 1
      • Sean Cook
      • Product Analyst @ Facebook
      • Sean_Cook
      • 2 yrs ago
      • Reported - view

      Matt Turner That is great! Would you mind posting in the SQL Snippets section so users can find it. No one will reap the benefit of your useful code in here! :)

      Like
  • curl -X GET   'http://shirts.periscopedata.com/?size=medium'   -H 'cache-control: no-cache'   -H 'postman-token: 4491e426-38d3-f3fc-1bc2-e310aaf85bb6'
    Like
      • Sean Cook
      • Product Analyst @ Facebook
      • Sean_Cook
      • 2 yrs ago
      • 1
      • Reported - view

      adam That host doesn't seem to be resolving 😂

      Like 1
Replies are closed
Like1
  • 1 Likes
  • 2 yrs agoLast active
  • 7Replies closed
  • 546Views
  • 6 Following