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