Table: facebookmarketing_promote_pages
This table shows data for Facebook Marketing Promote Pages.
https://developers.facebook.com/docs/graph-api/reference/page#Reading (opens in a new tab)
The composite primary key for this table is (account_id, id).
Columns
| Name | Type |
|---|---|
| _cq_source_name | String |
| _cq_sync_time | Timestamp |
| _cq_id | UUID |
| _cq_parent_id | UUID |
| account_id (PK) | String |
| about | String |
| access_token | String |
| ad_campaign | JSON |
| affiliation | String |
| app_id | String |
| artists_we_like | String |
| attire | String |
| awards | String |
| band_interests | String |
| band_members | String |
| best_page | JSON |
| bio | String |
| birthday | String |
| booking_agent | String |
| built | String |
| can_checkin | Bool |
| can_post | Bool |
| category | String |
| category_list | JSON |
| checkins | Int |
| company_overview | String |
| connected_instagram_account | JSON |
| connected_page_backed_instagram_account | JSON |
| contact_address | JSON |
| copyright_whitelisted_ig_partners | StringArray |
| country_page_likes | Int |
| cover | JSON |
| culinary_team | String |
| current_location | String |
| delivery_and_pickup_option_info | StringArray |
| description | String |
| description_html | String |
| differently_open_offerings | JSON |
| directed_by | String |
| display_subtext | String |
| displayed_message_response_time | String |
| emails | StringArray |
| engagement | JSON |
| fan_count | Int |
| featured_video | JSON |
| features | String |
| followers_count | Int |
| food_styles | StringArray |
| founded | String |
| general_info | String |
| general_manager | String |
| genre | String |
| global_brand_page_name | String |
| global_brand_root_id | String |
| has_added_app | Bool |
| has_transitioned_to_new_page_experience | Bool |
| has_whatsapp_business_number | Bool |
| has_whatsapp_number | Bool |
| hometown | String |
| hours | JSON |
| id (PK) | String |
| impressum | String |
| influences | String |
| instagram_business_account | JSON |
| instant_articles_review_status | String |
| is_always_open | Bool |
| is_chain | Bool |
| is_community_page | Bool |
| is_eligible_for_branded_content | Bool |
| is_messenger_bot_get_started_enabled | Bool |
| is_messenger_platform_bot | Bool |
| is_owned | Bool |
| is_permanently_closed | Bool |
| is_published | Bool |
| is_unclaimed | Bool |
| is_verified | Bool |
| is_webhooks_subscribed | Bool |
| leadgen_tos_acceptance_time | Timestamp |
| leadgen_tos_accepted | Bool |
| leadgen_tos_accepting_user | JSON |
| link | String |
| location | JSON |
| members | String |
| merchant_id | String |
| merchant_review_status | String |
| messaging_feature_status | JSON |
| messenger_ads_default_icebreakers | StringArray |
| messenger_ads_default_page_welcome_message | JSON |
| messenger_ads_default_quick_replies | StringArray |
| messenger_ads_quick_replies_type | String |
| mini_shop_storefront | JSON |
| mission | String |
| mpg | String |
| name | String |
| name_with_location_descriptor | String |
| network | String |
| new_like_count | Int |
| offer_eligible | Bool |
| overall_star_rating | Float |
| owner_business | JSON |
| page_token | String |
| parent_page | JSON |
| parking | JSON |
| payment_options | JSON |
| personal_info | String |
| personal_interests | String |
| pharma_safety_info | String |
| phone | String |
| pickup_options | StringArray |
| place_type | String |
| plot_outline | String |
| preferred_audience | JSON |
| press_contact | String |
| price_range | String |
| privacy_info_url | String |
| produced_by | String |
| products | String |
| promotion_eligible | Bool |
| promotion_ineligible_reason | String |
| public_transit | String |
| rating_count | Int |
| recipient | String |
| record_label | String |
| release_date | String |
| restaurant_services | JSON |
| restaurant_specialties | JSON |
| schedule | String |
| screenplay_by | String |
| season | String |
| single_line_address | String |
| starring | String |
| start_info | JSON |
| store_code | String |
| store_location_descriptor | String |
| store_number | Int |
| studio | String |
| supports_donate_button_in_live_video | Bool |
| supports_instant_articles | Bool |
| talking_about_count | Int |
| temporary_status | String |
| unread_message_count | Int |
| unread_notif_count | Int |
| unseen_message_count | Int |
| username | String |
| verification_status | String |
| voip_info | JSON |
| website | String |
| were_here_count | Int |
| whatsapp_number | String |
| written_by | String |
