ad_enriched: 4

This data as json

rowid id source_ad_id details advertiser_name platform_name enriched_data
4 01908219-3c62-744f-9d92-8cbdd28a9a6e 319594967876215 
{
    "stats": {
        "spend": "<$100",
        "report_count": null,
        "reach_estimate": ">1M",
        "impression_text": "1K - 2K"
    },
    "content": {
        "all_links": [
            "https://www.facebook.com/help/180607332665293?ref=infosheet",
            "https://www.exxchange.com/learn?&utm_source=facebook&utm_medium=ad&utm_campaign=exxchange_targetstates_acquisition_102169_facebook_20230824-20231231_display-na-na_na_1v_y4_",
            "https://facebook.com/ExxonMobil",
            "http://www.exxonmobil.com/",
            "http://fb.me/",
            "https://scontent.fmkc1-1.fna.fbcdn.net/v/t39.35426-6/448097179_412755638427049_339893647121789117_n.jpg?stp=dst-jpg_s60x60&_nc_cat=100&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=FadXOqmoD6IQ7kNvgGtODV6&_nc_ht=scontent.fmkc1-1.fna&gid=AILbdxvP-SL9J6MpcIb5TTr&oh=00_AYAt8JTX5QH6yT9cjlGv6vkzJyHZ3lPg4KtQHYEJRxET6Q&oe=668D8A62",
            "https://www.exxchange.com/terms_and_conditions"
        ],
        "all_texts": [
            "sign up",
            "sign_up",
            "exxon mobil corporation",
            "one question poll",
            "fb.me",
            "respond now"
        ],
        "all_images": [
            "images/9126a2c0fc3e3b29.jpeg",
            "images/bd08f4674e4f4753.png"
        ],
        "all_videos": []
    },
    "metadata": {
        "currency": "USD",
        "duration": {
            "end_date": "2024-06-28T07:00:00Z",
            "start_date": "2024-06-14T07:00:00Z"
        },
        "countries": [
            "US"
        ],
        "categories": [
            "Energy Company"
        ]
    }
}
 ExxonMobil facebook 
{
    "obj_detect": [
        "The image is a graphic with a teal background featuring bold text and a red button, asking a question about addressing plastic waste and asking the viewer to respond with \"YES\" or \"NO\".",
        "The image is a graphic with a teal background featuring bold text and a button, asking a question about addressing plastic waste and indicating a response with \"YES\" and \"NO\" options."
    ],
    "bert_classify": {
        "score": 0.9814972877502441
    },
    "transcription": [],
    "ocr_extraction": [
        "CHALLENGE OF\nPLASTIC WASTE\n\n \n\f",
        "CHALLENGE OF\nPLASTIC WASTE\n\n4 NO\n\f"
    ]
}