home / unwash_db / ad

ad: 78

This data as json

rowid id source_ad_id raw_data details processed_details advertiser_id created_at updated_at media_archived_at
78 01908230-56be-7673-a22f-9193c86abb13 1473354799956553
{
    "adid": "0",
    "spend": null,
    "pageID": "200969413280005",
    "endDate": 1715065200,
    "fevInfo": null,
    "aaa_info": {
        "targets_eu": true,
        "age_audience": {
            "max": 65,
            "min": 18
        },
        "eu_total_reach": 8024,
        "gender_audience": "All",
        "is_ad_taken_down": false,
        "location_audience": [
            {
                "name": "Luxembourg",
                "type": "countries",
                "excluded": false,
                "num_obfuscated": 0
            }
        ],
        "payer_beneficiary_data": [
            {
                "payer": "Wuzz BV",
                "beneficiary": "Shell"
            }
        ],
        "has_violating_payer_beneficiary": false,
        "age_country_gender_reach_breakdown": [
            {
                "country": "LU",
                "age_gender_breakdowns": [
                    {
                        "male": 192,
                        "female": 69,
                        "unknown": 2,
                        "age_range": "18-24"
                    },
                    {
                        "male": 1307,
                        "female": 784,
                        "unknown": 16,
                        "age_range": "35-44"
                    },
                    {
                        "male": 343,
                        "female": 272,
                        "unknown": 5,
                        "age_range": "65+"
                    },
                    {
                        "male": 882,
                        "female": 633,
                        "unknown": 11,
                        "age_range": "55-64"
                    },
                    {
                        "male": 1155,
                        "female": 877,
                        "unknown": 6,
                        "age_range": "45-54"
                    },
                    {
                        "male": 991,
                        "female": 472,
                        "unknown": 14,
                        "age_range": "25-34"
                    }
                ]
            }
        ]
    },
    "currency": "",
    "isActive": false,
    "pageInfo": null,
    "pageName": "Shell",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "Les membres Shell GO+ peuvent tenter de gagner le s\u00e9jour magique de 3 jours \u00e0 Disneyland\u00ae Paris. D\u00e9couvrez tous les avantages dans l\u2019appli Shell."
            },
            "context": {},
            "callerHash": "5fc8d76a40da252b2fe1ea46e5c017ab"
        },
        "cards": [],
        "event": [],
        "title": "La magie de Disneyland\u00ae Paris",
        "byline": null,
        "images": [],
        "videos": [
            {
                "video_hd_url": "https://video.fmem1-2.fna.fbcdn.net/v/t42.1790-2/439079778_1473354849956548_366858175074719513_n.?_nc_cat=111&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=d4tOJ4R7ys8Q7kNvgGqCAvV&_nc_ht=video.fmem1-2.fna&gid=A5giY-ipCBFWn2uXwlD1c-Q&oh=00_AYBJnxdIRWHC6uMXmwJiMhvr_W7_SNU_a9-4hNi4vYIIAw&oe=668DA4FE",
                "video_sd_url": "https://video.fmem1-1.fna.fbcdn.net/v/t42.1790-2/435803864_797714261780981_1138920549696127529_n.mp4?_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=yIeif07RKZYQ7kNvgGWYDXn&_nc_ht=video.fmem1-1.fna&gid=A5giY-ipCBFWn2uXwlD1c-Q&oh=00_AYAjLLKwn1S4JJgO2APRn82MAwihjwA_aNbBxDBXfPmr3g&oe=668DA21D",
                "video_preview_image_url": "https://scontent.fmem1-2.fna.fbcdn.net/v/t39.35426-6/439212244_415217521260587_1855567662733869214_n.jpg?_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=ibzEoZVhwiIQ7kNvgFVWQmK&_nc_ht=scontent.fmem1-2.fna&gid=A5giY-ipCBFWn2uXwlD1c-Q&oh=00_AYDNa0AgKESF3MO-lxea8PLMQr1bQeBhh_Z3jhK5SfwxOQ&oe=668D924E",
                "watermarked_video_hd_url": "",
                "watermarked_video_sd_url": ""
            }
        ],
        "caption": "play.google.com",
        "page_id": 200969413280005,
        "version": 3,
        "cta_text": "Install now",
        "cta_type": "INSTALL_MOBILE_APP",
        "link_url": "http://play.google.com/store/apps/details?id=com.shell.sitibv.retail",
        "page_name": "Shell",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": null,
        "creation_time": 1713806739,
        "instagram_url": "",
        "ad_creative_id": "120211271562320460",
        "display_format": "video",
        "additional_info": null,
        "branded_content": null,
        "ec_certificates": null,
        "page_categories": {
            "2238": "Energy Company"
        },
        "page_is_deleted": false,
        "page_like_count": 9609444,
        "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/Shell",
        "body_translations": {},
        "current_page_name": "Shell",
        "dynamic_item_flags": {},
        "root_reshared_post": null,
        "instagram_actor_name": "Shell",
        "page_is_profile_page": false,
        "page_welcome_message": null,
        "page_profile_picture_url": "https://scontent.fmem1-1.fna.fbcdn.net/v/t39.35426-6/439142914_420331473966003_7097717483307190533_n.jpg?stp=dst-jpg_s60x60&_nc_cat=103&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=RhTmEpQnfBkQ7kNvgHomek7&_nc_ht=scontent.fmem1-1.fna&gid=A5giY-ipCBFWn2uXwlD1c-Q&oh=00_AYCugyz8iOSA0jdbz-_2nCYCuwYoD0ASuN4_CK_ZSqSO7Q&oe=668D9C6A",
        "instagram_branded_content": null,
        "instagram_profile_pic_url": "https://scontent.fmem1-2.fna.fbcdn.net/v/t39.35426-6/439111023_796004429087864_5601139998250590675_n.jpg?_nc_cat=107&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=XLCs76DugOcQ7kNvgEVZd5s&_nc_ht=scontent.fmem1-2.fna&gid=A5giY-ipCBFWn2uXwlD1c-Q&oh=00_AYAcYmq25DzDUA1r8ZJZipFsK103W7MONgjBLr63d_uIWA&oe=668D7615",
        "instagram_shopping_products": [],
        "effective_authorization_category": "NONE"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1713855600,
    "advertiser": {
        "page": {
            "id": "200969413280005",
            "about": {
                "text": "Welcome to the official Facebook page of Shell."
            },
            "is_delegate_page_with_linked_primary_profile": false
        },
        "ad_library_page_info": null
    },
    "categories": [
        0
    ],
    "entityType": "person_profile",
    "adArchiveID": "1473354799956553",
    "collationID": 416127254700013,
    "reportCount": null,
    "archiveTypes": [],
    "finServAdData": {
        "is_deemed_finserv": false,
        "is_limited_delivery": false
    },
    "isAAAEligible": true,
    "isProfilePage": false,
    "pageIsDeleted": false,
    "reachEstimate": null,
    "collationCount": null,
    "hideDataStatus": "NONE",
    "hasUserReported": false,
    "violation_types": [],
    "hiddenSafetyData": false,
    "publisherPlatform": [
        "facebook",
        "instagram",
        "audience_network",
        "messenger"
    ],
    "politicalCountries": [],
    "source_platform_id": "audience_network",
    "stateMediaRunLabel": null,
    "isAdAccountActioned": false,
    "impressionsWithIndex": {
        "impressionsText": null,
        "impressionsIndex": -1
    },
    "source_advertiser_id": "200969413280005",
    "verified_voice_context": null,
    "containsSensitiveContent": false,
    "containsDigitallyCreatedMedia": false
}
{
    "stats": {
        "spend": null,
        "report_count": null,
        "reach_estimate": null,
        "impression_text": null
    },
    "content": {
        "all_links": [
            "https://scontent.fmem1-1.fna.fbcdn.net/v/t39.35426-6/439142914_420331473966003_7097717483307190533_n.jpg?stp=dst-jpg_s60x60&_nc_cat=103&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=RhTmEpQnfBkQ7kNvgHomek7&_nc_ht=scontent.fmem1-1.fna&gid=A5giY-ipCBFWn2uXwlD1c-Q&oh=00_AYCugyz8iOSA0jdbz-_2nCYCuwYoD0ASuN4_CK_ZSqSO7Q&oe=668D9C6A",
            "https://scontent.fmem1-2.fna.fbcdn.net/v/t39.35426-6/439111023_796004429087864_5601139998250590675_n.jpg?_nc_cat=107&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=XLCs76DugOcQ7kNvgEVZd5s&_nc_ht=scontent.fmem1-2.fna&gid=A5giY-ipCBFWn2uXwlD1c-Q&oh=00_AYAcYmq25DzDUA1r8ZJZipFsK103W7MONgjBLr63d_uIWA&oe=668D7615",
            "https://facebook.com/Shell",
            "http://play.google.com/store/apps/details?id=com.shell.sitibv.retail"
        ],
        "all_texts": [
            "la magie de disneyland\u00ae paris",
            "install now",
            "play.google.com",
            "install_mobile_app"
        ],
        "all_images": [
            "images/102ba75b7273a593.jpeg"
        ],
        "all_videos": [
            "videos/4edb1fefd77f1f44.mp4",
            "videos/2c6ac56aad96276b.mp4"
        ]
    },
    "metadata": {
        "currency": null,
        "duration": {
            "end_date": "2024-05-07T07:00:00Z",
            "start_date": "2024-04-23T07:00:00Z"
        },
        "countries": [],
        "categories": [
            "Energy Company"
        ]
    }
}
{
    "ocr": {
        "processed": true
    },
    "bert_classify": {
        "result": {
            "score": 0.9257023334503174
        },
        "processed": true
    },
    "transcription": {
        "processed": true
    }
}
019082e4-d857-7619-9483-435215664ad2 2024-07-05 12:35:54.07911 2024-08-03 19:37:55.675483 2024-07-05 14:35:05.523989
Powered by Datasette · Queries took 2.409ms