raw_ad: 87
This data as json
| rowid | id | external_id | raw_data | base_fk_updated_at |
|---|---|---|---|---|
| 87 | 019272e6-2d3d-743e-969b-1eccdfed0ef7 | 1349591222589424_instagram_253615198009828 | {
"url": "https://www.facebook.com/ads/library/?active_status=all&ad_type=all&country=ALL&view_all_page_id=253615198009828&sort_data[direction]=desc&sort_data[mode]=relevancy_monthly_grouped&search_type=page&media_type=all",
"adid": "0",
"spend": null,
"pageID": "253615198009828",
"endDate": 1703232000,
"fevInfo": null,
"aaa_info": {
"targets_eu": true,
"age_audience": {
"max": 55,
"min": 25
},
"eu_total_reach": 70,
"gender_audience": "All",
"is_ad_taken_down": true,
"location_audience": [
{
"name": "Asia",
"type": "country_groups",
"excluded": false,
"num_obfuscated": 0
},
{
"name": "South America",
"type": "country_groups",
"excluded": false,
"num_obfuscated": 0
},
{
"name": "Malta",
"type": "countries",
"excluded": false,
"num_obfuscated": 0
}
],
"payer_beneficiary_data": [
{
"payer": "Anglo American",
"beneficiary": "Anglo American"
}
],
"has_violating_payer_beneficiary": false,
"age_country_gender_reach_breakdown": [
{
"country": "MT",
"age_gender_breakdowns": [
{
"male": 4,
"female": null,
"unknown": null,
"age_range": "35-44"
},
{
"male": 1,
"female": null,
"unknown": null,
"age_range": "45-54"
},
{
"male": 7,
"female": null,
"unknown": null,
"age_range": "25-34"
}
]
},
{
"country": "CY",
"age_gender_breakdowns": [
{
"male": 13,
"female": null,
"unknown": null,
"age_range": "35-44"
},
{
"male": 9,
"female": 3,
"unknown": 1,
"age_range": "45-54"
},
{
"male": 1,
"female": 1,
"unknown": null,
"age_range": "55-64"
},
{
"male": 19,
"female": null,
"unknown": null,
"age_range": "25-34"
}
]
},
{
"country": "GF",
"age_gender_breakdowns": [
{
"male": 7,
"female": 1,
"unknown": null,
"age_range": "35-44"
},
{
"male": 3,
"female": null,
"unknown": null,
"age_range": "25-34"
}
]
}
]
},
"currency": "",
"isActive": false,
"pageInfo": null,
"pageName": "Anglo American",
"snapshot": {
"body": {
"markup": {
"__html": "Our innovation-led approach to sustainable mining is all about building an industry that contributes to a better world."
},
"context": {},
"callerHash": "3afbdffd09f531c1f771d97310e9812a"
},
"cards": [],
"event": [],
"title": "Re-imagining mining to improve lives",
"byline": null,
"images": [],
"videos": [
{
"video_hd_url": "https://video-lga3-2.xx.fbcdn.net/v/t42.1790-2/411433620_1349591245922755_5041467415842075274_n.?_nc_cat=101&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=WCnZPvB7-3YQ7kNvgGRzaAh&_nc_ht=video-lga3-2.xx&_nc_gid=ATUHpz3XVhWzkNTuNCwgMXW&oh=00_AYBudXiuFFGSZypX8eqO054TpZV3wCvRhCOEwziMIszvMQ&oe=670CB3E5",
"video_sd_url": "https://video-lga3-1.xx.fbcdn.net/v/t42.1790-2/409324677_6930420890371376_5604385104024402710_n.mp4?_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=dG5e6Z2517wQ7kNvgHQznUK&_nc_ht=video-lga3-1.xx&_nc_gid=ATUHpz3XVhWzkNTuNCwgMXW&oh=00_AYDvROaYmOIJTUVoeSDh0AsC6x8AuJRAgsy09VFj7dTxTA&oe=670CB27B",
"video_preview_image_url": "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/412853451_1549424319153021_8072099312477274167_n.jpg?_nc_cat=103&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=PlktdBEtTqAQ7kNvgEiSe61&_nc_ht=scontent-lga3-1.xx&_nc_gid=ATUHpz3XVhWzkNTuNCwgMXW&oh=00_AYCai9MrRXN48wpykP07MFEXhSOX0mMFKBRog3yHqTUaRQ&oe=670CA7A2",
"watermarked_video_hd_url": "",
"watermarked_video_sd_url": ""
}
],
"caption": "www.angloamerican.com",
"page_id": 253615198009828,
"version": 3,
"cta_text": "Learn more",
"cta_type": "LEARN_MORE",
"link_url": "https://www.angloamerican.com/",
"page_name": "Anglo American",
"extra_links": [],
"extra_texts": [],
"is_reshared": false,
"extra_images": [],
"extra_videos": [],
"brazil_tax_id": null,
"creation_time": 1703090201,
"instagram_url": "",
"ad_creative_id": "120202978652190163",
"display_format": "video",
"additional_info": null,
"branded_content": null,
"ec_certificates": null,
"page_categories": {
"2245": "Mining Company",
"2600": "Organization"
},
"page_is_deleted": false,
"page_like_count": 620918,
"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/AngloAmerican",
"body_translations": {},
"current_page_name": "Anglo American",
"dynamic_item_flags": {},
"root_reshared_post": null,
"instagram_actor_name": "Anglo American",
"page_is_profile_page": false,
"page_welcome_message": null,
"page_profile_picture_url": "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/412717622_688811456724328_647396421867085260_n.jpg?stp=dst-jpg_s60x60&_nc_cat=103&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=AXdALXOTGv8Q7kNvgG6QVj4&_nc_ht=scontent-lga3-1.xx&_nc_gid=ATUHpz3XVhWzkNTuNCwgMXW&oh=00_AYCBf7ceO-aTCVUBrgGdPuyBeaP5osA4ujxYtNsjDySv1w&oe=670C9CFC",
"instagram_branded_content": null,
"instagram_profile_pic_url": "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/412862674_349308214628383_6467269279770532304_n.jpg?_nc_cat=106&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=8ABbFVnULnwQ7kNvgHCoTfD&_nc_ht=scontent-lga3-1.xx&_nc_gid=ATUHpz3XVhWzkNTuNCwgMXW&oh=00_AYCMAW4xxqQCQwGfmZeQbmmIuZ9Pj9CXARLEyV6wO40W1A&oe=670CCAA7",
"instagram_shopping_products": [],
"effective_authorization_category": "NONE"
},
"gatedType": "taken-down",
"menuItems": [],
"startDate": 1703059200,
"advertiser": {
"page": {
"id": "253615198009828",
"about": {
"text": "Anglo American is a leading global mining company and our products are the essential ingredients in a"
},
"is_delegate_page_with_linked_primary_profile": false
},
"ad_library_page_info": null
},
"categories": [
0
],
"entityType": "person_profile",
"adArchiveID": "1349591222589424",
"collationID": 391233523243235,
"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,
"totalActiveTime": null,
"violation_types": [
{
"link": "https://www.facebook.com/policies/ad-standards/objectionable-content/personal-health-and-appearance",
"name": "Personal Health and Appearance",
"is_legal": false
}
],
"hiddenSafetyData": false,
"publisherPlatform": [
"facebook",
"instagram"
],
"politicalCountries": [
"ER",
"TR",
"PH",
"ID",
"PE",
"CL",
"TH",
"GB",
"AR",
"VE",
"JO",
"IL",
"CA",
"AE",
"TL",
"SS",
"ZA",
"GW",
"SG",
"SA",
"TD",
"SO",
"CF",
"PK",
"KM",
"GQ",
"KW",
"BR",
"TJ",
"PY",
"DZ",
"IQ",
"OM",
"MV",
"MT",
"MU",
"GH",
"VN",
"BH",
"TN",
"PS",
"UY",
"EG",
"AU",
"QA",
"GT",
"BO",
"EC",
"CO",
"CY",
"MA",
"KE",
"LK",
"BD",
"NG",
"TW",
"FK",
"US",
"NP",
"BW",
"MW",
"AM",
"GY",
"JP",
"KH",
"ZM",
"YE",
"MG",
"NA",
"KZ",
"ET",
"CM",
"GM",
"MM",
"LY",
"TZ",
"AZ",
"CI",
"ZW",
"IN",
"UG",
"BN",
"GE",
"SN",
"ME",
"RW",
"LB",
"BI",
"PG",
"TM",
"GN",
"CV",
"LR",
"NE",
"SL",
"NZ",
"SC",
"SR",
"LA",
"LS",
"BT",
"KG",
"BJ",
"CD",
"GA",
"TG",
"BF",
"DJ",
"UZ",
"AO",
"ML",
"MY",
"MZ",
"MN"
],
"source_platform_id": "instagram",
"stateMediaRunLabel": null,
"isAdAccountActioned": false,
"impressionsWithIndex": {
"impressionsText": null,
"impressionsIndex": -1
},
"source_advertiser_id": "253615198009828",
"verified_voice_context": null,
"containsSensitiveContent": false,
"containsDigitallyCreatedMedia": false
} |
2024-10-09 20:12:53.722777 |