raw_ad: 28
This data as json
rowid | id | external_id | raw_data | base_fk_updated_at |
---|---|---|---|---|
28 | 019081d2-d7fa-7f4f-a559-e74ca47f57d0 | 727528911425555_facebook_241589262962248 | { "adid": "0", "spend": "<$100", "pageID": "241589262962248", "endDate": 1598511600, "fevInfo": null, "aaa_info": null, "currency": "USD", "isActive": false, "pageInfo": null, "pageName": "ExxonMobil Guyana", "snapshot": { "body": { "markup": { "__html": "ExxonMobil Guyana President Alistair Routledge clarifies statement about the Payara project." }, "context": {}, "callerHash": null }, "cards": [], "event": [], "title": "Alistair Routledge- Statement", "byline": null, "images": [], "videos": [ { "video_hd_url": "", "video_sd_url": "https://video-ord5-2.xx.fbcdn.net/v/t42.9040-2/118444998_1237987789895868_4388994908079260408_n.mp4?_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=es_CnRlcoh0Q7kNvgHnlVeP&_nc_ht=video-ord5-2.xx&oh=00_AYDaZvAnBcJxyx1qkrs0tdcgmbuYXbVwpO8waG603e4CLQ&oe=6687C584", "video_preview_image_url": "https://scontent-ord5-1.xx.fbcdn.net/v/t39.35426-6/131182102_3634396556627942_2594969481899509859_n.jpg?_nc_cat=111&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=va0YaZ-kdKQQ7kNvgFPrXmn&_nc_ht=scontent-ord5-1.xx&oh=00_AYD7d0K7Q73A9FMDMt14D5p39C5PgVzO1jscdnTHTJfHFw&oe=668D7D9C", "watermarked_video_sd_url": "" } ], "caption": "www.exxonmobil.com", "page_id": 241589262962248, "version": 3, "cta_text": "Learn more", "cta_type": "LEARN_MORE", "link_url": "http://www.exxonmobil.com/", "page_name": "ExxonMobil Guyana", "extra_links": [], "extra_texts": [], "is_reshared": false, "extra_images": [], "extra_videos": [], "brazil_tax_id": null, "creation_time": 1608005914, "instagram_url": "", "ad_creative_id": "23845988473280302", "display_format": "video", "additional_info": null, "branded_content": null, "ec_certificates": null, "page_categories": { "2238": "Energy Company" }, "page_is_deleted": false, "page_like_count": 220163, "country_iso_code": null, "disclaimer_label": null, "dynamic_versions": null, "edited_snapshots": [], "instagram_handle": "", "link_description": null, "page_entity_type": "person_profile", "page_profile_uri": "https://facebook.com/exxonmobilguyana", "body_translations": {}, "current_page_name": "ExxonMobil Guyana", "dynamic_item_flags": {}, "root_reshared_post": null, "instagram_actor_name": "ExxonMobil Guyana", "page_is_profile_page": false, "page_welcome_message": null, "page_profile_picture_url": "https://scontent-ord5-1.xx.fbcdn.net/v/t1.6435-9/48277485_620126675108503_2922433157087100928_n.jpg?stp=dst-jpg_s60x60&_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=U2MuWRdrE9gQ7kNvgELR3e4&_nc_ht=scontent-ord5-1.xx&oh=00_AYBhX9rjBxOXlnSrGSIpTIF_9g3ikNbiDd96CVRIqkecsg&oe=66AF258C", "instagram_branded_content": null, "instagram_profile_pic_url": "https://scontent-ord5-1.xx.fbcdn.net/v/t39.35426-6/131374443_301206627917585_3852877000705427118_n.jpg?_nc_cat=108&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=3SZtE7icT5EQ7kNvgF2478Y&_nc_ht=scontent-ord5-1.xx&oh=00_AYAJPVVRyWwZvWTghwYy0UsrYUFnptpqRO3vGQoquULbyA&oe=668D5995", "instagram_shopping_products": [], "effective_authorization_category": "NONE" }, "gatedType": "taken-down", "menuItems": [], "startDate": 1598511600, "advertiser": { "page": { "id": "241589262962248", "about": { "text": "Official Facebook account of ExxonMobil in Guyana." }, "is_delegate_page_with_linked_primary_profile": false }, "ad_library_page_info": null }, "categories": [ 1 ], "entityType": "person_profile", "adArchiveID": "727528911425555", "collationID": 362341058101774, "reportCount": null, "archiveTypes": [ 1 ], "finServAdData": { "is_deemed_finserv": false, "is_limited_delivery": false }, "isAAAEligible": false, "isProfilePage": false, "pageIsDeleted": false, "reachEstimate": "500K - 1M", "collationCount": 1, "hideDataStatus": "NONE", "hasUserReported": false, "violation_types": [], "hiddenSafetyData": false, "publisherPlatform": [ "facebook", "instagram", "messenger" ], "politicalCountries": [ "GY" ], "source_platform_id": "facebook", "stateMediaRunLabel": null, "isAdAccountActioned": false, "impressionsWithIndex": { "impressionsText": "30K - 35K", "impressionsIndex": 14 }, "source_advertiser_id": "241589262962248", "verified_voice_context": null, "containsSensitiveContent": false, "containsDigitallyCreatedMedia": false } |
2024-07-05 07:36:45.050619 |