home / unwash_db / raw_ad

raw_ad: 44

This data as json

rowid id external_id raw_data base_fk_updated_at
44 0190abfa-2eee-73f8-941d-b5273894e41c 1604655510379153_facebook_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": "<\u20ac100",
    "pageID": "81753537108",
    "endDate": 1720767600,
    "fevInfo": {
        "email": "raphael.laurenge@totalenergies.com",
        "phone": "+33647960553",
        "address": "La D\u00e9fense",
        "website": "https://www.totalenergies.com/",
        "submitted_on": "Submitted Jun 28, 2021",
        "learn_more_content": {
            "help_center_url": "https://www.facebook.com/help/180607332665293?ref=infosheet",
            "learn_more_text": "Learn more",
            "help_center_text": "Visit the Help Center to learn about what we require from advertisers to run ads about social issues, elections or politics."
        },
        "fec_additional_info": null,
        "authorized_entity_text": "This information was submitted by the advertiser.",
        "free_form_additional_info": {
            "agent_name": null,
            "gst_number": null,
            "cnpj_or_cpf": null,
            "committee_id": null,
            "director_name": null,
            "promoter_name": null,
            "treasurer_name": null,
            "ec_certificates": [],
            "point_of_contact": null,
            "corporate_purpose": "Compagnie multi-\u00e9nergies mondiale de production & de fourniture d\u2019\u00e9nergies : p\u00e9trole & biocarburants, gaz naturel & gaz verts, renouvelables & \u00e9lectricit\u00e9."
        },
        "page_name_additional_info": null,
        "page_admin_additional_info": null
    },
    "aaa_info": {
        "targets_eu": true,
        "age_audience": {
            "max": 65,
            "min": 18
        },
        "eu_total_reach": 30471,
        "gender_audience": "All",
        "is_ad_taken_down": false,
        "location_audience": [
            {
                "name": "France",
                "type": "countries",
                "excluded": false,
                "num_obfuscated": 0
            }
        ],
        "payer_beneficiary_data": [
            {
                "payer": "Wunderman Thompson",
                "beneficiary": "TotalEnergies"
            }
        ],
        "has_violating_payer_beneficiary": false,
        "age_country_gender_reach_breakdown": [
            {
                "country": "FR",
                "age_gender_breakdowns": [
                    {
                        "male": 232,
                        "female": 59,
                        "unknown": 1,
                        "age_range": "18-24"
                    },
                    {
                        "male": 738,
                        "female": 440,
                        "unknown": 10,
                        "age_range": "45-54"
                    },
                    {
                        "male": 9592,
                        "female": 13507,
                        "unknown": 110,
                        "age_range": "65+"
                    },
                    {
                        "male": 2540,
                        "female": 2413,
                        "unknown": 28,
                        "age_range": "55-64"
                    },
                    {
                        "male": 643,
                        "female": 166,
                        "unknown": 7,
                        "age_range": "35-44"
                    },
                    {
                        "male": 626,
                        "female": 109,
                        "unknown": 3,
                        "age_range": "25-34"
                    }
                ]
            }
        ]
    },
    "currency": "EUR",
    "isActive": true,
    "pageInfo": null,
    "pageName": "TotalEnergies",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "Partez \u00e0 la d\u00e9couverte des sp\u00e9cialit\u00e9s r\u00e9gionales dans nos stations sur les autoroutes de France ! Les petits producteurs r\u00e9gionaux sont \u00e0 l\u2019honneur pour vous proposer des produits de qualit\u00e9 pendant vos moments de pause. \ud83d\udee3\ufe0f<br /> On parie que vous allez adorer d\u00e9couvrir et d\u00e9guster ces produits locaux ? \ud83d\ude0b"
            },
            "context": {},
            "callerHash": "400342703b25101d2dd9cc0fc45c2d9d"
        },
        "cards": [
            {
                "body": " ",
                "title": "Les stations TotalEnergies",
                "caption": "",
                "link_url": "https://totalms.webgeoservices.com/maps/embed/?country=fr&languageTranslation=fr_fr&showPrices=true&brands=TAC,TOT&poiTypes=ST001,ST002,ST003&filters=MurDesReg",
                "image_crops": {},
                "link_description": " ",
                "resized_image_url": "https://scontent-lax3-2.xx.fbcdn.net/v/t39.35426-6/450766554_1429436754420088_5976582854379574098_n.jpg?stp=dst-jpg_s600x600&_nc_cat=111&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=co27H0PgeQ8Q7kNvgFjeolr&_nc_ht=scontent-lax3-2.xx&oh=00_AYCi0KiS95KYAJUU3ZF4gkjP4vVH33gMLZHMC7hj2QnHIw&oe=669840DA",
                "original_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/450715652_770215178516995_6268679805707646558_n.jpg?_nc_cat=109&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=HGF0y5FnNAwQ7kNvgEVKpZC&_nc_ht=scontent-lax3-1.xx&oh=00_AYCkw5jNE8kNw2lAa048594BCOB5VmoMh3clLYUIrXbsVg&oe=6698314D",
                "watermarked_resized_image_url": ""
            },
            {
                "body": " ",
                "title": "Les stations TotalEnergies",
                "caption": "",
                "link_url": "https://totalms.webgeoservices.com/maps/embed/?country=fr&languageTranslation=fr_fr&showPrices=true&brands=TAC,TOT&poiTypes=ST001,ST002,ST003&filters=MurDesReg",
                "image_crops": {},
                "link_description": " ",
                "resized_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/450979472_1035506921529867_1583640128779825592_n.jpg?stp=dst-jpg_s600x600&_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=upTSFNEvjssQ7kNvgHmeGj3&_nc_ht=scontent-lax3-1.xx&oh=00_AYAsGU4h1OtW_NKIAh7R5RszFJ4g84QY5-dd98fsP2Vp5g&oe=6698389E",
                "original_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/451022693_1021820676186275_6291412253621945026_n.jpg?_nc_cat=104&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=ST6_XORkLzYQ7kNvgFhczT0&_nc_ht=scontent-lax3-1.xx&oh=00_AYDkuYuoXq9zbgQ3kRNJ-tSWLbCgq3N7IbNbVKZ4uALG5g&oe=66984359",
                "watermarked_resized_image_url": ""
            },
            {
                "body": " ",
                "title": "Les stations TotalEnergies",
                "caption": "",
                "link_url": "https://totalms.webgeoservices.com/maps/embed/?country=fr&languageTranslation=fr_fr&showPrices=true&brands=TAC,TOT&poiTypes=ST001,ST002,ST003&filters=MurDesReg",
                "image_crops": {},
                "link_description": " ",
                "resized_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/450625644_503997932313410_3672216490439925292_n.jpg?stp=dst-jpg_s600x600&_nc_cat=105&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=HLAFBYa13oUQ7kNvgExDHGz&_nc_ht=scontent-lax3-1.xx&oh=00_AYAJEymFXoJRc04Dt6_dnYk6zYnHi3X6aqWjH45xEMDcGg&oe=669857B8",
                "original_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/450653203_474919331798429_7424708534396344725_n.jpg?_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=xAgkaCHUSeUQ7kNvgG3qf3w&_nc_ht=scontent-lax3-1.xx&oh=00_AYAW2mSFr3_4z6LoQMmXVOTdEbDB4LpDeVOTURGl-Cnqug&oe=6698582A",
                "watermarked_resized_image_url": ""
            },
            {
                "body": " ",
                "title": "Les stations TotalEnergies",
                "caption": "",
                "link_url": "https://totalms.webgeoservices.com/maps/embed/?country=fr&languageTranslation=fr_fr&showPrices=true&brands=TAC,TOT&poiTypes=ST001,ST002,ST003&filters=MurDesReg",
                "image_crops": {},
                "link_description": " ",
                "resized_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/450668508_1008695123687264_1732022914540801086_n.jpg?stp=dst-jpg_s600x600&_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=vj2nrz3Y8nIQ7kNvgHMJMQU&_nc_ht=scontent-lax3-1.xx&oh=00_AYDj8f23SUO4CfC-SMdEiOk9n-CudhMAr9Nk6m5uvz23nw&oe=66983796",
                "original_image_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/450849011_1076708890758338_8550660613775908397_n.jpg?_nc_cat=109&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=IaSIs-WaABkQ7kNvgGfKMm9&_nc_ht=scontent-lax3-1.xx&oh=00_AYDvQd21lKvoW8xUfMFxWGArS_3JG6m9i0BygtRThx3i2Q&oe=66982FC9",
                "watermarked_resized_image_url": ""
            }
        ],
        "event": [],
        "title": "TotalEnergies",
        "byline": "TotalEnergies",
        "images": [],
        "videos": [],
        "caption": null,
        "page_id": 81753537108,
        "version": 3,
        "cta_text": null,
        "cta_type": null,
        "link_url": "https://totalms.webgeoservices.com/maps/embed/?country=fr&languageTranslation=fr_fr&showPrices=true&brands=TAC%2CTOT&poiTypes=ST001%2CST002%2CST003&filters=MurDesReg",
        "page_name": "TotalEnergies",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": "",
        "creation_time": 1720709563,
        "instagram_url": "",
        "ad_creative_id": "120210544698130429",
        "display_format": "carousel",
        "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": "FR",
        "disclaimer_label": 1,
        "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": "",
        "page_is_profile_page": false,
        "page_welcome_message": null,
        "page_profile_picture_url": "https://scontent-lax3-2.xx.fbcdn.net/v/t39.35426-6/450643986_442667212079761_775017511451252295_n.jpg?stp=dst-jpg_s60x60&_nc_cat=101&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=I4V36Bz1f4AQ7kNvgFCPUsr&_nc_ht=scontent-lax3-2.xx&oh=00_AYAU6IJimUp6MqP2K5eb7H5PYUzM6liHkCON5AyKU0gmvw&oe=669839C6",
        "instagram_branded_content": null,
        "instagram_profile_pic_url": "",
        "instagram_shopping_products": [],
        "effective_authorization_category": "POLITICAL"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1720681200,
    "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": [
        1
    ],
    "entityType": "person_profile",
    "adArchiveID": "1604655510379153",
    "collationID": 1192586175527213,
    "reportCount": null,
    "archiveTypes": [],
    "finServAdData": {
        "is_deemed_finserv": false,
        "is_limited_delivery": false
    },
    "isAAAEligible": true,
    "isProfilePage": false,
    "pageIsDeleted": false,
    "reachEstimate": ">1M",
    "collationCount": null,
    "hideDataStatus": "NONE",
    "hasUserReported": false,
    "violation_types": [],
    "hiddenSafetyData": false,
    "publisherPlatform": [
        "facebook"
    ],
    "politicalCountries": [
        "FR"
    ],
    "source_platform_id": "facebook",
    "stateMediaRunLabel": null,
    "isAdAccountActioned": false,
    "impressionsWithIndex": {
        "impressionsText": "35K - 40K",
        "impressionsIndex": 15
    },
    "source_advertiser_id": "81753537108",
    "verified_voice_context": {
        "types": [
            "POLITICAL"
        ],
        "ad_library_fin_serv_info": null
    },
    "containsSensitiveContent": false,
    "containsDigitallyCreatedMedia": false
}
2024-07-13 12:05:34.357383
Powered by Datasette · Queries took 3.1ms