BigQuery: Instagram Feed 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_EFFECTIVENESS", "type": "FLOAT" },
      { "name": "AVG_EFFECTIVENESS_VIDEO", "type": "FLOAT" },
      { "name": "AVG_EFFECTIVENESS_REEL", "type": "FLOAT" },
      { "name": "AVG_EFFECTIVENESS_PHOTO", "type": "FLOAT" },
      { "name": "AVG_EFFECTIVENESS_CAROUSEL", "type": "FLOAT" },
      { "name": "AVG_EFFECTIVENESS_VIDEO_REEL", "type": "FLOAT" },
      { "name": "AVG_EFFECTIVENESS_PHOTO_CAROUSEL", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE_VIDEO", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE_REEL", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE_PHOTO", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE_CAROUSEL", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE_VIDEO_REEL", "type": "FLOAT" },
      { "name": "AVG_ENGAGEMENT_RATE_PHOTO_CAROUSEL", "type": "FLOAT" },
      { "name": "AVG_REACH", "type": "FLOAT" },
      { "name": "FOLLOWER_GROWTH_RATE", "type": "FLOAT" },
      { "name": "LIKESHOP_CLICKS", "type": "FLOAT" },
      { "name": "NET_NEW_FOLLOWERS", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS_VIDEO", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS_REEL", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS_CAROUSEL", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS_VIDEO_REEL", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS_PHOTO_CAROUSEL", "type": "FLOAT" },
      { "name": "ORGANIC_COMMENTS", "type": "FLOAT" },
      { "name": "IMPRESSIONS", "type": "FLOAT" },
      { "name": "ORGANIC_LIKES", "type": "FLOAT" },
      { "name": "ORGANIC_VIDEO_VIEWS", "type": "FLOAT" },
      { "name": "ORGANIC_VIDEO_VIEWS_REEL", "type": "FLOAT" },
      { "name": "SUM_TOTAL_ENGAGEMENTS", "type": "FLOAT" },
      { "name": "PAID_COMMENTS", "type": "FLOAT" },
      { "name": "PAID_IMPRESSIONS", "type": "FLOAT" },
      { "name": "PAID_LIKES", "type": "FLOAT" },
      { "name": "PAID_VIDEO_VIEWS", "type": "FLOAT" },
      { "name": "PAID_VIDEO_VIEWS_VIDEO", "type": "FLOAT" },
      { "name": "PAID_VIDEO_VIEWS_REEL", "type": "FLOAT" },
      { "name": "PAID_TOTAL_ENGAGEMENTS", "type": "FLOAT" },
      { "name": "PROFILE_VIEWS", "type": "FLOAT" },
      { "name": "SAVES", "type": "FLOAT" },
      { "name": "SHARES", "type": "FLOAT" },
      { "name": "SHARES_REEL", "type": "FLOAT" },
      { "name": "TEXT_MESSAGE_CLICKS", "type": "FLOAT" },
      { "name": "TOTAL_COMMENTS", "type": "FLOAT" },
      { "name": "TOTAL_ENGAGEMENTS", "type": "FLOAT" },
      { "name": "TOTAL_FOLLOWERS", "type": "FLOAT" },
      { "name": "TOTAL_IMPRESSIONS", "type": "FLOAT" },
      { "name": "TOTAL_LIKES", "type": "FLOAT" },
      { "name": "TOTAL_VIDEO_VIEWS", "type": "FLOAT" },
      { "name": "TOTAL_VIDEO_VIEWS_VIDEO", "type": "FLOAT" },
      { "name": "TOTAL_VIDEO_VIEWS_REEL", "type": "FLOAT" },
      { "name": "WEBSITE_CLICKS", "type": "FLOAT" },
      { "name": "EMAIL_CONTACT_CLICKS", "type": "FLOAT" },
      { "name": "FOLLOWERS_LOST", "type": "FLOAT" },
      { "name": "GET_DIRECTION_CLICKS", "type": "FLOAT" },
      { "name": "NUMBER_OF_POSTS_PHOTO", "type": "FLOAT" },
      { "name": "ORGANIC_VIDEO_VIEWS_VIDEO", "type": "FLOAT" },
      { "name": "AVG_ENTERTAINMENT_SCORE_REEL", "type": "FLOAT" },
      { "name": "COMMENT_SENTIMENT_POSITIVE_RATE", "type": "FLOAT" },
      { "name": "COMMENT_SENTIMENT_NEUTRAL_RATE", "type": "FLOAT" },
      { "name": "COMMENT_SENTIMENT_NEGATIVE_RATE", "type": "FLOAT" }
    ]
  }
}