Schema Info

Schema Name: sfdl_prod_segment.reactfoot_gtmwebreservation

created: 2017-11-02 14:15:40
disabled: False
format: raw
id: 143
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_segment",
    "table": "reactfoot_gtmwebreservation"
}

type: segment

Schema Versions: 3

Version 1214954

created: 2025-03-04 13:35:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmwebreservation`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`messageId`STRING,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`campaign`:struct<`source`:STRING,`id`:STRING,`term`:STRING,`name`:STRING,`content`:STRING,`medium`:STRING>,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`timezone`:STRING,`page`:struct<`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`userAgent`:STRING>,`version`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`booking`:struct<`emailHash`:STRING,`confirmationCode`:STRING,`email`:STRING,`npv`:STRING>,`transaction`:struct<`free`:STRING,`facilitylocation`:struct<`city`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING,`address1`:STRING,`zip`:STRING>,`bookedUnit`:struct<`reservation_days`:STRING,`promotion`:STRING,`unitType`:STRING,`description`:struct<`vehicle`:struct<`permitted`:STRING,`only`:STRING,`warehouse`:STRING>,`physical`:struct<`height`:STRING,`length`:STRING,`width`:STRING>>,`amenities`:array,`id`:STRING,`price`:struct<`meta`:STRING>>,`affiliateId`:STRING,`corrected`:STRING,`facilityName`:STRING,`AAAMemberNumber`:STRING,`phoneFacilityTransfer`:STRING,`alternateLastNames`:array,`bookingWidget`:STRING,`promoCode`:STRING,`depositPaid`:STRING,`phoneChangedNumber`:STRING,`promo`:STRING,`modifiedDtm`:STRING,`sizeW`:STRING,`apiUnitId`:STRING,`canceled`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`trafficSourceId`:STRING,`alternateEmails`:array,`visitId`:STRING,`callerIdPhone`:STRING,`bookingType`:STRING,`bookingState`:STRING,`facilityId`:STRING,`moveIn`:STRING,`unitId`:STRING,`phoneVerified`:STRING,`eSignType`:STRING,`baseBid`:STRING,`centershiftAccountId`:STRING,`totalPaid`:STRING,`omiCompleted`:STRING,`resaleRate`:STRING,`matchScore`:STRING,`facilityGetsNotificationEmails`:STRING,`sessionId`:STRING,`sizeH`:STRING,`firstName`:STRING,`omiPri`:STRING,`facilityTenantId`:STRING,`phone`:STRING,`callCenter`:STRING,`reviewStatus`:STRING,`alternateFirstNames`:array,`phoneStatus`:STRING,`apiCustId`:STRING,`payoutBatchId`:STRING,`bidAmount`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`siteId`:STRING,`hotLead`:STRING,`facilityPhone`:STRING,`hostedWebsite`:STRING,`bookingAgent`:STRING,`facilityTenant`:STRING,`hasContactlessMoveins`:STRING,`onlineMoveInUrl`:STRING,`termsVersion`:STRING,`contacted`:STRING,`bookingAgentId`:STRING,`emailHash`:STRING,`commission`:STRING,`read`:STRING,`companyCode`:STRING,`unitNumber`:STRING,`alternatePhones`:array,`email`:STRING,`lastName`:STRING,`statementId`:STRING,`sizeD`:STRING,`message`:STRING,`experiments`:struct<`sf_4161_post_res_paid`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_omi_mfe_embed`:STRING,`sf_5289_facility_page_two`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_11616_homepage_updates`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_7018_upsellit`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_5430_incentive_header`:STRING,`sf_6852_serp_results`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_6138_mid_field_text`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`hack_01_facility_page`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_13380_sfdc_new_filter`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_6327_visa_incentive`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_5129_call_me_back`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_4606_post_res_sms`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_7249_guided_unit_selection`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_13810_new_map_strategy`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_5288_informed_search_2`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_5635_half_nomad`:STRING,`sf_8535_sfdc_unit_comparsion_v1`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`red_716_tracking_prerender`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_9463_sfdc_tpp_badging`:STRING>,`price`:STRING,`searchWeightId`:STRING,`hasOnlineMoveIns`:STRING,`referrerId`:STRING,`estimatedRevenue`:STRING,`apiLeadId`:STRING,`omiFlowEnabled`:STRING,`userId`:STRING,`moveInActual`:STRING,`monthlyInsurance`:STRING,`unit`:struct<`unitIds`:array>,`rebateProcessed`:STRING,`movedIn`:STRING,`timestamp`:STRING,`callCenterNotes`:STRING,`sitePhone`:STRING,`duplicateOf`:STRING,`autoState`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`invoiceId`:STRING,`bookingAuth`:STRING,`searchWeightTestId`:STRING,`confirmationCode`:STRING,`pickupTime`:STRING,`actualD`:STRING,`customerNotes`:STRING,`callCenterTransfer`:STRING,`typeOfListing`:STRING,`bidType`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`moveInOriginal`:STRING,`listingWantId`:STRING,`npv`:STRING,`eVisitId`:STRING,`actualW`:STRING,`complete`:STRING,`moveOut`:STRING>,`env`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmwebreservation"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation
id: 1214954
processed: 1

raw_data:

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2025-03-04T19:34:43Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1741046400000/1741116853676.events-archiver-480-13..c48f605f-465f-4fee-bbe9-c3f5aa175ca9.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "647300bd-6520-4232-8c2a-a1e5eb9addf8",
    "channel": "client",
    "context": {
        "ip": "2600:1006:b151:4aa6:4062:5219:e591:3170",
        "library": {
            "name": "analytics.js",
            "version": "next-1.77.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/West-Palm-Beach-FL-self-storage/Extra-Space-Storage-3871-West-Palm-Beach-Belvedere-Rd-230569.html",
            "referrer": "https://www.sparefoot.com/West-Palm-Beach-FL-self-storage/climate-controlled.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834078591&cpgnid=611394405&ptaid=dsa-90224162997&mkwid=s%7Cpcrid%7C341926302866%7Cpkw%7C%7Cpmt%7C%7Cpdv%7Cm%7Cpgrid%7C32834078591%7Ccpgnid%7C611394405%7Cptaid%7Cdsa-90224162997%7Cadext%7C&gad_source=1&gbraid=0AAAAAD0HYGnlSXLc_aaYJPBURlfAM-vsQ&gclid=CjwKCAiA5pq-BhBuEiwAvkzVZa_1K7K5hkHwr7mZE5P4qYyJ4SGCsVCBRZF_T8UmV0vqyQbwLh5PtBoCN_oQAvD_BwE",
            "search": "",
            "title": "Extra Space Storage - 3871 - West Palm Beach - Belvedere Rd | 1520 Belvedere Road | SpareFoot",
            "url": "https://www.sparefoot.com/West-Palm-Beach-FL-self-storage/Extra-Space-Storage-3871-West-Palm-Beach-Belvedere-Rd-230569.html"
        },
        "timezone": "America/New_York",
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.3 Mobile/15E148 Safari/604.1"
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1741116828476-673688b9-d750-4dc1-bf18-bbcd959c5601",
    "originalTimestamp": "2025-03-04T19:33:48.476Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1741116828476,
        "booking": {
            "confirmationCode": "YYGXN4528",
            "email": "[email protected]",
            "emailHash": "c393901f1ab15425a71a5970bcbdc1b0f8153f88e1cdbf2c5f27dc5c7fe7ef3d",
            "npv": "1510.65"
        },
        "env": "production",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 5910,
                "hasOnlineMoveIns": true
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": null,
            "apiLeadId": "8b345fff-d3f1-4142-a947-ba11d32b6d68",
            "apiUnitId": "3124",
            "autoState": null,
            "baseBid": "4.05",
            "bidAmount": "1510.65",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "Climate Controlled",
                    "Interior",
                    "Upstairs (Access via Elevator)"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "30.00",
                        "width": "10.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 30939698,
                "price": {
                    "meta": "373.00"
                },
                "promotion": "",
                "reservation_days": 5,
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingAuth": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJzaXRlLWlkIiwiaWF0IjoxNzQxMTE2ODI4LCJleHAiOjE3NDEyODk2MjgsImRhdGEiOnsiZW1haWwiOiJyYWZmYWVsZUAyYmVsaWV2ZS5jb20iLCJjb25maXJtYXRpb25Db2RlIjoiWVlHWE40NTI4In19.nKvcJrpdZjxDbekaoAXaEz-OACO6k7Bt5RfHsHSfBGk",
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2025-03-04 1:33pm] Booking 10' x 30' unit $373.00 (Climate Controlled, Interior, Upstairs (Access via Elevator)) on website (Mobile - m.SpareFoot.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": 0,
            "companyCode": "3871",
            "complete": 1,
            "confirmationCode": "YYGXN4528",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "c393901f1ab15425a71a5970bcbdc1b0f8153f88e1cdbf2c5f27dc5c7fe7ef3d",
            "estimatedRevenue": 819.98082,
            "experiments": {
                "sf_11349_sfdc_omi": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "control",
                "sf_12700_sfdc_paid_landing_refresh": "control",
                "sf_13230_distance_top_five_algo": "inactive",
                "sf_13380_sfdc_new_filter": "control",
                "sf_13810_new_map_strategy": "inactive",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 230569,
            "facilityName": "Extra Space Storage - 3871 - West Palm Beach - Belvedere Rd",
            "facilityPhone": 5617171366,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "1520 Belvedere Road",
                "address2": "",
                "city": "West Palm Beach",
                "country": "",
                "state": "FL",
                "zip": "33406"
            },
            "firstName": "Susannah",
            "free": 0,
            "hasContactlessMoveins": true,
            "hasOnlineMoveIns": true,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "Forest",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2025-03-04 13:33:48",
            "monthlyInsurance": null,
            "moveIn": "2025-03-08",
            "moveInActual": null,
            "moveInOriginal": "2025-03-08",
            "moveOut": null,
            "movedIn": 0,
            "npv": "1510.65",
            "omiCompleted": false,
            "omiFlowEnabled": false,
            "omiPri": null,
            "onlineMoveInUrl": "https://www.extraspace.com/storage/online-lease/e-rental/?confirmationCode=8b345fff-d3f1-4142-a947-ba11d32b6d68",
            "payoutBatchId": null,
            "phone": "9149123449",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "373.00",
            "promo": "",
            "promoCode": null,
            "read": 0,
            "rebateProcessed": 0,
            "referrerId": null,
            "resaleRate": null,
            "reviewStatus": null,
            "searchWeightId": null,
            "searchWeightTestId": null,
            "sessionId": null,
            "siteId": 59,
            "sitePhone": null,
            "sizeD": "30.00",
            "sizeH": null,
            "sizeW": "10.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2025-03-04 13:33:48",
            "totalPaid": null,
            "trafficSourceId": "google-ppc",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "30939698"
                ]
            },
            "unitId": 30939698,
            "unitNumber": null,
            "userId": 6578429,
            "visitId": "a3daffbb6bb8128463d3e346acf6bdc7"
        }
    },
    "receivedAt": "2025-03-04T19:33:48.785Z",
    "sentAt": "2025-03-04T19:33:48.496Z",
    "timestamp": "2025-03-04T19:33:48.765Z",
    "type": "track",
    "userId": "a3daffbb6bb8128463d3e346acf6bdc7",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.id": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingAuth": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
    "properties.transaction.experiments.sf_13810_new_map_strategy": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparsion_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facility__cpLocation.address1": "string",
    "properties.transaction.facility__cpLocation.address2": "string",
    "properties.transaction.facility__cpLocation.city": "string",
    "properties.transaction.facility__cpLocation.country": "string",
    "properties.transaction.facility__cpLocation.state": "string",
    "properties.transaction.facility__cpLocation.zip": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiAttributes.facility": "string",
    "properties.transaction.omiAttributes.organization": "string",
    "properties.transaction.omiAttributes.provider": "string",
    "properties.transaction.omiAttributes.reservation": "string",
    "properties.transaction.omiAttributes.unit": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 143
schema_scan_id: 138216402
updated: 2025-03-04 13:36:24

Version 1102632

created: 2024-11-27 14:57:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmwebreservation`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`context`struct<`locale`:STRING,`amp`:struct<`id`:STRING>,`page`:struct<`url`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING>,`userAgent`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`timezone`:STRING,`campaign`:struct<`source`:STRING,`id`:STRING,`term`:STRING,`name`:STRING,`content`:STRING,`medium`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>>,`_origin`STRING,`projectId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`version`STRING,`timestamp`STRING,`anonymousId`STRING,`receivedAt`STRING,`type`STRING,`event`STRING,`sentAt`STRING,`messageId`STRING,`originalTimestamp`STRING,`properties`struct<`isReact`:STRING,`booking`:struct<`confirmationCode`:STRING,`email`:STRING,`emailHash`:STRING,`npv`:STRING>,`transaction`:struct<`statementId`:STRING,`duplicateOf`:STRING,`matchReasons`:STRING,`alternateFirstNames`:array,`phoneChangedNumber`:STRING,`apiUnitId`:STRING,`typeOfListing`:STRING,`sizeW`:STRING,`bookingAgentId`:STRING,`sessionId`:STRING,`eVisitId`:STRING,`termsVersion`:STRING,`phone`:STRING,`apiLeadId`:STRING,`sizeD`:STRING,`complete`:STRING,`onlineMoveInUrl`:STRING,`searchWeightTestId`:STRING,`hostedWebsite`:STRING,`experiments`:struct<`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_5430_incentive_header`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_6138_mid_field_text`:STRING,`sf_7018_upsellit`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_13810_new_map_strategy`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_omi_mfe_embed`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_8535_sfdc_unit_comparsion_v1`:STRING,`sf_4161_post_res_paid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_6327_visa_incentive`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_13380_sfdc_new_filter`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`hack_01_facility_page`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_5289_facility_page_two`:STRING,`sf_5288_informed_search_2`:STRING,`sf_5635_half_nomad`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_6852_serp_results`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_4606_post_res_sms`:STRING,`red_716_tracking_prerender`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_11616_homepage_updates`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_5129_call_me_back`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING>,`depositPaid`:STRING,`matchScore`:STRING,`bookedUnit`:struct<`id`:STRING,`reservation_days`:STRING,`price`:struct<`meta`:STRING>,`description`:struct<`vehicle`:struct<`only`:STRING,`permitted`:STRING,`warehouse`:STRING>,`physical`:struct<`length`:STRING,`height`:STRING,`width`:STRING>>,`amenities`:array,`promotion`:STRING,`unitType`:STRING>,`promoCode`:STRING,`affiliateId`:STRING,`price`:STRING,`hotLead`:STRING,`moveOut`:STRING,`read`:STRING,`siteId`:STRING,`omiCompleted`:STRING,`baseBid`:STRING,`referrerId`:STRING,`movedIn`:STRING,`monthlyInsurance`:STRING,`disputeReason`:STRING,`reviewStatus`:STRING,`callCenter`:STRING,`phoneFacilityTransfer`:STRING,`alternateEmails`:array,`rebateProcessed`:STRING,`phoneStatus`:STRING,`AAAMemberNumber`:STRING,`omiPri`:STRING,`centershiftAccountId`:STRING,`facilityGetsNotificationEmails`:STRING,`trafficSourceId`:STRING,`payoutBatchId`:STRING,`bookingWidget`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`lastName`:STRING,`callCenterTransfer`:STRING,`hasContactlessMoveins`:STRING,`autoState`:STRING,`facilityId`:STRING,`moveInOriginal`:STRING,`searchWeightId`:STRING,`callerIdPhone`:STRING,`facilityTenantId`:STRING,`unitId`:STRING,`commission`:STRING,`bookingState`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`emailHash`:STRING,`actualW`:STRING,`totalPaid`:STRING,`contacted`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`facilityPhone`:STRING,`firstName`:STRING,`confirmationCode`:STRING,`unitNumber`:STRING,`userId`:STRING,`resaleRate`:STRING,`message`:STRING,`alternatePhones`:array,`unit`:struct<`unitIds`:array>,`corrected`:STRING,`companyCode`:STRING,`free`:STRING,`modifiedDtm`:STRING,`bookingAgent`:STRING,`eSignType`:STRING,`omiFlowEnabled`:STRING,`promo`:STRING,`bookingType`:STRING,`listingWantId`:STRING,`visitId`:STRING,`sizeH`:STRING,`apiCustId`:STRING,`invoiceId`:STRING,`customerNotes`:STRING,`pickupTime`:STRING,`moveIn`:STRING,`facilityName`:STRING,`email`:STRING,`callCenterNotes`:STRING,`timestamp`:STRING,`estimatedRevenue`:STRING,`sitePhone`:STRING,`bidAmount`:STRING,`actualD`:STRING,`npv`:STRING,`moveInActual`:STRING,`facilitylocation`:struct<`country`:STRING,`address1`:STRING,`address2`:STRING,`city`:STRING,`zip`:STRING,`state`:STRING>,`bidType`:STRING,`phoneVerified`:STRING,`hasOnlineMoveIns`:STRING,`canceled`:STRING,`alternateLastNames`:array,`facilityTenant`:STRING>,`env`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`userId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmwebreservation"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation
id: 1102632
processed: 1

raw_data:

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-11-27T20:56:45Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1732665600000/1732740954756.events-archiver-480-52..f16963c1-e0f8-40e1-9939-189df470f80f.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "9f8cd674-5800-4773-8504-747b508786ac",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "24 Hour",
            "id": "120211029505070476",
            "medium": "paid",
            "name": "SF Facebook|General",
            "source": "facebook",
            "term": "120211029505120476"
        },
        "ip": "2607:fb91:be9:b766:7048:b0aa:d7fd:cdce",
        "library": {
            "name": "analytics.js",
            "version": "next-1.76.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/Hannibal-MO-self-storage/JDs-Self-Storage-Hwy-61-S-218145.html",
            "referrer": "https://www.google.com/",
            "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834079551&cpgnid=611394405&ptaid=dsa-660763671546&mkwid=s%7Cpcrid%7C342076868826%7Cpkw%7C%7Cpmt%7C%7Cpdv%7Cm%7Cpgrid%7C32834079551%7Ccpgnid%7C611394405%7Cptaid%7Cdsa-660763671546%7Cadext%7C&gad_source=1&gbraid=0AAAAAD0HYGkQwTsy99kwEtqPDsVFSgy_D&gclid=Cj0KCQiAo5u6BhDJARIsAAVoDWsK_LN31o3vYj5joQK6iu4MWs_8ud49FfwdRktpuQrWOMQ0OqvGxEYaApikEALw_wcB",
            "title": "J.D's Self Storage - Hwy 61 S | 134 U.S. 61 | SpareFoot",
            "url": "https://www.sparefoot.com/Hannibal-MO-self-storage/JDs-Self-Storage-Hwy-61-S-218145.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834079551&cpgnid=611394405&ptaid=dsa-660763671546&mkwid=s%7Cpcrid%7C342076868826%7Cpkw%7C%7Cpmt%7C%7Cpdv%7Cm%7Cpgrid%7C32834079551%7Ccpgnid%7C611394405%7Cptaid%7Cdsa-660763671546%7Cadext%7C&gad_source=1&gbraid=0AAAAAD0HYGkQwTsy99kwEtqPDsVFSgy_D&gclid=Cj0KCQiAo5u6BhDJARIsAAVoDWsK_LN31o3vYj5joQK6iu4MWs_8ud49FfwdRktpuQrWOMQ0OqvGxEYaApikEALw_wcB"
        },
        "timezone": "America/Chicago",
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Mobile/15E148 Safari/604.1"
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1732738923390-9ee1b8fb-3daa-448b-bfd9-52d3046cf8e2",
    "originalTimestamp": "2024-11-27T20:22:03.390Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1732738923390,
        "booking": {
            "confirmationCode": "A6KP9ZPME",
            "email": "[email protected]",
            "emailHash": "e29d6a7e3ff853040cb148bcee1aae534ea20cce48694476746313459b002b9f",
            "npv": "148.75"
        },
        "env": "production",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 9112,
                "hasOnlineMoveIns": false
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": "71705",
            "apiLeadId": "71705",
            "apiUnitId": "1726877",
            "autoState": null,
            "baseBid": "1.75",
            "bidAmount": "148.75",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "1st Floor",
                    "Interior"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "8.00",
                        "width": "20.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 27187064,
                "price": {
                    "meta": "85.00"
                },
                "promotion": "MINIMUM 3 MONTHS RENTAL",
                "reservation_days": 3,
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2024-11-27 2:22pm] Booking 20' x 8' unit $85 (24 Hour Access, Interior) on website (Mobile - m.SpareFoot.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": 0,
            "companyCode": null,
            "complete": 1,
            "confirmationCode": "A6KP9ZPME",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "e29d6a7e3ff853040cb148bcee1aae534ea20cce48694476746313459b002b9f",
            "estimatedRevenue": 47.6,
            "experiments": {
                "sf_11349_sfdc_omi": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "control",
                "sf_12700_sfdc_paid_landing_refresh": "control",
                "sf_13230_distance_top_five_algo": "inactive",
                "sf_13380_sfdc_new_filter": "control",
                "sf_13810_new_map_strategy": "variation",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 218145,
            "facilityName": "J.D's Self Storage - Hwy 61 S",
            "facilityPhone": 5736036163,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "134 U.S. 61",
                "address2": "",
                "city": "Hannibal",
                "country": "",
                "state": "MO",
                "zip": "63401"
            },
            "firstName": "Stacy",
            "free": 0,
            "hasContactlessMoveins": true,
            "hasOnlineMoveIns": false,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "Coursume",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2024-11-27 14:22:03",
            "monthlyInsurance": null,
            "moveIn": "2024-11-27",
            "moveInActual": null,
            "moveInOriginal": "2024-11-27",
            "moveOut": null,
            "movedIn": 0,
            "npv": "148.75",
            "omiCompleted": false,
            "omiFlowEnabled": false,
            "omiPri": null,
            "onlineMoveInUrl": null,
            "payoutBatchId": null,
            "phone": "6362976447",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "85.00",
            "promo": "MINIMUM 3 MONTHS RENTAL",
            "promoCode": null,
            "read": 0,
            "rebateProcessed": 0,
            "referrerId": null,
            "resaleRate": null,
            "reviewStatus": null,
            "searchWeightId": null,
            "searchWeightTestId": null,
            "sessionId": null,
            "siteId": 59,
            "sitePhone": null,
            "sizeD": "8.00",
            "sizeH": null,
            "sizeW": "20.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-11-27 14:22:02",
            "totalPaid": null,
            "trafficSourceId": "google-ppc",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "30945875"
                ]
            },
            "unitId": 27187064,
            "unitNumber": "JDS008",
            "userId": 6416029,
            "visitId": "f860e505455409b3eec5113c7592e44d"
        }
    },
    "receivedAt": "2024-11-27T20:22:03.761Z",
    "sentAt": "2024-11-27T20:22:03.413Z",
    "timestamp": "2024-11-27T20:22:03.738Z",
    "type": "track",
    "userId": "f860e505455409b3eec5113c7592e44d",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.id": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
    "properties.transaction.experiments.sf_13810_new_map_strategy": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparsion_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facility__cpLocation.address1": "string",
    "properties.transaction.facility__cpLocation.address2": "string",
    "properties.transaction.facility__cpLocation.city": "string",
    "properties.transaction.facility__cpLocation.country": "string",
    "properties.transaction.facility__cpLocation.state": "string",
    "properties.transaction.facility__cpLocation.zip": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiAttributes.facility": "string",
    "properties.transaction.omiAttributes.organization": "string",
    "properties.transaction.omiAttributes.provider": "string",
    "properties.transaction.omiAttributes.reservation": "string",
    "properties.transaction.omiAttributes.unit": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 143
schema_scan_id: 132506354
updated: 2024-11-27 15:07:14

Version 1042336

created: 2024-10-07 16:41:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmwebreservation`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`context`struct<`locale`:STRING,`amp`:struct<`id`:STRING>,`page`:struct<`url`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING>,`userAgent`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`timezone`:STRING,`campaign`:struct<`source`:STRING,`term`:STRING,`name`:STRING,`content`:STRING,`medium`:STRING>,`ip`:STRING,`library`:struct<`name`:STRING,`version`:STRING>>,`_origin`STRING,`projectId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`version`STRING,`timestamp`STRING,`anonymousId`STRING,`receivedAt`STRING,`type`STRING,`event`STRING,`sentAt`STRING,`messageId`STRING,`originalTimestamp`STRING,`properties`struct<`isReact`:STRING,`booking`:struct<`confirmationCode`:STRING,`email`:STRING,`emailHash`:STRING,`npv`:STRING>,`transaction`:struct<`statementId`:STRING,`duplicateOf`:STRING,`matchReasons`:STRING,`alternateFirstNames`:array,`phoneChangedNumber`:STRING,`apiUnitId`:STRING,`typeOfListing`:STRING,`sizeW`:STRING,`bookingAgentId`:STRING,`sessionId`:STRING,`eVisitId`:STRING,`termsVersion`:STRING,`phone`:STRING,`apiLeadId`:STRING,`sizeD`:STRING,`complete`:STRING,`onlineMoveInUrl`:STRING,`searchWeightTestId`:STRING,`hostedWebsite`:STRING,`experiments`:struct<`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_5430_incentive_header`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_6138_mid_field_text`:STRING,`sf_7018_upsellit`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_13810_new_map_strategy`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_omi_mfe_embed`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_8535_sfdc_unit_comparsion_v1`:STRING,`sf_4161_post_res_paid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_6327_visa_incentive`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_13380_sfdc_new_filter`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`hack_01_facility_page`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_5289_facility_page_two`:STRING,`sf_5288_informed_search_2`:STRING,`sf_5635_half_nomad`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_6852_serp_results`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_4606_post_res_sms`:STRING,`red_716_tracking_prerender`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_11616_homepage_updates`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_5129_call_me_back`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING>,`depositPaid`:STRING,`matchScore`:STRING,`bookedUnit`:struct<`unitType`:STRING,`id`:STRING,`reservation_days`:STRING,`price`:struct<`meta`:STRING>,`description`:struct<`physical`:struct<`length`:STRING,`height`:STRING,`width`:STRING>,`vehicle`:struct<`only`:STRING,`permitted`:STRING,`warehouse`:STRING>>,`promotion`:STRING,`amenities`:array>,`promoCode`:STRING,`affiliateId`:STRING,`price`:STRING,`hotLead`:STRING,`moveOut`:STRING,`read`:STRING,`siteId`:STRING,`omiCompleted`:STRING,`baseBid`:STRING,`referrerId`:STRING,`movedIn`:STRING,`monthlyInsurance`:STRING,`disputeReason`:STRING,`reviewStatus`:STRING,`callCenter`:STRING,`phoneFacilityTransfer`:STRING,`alternateEmails`:array,`rebateProcessed`:STRING,`phoneStatus`:STRING,`AAAMemberNumber`:STRING,`omiPri`:STRING,`centershiftAccountId`:STRING,`facilityGetsNotificationEmails`:STRING,`trafficSourceId`:STRING,`payoutBatchId`:STRING,`bookingWidget`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`lastName`:STRING,`callCenterTransfer`:STRING,`hasContactlessMoveins`:STRING,`autoState`:STRING,`facilityId`:STRING,`moveInOriginal`:STRING,`searchWeightId`:STRING,`callerIdPhone`:STRING,`facilityTenantId`:STRING,`unitId`:STRING,`commission`:STRING,`bookingState`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`emailHash`:STRING,`actualW`:STRING,`totalPaid`:STRING,`contacted`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`facilityPhone`:STRING,`firstName`:STRING,`confirmationCode`:STRING,`unitNumber`:STRING,`userId`:STRING,`resaleRate`:STRING,`message`:STRING,`alternatePhones`:array,`unit`:struct<`unitIds`:array>,`corrected`:STRING,`companyCode`:STRING,`free`:STRING,`modifiedDtm`:STRING,`bookingAgent`:STRING,`eSignType`:STRING,`omiFlowEnabled`:STRING,`promo`:STRING,`bookingType`:STRING,`listingWantId`:STRING,`visitId`:STRING,`sizeH`:STRING,`apiCustId`:STRING,`invoiceId`:STRING,`customerNotes`:STRING,`pickupTime`:STRING,`moveIn`:STRING,`facilityName`:STRING,`email`:STRING,`callCenterNotes`:STRING,`timestamp`:STRING,`estimatedRevenue`:STRING,`sitePhone`:STRING,`bidAmount`:STRING,`actualD`:STRING,`npv`:STRING,`moveInActual`:STRING,`facilitylocation`:struct<`country`:STRING,`address1`:STRING,`address2`:STRING,`city`:STRING,`zip`:STRING,`state`:STRING>,`bidType`:STRING,`phoneVerified`:STRING,`hasOnlineMoveIns`:STRING,`canceled`:STRING,`alternateLastNames`:array,`facilityTenant`:STRING>,`env`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`userId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmwebreservation"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation
id: 1042336
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-10-07T21:40:56Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1728259200000/1728337202777.events-archiver-480-56..a2e067b3-069e-4996-9515-e96d2dbc2a9e.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "5c703b13-427a-4a16-9c4b-feed3f98d106",
    "channel": "client",
    "context": {
        "campaign": {
            "medium": "paidsearch",
            "name": "SF Google|General|Dynamic",
            "source": "google"
        },
        "ip": "2607:fb91:1834:3e3:dc8:e5e4:3a9b:dfdc",
        "library": {
            "name": "analytics.js",
            "version": "next-1.72.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/Daytona-Beach-FL-self-storage/U-Store-Daytona-Beach-370-North-Nova-Road-228145.html",
            "referrer": "https://www.google.com/",
            "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834078591&cpgnid=611394405&ptaid=dsa-663064472148&mkwid=s|pcrid|341926302866|pkw||pmt||pdv|m|pgrid|32834078591|cpgnid|611394405|ptaid|dsa-663064472148|adext|&gad_source=1&gclid=Cj0KCQjwjY64BhCaARIsAIfc7YbkVZyMk_FiEqmUZIdl7Ip4k0J8xs3ry1Ql0ULwZt0dwxn398Hvea0aAlfuEALw_wcB",
            "title": "U-Store- Daytona Beach - 370 North Nova Road | 370 North Nova Road | SpareFoot",
            "url": "https://www.sparefoot.com/Daytona-Beach-FL-self-storage/U-Store-Daytona-Beach-370-North-Nova-Road-228145.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=32834078591&cpgnid=611394405&ptaid=dsa-663064472148&mkwid=s|pcrid|341926302866|pkw||pmt||pdv|m|pgrid|32834078591|cpgnid|611394405|ptaid|dsa-663064472148|adext|&gad_source=1&gclid=Cj0KCQjwjY64BhCaARIsAIfc7YbkVZyMk_FiEqmUZIdl7Ip4k0J8xs3ry1Ql0ULwZt0dwxn398Hvea0aAlfuEALw_wcB"
        },
        "timezone": "America/New_York",
        "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Google Chrome",
                    "version": "129"
                },
                {
                    "brand": "Not=A?Brand",
                    "version": "8"
                },
                {
                    "brand": "Chromium",
                    "version": "129"
                }
            ],
            "mobile": true,
            "platform": "Android"
        }
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1728336756287-9d88b661-e483-4af7-8490-c8552fb2ce41",
    "originalTimestamp": "2024-10-07T21:32:36.287Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1728336756287,
        "booking": {
            "confirmationCode": "FU3GF9JTY",
            "email": "[email protected]",
            "emailHash": "2c87ece9ca986e26f13e113ee346956563cef0eeb6fb9628513648f4d481e737",
            "npv": "373.65"
        },
        "env": "production",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 3401,
                "hasOnlineMoveIns": false
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": "241007213236978",
            "apiLeadId": "241007213236799",
            "apiUnitId": "45961",
            "autoState": null,
            "baseBid": "2.35",
            "bidAmount": "373.65",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "Drive Up Access"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "10.00",
                        "width": "10.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 30084781,
                "price": {
                    "meta": "80.00"
                },
                "promotion": "First Month Free",
                "reservation_days": 7,
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2024-10-07 4:32pm] Booking 10' x 10' unit $80.00 (Drive Up Access) Promo: First Month Free on website (Mobile - m.SpareFoot.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": 0,
            "companyCode": "Nova/ Daytona Beach 10580",
            "complete": 1,
            "confirmationCode": "FU3GF9JTY",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "2c87ece9ca986e26f13e113ee346956563cef0eeb6fb9628513648f4d481e737",
            "estimatedRevenue": 141.987,
            "experiments": {
                "sf_11349_sfdc_omi": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "variation",
                "sf_12700_sfdc_paid_landing_refresh": "control",
                "sf_13230_distance_top_five_algo": "inactive",
                "sf_13380_sfdc_new_filter": "control",
                "sf_13810_new_map_strategy": "inactive",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 228145,
            "facilityName": "U-Store- Daytona Beach - 370 North Nova Road",
            "facilityPhone": 3862580800,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "370 North Nova Road",
                "address2": "",
                "city": "Daytona Beach",
                "country": "",
                "state": "FL",
                "zip": "32114"
            },
            "firstName": "Ida",
            "free": 0,
            "hasContactlessMoveins": true,
            "hasOnlineMoveIns": false,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "Gilbert",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2024-10-07 16:32:37",
            "monthlyInsurance": null,
            "moveIn": "2024-10-12",
            "moveInActual": null,
            "moveInOriginal": "2024-10-12",
            "moveOut": null,
            "movedIn": 0,
            "npv": "373.65",
            "omiCompleted": false,
            "omiFlowEnabled": false,
            "omiPri": null,
            "onlineMoveInUrl": null,
            "payoutBatchId": null,
            "phone": "3862487883",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "80.00",
            "promo": "First Month Free",
            "promoCode": null,
            "read": 0,
            "rebateProcessed": 0,
            "referrerId": null,
            "resaleRate": null,
            "reviewStatus": null,
            "searchWeightId": null,
            "searchWeightTestId": null,
            "sessionId": null,
            "siteId": 59,
            "sitePhone": null,
            "sizeD": "10.00",
            "sizeH": null,
            "sizeW": "10.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-10-07 16:32:37",
            "totalPaid": null,
            "trafficSourceId": "google-ppc",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "30084781",
                    "30097465",
                    "30141928",
                    "30358175",
                    "30362568",
                    "30467747",
                    "30668876",
                    "31434655",
                    "31834521",
                    "31944213",
                    "32154011",
                    "32162891",
                    "32282743",
                    "32285675",
                    "32577188"
                ]
            },
            "unitId": 30084781,
            "unitNumber": "A13",
            "userId": 6332958,
            "visitId": "a81b241b399c0bcf7a442b37c7ac73fe"
        }
    },
    "receivedAt": "2024-10-07T21:32:37.931Z",
    "sentAt": "2024-10-07T21:32:36.421Z",
    "timestamp": "2024-10-07T21:32:37.797Z",
    "type": "track",
    "userId": "a81b241b399c0bcf7a442b37c7ac73fe",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
    "properties.transaction.experiments.sf_13810_new_map_strategy": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparsion_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facility__cpLocation.address1": "string",
    "properties.transaction.facility__cpLocation.address2": "string",
    "properties.transaction.facility__cpLocation.city": "string",
    "properties.transaction.facility__cpLocation.country": "string",
    "properties.transaction.facility__cpLocation.state": "string",
    "properties.transaction.facility__cpLocation.zip": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiAttributes.facility": "string",
    "properties.transaction.omiAttributes.organization": "string",
    "properties.transaction.omiAttributes.provider": "string",
    "properties.transaction.omiAttributes.reservation": "string",
    "properties.transaction.omiAttributes.unit": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 143
schema_scan_id: 128973433
updated: 2024-10-07 16:42:28

Schema Scans: 3

Last at 2025-03-04 13:35:24

Scan 138216402

duration: 0:02:15.461949

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 2718,
    "partitions_applied": false,
    "success": true
}

id: 138216402

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-03-04/",
        "name": "dt",
        "type": "string",
        "value": "2025-03-04"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2025-03-04/1741116853676.events-archiver-480-13..c48f605f-465f-4fee-bbe9-c3f5aa175ca9.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 143
start_time: 2025-03-04 13:35:24
success: True
trace_id: 12000570541848620293

Scan 132506354

duration: 0:04:07.866968

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 2621,
    "partitions_applied": false,
    "success": true
}

id: 132506354

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2024-11-27/",
        "name": "dt",
        "type": "string",
        "value": "2024-11-27"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-11-27/1732740954756.events-archiver-480-52..f16963c1-e0f8-40e1-9939-189df470f80f.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 143
start_time: 2024-11-27 14:57:49
success: True
trace_id: 2786256165133840835

Scan 128973433

duration: 0:01:53.566879

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 2570,
    "partitions_applied": false,
    "success": true
}

id: 128973433

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2024-10-07/",
        "name": "dt",
        "type": "string",
        "value": "2024-10-07"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-10-07/1728337202777.events-archiver-480-56..a2e067b3-069e-4996-9515-e96d2dbc2a9e.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 143
start_time: 2024-10-07 16:41:23
success: True
trace_id: 6704943278777654368

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_gtmwebreservation`\nADD\n\n\n PARTITION (dt='2025-04-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-15/'\n PARTITION (dt='2025-04-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-16/'\n PARTITION (dt='2025-04-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-17/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 1483164,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-15/",
            "name": "dt",
            "value": "2025-04-15"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-14 19:52:10",
                "last_data": "2025-04-15 19:46:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1486173,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-16/",
            "name": "dt",
            "value": "2025-04-16"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-15 19:53:19",
                "last_data": "2025-04-16 19:46:30"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1488296,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-17/",
            "name": "dt",
            "value": "2025-04-17"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-16 19:53:28",
                "last_data": "2025-04-17 17:00:55"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.id": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingAuth": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
    "properties.transaction.experiments.sf_13810_new_map_strategy": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparsion_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facility__cpLocation.address1": "string",
    "properties.transaction.facility__cpLocation.address2": "string",
    "properties.transaction.facility__cpLocation.city": "string",
    "properties.transaction.facility__cpLocation.country": "string",
    "properties.transaction.facility__cpLocation.state": "string",
    "properties.transaction.facility__cpLocation.zip": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiAttributes.facility": "string",
    "properties.transaction.omiAttributes.organization": "string",
    "properties.transaction.omiAttributes.provider": "string",
    "properties.transaction.omiAttributes.reservation": "string",
    "properties.transaction.omiAttributes.unit": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2025-03-04 13:35:30

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`messageId`STRING,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`campaign`:struct<`source`:STRING,`id`:STRING,`term`:STRING,`name`:STRING,`content`:STRING,`medium`:STRING>,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`timezone`:STRING,`page`:struct<`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`userAgent`:STRING>,`version`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`booking`:struct<`emailHash`:STRING,`confirmationCode`:STRING,`email`:STRING,`npv`:STRING>,`transaction`:struct<`free`:STRING,`facilitylocation`:struct<`city`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING,`address1`:STRING,`zip`:STRING>,`bookedUnit`:struct<`reservation_days`:STRING,`promotion`:STRING,`unitType`:STRING,`description`:struct<`vehicle`:struct<`permitted`:STRING,`only`:STRING,`warehouse`:STRING>,`physical`:struct<`height`:STRING,`length`:STRING,`width`:STRING>>,`amenities`:array,`id`:STRING,`price`:struct<`meta`:STRING>>,`affiliateId`:STRING,`corrected`:STRING,`facilityName`:STRING,`AAAMemberNumber`:STRING,`phoneFacilityTransfer`:STRING,`alternateLastNames`:array,`bookingWidget`:STRING,`promoCode`:STRING,`depositPaid`:STRING,`phoneChangedNumber`:STRING,`promo`:STRING,`modifiedDtm`:STRING,`sizeW`:STRING,`apiUnitId`:STRING,`canceled`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`trafficSourceId`:STRING,`alternateEmails`:array,`visitId`:STRING,`callerIdPhone`:STRING,`bookingType`:STRING,`bookingState`:STRING,`facilityId`:STRING,`moveIn`:STRING,`unitId`:STRING,`phoneVerified`:STRING,`eSignType`:STRING,`baseBid`:STRING,`centershiftAccountId`:STRING,`totalPaid`:STRING,`omiCompleted`:STRING,`resaleRate`:STRING,`matchScore`:STRING,`facilityGetsNotificationEmails`:STRING,`sessionId`:STRING,`sizeH`:STRING,`firstName`:STRING,`omiPri`:STRING,`facilityTenantId`:STRING,`phone`:STRING,`callCenter`:STRING,`reviewStatus`:STRING,`alternateFirstNames`:array,`phoneStatus`:STRING,`apiCustId`:STRING,`payoutBatchId`:STRING,`bidAmount`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`siteId`:STRING,`hotLead`:STRING,`facilityPhone`:STRING,`hostedWebsite`:STRING,`bookingAgent`:STRING,`facilityTenant`:STRING,`hasContactlessMoveins`:STRING,`onlineMoveInUrl`:STRING,`termsVersion`:STRING,`contacted`:STRING,`bookingAgentId`:STRING,`emailHash`:STRING,`commission`:STRING,`read`:STRING,`companyCode`:STRING,`unitNumber`:STRING,`alternatePhones`:array,`email`:STRING,`lastName`:STRING,`statementId`:STRING,`sizeD`:STRING,`message`:STRING,`experiments`:struct<`sf_4161_post_res_paid`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_omi_mfe_embed`:STRING,`sf_5289_facility_page_two`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_11616_homepage_updates`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_7018_upsellit`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_5430_incentive_header`:STRING,`sf_6852_serp_results`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_6138_mid_field_text`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`hack_01_facility_page`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_13380_sfdc_new_filter`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_6327_visa_incentive`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_5129_call_me_back`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_4606_post_res_sms`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_7249_guided_unit_selection`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_13810_new_map_strategy`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_5288_informed_search_2`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_5635_half_nomad`:STRING,`sf_8535_sfdc_unit_comparsion_v1`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`red_716_tracking_prerender`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_9463_sfdc_tpp_badging`:STRING>,`price`:STRING,`searchWeightId`:STRING,`hasOnlineMoveIns`:STRING,`referrerId`:STRING,`estimatedRevenue`:STRING,`apiLeadId`:STRING,`omiFlowEnabled`:STRING,`userId`:STRING,`moveInActual`:STRING,`monthlyInsurance`:STRING,`unit`:struct<`unitIds`:array>,`rebateProcessed`:STRING,`movedIn`:STRING,`timestamp`:STRING,`callCenterNotes`:STRING,`sitePhone`:STRING,`duplicateOf`:STRING,`autoState`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`invoiceId`:STRING,`bookingAuth`:STRING,`searchWeightTestId`:STRING,`confirmationCode`:STRING,`pickupTime`:STRING,`actualD`:STRING,`customerNotes`:STRING,`callCenterTransfer`:STRING,`typeOfListing`:STRING,`bidType`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`moveInOriginal`:STRING,`listingWantId`:STRING,`npv`:STRING,`eVisitId`:STRING,`actualW`:STRING,`complete`:STRING,`moveOut`:STRING>,`env`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmwebreservation`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmwebreservation"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2017-11-02 14:15:40",
        "disabled": false,
        "format": "raw",
        "id": 143,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "reactfoot_gtmwebreservation"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_gtmwebreservation`\nADD\n\n\n PARTITION (dt='2025-04-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-15/'\n PARTITION (dt='2025-04-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-16/'\n PARTITION (dt='2025-04-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-17/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 1483164,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-15/",
                    "name": "dt",
                    "value": "2025-04-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-14 19:52:10",
                        "last_data": "2025-04-15 19:46:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1486173,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-16/",
                    "name": "dt",
                    "value": "2025-04-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-15 19:53:19",
                        "last_data": "2025-04-16 19:46:30"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1488296,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation/dt=2025-04-17/",
                    "name": "dt",
                    "value": "2025-04-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-16 19:53:28",
                        "last_data": "2025-04-17 17:00:55"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "anonymousId": "string",
            "channel": "string",
            "context.amp.id": "string",
            "context.campaign.content": "string",
            "context.campaign.id": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.campaign.term": "string",
            "context.ip": "string",
            "context.library.name": "string",
            "context.library.version": "string",
            "context.locale": "string",
            "context.page.path": "string",
            "context.page.referrer": "string",
            "context.page.search": "string",
            "context.page.title": "string",
            "context.page.url": "string",
            "context.timezone": "string",
            "context.userAgent": "string",
            "context.userAgentData.brands": [
                {
                    "brand": "string",
                    "version": "string"
                }
            ],
            "context.userAgentData.mobile": "string",
            "context.userAgentData.platform": "string",
            "event": "string",
            "integrations.library.name": "string",
            "integrations.library.version": "string",
            "integrations.page.path": "string",
            "integrations.page.referrer": "string",
            "integrations.page.search": "string",
            "integrations.page.title": "string",
            "integrations.page.url": "string",
            "messageId": "string",
            "originalTimestamp": "string",
            "projectId": "string",
            "properties.Hit_Timestamp": "string",
            "properties.booking.confirmationCode": "string",
            "properties.booking.email": "string",
            "properties.booking.emailHash": "string",
            "properties.booking.npv": "string",
            "properties.env": "string",
            "properties.isReact": "string",
            "properties.site_id": "string",
            "properties.transaction.AAAMemberNumber": "string",
            "properties.transaction.account.accountId": "string",
            "properties.transaction.account.hasOnlineMoveIns": "string",
            "properties.transaction.actualD": "string",
            "properties.transaction.actualW": "string",
            "properties.transaction.affiliateId": "string",
            "properties.transaction.alternateEmails": [
                "string"
            ],
            "properties.transaction.alternateFirstNames": [
                "string"
            ],
            "properties.transaction.alternateLastNames": [
                "string"
            ],
            "properties.transaction.alternatePhones": [
                "string"
            ],
            "properties.transaction.apiCustId": "string",
            "properties.transaction.apiLeadId": "string",
            "properties.transaction.apiUnitId": "string",
            "properties.transaction.autoState": "string",
            "properties.transaction.baseBid": "string",
            "properties.transaction.bidAmount": "string",
            "properties.transaction.bidType": "string",
            "properties.transaction.bookedUnit.amenities": [
                "string"
            ],
            "properties.transaction.bookedUnit.description.physical.height": "string",
            "properties.transaction.bookedUnit.description.physical.length": "string",
            "properties.transaction.bookedUnit.description.physical.width": "string",
            "properties.transaction.bookedUnit.description.vehicle.only": "string",
            "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
            "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
            "properties.transaction.bookedUnit.id": "string",
            "properties.transaction.bookedUnit.price.meta": "string",
            "properties.transaction.bookedUnit.promotion": "string",
            "properties.transaction.bookedUnit.reservation_days": "string",
            "properties.transaction.bookedUnit.unitType": "string",
            "properties.transaction.bookingAgent": "string",
            "properties.transaction.bookingAgentId": "string",
            "properties.transaction.bookingAuth": "string",
            "properties.transaction.bookingState": "string",
            "properties.transaction.bookingType": "string",
            "properties.transaction.bookingWidget": "string",
            "properties.transaction.callCenter": "string",
            "properties.transaction.callCenterNotes": "string",
            "properties.transaction.callCenterTransfer": "string",
            "properties.transaction.callerIdPhone": "string",
            "properties.transaction.canceled": "string",
            "properties.transaction.centershiftAccountId": "string",
            "properties.transaction.commission": "string",
            "properties.transaction.companyCode": "string",
            "properties.transaction.complete": "string",
            "properties.transaction.confirmationCode": "string",
            "properties.transaction.contacted": "string",
            "properties.transaction.corrected": "string",
            "properties.transaction.customerNotes": "string",
            "properties.transaction.depositPaid": "string",
            "properties.transaction.disputeReason": "string",
            "properties.transaction.duplicateOf": "string",
            "properties.transaction.eSignType": "string",
            "properties.transaction.eVisitId": "string",
            "properties.transaction.email": "string",
            "properties.transaction.emailHash": "string",
            "properties.transaction.estimatedRevenue": "string",
            "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
            "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
            "properties.transaction.experiments.hack_01_facility_page": "string",
            "properties.transaction.experiments.red_716_tracking_prerender": "string",
            "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
            "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
            "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
            "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
            "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
            "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
            "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
            "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
            "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
            "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
            "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
            "properties.transaction.experiments.sf_11616_homepage_updates": "string",
            "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
            "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
            "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
            "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
            "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
            "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
            "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
            "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
            "properties.transaction.experiments.sf_13810_new_map_strategy": "string",
            "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
            "properties.transaction.experiments.sf_4161_post_res_paid": "string",
            "properties.transaction.experiments.sf_4606_post_res_sms": "string",
            "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
            "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
            "properties.transaction.experiments.sf_5129_call_me_back": "string",
            "properties.transaction.experiments.sf_5288_informed_search_2": "string",
            "properties.transaction.experiments.sf_5289_facility_page_two": "string",
            "properties.transaction.experiments.sf_5430_incentive_header": "string",
            "properties.transaction.experiments.sf_5635_half_nomad": "string",
            "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
            "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
            "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
            "properties.transaction.experiments.sf_6138_mid_field_text": "string",
            "properties.transaction.experiments.sf_6327_visa_incentive": "string",
            "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
            "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
            "properties.transaction.experiments.sf_6852_serp_results": "string",
            "properties.transaction.experiments.sf_7018_upsellit": "string",
            "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
            "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
            "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
            "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
            "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
            "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
            "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
            "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
            "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
            "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
            "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
            "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
            "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
            "properties.transaction.experiments.sf_8535_sfdc_unit_comparsion_v1": "string",
            "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
            "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
            "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
            "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
            "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
            "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
            "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
            "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
            "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
            "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
            "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
            "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
            "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
            "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
            "properties.transaction.experiments.sf_omi_mfe_embed": "string",
            "properties.transaction.facilityGetsNotificationEmails": "string",
            "properties.transaction.facilityId": "string",
            "properties.transaction.facilityName": "string",
            "properties.transaction.facilityPhone": "string",
            "properties.transaction.facilityTenant": "string",
            "properties.transaction.facilityTenantId": "string",
            "properties.transaction.facility__cpLocation.address1": "string",
            "properties.transaction.facility__cpLocation.address2": "string",
            "properties.transaction.facility__cpLocation.city": "string",
            "properties.transaction.facility__cpLocation.country": "string",
            "properties.transaction.facility__cpLocation.state": "string",
            "properties.transaction.facility__cpLocation.zip": "string",
            "properties.transaction.facilitylocation.address1": "string",
            "properties.transaction.facilitylocation.address2": "string",
            "properties.transaction.facilitylocation.city": "string",
            "properties.transaction.facilitylocation.country": "string",
            "properties.transaction.facilitylocation.state": "string",
            "properties.transaction.facilitylocation.zip": "string",
            "properties.transaction.firstName": "string",
            "properties.transaction.free": "string",
            "properties.transaction.hasContactlessMoveins": "string",
            "properties.transaction.hasOnlineMoveIns": "string",
            "properties.transaction.hostedWebsite": "string",
            "properties.transaction.hotLead": "string",
            "properties.transaction.invoiceId": "string",
            "properties.transaction.lastName": "string",
            "properties.transaction.listingWantId": "string",
            "properties.transaction.matchReasons": "string",
            "properties.transaction.matchScore": "string",
            "properties.transaction.message": "string",
            "properties.transaction.modifiedDtm": "string",
            "properties.transaction.monthlyInsurance": "string",
            "properties.transaction.moveIn": "string",
            "properties.transaction.moveInActual": "string",
            "properties.transaction.moveInOriginal": "string",
            "properties.transaction.moveOut": "string",
            "properties.transaction.movedIn": "string",
            "properties.transaction.npv": "string",
            "properties.transaction.omiAttributes.facility": "string",
            "properties.transaction.omiAttributes.organization": "string",
            "properties.transaction.omiAttributes.provider": "string",
            "properties.transaction.omiAttributes.reservation": "string",
            "properties.transaction.omiAttributes.unit": "string",
            "properties.transaction.omiCompleted": "string",
            "properties.transaction.omiFlowEnabled": "string",
            "properties.transaction.omiPri": "string",
            "properties.transaction.onlineMoveInUrl": "string",
            "properties.transaction.payoutBatchId": "string",
            "properties.transaction.phone": "string",
            "properties.transaction.phoneChangedNumber": "string",
            "properties.transaction.phoneFacilityTransfer": "string",
            "properties.transaction.phoneStatus": "string",
            "properties.transaction.phoneVerified": "string",
            "properties.transaction.pickupTime": "string",
            "properties.transaction.price": "string",
            "properties.transaction.promo": "string",
            "properties.transaction.promoCode": "string",
            "properties.transaction.read": "string",
            "properties.transaction.rebateProcessed": "string",
            "properties.transaction.referrerId": "string",
            "properties.transaction.resaleRate": "string",
            "properties.transaction.reviewStatus": "string",
            "properties.transaction.searchWeightId": "string",
            "properties.transaction.searchWeightTestId": "string",
            "properties.transaction.sessionId": "string",
            "properties.transaction.siteId": "string",
            "properties.transaction.sitePhone": "string",
            "properties.transaction.sizeD": "string",
            "properties.transaction.sizeH": "string",
            "properties.transaction.sizeW": "string",
            "properties.transaction.statementId": "string",
            "properties.transaction.termsVersion": "string",
            "properties.transaction.timestamp": "string",
            "properties.transaction.totalPaid": "string",
            "properties.transaction.trafficSourceId": "string",
            "properties.transaction.typeOfListing": "string",
            "properties.transaction.unit.unitIds": [
                "string"
            ],
            "properties.transaction.unitId": "string",
            "properties.transaction.unitNumber": "string",
            "properties.transaction.userId": "string",
            "properties.transaction.visitId": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2025-03-04 13:35:30",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`messageId`STRING,`type`STRING,`sentAt`STRING,`originalTimestamp`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`campaign`:struct<`source`:STRING,`id`:STRING,`term`:STRING,`name`:STRING,`content`:STRING,`medium`:STRING>,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`timezone`:STRING,`page`:struct<`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`userAgent`:STRING>,`version`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`booking`:struct<`emailHash`:STRING,`confirmationCode`:STRING,`email`:STRING,`npv`:STRING>,`transaction`:struct<`free`:STRING,`facilitylocation`:struct<`city`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING,`address1`:STRING,`zip`:STRING>,`bookedUnit`:struct<`reservation_days`:STRING,`promotion`:STRING,`unitType`:STRING,`description`:struct<`vehicle`:struct<`permitted`:STRING,`only`:STRING,`warehouse`:STRING>,`physical`:struct<`height`:STRING,`length`:STRING,`width`:STRING>>,`amenities`:array,`id`:STRING,`price`:struct<`meta`:STRING>>,`affiliateId`:STRING,`corrected`:STRING,`facilityName`:STRING,`AAAMemberNumber`:STRING,`phoneFacilityTransfer`:STRING,`alternateLastNames`:array,`bookingWidget`:STRING,`promoCode`:STRING,`depositPaid`:STRING,`phoneChangedNumber`:STRING,`promo`:STRING,`modifiedDtm`:STRING,`sizeW`:STRING,`apiUnitId`:STRING,`canceled`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`trafficSourceId`:STRING,`alternateEmails`:array,`visitId`:STRING,`callerIdPhone`:STRING,`bookingType`:STRING,`bookingState`:STRING,`facilityId`:STRING,`moveIn`:STRING,`unitId`:STRING,`phoneVerified`:STRING,`eSignType`:STRING,`baseBid`:STRING,`centershiftAccountId`:STRING,`totalPaid`:STRING,`omiCompleted`:STRING,`resaleRate`:STRING,`matchScore`:STRING,`facilityGetsNotificationEmails`:STRING,`sessionId`:STRING,`sizeH`:STRING,`firstName`:STRING,`omiPri`:STRING,`facilityTenantId`:STRING,`phone`:STRING,`callCenter`:STRING,`reviewStatus`:STRING,`alternateFirstNames`:array,`phoneStatus`:STRING,`apiCustId`:STRING,`payoutBatchId`:STRING,`bidAmount`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`siteId`:STRING,`hotLead`:STRING,`facilityPhone`:STRING,`hostedWebsite`:STRING,`bookingAgent`:STRING,`facilityTenant`:STRING,`hasContactlessMoveins`:STRING,`onlineMoveInUrl`:STRING,`termsVersion`:STRING,`contacted`:STRING,`bookingAgentId`:STRING,`emailHash`:STRING,`commission`:STRING,`read`:STRING,`companyCode`:STRING,`unitNumber`:STRING,`alternatePhones`:array,`email`:STRING,`lastName`:STRING,`statementId`:STRING,`sizeD`:STRING,`message`:STRING,`experiments`:struct<`sf_4161_post_res_paid`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_omi_mfe_embed`:STRING,`sf_5289_facility_page_two`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_11616_homepage_updates`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_7018_upsellit`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_5430_incentive_header`:STRING,`sf_6852_serp_results`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_6138_mid_field_text`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`hack_01_facility_page`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_13380_sfdc_new_filter`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_6327_visa_incentive`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_5129_call_me_back`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_4606_post_res_sms`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_7249_guided_unit_selection`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_13810_new_map_strategy`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_5288_informed_search_2`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_5635_half_nomad`:STRING,`sf_8535_sfdc_unit_comparsion_v1`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`red_716_tracking_prerender`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_9463_sfdc_tpp_badging`:STRING>,`price`:STRING,`searchWeightId`:STRING,`hasOnlineMoveIns`:STRING,`referrerId`:STRING,`estimatedRevenue`:STRING,`apiLeadId`:STRING,`omiFlowEnabled`:STRING,`userId`:STRING,`moveInActual`:STRING,`monthlyInsurance`:STRING,`unit`:struct<`unitIds`:array>,`rebateProcessed`:STRING,`movedIn`:STRING,`timestamp`:STRING,`callCenterNotes`:STRING,`sitePhone`:STRING,`duplicateOf`:STRING,`autoState`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`invoiceId`:STRING,`bookingAuth`:STRING,`searchWeightTestId`:STRING,`confirmationCode`:STRING,`pickupTime`:STRING,`actualD`:STRING,`customerNotes`:STRING,`callCenterTransfer`:STRING,`typeOfListing`:STRING,`bidType`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`moveInOriginal`:STRING,`listingWantId`:STRING,`npv`:STRING,`eVisitId`:STRING,`actualW`:STRING,`complete`:STRING,`moveOut`:STRING>,`env`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/gtmWebReservation'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmwebreservation`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmwebreservation"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}