raw_ad: 42
This data as json
rowid | id | external_id | raw_data | base_fk_updated_at |
---|---|---|---|---|
42 | 0190abfa-2eee-7ba8-8cd8-7eb6289bb144 | 1131527034599068_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": 65, "min": 25 }, "eu_total_reach": 2708, "gender_audience": "All", "is_ad_taken_down": false, "location_audience": [ { "name": "France", "type": "countries", "excluded": false, "num_obfuscated": 0 } ], "payer_beneficiary_data": [ { "payer": "TotalEnergies", "beneficiary": "TotalEnergies" } ], "has_violating_payer_beneficiary": false, "age_country_gender_reach_breakdown": [ { "country": "FR", "age_gender_breakdowns": [ { "male": 502, "female": 72, "unknown": 7, "age_range": "45-54" }, { "male": 163, "female": 18, "unknown": 2, "age_range": "65+" }, { "male": 893, "female": 92, "unknown": 33, "age_range": "25-34" }, { "male": 461, "female": 45, "unknown": 19, "age_range": "35-44" }, { "male": 355, "female": 76, "unknown": 7, "age_range": "55-64" } ] } ] }, "currency": "", "isActive": false, "pageInfo": null, "pageName": "TotalEnergies", "snapshot": { "body": { "markup": { "__html": "Retour dans le temps avec ce van embl\u00e9matique ! \ud83d\ude90\ud83c\udf08 \u200b<br /> <br /> Une \u00e9poque o\u00f9 chaque stop \u00e9tait une aventure sur la route ! \u200b<br /> <br /> #Ann\u00e9es70 #VintageLife #Souvenirs #R\u00e9tro #stationservice #vintage #ClassicCar #Nostalgie #ThrowBack #OntheRoad #TotalEnergies #TotalEnergiesFrance #Auto #VintageVibe #CombiVW" }, "context": {}, "callerHash": "400342703b25101d2dd9cc0fc45c2d9d" }, "cards": [], "event": [], "title": null, "byline": null, "images": [ { "resized_image_url": "https://scontent-lax3-2.xx.fbcdn.net/v/t39.35426-6/450186968_1151845232729320_5992165865637342241_n.jpg?stp=dst-jpg_s600x600&_nc_cat=103&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=-gRlRIMIF34Q7kNvgEPdC-r&_nc_ht=scontent-lax3-2.xx&oh=00_AYBRvUidH1YkJYuVRPdFQhfrhQ3QX5A2oTNtv8eI0Y2zVw&oe=66982A6F", "original_image_url": "https://scontent-lax3-2.xx.fbcdn.net/v/t39.35426-6/450229514_1021702739594299_5618355392474835190_n.jpg?_nc_cat=111&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=VCGi2EP8UEIQ7kNvgHRQTT8&_nc_ht=scontent-lax3-2.xx&oh=00_AYB_CIk7EbTik3U6NJd_FT6dAxUnwNe1ihm8SbkK5Bkteg&oe=66982A67", "watermarked_resized_image_url": "" } ], "videos": [], "caption": null, "page_id": 81753537108, "version": 3, "cta_text": null, "cta_type": null, "link_url": null, "page_name": "TotalEnergies", "extra_links": [], "extra_texts": [], "is_reshared": false, "extra_images": [], "extra_videos": [], "brazil_tax_id": null, "creation_time": 1720455418, "instagram_url": "", "ad_creative_id": "120210455256600429", "display_format": "image", "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-2.xx.fbcdn.net/v/t39.35426-6/450178643_494514286578318_3492293731916526101_n.jpg?stp=dst-jpg_s60x60&_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=jIJ_cz27M5EQ7kNvgETn66y&_nc_ht=scontent-lax3-2.xx&oh=00_AYAhiiJfouZII4qk9cl-vIEpdbmSdAEljrP630lgQiWGyg&oe=66982476", "instagram_branded_content": null, "instagram_profile_pic_url": "https://scontent-lax3-1.xx.fbcdn.net/v/t39.35426-6/450248600_1401240277254023_7509882426298827522_n.jpg?_nc_cat=109&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=pDYHs_E2Eb0Q7kNvgFIb889&_nc_ht=scontent-lax3-1.xx&oh=00_AYA7ReGDLQLPj91sttEf911M0A53yfrWQecppEu_E7kc5w&oe=66984F36", "instagram_shopping_products": [], "effective_authorization_category": "NONE" }, "gatedType": "eligible", "menuItems": [], "startDate": 1720422000, "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": "1131527034599068", "collationID": 3856846311269941, "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": [ "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 |