Merge pull request 'Add pastDueUsers, newPaidToday, and cohort paidTotal to usage stats' (#314) from dean/usage-stats-pastdue-alltime into master

Reviewed-on: #314

src/index.tsx

@@ -265,6 +265,7 @@ export type CohortStatsGql = {
   activated7d: Scalars["Int"]["output"];
   activatedNotPaid7d: Scalars["Int"]["output"];
   paid7d: Scalars["Int"]["output"];
+  paidTotal: Scalars["Int"]["output"];
   signups: Scalars["Int"]["output"];
   weekStart: Scalars["Date"]["output"];
 };
@@ -2323,6 +2324,8 @@ export type FunnelStatsGql = {
   freemiumEpoch: Scalars["Date"]["output"];
   newPaid7d: Scalars["Int"]["output"];
   newPaid30d: Scalars["Int"]["output"];
+  newPaidToday: Scalars["Int"]["output"];
+  pastDueUsers: Scalars["Int"]["output"];
   payingUsers: Scalars["Int"]["output"];
   retentionPrevActive: Scalars["Int"]["output"];
   retentionReturned: Scalars["Int"]["output"];
@@ -4078,7 +4081,6 @@ export type SyncAppleSubscriptionResultGql = {
 export type TableStateGql = {
   __typename?: "TableStateGQL";
   homography?: Maybe<HomographyInfoGql>;
-  identifierToBox: Array<BoundingBoxGql>;
   identifierToColor: Array<Maybe<RgbColorGql>>;
   identifierToPosition: Array<Array<Scalars["Float"]["output"]>>;
 };
@@ -4319,7 +4321,7 @@ export type VideoExportJobGql = {
   createdAt?: Maybe<Scalars["DateTime"]["output"]>;
   downloadUrl?: Maybe<Scalars["String"]["output"]>;
   expiresAt?: Maybe<Scalars["DateTime"]["output"]>;
-  fileSizeBytes?: Maybe<Scalars["Int"]["output"]>;
+  fileSizeBytes?: Maybe<Scalars["BigInt"]["output"]>;
   id: Scalars["Int"]["output"];
   mode: VideoExportModeEnum;
   runId?: Maybe<Scalars["Int"]["output"]>;
@@ -6891,8 +6893,10 @@ export type ReactToVideoMutation = {
 };
 
 export type GetShotLabVideosQueryVariables = Exact<{
-  userId: Scalars["Int"]["input"];
+  feedInput: VideoFeedInputGql;
+  includePrivate: IncludePrivateEnum;
   limit?: Scalars["Int"]["input"];
+  after?: InputMaybe<Scalars["String"]["input"]>;
 }>;
 
 export type GetShotLabVideosQuery = {
@@ -6920,6 +6924,11 @@ export type GetShotLabVideosQuery = {
         lastSegmentUploadedAt?: any | null;
       } | null;
     }>;
+    pageInfo: {
+      __typename?: "PageInfoGQL";
+      hasNextPage: boolean;
+      endCursor?: string | null;
+    };
   };
 };
 
@@ -8149,6 +8158,8 @@ export type GetUsageStatsQuery = {
       activationCohort: number;
       activationActivated: number;
       payingUsers: number;
+      pastDueUsers: number;
+      newPaidToday: number;
       newPaid7d: number;
       newPaid30d: number;
       retentionPrevActive: number;
@@ -8161,6 +8172,7 @@ export type GetUsageStatsQuery = {
       activated7d: number;
       paid7d: number;
       activatedNotPaid7d: number;
+      paidTotal: number;
     }>;
     windows: Array<{
       __typename?: "UsageStatsWindowGQL";
@@ -9275,7 +9287,7 @@ export type VideoExportJobFieldsFragment = {
   shotIds?: Array<number> | null;
   runId?: number | null;
   downloadUrl?: string | null;
-  fileSizeBytes?: number | null;
+  fileSizeBytes?: any | null;
   expiresAt?: any | null;
   createdAt?: any | null;
 };
@@ -9297,7 +9309,7 @@ export type RequestVideoExportMutation = {
     shotIds?: Array<number> | null;
     runId?: number | null;
     downloadUrl?: string | null;
-    fileSizeBytes?: number | null;
+    fileSizeBytes?: any | null;
     expiresAt?: any | null;
     createdAt?: any | null;
   };
@@ -9329,7 +9341,7 @@ export type VideoExportJobQuery = {
     shotIds?: Array<number> | null;
     runId?: number | null;
     downloadUrl?: string | null;
-    fileSizeBytes?: number | null;
+    fileSizeBytes?: any | null;
     expiresAt?: any | null;
     createdAt?: any | null;
   } | null;
@@ -9353,7 +9365,7 @@ export type MyVideoExportsQuery = {
     shotIds?: Array<number> | null;
     runId?: number | null;
     downloadUrl?: string | null;
-    fileSizeBytes?: number | null;
+    fileSizeBytes?: any | null;
     expiresAt?: any | null;
     createdAt?: any | null;
   }>;
@@ -15171,12 +15183,18 @@ export type ReactToVideoMutationOptions = Apollo.BaseMutationOptions<
   ReactToVideoMutationVariables
 >;
 export const GetShotLabVideosDocument = gql`
-  query GetShotLabVideos($userId: Int!, $limit: Int! = 25) {
+  query GetShotLabVideos(
+    $feedInput: VideoFeedInputGQL!
+    $includePrivate: IncludePrivateEnum!
+    $limit: Int! = 25
+    $after: String = null
+  ) {
     getFeedVideos(
       limit: $limit
+      after: $after
       includeCallersVideos: false
-      includePrivate: MINE
+      includePrivate: $includePrivate
-      feedInput: { userId: $userId }
+      feedInput: $feedInput
     ) {
       videos {
         id
@@ -15196,6 +15214,10 @@ export const GetShotLabVideosDocument = gql`
           lastSegmentUploadedAt
         }
       }
+      pageInfo {
+        hasNextPage
+        endCursor
+      }
     }
   }
 `;
@@ -15212,8 +15234,10 @@ export const GetShotLabVideosDocument = gql`
  * @example
  * const { data, loading, error } = useGetShotLabVideosQuery({
  *   variables: {
- *      userId: // value for 'userId'
+ *      feedInput: // value for 'feedInput'
+ *      includePrivate: // value for 'includePrivate'
  *      limit: // value for 'limit'
+ *      after: // value for 'after'
  *   },
  * });
  */
@@ -17236,6 +17260,8 @@ export const GetUsageStatsDocument = gql`
         activationCohort
         activationActivated
         payingUsers
+        pastDueUsers
+        newPaidToday
         newPaid7d
         newPaid30d
         retentionPrevActive
@@ -17247,6 +17273,7 @@ export const GetUsageStatsDocument = gql`
         activated7d
         paid7d
         activatedNotPaid7d
+        paidTotal
       }
       totalUsers
       totalVideos

src/operations/recorded_shots.gql

@@ -1,12 +1,19 @@
-# Lightweight two-step picker data for Shot Lab's video-first source: the
+# Lightweight two-step picker data for Shot Lab's video-first source: recent
-# caller's recent videos (completed or still uploading), then that video's
+# videos from the requested audience (mine, followed users, or public), then
-# shots. The stream fields hint at "actively updating" without gating.
+# that video's shots. The stream fields hint at "actively updating" without
-query GetShotLabVideos($userId: Int!, $limit: Int! = 25) {
+# gating.
+query GetShotLabVideos(
+  $feedInput: VideoFeedInputGQL!
+  $includePrivate: IncludePrivateEnum!
+  $limit: Int! = 25
+  $after: String = null
+) {
   getFeedVideos(
     limit: $limit
+    after: $after
     includeCallersVideos: false
-    includePrivate: MINE
+    includePrivate: $includePrivate
-    feedInput: { userId: $userId }
+    feedInput: $feedInput
   ) {
     videos {
       id
@@ -26,6 +33,10 @@ query GetShotLabVideos($userId: Int!, $limit: Int! = 25) {
         lastSegmentUploadedAt
       }
     }
+    pageInfo {
+      hasNextPage
+      endCursor
+    }
   }
 }
 

src/operations/usage_stats.gql

@@ -7,6 +7,8 @@ query getUsageStats($days: Int! = 30) {
       activationCohort
       activationActivated
       payingUsers
+      pastDueUsers
+      newPaidToday
       newPaid7d
       newPaid30d
       retentionPrevActive
@@ -18,6 +20,7 @@ query getUsageStats($days: Int! = 30) {
       activated7d
       paid7d
       activatedNotPaid7d
+      paidTotal
     }
     totalUsers
     totalVideos

src/schema.gql

@@ -214,6 +214,7 @@ type CohortStatsGQL {
   activated7d: Int!
   paid7d: Int!
   activatedNotPaid7d: Int!
+  paidTotal: Int!
 }
 
 type CommentGQL {
@@ -249,6 +250,11 @@ input CreatePoolHallCameraInput {
   claimTermsText: String = null
 }
 
+input CreateShotShareLinkInput {
+  shotIds: [Int!]!
+  paddingSeconds: Float = null
+}
+
 input CreatePoolHallInput {
   name: String!
   address: String = null
@@ -464,6 +470,8 @@ type FunnelStatsGQL {
   activationCohort: Int!
   activationActivated: Int!
   payingUsers: Int!
+  pastDueUsers: Int!
+  newPaidToday: Int!
   newPaid7d: Int!
   newPaid30d: Int!
   retentionPrevActive: Int!
@@ -1713,7 +1721,6 @@ type TableStateGQL {
   identifierToPosition: [[Float!]!]!
   homography: HomographyInfoGQL
   identifierToColor: [RGBColorGQL]!
-  identifierToBox: [BoundingBoxGQL!]!
 }
 
 type TagClassGQL {
@@ -1925,6 +1932,11 @@ type UserSubscriptionStatusGQL {
   stripeSubscriptionId: String
 }
 
+type ShareLinkGQL {
+  slug: String!
+  url: String!
+}
+
 type VideoExportJobGQL {
   id: Int!
   videoId: Int!
@@ -1935,7 +1947,7 @@ type VideoExportJobGQL {
   shotIds: [Int!]
   runId: Int
   downloadUrl: String
-  fileSizeBytes: Int
+  fileSizeBytes: BigInt
   expiresAt: DateTime
   createdAt: DateTime
 }