home / unwash_db / ad

ad: 12

This data as json

rowid id source_ad_id raw_data details processed_details advertiser_id created_at updated_at media_archived_at
12 01908230-118c-70f0-8d12-e568f4c86dd1 1637045270471102
{
    "adid": "0",
    "spend": null,
    "pageID": "431744650466",
    "endDate": 1720076400,
    "fevInfo": null,
    "aaa_info": null,
    "currency": "",
    "isActive": true,
    "pageInfo": null,
    "pageName": "Chevron",
    "snapshot": {
        "body": {
            "markup": {
                "__html": "It\u2019s true! You get $1 off per gallon on your next three visits when you download and join Chevron Rewards."
            },
            "context": {},
            "callerHash": "5fc8d76a40da252b2fe1ea46e5c017ab"
        },
        "cards": [],
        "event": [],
        "title": "Chevron Rewards",
        "byline": null,
        "images": [],
        "videos": [
            {
                "video_hd_url": "https://video-lga3-1.xx.fbcdn.net/v/t42.1790-2/449135778_1637045290471100_1240872010406070150_n.?_nc_cat=103&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=aZ8r_5tG7E0Q7kNvgFt3SjR&_nc_ht=video-lga3-1.xx&gid=Aadqbe-h8sS3ahYZ18bn589&oh=00_AYAdGXxBLSRliNbgwhmSVOckQQwJ09Y0u7Q-I8rHyZjEGg&oe=668DA7B7",
                "video_sd_url": "https://video-lga3-1.xx.fbcdn.net/v/t42.1790-2/448094308_987289049569922_224914556893643762_n.mp4?_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=GEcXqm4B5_UQ7kNvgHYN7kx&_nc_ht=video-lga3-1.xx&gid=Aadqbe-h8sS3ahYZ18bn589&oh=00_AYDnyi4MHefDN55gtzmDqiIg0OFKT0CAEAExvRga_HgM7g&oe=668D83FA",
                "video_preview_image_url": "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/449167675_393994093096375_7861371285592736979_n.jpg?_nc_cat=110&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=EhxfkffsIe4Q7kNvgH7359q&_nc_ht=scontent-lga3-1.xx&gid=Aadqbe-h8sS3ahYZ18bn589&oh=00_AYAiBUxCBXmOuZ_Y5ft-aiRdCYmkH7xyLl1v7kUsA2CJsw&oe=668DA1B1",
                "watermarked_video_hd_url": "",
                "watermarked_video_sd_url": ""
            }
        ],
        "caption": "play.google.com",
        "page_id": 431744650466,
        "version": 3,
        "cta_text": "Download",
        "cta_type": "DOWNLOAD",
        "link_url": "http://play.google.com/store/apps/details?id=com.stuzo.chevron",
        "page_name": "Chevron",
        "extra_links": [],
        "extra_texts": [],
        "is_reshared": false,
        "extra_images": [],
        "extra_videos": [],
        "brazil_tax_id": null,
        "creation_time": 1719472841,
        "instagram_url": "",
        "ad_creative_id": "120209149466220527",
        "display_format": "video",
        "additional_info": null,
        "branded_content": null,
        "ec_certificates": null,
        "page_categories": {
            "2238": "Energy Company"
        },
        "page_is_deleted": false,
        "page_like_count": 1213114,
        "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/Chevron",
        "body_translations": {},
        "current_page_name": "Chevron",
        "dynamic_item_flags": {},
        "root_reshared_post": null,
        "instagram_actor_name": "chevron",
        "page_is_profile_page": false,
        "page_welcome_message": null,
        "page_profile_picture_url": "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/449210176_1010979423736749_580976888945792150_n.jpg?stp=dst-jpg_s60x60&_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=joS_kXAXBgIQ7kNvgHeyDuH&_nc_ht=scontent-lga3-1.xx&gid=Aadqbe-h8sS3ahYZ18bn589&oh=00_AYALWM_-e1RlPv1AoMrf4zgaaP6VjnyUYKlCDVOLT9lBNQ&oe=668D9821",
        "instagram_branded_content": null,
        "instagram_profile_pic_url": "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/449167151_1283411189300989_6211935720351988089_n.jpg?_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=BoBQrVQZ6yIQ7kNvgE-ZIFO&_nc_ht=scontent-lga3-1.xx&gid=Aadqbe-h8sS3ahYZ18bn589&oh=00_AYAl-Gi9MgWS7MEHOVjLX7yqfMCARnlVt3qFTrogTgfjjg&oe=668D9F1A",
        "instagram_shopping_products": [],
        "effective_authorization_category": "NONE"
    },
    "gatedType": "eligible",
    "menuItems": [],
    "startDate": 1719471600,
    "advertiser": {
        "page": {
            "id": "431744650466",
            "about": {
                "text": "This is the official Facebook page of Chevron. \nOur greatest resource is our people. Their ingenuity, creativity and collaboration have met the complex challenges of energy\u2019s past. Together, we\u2019ll take on the future."
            },
            "is_delegate_page_with_linked_primary_profile": false
        },
        "ad_library_page_info": null
    },
    "categories": [
        0
    ],
    "entityType": "person_profile",
    "adArchiveID": "1637045270471102",
    "collationID": 2132374737132244,
    "reportCount": null,
    "archiveTypes": [],
    "finServAdData": {
        "is_deemed_finserv": false,
        "is_limited_delivery": false
    },
    "isAAAEligible": false,
    "isProfilePage": false,
    "pageIsDeleted": false,
    "reachEstimate": null,
    "collationCount": null,
    "hideDataStatus": "NONE",
    "hasUserReported": false,
    "violation_types": [],
    "hiddenSafetyData": false,
    "publisherPlatform": [
        "facebook",
        "instagram",
        "audience_network",
        "messenger"
    ],
    "politicalCountries": [],
    "source_platform_id": "audience_network",
    "stateMediaRunLabel": null,
    "isAdAccountActioned": false,
    "impressionsWithIndex": {
        "impressionsText": null,
        "impressionsIndex": -1
    },
    "source_advertiser_id": "431744650466",
    "verified_voice_context": null,
    "containsSensitiveContent": false,
    "containsDigitallyCreatedMedia": false
}
{
    "stats": {
        "spend": null,
        "report_count": null,
        "reach_estimate": null,
        "impression_text": null
    },
    "content": {
        "all_links": [
            "http://play.google.com/store/apps/details?id=com.stuzo.chevron",
            "https://facebook.com/Chevron",
            "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/449167151_1283411189300989_6211935720351988089_n.jpg?_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=BoBQrVQZ6yIQ7kNvgE-ZIFO&_nc_ht=scontent-lga3-1.xx&gid=Aadqbe-h8sS3ahYZ18bn589&oh=00_AYAl-Gi9MgWS7MEHOVjLX7yqfMCARnlVt3qFTrogTgfjjg&oe=668D9F1A",
            "https://scontent-lga3-1.xx.fbcdn.net/v/t39.35426-6/449210176_1010979423736749_580976888945792150_n.jpg?stp=dst-jpg_s60x60&_nc_cat=102&ccb=1-7&_nc_sid=c53f8f&_nc_ohc=joS_kXAXBgIQ7kNvgHeyDuH&_nc_ht=scontent-lga3-1.xx&gid=Aadqbe-h8sS3ahYZ18bn589&oh=00_AYALWM_-e1RlPv1AoMrf4zgaaP6VjnyUYKlCDVOLT9lBNQ&oe=668D9821"
        ],
        "all_texts": [
            "chevron rewards",
            "play.google.com",
            "download"
        ],
        "all_images": [
            "images/1e820047b9dceeb2.jpeg"
        ],
        "all_videos": [
            "videos/9159d2d88e29f911.mp4",
            "videos/c6b38f184e1e6cc4.mp4"
        ]
    },
    "metadata": {
        "currency": null,
        "duration": {
            "end_date": "2024-07-04T07:00:00Z",
            "start_date": "2024-06-27T07:00:00Z"
        },
        "countries": [],
        "categories": [
            "Energy Company"
        ]
    }
}
{
    "ocr": {
        "processed": true
    },
    "bert_classify": {
        "result": {
            "score": 0.6058502197265625
        },
        "processed": true
    },
    "transcription": {
        "processed": true
    }
}
019082e4-d857-766e-825b-da38cee6c1ec 2024-07-05 12:35:54.07911 2024-08-03 19:51:38.199269 2024-07-05 14:36:53.21883
Powered by Datasette · Queries took 2.434ms