connect 'jdbc:meta:https://graph.facebook.com/v25.0|spec=meta-spec.json,token=<SYSTEM_USER_TOKEN>'

status

SELECT page_id, name, insta_user_id, followers_count, fan_count
FROM fbk_page_insights
;

SELECT page_id, dat, page_total_media_view_unique, page_post_engagements
FROM fbk_page_insights_daily
FILTER von_dt='2025-01-01' AND bis_dt='2025-01-31'
;

SELECT insta_user_id, name, follower_bestand, dat
FROM ins_page_insights
;

SELECT insta_user_id, dat, reach, likes, comments, views, follower_count
FROM ins_page_insights_daily
FILTER von_dt='2025-01-01' AND bis_dt='2025-01-31'
;

SELECT insta_user_id, media_id, media_type, caption, "timestamp", permalink
FROM ins_media
;

SELECT insta_user_id, media_id, dat, media_type, reach, likes, comments, views
FROM ins_media_insights
FILTER von_dt='2025-01-01' AND bis_dt='2025-01-31'
;

SELECT ad_account_id, name, business_name, currency
FROM meta_ad_account
;

SELECT ad_account_id, campaign_id, name, status, objective
FROM meta_campaign
;

SELECT ad_account_id, adset_id, campaign_id, name, status
FROM meta_adset
;

SELECT ad_account_id, ad_id, adset_id, name, effective_status
FROM meta_ad
;

SELECT ad_account_id, ad_id, datum, impressions, clicks, spend
FROM meta_ad_stats
FILTER von_dt='2025-01-01' AND bis_dt='2025-01-31' AND load_type=delta
;

SELECT ad_account_id, ad_id, datum, conversions, action_type
FROM meta_conversion_stats
FILTER von_dt='2025-01-01' AND bis_dt='2025-01-31' AND load_type=delta
;
