home / unwash_db / raw_ad

raw_ad: 45

This data as json

rowid id external_id raw_data base_fk_updated_at
45 0190abfa-2eee-7109-8695-34ab536e9ca6 464256273019716_instagram_81753537108
{
    "url": "https://www.facebook.com/ads/library/?active_status=all&ad_type=all&country=ALL&view_all_page_id=81753537108&sort_data[direction]=desc&sort_data[mode]=relevancy_monthly_grouped&search_type=page&media_type=all",
    "adid": "0",
    "spend": null,
    "pageID": "81753537108",
    "endDate": 1720767600,
    "fevInfo": null,
    "aaa_info": {
        "targets_eu": true,
        "age_audience": {
            "max": 50,
            "min": 18
        },
        "eu_total_reach": 419959,
        "gender_audience": "All",
        "is_ad_taken_down": false,
        "location_audience": [
            {
                "name": "France",
                "type": "countries",
                "excluded": false,
                "num_obfuscated": 0
            }
        ],
        "payer_beneficiary_data": [
            {
                "payer": "Wavemaker",
                "beneficiary": "TotalEnergies"
            }
        ],
        "has_violating_payer_beneficiary": false,
        "age_country_gender_reach_breakdown": [
            {
                "country": "FR",
                "age_gender_breakdowns": [
                    {
                        "male": 180214,
                        "female": 30135,
                        "unknown": 4173,
                        "age_range": "18-24"
                    },
                    {
                        "male": 121345,
                        "female": 12891,
                        "unknown": 1069,
                        "age_range": "25-34"
                    },
                    {
                        "male": 44265,
                        "female": 4406,
                        "unknown": 534,
                        "age_range": "35-44"
                    },
                    {
                        "male": 20544,
                        "female": 2887,
                        "unknown": 320,
                        "age_range": "45-54"
                    }
                ]
            }
        ]
    },
    "currency": "",
    "isActive": false,
    "pageInfo": null,
    "pageName": "TotalEnergies",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "Je t\u2019emm\u00e8ne en immersion dans les coulisses de la plus grande course d\u2019endurance au monde ! \ud83e\udd2b \ud83c\udfc1<br /> <br /> Vid\u00e9o disponible sur YouTube \ud83c\udfac\ud83c\udf7f <br /> <br /> Merci au Club TotalEnergies \ud83d\udc4a\ud83c\udffc<br /> <br /> #ClubTotalEnergies#CollaborationCommerciale"
            },
            "context": {},
            "callerHash": "400342703b25101d2dd9cc0fc45c2d9d"
        },
        "cards": [],
        "event": [],
        "title": null,
        "byline": null,
        "images": [],
        "videos": [
            {
                "video_hd_url": "https://video-lax3-2.xx.fbcdn.net/v/t42.1790-2/450005952_464256323019711_7140534623508508313_n.?_nc_cat=107&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=jcVtOcDlQiYQ7kNvgEDKTyU&_nc_ht=video-lax3-2.xx&oh=00_AYAcYW1hKEXy3Adot0Vd33vWD3r73WeyeHtfki51ptEauw&oe=669840B0",
                "video_sd_url": "https://video-lax3-2.xx.fbcdn.net/v/t42.1790-2/449736600_274832205693313_5347530741390196446_n.mp4?_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=OLaUO1gSLpIQ7kNvgHtVtDH&_nc_ht=video-lax3-2.xx&oh=00_AYC81SF-7JPMmSB5ppWkd7dmamYDlwvyI_68Jt5J0XBdxg&oe=66982761",
                "video_preview_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/449049942_1578510569673083_6265768025954170820_n.jpg?_nc_cat=104&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=EPTtg9vwcJ4Q7kNvgGfGP2g&_nc_ht=scontent-lax3-1.xx&oh=00_AYBVbHWBKlieoNo6n5cTfBon_OO4gjFUNBG7OnOprB9Qxw&oe=66982B7D",
                "watermarked_video_hd_url": "",
                "watermarked_video_sd_url": ""
            }
        ],
        "caption": null,
        "page_id": 608950779144131,
        "version": 3,
        "cta_text": null,
        "cta_type": null,
        "link_url": null,
        "page_name": "Romain Monti",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": null,
        "creation_time": 1720171337,
        "instagram_url": "",
        "ad_creative_id": "120210638495670421",
        "display_format": "video",
        "additional_info": null,
        "branded_content": {
            "page_id": 81753537108,
            "page_name": "TotalEnergies",
            "page_categories": {
                "2238": "Energy Company"
            },
            "page_is_deleted": false,
            "page_profile_uri": "https://facebook.com/TotalEnergiesFrance",
            "current_page_name": "TotalEnergies",
            "page_profile_picture_url": "https://scontent-lax3-2.xx.fbcdn.net/v/t39.35426-6/450043525_442623058691473_395129437556388970_n.jpg?_nc_cat=111&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=wa1qXWAAGxwQ7kNvgEUQ8Ar&_nc_ht=scontent-lax3-2.xx&oh=00_AYBwbPuHsDF1D-qA9dTKMBVGTgiiXQKPQU9LvSeidG6TJA&oe=66985770"
        },
        "ec_certificates": null,
        "page_categories": {
            "1600": "Athlete"
        },
        "page_is_deleted": false,
        "page_like_count": 71432,
        "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/romainmontipilote",
        "body_translations": {},
        "current_page_name": "Romain Monti",
        "dynamic_item_flags": {},
        "root_reshared_post": null,
        "instagram_actor_name": "\ud83c\uddeb\ud83c\uddf7 Romain MONTI",
        "page_is_profile_page": false,
        "page_welcome_message": null,
        "page_profile_picture_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/449764106_383214117668067_3117034595731229613_n.jpg?stp=dst-jpg_s60x60&_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=qeVHocmaBOIQ7kNvgHznpuv&_nc_ht=scontent-lax3-1.xx&oh=00_AYCP_pre7CW7TauBDyU4DvUUfbZX4dt9-UgqN5479gnUuw&oe=6698569E",
        "instagram_branded_content": {
            "instagram_bc_sponsor_id": "17841404506655647",
            "instagram_bc_sponsor_name": "totalenergies_fr"
        },
        "instagram_profile_pic_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/449729213_488266513572075_6384783526166950799_n.jpg?_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=ijLwz6OeCX4Q7kNvgH0LiKJ&_nc_ht=scontent-lax3-1.xx&oh=00_AYDt8GTg1cQFiRgMXJlF3aJXYikLWw_h4XGbInXP3Ny_2A&oe=669826B1",
        "instagram_shopping_products": [],
        "effective_authorization_category": "NONE"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1720162800,
    "advertiser": {
        "page": {
            "id": "81753537108",
            "about": {
                "text": "Compagnie multi-\u00e9nergies mondiale de production & de fourniture d\u2019\u00e9nergies : p\u00e9trole & biocarburants,"
            },
            "is_delegate_page_with_linked_primary_profile": false
        },
        "ad_library_page_info": null
    },
    "categories": [
        0
    ],
    "entityType": "person_profile",
    "adArchiveID": "464256273019716",
    "collationID": 1022244535933480,
    "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": [
        "instagram"
    ],
    "politicalCountries": [],
    "source_platform_id": "instagram",
    "stateMediaRunLabel": null,
    "isAdAccountActioned": false,
    "impressionsWithIndex": {
        "impressionsText": null,
        "impressionsIndex": -1
    },
    "source_advertiser_id": "81753537108",
    "verified_voice_context": null,
    "containsSensitiveContent": false,
    "containsDigitallyCreatedMedia": false
}
2024-07-13 12:05:34.357383
Powered by Datasette · Queries took 3.251ms