home / unwash_db / ad

ad: 88

This data as json

rowid id source_ad_id raw_data details processed_details advertiser_id created_at updated_at media_archived_at
88 01908219-3c66-7df6-9333-debdad549c2b 439572538822015
{
    "adid": "0",
    "spend": "<$100",
    "pageID": "925007000949719",
    "endDate": 1717743600,
    "fevInfo": {
        "email": "socialmedia@exxonmobil.com",
        "phone": "+19729406007",
        "address": "5959 Las Colinas Blvd, Irving, TX 75039-2298, US",
        "website": "http://www.exxonmobil.com/",
        "submitted_on": "Submitted Oct 23, 2020",
        "learn_more_content": {
            "help_center_url": "https://www.facebook.com/help/180607332665293?ref=infosheet",
            "learn_more_text": "Learn more",
            "help_center_text": "Visit the Help Center to learn about what we require from advertisers to run ads about social issues, elections or politics."
        },
        "fec_additional_info": null,
        "authorized_entity_text": "This information was confirmed using an employer identification number (EIN).",
        "free_form_additional_info": null,
        "page_name_additional_info": null,
        "page_admin_additional_info": null
    },
    "aaa_info": null,
    "currency": "USD",
    "isActive": false,
    "pageInfo": null,
    "pageName": "ExxonMobil",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "Experts agree: CCS is one of the most important low-carbon technologies required to achieve societal climate goals. <br /> <br /> Discover the Impact of CCS &gt;&gt;"
            },
            "context": {},
            "callerHash": null
        },
        "cards": [],
        "event": [],
        "title": "Carbon Capture & Storage",
        "byline": "EXXON MOBIL CORPORATION",
        "images": [],
        "videos": [
            {
                "video_hd_url": "https://video-atl3-1.xx.fbcdn.net/v/t42.1790-2/447568700_439572558822013_1436023370838115821_n.?_nc_cat=100&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=5AGYfuIDiKEQ7kNvgEbWTM1&_nc_ht=video-atl3-1.xx&oh=00_AYBHvwbC-iNE61M64_7uGg-4Wl5mX3k7EGrucY9wSPYlow&oe=668D71B0",
                "video_sd_url": "https://video-atl3-1.xx.fbcdn.net/v/t42.1790-2/447915877_428042260194269_2616829306073543039_n.mp4?_nc_cat=109&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=yzub_UG-kywQ7kNvgHbA4sq&_nc_ht=video-atl3-1.xx&oh=00_AYC5KeK74JHBx5PAoN7ZDFmkB_emLBH9blpmCOkCa5r8_Q&oe=668D8475",
                "video_preview_image_url": "https://scontent-atl3-1.xx.fbcdn.net/v/t39.35426-6/446881157_813571530704603_1169865209028386033_n.jpg?_nc_cat=100&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=YqTfrQmsOdYQ7kNvgHmgLvg&_nc_ht=scontent-atl3-1.xx&oh=00_AYC94FT2DraLCx8bzdD46-aLH9RTKazldqx1-KmqF4LHZA&oe=668D7F82",
                "watermarked_video_hd_url": "",
                "watermarked_video_sd_url": ""
            }
        ],
        "caption": "exxchange.com",
        "page_id": 925007000949719,
        "version": 3,
        "cta_text": "Learn more",
        "cta_type": "LEARN_MORE",
        "link_url": "https://www.exxchange.com/ccs_educational",
        "page_name": "ExxonMobil",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": "",
        "creation_time": 1717592911,
        "instagram_url": "",
        "ad_creative_id": "120209963004170330",
        "display_format": "video",
        "additional_info": null,
        "branded_content": null,
        "ec_certificates": null,
        "page_categories": {
            "2238": "Energy Company"
        },
        "page_is_deleted": false,
        "page_like_count": 3006695,
        "country_iso_code": "US",
        "disclaimer_label": 1,
        "dynamic_versions": null,
        "edited_snapshots": [],
        "instagram_handle": "",
        "link_description": "Learn More Now",
        "page_entity_type": "person_profile",
        "page_profile_uri": "https://facebook.com/ExxonMobil",
        "body_translations": {},
        "current_page_name": "ExxonMobil",
        "dynamic_item_flags": {},
        "root_reshared_post": null,
        "instagram_actor_name": "",
        "page_is_profile_page": false,
        "page_welcome_message": null,
        "page_profile_picture_url": "https://scontent-atl3-2.xx.fbcdn.net/v/t39.35426-6/446809222_445642268177470_2266946921075055229_n.jpg?stp=dst-jpg_s60x60&_nc_cat=104&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=dWT2fsDcbNcQ7kNvgFNW7OJ&_nc_ht=scontent-atl3-2.xx&oh=00_AYA5CWEUY8hFiV6cG2LkSXEjM_PtFw0cCEbbCO6mAMRrhQ&oe=668D9A54",
        "instagram_branded_content": null,
        "instagram_profile_pic_url": "",
        "instagram_shopping_products": [],
        "effective_authorization_category": "POLITICAL"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1717657200,
    "advertiser": {
        "page": {
            "id": "925007000949719",
            "about": {
                "text": "Committed to responsibly meeting the world's energy needs."
            },
            "is_delegate_page_with_linked_primary_profile": false
        },
        "ad_library_page_info": null
    },
    "categories": [
        1
    ],
    "entityType": "person_profile",
    "adArchiveID": "439572538822015",
    "collationID": 974194687479536,
    "reportCount": null,
    "archiveTypes": [],
    "finServAdData": {
        "is_deemed_finserv": false,
        "is_limited_delivery": false
    },
    "isAAAEligible": false,
    "isProfilePage": false,
    "pageIsDeleted": false,
    "reachEstimate": "5K - 10K",
    "collationCount": 1,
    "hideDataStatus": "NONE",
    "hasUserReported": false,
    "violation_types": [],
    "hiddenSafetyData": false,
    "publisherPlatform": [
        "facebook"
    ],
    "politicalCountries": [
        "US"
    ],
    "source_platform_id": "facebook",
    "stateMediaRunLabel": null,
    "isAdAccountActioned": false,
    "impressionsWithIndex": {
        "impressionsText": "<1K",
        "impressionsIndex": 0
    },
    "source_advertiser_id": "925007000949719",
    "verified_voice_context": {
        "types": [
            "POLITICAL"
        ],
        "ad_library_fin_serv_info": null
    },
    "containsSensitiveContent": false,
    "containsDigitallyCreatedMedia": false
}
{
    "stats": {
        "spend": "<$100",
        "report_count": null,
        "reach_estimate": "5K - 10K",
        "impression_text": "<1K"
    },
    "content": {
        "all_links": [
            "https://www.facebook.com/help/180607332665293?ref=infosheet",
            "https://www.exxchange.com/ccs_educational",
            "http://www.exxonmobil.com/",
            "https://facebook.com/ExxonMobil",
            "https://scontent-atl3-2.xx.fbcdn.net/v/t39.35426-6/446809222_445642268177470_2266946921075055229_n.jpg?stp=dst-jpg_s60x60&_nc_cat=104&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=dWT2fsDcbNcQ7kNvgFNW7OJ&_nc_ht=scontent-atl3-2.xx&oh=00_AYA5CWEUY8hFiV6cG2LkSXEjM_PtFw0cCEbbCO6mAMRrhQ&oe=668D9A54"
        ],
        "all_texts": [
            "learn more",
            "exxchange.com",
            "learn_more",
            "learn more now",
            "exxon mobil corporation",
            "carbon capture & storage"
        ],
        "all_images": [
            "images/9547272421c20cf2.jpeg"
        ],
        "all_videos": [
            "videos/da95789678337559.mp4",
            "videos/bb114fd18dcd16ad.mp4"
        ]
    },
    "metadata": {
        "currency": "USD",
        "duration": {
            "end_date": "2024-06-07T07:00:00Z",
            "start_date": "2024-06-06T07:00:00Z"
        },
        "countries": [
            "US"
        ],
        "categories": [
            "Energy Company"
        ]
    }
}
{
    "ocr": {
        "processed": true
    },
    "bert_classify": {
        "result": {
            "score": 0.9977438449859619
        },
        "processed": true
    },
    "transcription": {
        "processed": true
    }
}
019082e4-d857-76f8-933f-427dc9e613c0 2024-07-05 12:35:54.07911 2024-08-03 19:38:08.078547 2024-07-05 14:37:39.100373
Powered by Datasette · Queries took 0.743ms