BigQuery: Facebook Owned Metrics Schema

{
  "schema": {
    "fields": [
      { "name": "DATA_SYNC_TIME", "type": "DATETIME" },
      { "name": "REPORTING_PERIOD_START_DATE", "type": "DATE" },
      { "name": "REPORTING_PERIOD_END_DATE", "type": "DATE" },
      { "name": "REPORTING_PERIOD_IN_DAYS", "type": "INTEGER" },
      { "name": "AVG_REACH", "type": "FLOAT" },
      { "name": "AVG_EFFECTIVENESS", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE", "type": "FLOAT" },
      { "name": "COMMENTS", "type": "FLOAT" },
      { "name": "LINK_CLICKS", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS", "type": "FLOAT" },
      { "name": "OTHER_CLICKS", "type": "FLOAT" },
      { "name": "FOLLOWER_GROWTH_RATE", "type": "FLOAT" },
      { "name": "NET_NEW_FOLLOWERS", "type": "FLOAT" },
      { "name": "TOTAL_FOLLOWERS", "type": "FLOAT" },
      { "name": "PAGE_REACH", "type": "FLOAT" },
      { "name": "PHOTO_VIEW_CLICKS", "type": "FLOAT" },
      { "name": "POST_CLICKS", "type": "FLOAT" },
      { "name": "IMPRESSIONS_BY_POST", "type": "FLOAT" },
      { "name": "REACTIONS", "type": "FLOAT" },
      { "name": "SHARES", "type": "FLOAT" },
      { "name": "TOTAL_ENGAGEMENTS", "type": "FLOAT" },
      { "name": "VIDEO_COMPLETE_VIEWS", "type": "FLOAT" },
      { "name": "VIDEO_VIEWS", "type": "FLOAT" },
      { "name": "COMMENT_SENTIMENT_POSITIVE_RATE", "type": "FLOAT" },
      { "name": "COMMENT_SENTIMENT_NEUTRAL_RATE", "type": "FLOAT" },
      { "name": "COMMENT_SENTIMENT_NEGATIVE_RATE", "type": "FLOAT" }
    ]
  }
}