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