MetaAPI2

Tables (7)

Untitled (ad_performance_daily)

  • ad_id — INT — Foreign key → ad.ad_id — NOT NULL
  • Field (date_start) — DATE — NOT NULL
  • Field (age) — VARCHAR(50) — NOT NULL
  • Field (gender) — VARCHAR(50) — NOT NULL
  • Field (reach) — INT
  • Field (impressions) — INT
  • Field (inline_post_engagement) — INT
  • Field (inline_link_clicks) — INT
  • Field (unique_link_clicks_ctr) — NUMERIC
  • Field (ctr) — NUMERIC
  • Field (landing_page_view_per_link_click) — INT

Untitled (keyword)

  • ad_id — INT — Foreign key → ad.ad_id — NOT NULL
  • Field (essential_keywords) — VARCHAR(255)
  • Field (essential_update) — DATE
  • Field (variable_keywords) — VARCHAR(255)
  • Field (variable_update) — DATE

ad

  • ad_id — INT — Primary key — NOT NULL
  • account_id — INT — Foreign key → ad_account.account_id — NOT NULL
  • ad_name — VARCHAR(255) — NOT NULL
  • Field (body) — VARCHAR(255)
  • Field (created_time) — DATE — NOT NULL
  • Field (adset_start) — DATE
  • Field (adset_end) — DATE

ad_account

  • account_id — INT — Primary key — NOT NULL
  • fb_ad_account_id — INT — NOT NULL
  • account_name — VARCHAR(50)
  • account_status — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • crated_at (created_at) — DATE — NOT NULL

ad_performance_accumulative

  • ad_id — INT — Foreign key → ad.ad_id — NOT NULL
  • Field (date_start) — DATE — NOT NULL
  • Field (age) — VARCHAR(50) — NOT NULL
  • Field (gender) — VARCHAR(20) — NOT NULL
  • Field (reach) — INT
  • Field (impressions) — INT
  • Field (inline_post_engagement) — INT
  • Field (inline_link_clicks) — INT
  • Field (unique_link_clicks_ctr) — NUMERIC
  • Field (ctr) — NUMERIC
  • Field (landing_page_view_per_link_click) — INT

assigned_account

  • account_id — INT — Foreign key → ad_account.account_id — NOT NULL
  • client_id — INT — Foreign key → user.user_id
  • builder_id — INT — Foreign key → user.user_id
  • partner_id — INT — Foreign key → user.user_id

user

  • user_id — INT — Primary key — NOT NULL
  • role — VARCHAR(50)
  • created_at — DATE — NOT NULL