Actions GraphQL & DynamoBD Schema Contract

actions.md

DynamoDB Item Schema

Currently we have 5 predefined time range - Last 7, 14, 30, 90 days, and all - so we will have 5 items per pixel per type per subtype

// for type_id - geo (12), segment(13), multiscore (14), and user agent (15)
// for time_range - 0 (all), 7 (last 7 days), 14 (last 14 days), 30 (last 30 days), 90 (last 90 days)
{
  metric_id: 123-7-13-1, // {pixel_id}-{time_range}-{type_id}-{subtype_id}
  pixel_id: 123,
  metrics: {
    18-24: {
      total_universe: 100,
      actions: 80,
      unique_actions: 50
    },
    ...
  }
}

// for summary (11)
{
  metric_id: 123-7-11,
  pixel_id: 123,
  metrics: {
    total_universe: 100,
    actions: 80,
    unique_actions: 50
  }
}

GraphQL Schema

  ActionPixel {
    id: ID!
    name: String
    summary(time_period: Int): ActionPixelSummary
    metrics(type_id: ID!, subtype_id ID, time_period: Int): [ActionPixelMetric]
  }
  
  ActionPixelSummary {
    actions: Int
    unique_actions: Int
    total_universe: Int
  }
  
  ActionPixelMetric {
    name: String!
    actions: Int
    unique_actions: Int
    total_universe: Int
  }