home / unwash_db / ad

ad: 70

This data as json

rowid id source_ad_id raw_data details processed_details advertiser_id created_at updated_at media_archived_at
70 0190821d-9b5c-715b-9a12-08fb9c1591f0 3497580290533362
{
    "adid": "0",
    "spend": null,
    "pageID": "527448087683278",
    "endDate": 1720076400,
    "fevInfo": null,
    "aaa_info": {
        "targets_eu": true,
        "age_audience": {
            "max": 65,
            "min": 18
        },
        "eu_total_reach": 8637,
        "gender_audience": "All",
        "is_ad_taken_down": false,
        "location_audience": [
            {
                "name": "\u017bmigr\u00f3d gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 2
            },
            {
                "name": "\u0141ask, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Ostr\u00f3w Wielkopolski, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 4
            },
            {
                "name": "G\u00f3ra, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Nowe Skalmierzyce gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Opat\u00f3wek, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Kalisz, Kalisz, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 2
            },
            {
                "name": "Wschowa gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Leszno, Leszno, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Blizan\u00f3w, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Pleszew gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Stawiszyn gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Srem, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "\u015arem gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Wolsztyn, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Rakoniewice, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Kornica Stara, Biala Podlaska, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Opalenica gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Steszew, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "S\u0142upca, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Wrze\u015bnia gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Komorniki, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Wrzesnia, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Torzym gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Nowy Tomy\u015bl gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Poznan, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 16
            },
            {
                "name": "Dopiewo, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Buk gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Swarz\u0119dz gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Tarnowo Podg\u00f3rne, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Rokietnica, Pozna\u0144, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Pniewy, Pozna\u0144, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 2
            },
            {
                "name": "Gniezno, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Lubowo, Pozna\u0144, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Gniezno gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Oborniki gmina, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Rogozno, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Pi\u0142a, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            },
            {
                "name": "Szczecinek, Poland",
                "type": "CITY",
                "excluded": false,
                "num_obfuscated": 1
            }
        ],
        "payer_beneficiary_data": [
            {
                "payer": "bp",
                "beneficiary": "bp"
            }
        ],
        "has_violating_payer_beneficiary": false,
        "age_country_gender_reach_breakdown": [
            {
                "country": "PL",
                "age_gender_breakdowns": [
                    {
                        "male": 372,
                        "female": 72,
                        "unknown": 3,
                        "age_range": "18-24"
                    },
                    {
                        "male": 1333,
                        "female": 236,
                        "unknown": 9,
                        "age_range": "35-44"
                    },
                    {
                        "male": 1758,
                        "female": 645,
                        "unknown": 15,
                        "age_range": "65+"
                    },
                    {
                        "male": 1025,
                        "female": 317,
                        "unknown": 11,
                        "age_range": "55-64"
                    },
                    {
                        "male": 1240,
                        "female": 254,
                        "unknown": 10,
                        "age_range": "45-54"
                    },
                    {
                        "male": 1020,
                        "female": 176,
                        "unknown": 5,
                        "age_range": "25-34"
                    }
                ]
            }
        ]
    },
    "currency": "",
    "isActive": false,
    "pageInfo": null,
    "pageName": "bp",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "Nie pozw\u00f3l, aby du\u017ce oszcz\u0119dno\u015bci przejecha\u0142y \ud83d\ude97 Ci ko\u0142o nosa! Tej wiosny, wymieniaj\u0105c olej w Q Service Castrol, mo\u017cesz zaoszcz\u0119dzi\u0107 nawet 70 groszy na litrze paliwa tankuj\u0105c na bp. \ud83d\udcb0 \ud83d\udcb0 \ud83d\udcb0<br /> <br /> We\u017a udzia\u0142 w promocji ju\u017c dzi\u015b i um\u00f3w si\u0119 na wymian\u0119 oleju, aby otrzyma\u0107 przypomnienie o wizycie i rabat na paliwo przy kolejnym tankowaniu: <a href=\"https://l.facebook.com/l.php?u=http%3A%2F%2Fbpkatalog.pl%2Fregistration%2Fregister&amp;h=AT1PY15-u2D0NuHCpiPrHG9SuN4IXbSPoBoiB_yLPNmkbmHBvnv1oeLyDYDeVwso9eXSGEQU-pq5KzwMt45X9Joosj_fNnYtj_RhzcmqJcomE8TgWCfWh4V2B4CRnRV9Ktqg5NVojejAQO0V3vQWrUClKP6QyqZrfiibT2Z8cw0\" rel=\"nofollow noreferrer\" target=\"_blank\" data-lynx-mode=\"asynclazy\">bpkatalog.pl/registration/register</a>"
            },
            "context": {},
            "callerHash": "5fc8d76a40da252b2fe1ea46e5c017ab"
        },
        "cards": [],
        "event": [],
        "title": "Q Service Castrol",
        "byline": null,
        "images": [
            {
                "image_crops": {},
                "resized_image_url": "https://scontent-atl3-1.xx.fbcdn.net/v/t39.35426-6/448340430_487558533835155_985660230642423074_n.jpg?stp=dst-jpg_s600x600&_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=CGecvLxDRekQ7kNvgHbXuiU&_nc_ht=scontent-atl3-1.xx&oh=00_AYBtDVY-MJ8JClbjDFiRq_gyqtolSZxGbWE3VGWOcrg5dQ&oe=668D9B87",
                "original_image_url": "https://scontent-atl3-2.xx.fbcdn.net/v/t39.35426-6/448283525_837425601150152_8433619309449487018_n.jpg?_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=lGyJ3wcG4qMQ7kNvgHxP8eF&_nc_ht=scontent-atl3-2.xx&oh=00_AYAlMrS8Inbe9WIUKnIL3Jg04JFh7gM-xL92U-3M6KlqVg&oe=668D72B7",
                "watermarked_resized_image_url": ""
            }
        ],
        "videos": [],
        "caption": "bpkatalog.pl",
        "page_id": 527448087683278,
        "version": 3,
        "cta_text": "Sign up",
        "cta_type": "SIGN_UP",
        "link_url": "https://www.bpkatalog.pl/registration/register",
        "page_name": "bp",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": null,
        "creation_time": 1718367758,
        "instagram_url": "",
        "ad_creative_id": "120210728590010324",
        "display_format": "image",
        "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": "Um\u00f3w wymian\u0119 oleju",
        "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-atl3-1.xx.fbcdn.net/v/t39.35426-6/448455970_791601853141716_8589212500492517093_n.jpg?stp=dst-jpg_s60x60&_nc_cat=109&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=7tR9AwW4NqEQ7kNvgGP9NdY&_nc_ht=scontent-atl3-1.xx&oh=00_AYBKk-5GyG37kqI-8Alko4m6BNiU8vTJ_jUvFyKby7YIfA&oe=668D9708",
        "instagram_branded_content": null,
        "instagram_profile_pic_url": "https://scontent-atl3-2.xx.fbcdn.net/v/t39.35426-6/448456578_1489281115007113_3675058897080909805_n.jpg?_nc_cat=101&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=UT2GZwOyrugQ7kNvgHv7k_E&_nc_ht=scontent-atl3-2.xx&oh=00_AYBVo18N5OffAg9VJItuTnhKtjmK6rjRBDimY044cUnUDQ&oe=668DA03C",
        "instagram_shopping_products": [],
        "effective_authorization_category": "NONE"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1718348400,
    "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": "3497580290533362",
    "collationID": 1582414335656025,
    "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"
    ],
    "politicalCountries": [],
    "source_platform_id": "facebook",
    "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-atl3-1.xx.fbcdn.net/v/t39.35426-6/448455970_791601853141716_8589212500492517093_n.jpg?stp=dst-jpg_s60x60&_nc_cat=109&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=7tR9AwW4NqEQ7kNvgGP9NdY&_nc_ht=scontent-atl3-1.xx&oh=00_AYBKk-5GyG37kqI-8Alko4m6BNiU8vTJ_jUvFyKby7YIfA&oe=668D9708",
            "https://scontent-atl3-2.xx.fbcdn.net/v/t39.35426-6/448456578_1489281115007113_3675058897080909805_n.jpg?_nc_cat=101&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=UT2GZwOyrugQ7kNvgHv7k_E&_nc_ht=scontent-atl3-2.xx&oh=00_AYBVo18N5OffAg9VJItuTnhKtjmK6rjRBDimY044cUnUDQ&oe=668DA03C",
            "https://www.bpkatalog.pl/registration/register",
            "https://facebook.com/bp.polska"
        ],
        "all_texts": [
            "q service castrol",
            "sign up",
            "sign_up",
            "bpkatalog.pl",
            "um\u00f3w wymian\u0119 oleju"
        ],
        "all_images": [
            "images/2b8edf3590ed2b00.jpeg",
            "images/f9bdea2e61845713.jpeg"
        ],
        "all_videos": []
    },
    "metadata": {
        "currency": null,
        "duration": {
            "end_date": "2024-07-04T07:00:00Z",
            "start_date": "2024-06-14T07:00:00Z"
        },
        "countries": [],
        "categories": [
            "Energy Company"
        ]
    }
}
{
    "ocr": {
        "processed": true
    },
    "obj_detect": {
        "processed": true
    },
    "bert_classify": {
        "result": {
            "score": 0.5801331400871277
        },
        "processed": true
    }
}
019082e4-d857-7674-a0f8-4c00b50c36e3 2024-07-05 12:35:54.07911 2024-08-03 19:37:50.700214 2024-07-05 14:37:43.419478
Powered by Datasette · Queries took 1.573ms