steplercamp

Privacy Policy for Up / "Up with Friends"
Effective date: Immediately

This Privacy Policy explains how Charthomp, LLC ("we," "us," or "our") collects, uses, shares, and protects information when you use the Up / "Up with Friends" mobile application (the "App").

Summary
- We use your phone number to sign you in and run the App.
- We store your profile, friend connections, and Up status so the App works.
- We use push notification tokens to send notifications if you enable them.
- We do not sell your personal information.

steplercamp

-- avg posts per active user yesterday
SELECT
  AVG(xx.posts_made)
FROM(
  SELECT
    u.user_id,
    COUNT(DISTINCT p.post_id) AS posts_made
  FROM users u
  LEFT OUTER JOIN posts p
    ON u.user_id = p.user_id