home / unwash_db / raw_ad

raw_ad: 30

This data as json

rowid id external_id raw_data base_fk_updated_at
30 019081d2-d7fa-7ecf-862a-965fcef224ab 727528911425555_messenger_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": "messenger",
    "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
Powered by Datasette · Queries took 1.735ms