home / unwash_db / ad_enriched

ad_enriched: 77

This data as json

rowid id source_ad_id details advertiser_name platform_name enriched_data
77 0190dff5-4250-7d7a-8096-f01f8ac7891a 1004143764322525
{
    "stats": {
        "spend": null,
        "report_count": null,
        "reach_estimate": null,
        "impression_text": null
    },
    "content": {
        "all_links": [
            "https://facebook.com/Shell",
            "https://scontent-atl3-1.xx.fbcdn.net/v/t39.35426-6/452515193_218093448065977_7045864920527518926_n.jpg?stp=dst-jpg_s60x60&_nc_cat=100&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=z50xHeikiu0Q7kNvgFzRh8N&_nc_ht=scontent-atl3-1.xx&oh=00_AYCfXBJucECFy-exjyAxAKo_sMdd4qzfL6YfuMJ9f7WqEg&oe=66A58CAC",
            "https://www.facebook.com/ads/library/?active_status=all&ad_type=all&country=ALL&view_all_page_id=200969413280005&sort_data[direction]=desc&sort_data[mode]=relevancy_monthly_grouped&search_type=page&media_type=all",
            "http://itunes.apple.com/app/id1451030918",
            "https://scontent-atl3-2.xx.fbcdn.net/v/t39.35426-6/452443553_1255317902547489_8374209722977409134_n.jpg?_nc_cat=104&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=JHitGwqEot0Q7kNvgGkQjQ3&_nc_ht=scontent-atl3-2.xx&oh=00_AYChOGw64KYdJOnOJgRa-KugsIz9-vkEst3C6VoGzYqHsA&oe=66A59974"
        ],
        "all_texts": [
            "learn_more",
            "learn more",
            "itunes.apple.com"
        ],
        "all_images": [
            "images/70fbc28f021f1da2.jpeg"
        ],
        "all_videos": [
            "videos/b02332c6b558ccdc.mp4",
            "videos/c874265b678e8856.mp4"
        ]
    },
    "metadata": {
        "currency": null,
        "duration": {
            "end_date": "2024-07-22T07:00:00Z",
            "start_date": "2024-07-22T07:00:00Z"
        },
        "countries": [],
        "categories": [
            "Energy Company"
        ]
    }
}
Shell audience_network
{
    "obj_detect": [
        "A smiling woman in an orange safety vest is seated in the driver's seat of a car, with a man in an orange vest standing beside her."
    ],
    "bert_classify": {
        "score": 0.95203697681427
    },
    "transcription": [
        " Thank you for watching!",
        " Thank you for watching!"
    ],
    "ocr_extraction": [
        " \n\nShell \\\nae App a y u\n\f"
    ]
}
Powered by Datasette · Queries took 0.726ms