MetaAPI

Tables (6)

Untitled (post_info)

  • Key (post_id) — INT — Primary key — NOT NULL
  • Field (post_title) — NOT NULL
  • Field2 (post_caption) — NOT NULL
  • Field (post_timestamp) — DATETIME — NOT NULL

Untitled (ad_reach)

  • Key (ad_id) — INT — Primary key — NOT NULL
  • Field (date_start) — DATETIME — NOT NULL
  • Field (age) — VARCHAR(10) — NOT NULL
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Field (reach) — INT
  • Field (impressions) — INT

Untitled (ad_engagement)

  • Key (ad_id) — INT — Primary key — NOT NULL
  • Field (date_start) — DATETIME — NOT NULL
  • Field (age) — VARCHAR(10) — NOT NULL
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Field (inline_post_engagement)

Untitled (post_engagement)

  • Key (post_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (age) — VARCHAR(10) — NOT NULL
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Field (page_post_engagements)
  • Field (post_reactions_by_type_total)
  • Field (hide_clicks)
  • Field (hide_all_clicks)
  • Field (report_spam_clicks)
  • Field (unlike_page_clicks)

Untitled (ad_click)

  • Key (ad_id) — INT — Primary key — NOT NULL
  • Field (date_start) — DATETIME — NOT NULL
  • Field (age) — VARCHAR(10) — NOT NULL
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Field (reach) — INT
  • Field (inline_link_clicks) — INT
  • Field (unique_link_clicks_ctr) — FLOAT
  • Field (ctr) — FLOAT
  • Field (landing_page_view_per_link_click) — INT

ad_info

  • ad_id — INT — Primary key — NOT NULL
  • Key (post_id) — INT — Foreign key → Untitled.Key
  • ad_name — VARCHAR(100)
  • Field (created_time) — DATETIME — NOT NULL
  • Field (adset_start) — DATETIME
  • Field (adset_end) — DATETIME