home / unwash_db / ad

ad: 14

This data as json

rowid id source_ad_id raw_data details processed_details advertiser_id created_at updated_at media_archived_at
14 0190821d-9b72-7882-b400-56333abb3ffe 467754138935984
{
    "adid": "0",
    "spend": null,
    "pageID": "527448087683278",
    "endDate": 1714978800,
    "fevInfo": null,
    "aaa_info": {
        "targets_eu": true,
        "age_audience": {
            "max": 58,
            "min": 18
        },
        "eu_total_reach": 313913,
        "gender_audience": "All",
        "is_ad_taken_down": false,
        "location_audience": [
            {
                "name": "Poland",
                "type": "countries",
                "excluded": false,
                "num_obfuscated": 0
            }
        ],
        "payer_beneficiary_data": [
            {
                "payer": "bp",
                "beneficiary": "bp"
            }
        ],
        "has_violating_payer_beneficiary": false,
        "age_country_gender_reach_breakdown": [
            {
                "country": "PL",
                "age_gender_breakdowns": [
                    {
                        "male": 75585,
                        "female": 19911,
                        "unknown": 2086,
                        "age_range": "18-24"
                    },
                    {
                        "male": 69972,
                        "female": 11210,
                        "unknown": 450,
                        "age_range": "25-34"
                    },
                    {
                        "male": 51361,
                        "female": 14064,
                        "unknown": 375,
                        "age_range": "35-44"
                    },
                    {
                        "male": 37986,
                        "female": 17255,
                        "unknown": 319,
                        "age_range": "45-54"
                    },
                    {
                        "male": 9927,
                        "female": 7794,
                        "unknown": 88,
                        "age_range": "55-64"
                    }
                ]
            }
        ]
    },
    "currency": "",
    "isActive": false,
    "pageInfo": null,
    "pageName": "bp",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "Bez \u015bniadania ani rusz! \u270b<br /> <br /> Maj\u00f3wka na horyzoncie, a w brzuchu pusto? Ruszaj na bp po po\u017cywne \u015bniadanie.  Skieruj si\u0119 po te, kt\u00f3re lubisz najbardziej lub zr\u00f3b zwrot w stron\u0119 naszych nowych CHRUPKO\u015aCI - zakr\u0119conych bajgli \ud83e\udd6f z \u0142ososiem \ud83d\udc1f lub kurczakiem, S\u0141ODKO\u015aCI \u2013 ry\u017cowego puddingu z mango albo \u015aWIE\u017bO\u015aCI \u2013 ameryka\u0144skiej sa\u0142atki z pikantn\u0105 pol\u0119dwiczk\u0105! <br /> <br /> A teraz do ka\u017cdego \u015bniadania du\u017ca kawa \u2615 50% taniej!<br /> Szczeg\u00f3\u0142y na <a href=\"https://l.facebook.com/l.php?u=https%3A%2F%2Ftak.to%2FNowosciSniadania&amp;h=AT1sK0JLheB-Mb6cfkkp_6brilLOFdPgrF8m6xojym-0fu6_hmfEKfeQHyqRABorTv2U2IpRAzRpFW1jmiId8mNvE4SNj-w_M5pkGv36SjWxRxWSLyQDfFL93ayBUkO0zqg25x_XFCvJ_eayL3s_wmWTk2k4ZOuJJBkzWg\" rel=\"nofollow noreferrer\" target=\"_blank\" data-lynx-mode=\"asynclazy\">https://tak.to/NowosciSniadania</a>"
            },
            "context": {},
            "callerHash": "5fc8d76a40da252b2fe1ea46e5c017ab"
        },
        "cards": [],
        "event": [],
        "title": "Bez \u015bniadania ani rusz! \u270b",
        "byline": null,
        "images": [],
        "videos": [
            {
                "video_hd_url": "https://video.flas1-2.fna.fbcdn.net/v/t42.1790-2/440874651_467754185602646_637907735598564098_n.?_nc_cat=105&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=6eiGsks2YykQ7kNvgGB3zX4&_nc_ht=video.flas1-2.fna&gid=AT3bv-WODAUHgTVBj3Ir8yX&oh=00_AYBNzqk-BjoTsujTvtv4nyDPfWonfF35nrnoaezlJCH0Ug&oe=668D8480",
                "video_sd_url": "https://video.flas1-2.fna.fbcdn.net/v/t42.1790-2/440661943_788217386602685_2793395802191567595_n.mp4?_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=xwyevNJArAQQ7kNvgGWuigQ&_nc_ht=video.flas1-2.fna&gid=AT3bv-WODAUHgTVBj3Ir8yX&oh=00_AYCxO-nRyHXRakqSMtAL7vzjx0tGgGPfpk7K_pGDdvdTiQ&oe=668D9696",
                "video_preview_image_url": "https://scontent.flas1-2.fna.fbcdn.net/v/t39.35426-6/438094856_1531628077761966_231035685169583877_n.jpg?_nc_cat=100&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=MqgCZ5kg5GQQ7kNvgGcag7V&_nc_ht=scontent.flas1-2.fna&gid=AT3bv-WODAUHgTVBj3Ir8yX&oh=00_AYBBqVdvKKfx9B9LVqAeeO0MC2RI0nENexosIvwTcFP4IQ&oe=668D7DD0",
                "watermarked_video_hd_url": "",
                "watermarked_video_sd_url": ""
            }
        ],
        "caption": null,
        "page_id": 527448087683278,
        "version": 3,
        "cta_text": null,
        "cta_type": null,
        "link_url": null,
        "page_name": "bp",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": null,
        "creation_time": 1714480569,
        "instagram_url": "",
        "ad_creative_id": "120209342868590324",
        "display_format": "video",
        "additional_info": null,
        "branded_content": null,
        "ec_certificates": null,
        "page_categories": {
            "2238": "Energy Company"
        },
        "page_is_deleted": false,
        "page_like_count": 1068483,
        "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/bp.polska",
        "body_translations": {},
        "current_page_name": "bp",
        "dynamic_item_flags": {},
        "root_reshared_post": null,
        "instagram_actor_name": "bp Polska",
        "page_is_profile_page": false,
        "page_welcome_message": null,
        "page_profile_picture_url": "https://scontent.flas1-2.fna.fbcdn.net/v/t39.35426-6/438096809_1618902085598642_2940790256771403476_n.jpg?stp=dst-jpg_s60x60&_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=pZ3n6rP-TKIQ7kNvgF-yu9A&_nc_ht=scontent.flas1-2.fna&gid=AT3bv-WODAUHgTVBj3Ir8yX&oh=00_AYAB349BofAIQUphVB9eT-YwOGVwCnYENoAg4Y3xYtytVg&oe=668D801C",
        "instagram_branded_content": null,
        "instagram_profile_pic_url": "https://scontent.flas1-1.fna.fbcdn.net/v/t39.35426-6/438108167_7549679685070047_1607470582262085498_n.jpg?_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=7z-ZBYQ2yQEQ7kNvgHJPmwK&_nc_ht=scontent.flas1-1.fna&gid=AT3bv-WODAUHgTVBj3Ir8yX&oh=00_AYCx5xfBCEcBoVVf3-tgMltzx8vk5lM1RLooEGsL6S4o3g&oe=668D8563",
        "instagram_shopping_products": [],
        "effective_authorization_category": "NONE"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1714460400,
    "advertiser": {
        "page": {
            "id": "527448087683278",
            "about": {
                "text": "Witamy na profilu bp w Polsce! Do\u0142\u0105cz do naszych fan\u00f3w aby by\u0107 na bie\u017c\u0105co z nowo\u015bciami i ofertami firmy, kt\u00f3ra istnieje ju\u017c od 1909 roku."
            },
            "is_delegate_page_with_linked_primary_profile": false
        },
        "ad_library_page_info": null
    },
    "categories": [
        0
    ],
    "entityType": "person_profile",
    "adArchiveID": "467754138935984",
    "collationID": 3730017770607259,
    "reportCount": null,
    "archiveTypes": [],
    "finServAdData": {
        "is_deemed_finserv": false,
        "is_limited_delivery": false
    },
    "isAAAEligible": true,
    "isProfilePage": false,
    "pageIsDeleted": false,
    "reachEstimate": null,
    "collationCount": 1,
    "hideDataStatus": "NONE",
    "hasUserReported": false,
    "violation_types": [],
    "hiddenSafetyData": false,
    "publisherPlatform": [
        "facebook",
        "instagram"
    ],
    "politicalCountries": [],
    "source_platform_id": "instagram",
    "stateMediaRunLabel": null,
    "isAdAccountActioned": false,
    "impressionsWithIndex": {
        "impressionsText": null,
        "impressionsIndex": -1
    },
    "source_advertiser_id": "527448087683278",
    "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.flas1-1.fna.fbcdn.net/v/t39.35426-6/438108167_7549679685070047_1607470582262085498_n.jpg?_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=7z-ZBYQ2yQEQ7kNvgHJPmwK&_nc_ht=scontent.flas1-1.fna&gid=AT3bv-WODAUHgTVBj3Ir8yX&oh=00_AYCx5xfBCEcBoVVf3-tgMltzx8vk5lM1RLooEGsL6S4o3g&oe=668D8563",
            "https://scontent.flas1-2.fna.fbcdn.net/v/t39.35426-6/438096809_1618902085598642_2940790256771403476_n.jpg?stp=dst-jpg_s60x60&_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=pZ3n6rP-TKIQ7kNvgF-yu9A&_nc_ht=scontent.flas1-2.fna&gid=AT3bv-WODAUHgTVBj3Ir8yX&oh=00_AYAB349BofAIQUphVB9eT-YwOGVwCnYENoAg4Y3xYtytVg&oe=668D801C",
            "https://facebook.com/bp.polska"
        ],
        "all_texts": [
            "bez \u015bniadania ani rusz! \u270b"
        ],
        "all_images": [
            "images/1f92e600fe2c034d.jpeg"
        ],
        "all_videos": [
            "videos/fb5f1b17078ae538.mp4",
            "videos/8ffc3c5bed6726ca.mp4"
        ]
    },
    "metadata": {
        "currency": null,
        "duration": {
            "end_date": "2024-05-06T07:00:00Z",
            "start_date": "2024-04-30T07:00:00Z"
        },
        "countries": [],
        "categories": [
            "Energy Company"
        ]
    }
}
{
    "ocr": {
        "processed": true
    },
    "bert_classify": {
        "result": {
            "score": 0.8616465926170349
        },
        "processed": true
    },
    "transcription": {
        "processed": true
    }
}
019082e4-d857-7d29-b3c9-79714bcb31f2 2024-07-05 12:35:54.07911 2024-08-03 19:51:39.443784 2024-07-05 14:37:11.621942
Powered by Datasette · Queries took 2.677ms