home / unwash_db / raw_ad

raw_ad: 43

This data as json

rowid id external_id raw_data base_fk_updated_at
43 0190abfa-2eee-7f33-bdb7-9d3ae785c2ce 415455261456769_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": 1720594800,
    "fevInfo": null,
    "aaa_info": {
        "targets_eu": true,
        "age_audience": {
            "max": 54,
            "min": 25
        },
        "eu_total_reach": 750857,
        "gender_audience": "All",
        "is_ad_taken_down": false,
        "location_audience": [
            {
                "name": "France",
                "type": "countries",
                "excluded": false,
                "num_obfuscated": 0
            }
        ],
        "payer_beneficiary_data": [
            {
                "payer": "KR WAVEMAKER",
                "beneficiary": "TotalEnergies"
            }
        ],
        "has_violating_payer_beneficiary": false,
        "age_country_gender_reach_breakdown": [
            {
                "country": "FR",
                "age_gender_breakdowns": [
                    {
                        "male": 224069,
                        "female": 46782,
                        "unknown": 1782,
                        "age_range": "25-34"
                    },
                    {
                        "male": 175936,
                        "female": 65212,
                        "unknown": 2798,
                        "age_range": "35-44"
                    },
                    {
                        "male": 158803,
                        "female": 89829,
                        "unknown": 2832,
                        "age_range": "45-54"
                    },
                    {
                        "male": 3,
                        "female": null,
                        "unknown": null,
                        "age_range": "65+"
                    }
                ]
            }
        ]
    },
    "currency": "",
    "isActive": false,
    "pageInfo": null,
    "pageName": "TotalEnergies",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "A l'occasion des 24h du Mans, nous avons eu la chance de rencontrer @jackyickxofficial! Retour en 1969, que pensez-vous de sa victoire l\u00e9gendaire ? #totalenergies #24hlemans"
            },
            "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/449658208_415455358123426_1346858621493831622_n.?_nc_cat=100&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=Q5iwUjPoFAoQ7kNvgEIy1zI&_nc_ht=video-lax3-2.xx&oh=00_AYDJVTBRPgzn3sOOVtMqZatGxT0YRZBycsB-t6_-ZK22lA&oe=6698497B",
                "video_sd_url": "https://video-lax3-2.xx.fbcdn.net/v/t42.1790-2/449403708_467605005859417_1148981310308523463_n.mp4?_nc_cat=103&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=VJnd-CYlRmUQ7kNvgEoJqvP&_nc_ht=video-lax3-2.xx&oh=00_AYD8kXyXz3T3IVk0mL8iMi1SFHPqOzJxQ07ZkVN4zxDyZw&oe=66985A20",
                "video_preview_image_url": "https://scontent-lax3-2.xx.fbcdn.net/v/t39.35426-6/449618035_1017696062814404_3821861966039859096_n.jpg?_nc_cat=101&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=Mw0a5orFm3IQ7kNvgEE6tFl&_nc_ht=scontent-lax3-2.xx&oh=00_AYCB8IVv2QL8EygNMSyqiO3SIIEr09rvA8_OdGo-msX0CQ&oe=66983ACB",
                "watermarked_video_hd_url": "",
                "watermarked_video_sd_url": ""
            }
        ],
        "caption": "competition.totalenergies.com",
        "page_id": 81753537108,
        "version": 3,
        "cta_text": "Learn more",
        "cta_type": "LEARN_MORE",
        "link_url": "https://competition.totalenergies.com/fr/auto/endurance/wec/totalenergies-et-le-wec",
        "page_name": "TotalEnergies",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": null,
        "creation_time": 1719909270,
        "instagram_url": "",
        "ad_creative_id": "120210085699540721",
        "display_format": "video",
        "additional_info": null,
        "branded_content": null,
        "ec_certificates": null,
        "page_categories": {
            "2238": "Energy Company"
        },
        "page_is_deleted": false,
        "page_like_count": 10299104,
        "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/TotalEnergiesFrance",
        "body_translations": {},
        "current_page_name": "TotalEnergies",
        "dynamic_item_flags": {},
        "root_reshared_post": null,
        "instagram_actor_name": "TotalEnergies France",
        "page_is_profile_page": false,
        "page_welcome_message": null,
        "page_profile_picture_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/449637530_1050888793261211_4872057567898108012_n.jpg?stp=dst-jpg_s60x60&_nc_cat=104&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=9d50rJH1y54Q7kNvgF93MS0&_nc_ht=scontent-lax3-1.xx&oh=00_AYAE8MydTf_NoOaORgXfVU5BNj2EEjUY5HgPriExGBlntA&oe=66985AAF",
        "instagram_branded_content": null,
        "instagram_profile_pic_url": "https://scontent-lax3-2.xx.fbcdn.net/v/t39.35426-6/449626843_849068057112112_4993806797030609508_n.jpg?_nc_cat=101&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=3Nf7VQ9ledoQ7kNvgFMUrJf&_nc_ht=scontent-lax3-2.xx&oh=00_AYChVcqLpP0pjTqMif8zCWE7o5pa4LedOJwscyp6TdKhDw&oe=6698303F",
        "instagram_shopping_products": [],
        "effective_authorization_category": "NONE"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1719903600,
    "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": "415455261456769",
    "collationID": 831766865559470,
    "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 2.919ms