Schema Info
Schema Name: sfdl_dev_segment.reactfoot_productlistviewed
- created: 2021-02-12 11:16:22
- disabled: False
- format: raw
- id: 1544
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_segment", "table": "reactfoot_productlistviewed" } - type: segment
Schema Versions: 15
-
Version 4704815
- created: 2024-03-29 10:24:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704815
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-29T15:24:13Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711670400000/1711725654840.events-archiver-480-0..60525b91-25ba-4bcb-aae6-fd4732c72344.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "6ec4a296-9d50-4301-8a6b-fb06ca86c4f4", "channel": "client", "context": { "campaign": {}, "ip": "189.176.32.98", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Albuquerque-NM-self-storage.html", "referrer": "", "search": "?location=Albuquerque%2C%20NM%2C%20USA", "title": "15 Cheap Storage Units in Albuquerque, NM (From $19) - SpareFoot", "url": "http://localhost:9000/Albuquerque-NM-self-storage.html?location=Albuquerque%2C%20NM%2C%20USA" }, "timezone": "America/Cancun", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:124.0) Gecko/20100101 Firefox/124.0" }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-7be6ae176d60cd6d0025bf12f76b068a", "originalTimestamp": "2024-03-29T14:22:43.882Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711722162538, "category": "Albuquerque, NM-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Albuquerque, NM, USA", "page": 1, "productIds": [ 230835, 232491, 230897, 230835, 229763, 211581, 63236, 63234, 232588, 232392, 234471, 232504, 156731, 209292, 211585, 211720 ], "products": [ { "distance": 3.6, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 211720, "inNetwork": true, "isTopYielder": false, "name": "CubeSmart Self Storage - Albuquerque -4800 Jefferson St. NE", "position": 16, "rank": 16, "reviewAverage": 4.808, "reviewCount": 13, "unitCount": 2, "units": [ { "id": 26561646, "maxBookingDate": "2024-04-13T06:18:02.000Z", "priceValue": 35, "promotion": "50% Off", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 26765629, "maxBookingDate": "2024-04-13T06:18:02.000Z", "priceValue": 54.6, "promotion": "35% Off", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Albuquerque, NM, USA", "search_id": "6c976606ceb0cd9103.55812269", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-29T14:22:44.477Z", "sentAt": "2024-03-29T14:22:43.889Z", "timestamp": "2024-03-29T14:22:44.470Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ { "distance": "string", "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "id": "string", "inNetwork": "string", "isTopYielder": "string", "name": "string", "position": "string", "rank": "string", "reviewAverage": "string", "reviewCount": "string", "unitCount": "string", "units": [ "string" ] } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6458370
- updated: 2024-03-29 10:25:15
-
Version 4704803
- created: 2024-03-28 15:15:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`env`:STRING,`search_id`:STRING,`isReact`:STRING,`productIds`:array ,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`value`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704803
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T20:15:30Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711656744011.events-archiver-480-3..167760de-e3f3-4747-8938-89b43813a4dc.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-a0eeafccba0682b9c737f2cf9e0d45a1", "originalTimestamp": "2024-03-28T20:08:11.939Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711656490602, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ 215880, 227068, 218706, 215880, 215945, 215141, 234823, 219764, 232372, 232624, 230361, 202484, 231021, 227064, 210620, 215179 ], "products": [ { "distance": 2.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215880, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 1, "rank": 1, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227068, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Van Buren", "position": 2, "rank": 2, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28363143, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 38, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28363441, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 49, "promotion": "50% Off First Month!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28363188, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 85, "promotion": "50% Off First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 218706, "inNetwork": true, "isTopYielder": false, "name": "Prime Storage - Phoenix E. Indian School Road", "position": 3, "rank": 3, "reviewAverage": 4, "reviewCount": 52, "unitCount": 3, "units": [ { "id": 28746795, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 53, "promotion": "First Month FREE", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28748063, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 80, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28746617, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 141, "promotion": "First Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.9, "id": 215880, "inNetwork": true, "isTopYielder": true, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 4, "rank": 4, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215945, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1949 E Camelback Rd #21", "position": 5, "rank": 5, "reviewAverage": 5, "reviewCount": 20, "unitCount": 3, "units": [ { "id": 22599181, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 37, "promotion": "50% off 1st Month", "sizeText": "7' x 3'", "squareFootage": 21, "unitTypeText": "unit" }, { "id": 22599167, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 76, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22599170, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 143, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215141, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1808 W Camelback Rd", "position": 6, "rank": 6, "reviewAverage": 4.5, "reviewCount": 72, "unitCount": 3, "units": [ { "id": 22521770, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 33, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22884666, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 45, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22521783, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 123, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.2, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 234823, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 6344 - Phoenix - N 16th St", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 31349379, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 29, "promotion": "First Month Free", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 31349371, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 50, "promotion": "First Month Free", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 31349337, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 86, "promotion": "First Month Free", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 0.7, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 219764, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 841 E Jefferson St", "position": 8, "rank": 8, "reviewAverage": 5, "reviewCount": 7, "unitCount": 3, "units": [ { "id": 25066240, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 49, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25066215, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 64, "promotion": "50% off 1st Month", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25066210, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 73, "promotion": "$1 first month rent", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.2, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232372, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 0257 - Phoenix - N 7th Street", "position": 9, "rank": 9, "reviewAverage": 5, "reviewCount": 1, "unitCount": 3, "units": [ { "id": 30964352, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 34, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 30964355, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 67, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30964381, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 94, "promotion": "", "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit" } ] }, { "distance": 3.8, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232624, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 7246 - Phoenix - 27th Ave", "position": 10, "rank": 10, "reviewAverage": 5, "reviewCount": 2, "unitCount": 1, "units": [ { "id": 30981445, "maxBookingDate": "2024-03-30T02:23:00.000Z", "priceValue": 112, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 5.5, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 230361, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - 3406 - Phoenix - 48th St", "position": 11, "rank": 11, "reviewAverage": 4.5, "reviewCount": 14, "unitCount": 2, "units": [ { "id": 30375598, "maxBookingDate": "2024-04-10T02:27:53.000Z", "priceValue": 57, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30375591, "maxBookingDate": "2024-04-03T02:27:53.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 202484, "inNetwork": true, "isTopYielder": false, "name": "US Storage Centers - Phoenix - 2563 West Indian School Road", "position": 12, "rank": 12, "reviewAverage": 4.5, "reviewCount": 19, "unitCount": 3, "units": [ { "id": 18625367, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 28.5, "promotion": "1 Month 25% Off", "sizeText": "4' x 6'", "squareFootage": 24, "unitTypeText": "unit" }, { "id": 18625466, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 103.5, "promotion": "1 Month 25% Off", "sizeText": "7' x 7'", "squareFootage": 49, "unitTypeText": "unit" }, { "id": 18625496, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 105.5, "promotion": "1 Month 25% Off", "sizeText": "8' x 10'", "squareFootage": 80, "unitTypeText": "unit" } ] }, { "distance": 4.1, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 231021, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 1666 - Phoenix - Washington", "position": 13, "rank": 13, "reviewAverage": 0, "reviewCount": 0, "unitCount": 2, "units": [ { "id": 30948691, "maxBookingDate": "2024-04-10T10:00:41.000Z", "priceValue": 47, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30948695, "maxBookingDate": "2024-03-31T10:00:41.000Z", "priceValue": 93, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.8, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227064, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Portland", "position": 14, "rank": 14, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28122356, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 55, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28122603, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 68, "promotion": "$1 First Month!", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28122457, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 98, "promotion": "$1 First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 210620, "inNetwork": true, "isTopYielder": false, "name": "Storage Sense - Washington St.", "position": 15, "rank": 15, "reviewAverage": 4.5, "reviewCount": 59, "unitCount": 3, "units": [ { "id": 22944013, "maxBookingDate": "2024-04-10T01:58:47.000Z", "priceValue": 39, "promotion": "2nd Month Free!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22933729, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 59, "promotion": "2nd Month Free!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22931029, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 99, "promotion": "2nd Month Free!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 6, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215179, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 4725 N 43rd Ave", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 93, "unitCount": 3, "units": [ { "id": 22520966, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 22, "promotion": "$1 first month rent", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22520970, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 48, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22520962, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 94, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-28T20:08:12.448Z", "sentAt": "2024-03-28T20:08:11.945Z", "timestamp": "2024-03-28T20:08:12.442Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457964
- updated: 2024-03-28 15:16:20
-
Version 4704800
- created: 2024-03-28 14:53:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704800
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:53:35Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711655468095.events-archiver-480-9..e6ac9049-b947-4779-9843-02e6c40f10f2.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-2dc9fb9cf2d33b41d3ba45584a58ce8d", "originalTimestamp": "2024-03-28T18:52:03.418Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711651922487, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "products": [ { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 1, "rank": 1 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 2, "rank": 2 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 3, "rank": 3 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 4, "rank": 4 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 5, "rank": 5 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 6, "rank": 6 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 7, "rank": 7 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 8, "rank": 8 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 9, "rank": 9 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 10, "rank": 10 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 11, "rank": 11 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 12, "rank": 12 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 13, "rank": 13 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 14, "rank": 14 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 15, "rank": 15 } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 15 }, "receivedAt": "2024-03-28T18:52:03.929Z", "sentAt": "2024-03-28T18:52:03.423Z", "timestamp": "2024-03-28T18:52:03.924Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "string" ], "properties.products": [ { "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "inNetwork": "string", "isTopYielder": "string", "position": "string", "rank": "string" } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457950
- updated: 2024-03-28 14:54:15
-
Version 4704799
- created: 2024-03-28 14:37:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`env`:STRING,`isReact`:STRING,`search_id`:STRING,`productIds`:array ,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`value`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704799
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:37:43Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711654651672.events-archiver-480-45..8dab1e34-626a-482b-89f6-56a7ef348fdf.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-df70f1b0eb6e1c022dd14cb6e0a3d2c6", "originalTimestamp": "2024-03-28T19:03:01.864Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711652580813, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ 215880, 227068, 218706, 215880, 215945, 215141, 234823, 219764, 232372, 232624, 230361, 202484, 231021, 227064, 210620, 215179 ], "products": [ { "distance": 2.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215880, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 1, "rank": 1, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227068, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Van Buren", "position": 2, "rank": 2, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28363143, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 38, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28363441, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 49, "promotion": "50% Off First Month!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28363188, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 85, "promotion": "50% Off First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 218706, "inNetwork": true, "isTopYielder": false, "name": "Prime Storage - Phoenix E. Indian School Road", "position": 3, "rank": 3, "reviewAverage": 4, "reviewCount": 52, "unitCount": 3, "units": [ { "id": 28746795, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 53, "promotion": "First Month FREE", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28748063, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 80, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28746617, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 141, "promotion": "First Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.9, "id": 215880, "inNetwork": true, "isTopYielder": true, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 4, "rank": 4, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215945, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1949 E Camelback Rd #21", "position": 5, "rank": 5, "reviewAverage": 5, "reviewCount": 20, "unitCount": 3, "units": [ { "id": 22599181, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 37, "promotion": "50% off 1st Month", "sizeText": "7' x 3'", "squareFootage": 21, "unitTypeText": "unit" }, { "id": 22599167, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 76, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22599170, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 143, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215141, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1808 W Camelback Rd", "position": 6, "rank": 6, "reviewAverage": 4.5, "reviewCount": 72, "unitCount": 3, "units": [ { "id": 22521770, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 33, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22884666, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 45, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22521783, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 123, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.2, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 234823, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 6344 - Phoenix - N 16th St", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 31349379, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 29, "promotion": "First Month Free", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 31349371, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 50, "promotion": "First Month Free", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 31349337, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 86, "promotion": "First Month Free", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 0.7, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 219764, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 841 E Jefferson St", "position": 8, "rank": 8, "reviewAverage": 5, "reviewCount": 7, "unitCount": 3, "units": [ { "id": 25066240, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 49, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25066215, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 64, "promotion": "50% off 1st Month", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25066210, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 73, "promotion": "$1 first month rent", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.2, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232372, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 0257 - Phoenix - N 7th Street", "position": 9, "rank": 9, "reviewAverage": 5, "reviewCount": 1, "unitCount": 3, "units": [ { "id": 30964352, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 34, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 30964355, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 67, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30964381, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 94, "promotion": "", "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit" } ] }, { "distance": 3.8, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232624, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 7246 - Phoenix - 27th Ave", "position": 10, "rank": 10, "reviewAverage": 5, "reviewCount": 2, "unitCount": 1, "units": [ { "id": 30981445, "maxBookingDate": "2024-03-30T02:23:00.000Z", "priceValue": 112, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 5.5, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 230361, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - 3406 - Phoenix - 48th St", "position": 11, "rank": 11, "reviewAverage": 4.5, "reviewCount": 14, "unitCount": 2, "units": [ { "id": 30375598, "maxBookingDate": "2024-04-10T02:27:53.000Z", "priceValue": 57, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30375591, "maxBookingDate": "2024-04-03T02:27:53.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 202484, "inNetwork": true, "isTopYielder": false, "name": "US Storage Centers - Phoenix - 2563 West Indian School Road", "position": 12, "rank": 12, "reviewAverage": 4.5, "reviewCount": 19, "unitCount": 3, "units": [ { "id": 18625367, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 28.5, "promotion": "1 Month 25% Off", "sizeText": "4' x 6'", "squareFootage": 24, "unitTypeText": "unit" }, { "id": 18625466, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 103.5, "promotion": "1 Month 25% Off", "sizeText": "7' x 7'", "squareFootage": 49, "unitTypeText": "unit" }, { "id": 18625496, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 105.5, "promotion": "1 Month 25% Off", "sizeText": "8' x 10'", "squareFootage": 80, "unitTypeText": "unit" } ] }, { "distance": 4.1, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 231021, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 1666 - Phoenix - Washington", "position": 13, "rank": 13, "reviewAverage": 0, "reviewCount": 0, "unitCount": 2, "units": [ { "id": 30948691, "maxBookingDate": "2024-04-10T10:00:41.000Z", "priceValue": 47, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30948695, "maxBookingDate": "2024-03-31T10:00:41.000Z", "priceValue": 93, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.8, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227064, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Portland", "position": 14, "rank": 14, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28122356, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 55, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28122603, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 68, "promotion": "$1 First Month!", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28122457, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 98, "promotion": "$1 First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 210620, "inNetwork": true, "isTopYielder": false, "name": "Storage Sense - Washington St.", "position": 15, "rank": 15, "reviewAverage": 4.5, "reviewCount": 59, "unitCount": 3, "units": [ { "id": 22944013, "maxBookingDate": "2024-04-10T01:58:47.000Z", "priceValue": 39, "promotion": "2nd Month Free!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22933729, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 59, "promotion": "2nd Month Free!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22931029, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 99, "promotion": "2nd Month Free!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 6, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215179, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 4725 N 43rd Ave", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 93, "unitCount": 3, "units": [ { "id": 22520966, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 22, "promotion": "$1 first month rent", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22520970, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 48, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22520962, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 94, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-28T19:03:02.480Z", "sentAt": "2024-03-28T19:03:01.869Z", "timestamp": "2024-03-28T19:03:02.475Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457930
- updated: 2024-03-28 14:38:39
-
Version 4704797
- created: 2024-03-28 14:28:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704797
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:28:53Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711654094688.events-archiver-480-32..c63842b7-3b46-4e34-ac7c-bf26bae7acbb.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-74161b46072389f4cb7659642bb8fc88", "originalTimestamp": "2024-03-28T18:39:36.910Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711651175918, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "products": [ { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 1, "rank": 1 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 2, "rank": 2 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 3, "rank": 3 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 4, "rank": 4 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 5, "rank": 5 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 6, "rank": 6 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 7, "rank": 7 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 8, "rank": 8 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 9, "rank": 9 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 10, "rank": 10 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 11, "rank": 11 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 12, "rank": 12 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 13, "rank": 13 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 14, "rank": 14 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 15, "rank": 15 } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 15 }, "receivedAt": "2024-03-28T18:39:37.484Z", "sentAt": "2024-03-28T18:39:36.916Z", "timestamp": "2024-03-28T18:39:37.478Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "string" ], "properties.products": [ { "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "inNetwork": "string", "isTopYielder": "string", "position": "string", "rank": "string" } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457914
- updated: 2024-03-28 14:29:37
-
Version 4704793
- created: 2024-03-28 14:22:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`value`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704793
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:21:31Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711653535861.events-archiver-480-50..20a92267-94c6-4651-b05f-a649fade7bc2.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-8bd016b8b84814c5676547a1adce1773", "originalTimestamp": "2024-03-28T18:42:26.856Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711651345681, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ 215880, 227068, 218706, 215880, 215945, 215141, 234823, 219764, 232372, 232624, 230361, 202484, 231021, 227064, 210620, 215179 ], "products": [ { "distance": 3.4, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 210620, "inNetwork": true, "isTopYielder": false, "name": "Storage Sense - Washington St.", "position": 15, "rank": 15, "reviewAverage": 4.5, "reviewCount": 59, "unitCount": 3, "units": [ { "id": 22931029, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 99, "promotion": "2nd Month Free!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-28T18:42:27.484Z", "sentAt": "2024-03-28T18:42:26.869Z", "timestamp": "2024-03-28T18:42:27.471Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ { "distance": "string", "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "id": "string", "inNetwork": "string", "isTopYielder": "string", "name": "string", "position": "string", "rank": "string", "reviewAverage": "string", "reviewCount": "string", "unitCount": "string", "units": [ { "id": "string", "maxBookingDate": "string", "priceValue": "string", "promotion": "string", "sizeText": "string", "squareFootage": "string", "unitTypeText": "string" } ] } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457898
- updated: 2024-03-28 14:27:25
-
Version 4704792
- created: 2024-03-28 14:15:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704792
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:15:49Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711653150246.events-archiver-480-3..801bef13-3a01-4297-a58c-64fc24616723.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-b985b7aa3cc9d7fc558d3bb9448c6c13", "originalTimestamp": "2024-03-28T18:41:37.490Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711651296630, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "products": [ { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 1, "rank": 1 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 2, "rank": 2 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 3, "rank": 3 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 4, "rank": 4 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 5, "rank": 5 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 6, "rank": 6 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 7, "rank": 7 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 8, "rank": 8 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 9, "rank": 9 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 10, "rank": 10 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 11, "rank": 11 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 12, "rank": 12 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 13, "rank": 13 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 14, "rank": 14 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 15, "rank": 15 } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 15 }, "receivedAt": "2024-03-28T18:41:38.004Z", "sentAt": "2024-03-28T18:41:37.495Z", "timestamp": "2024-03-28T18:41:37.999Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "string" ], "properties.products": [ { "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "inNetwork": "string", "isTopYielder": "string", "position": "string", "rank": "string" } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457879
- updated: 2024-03-28 14:24:12
-
Version 4704791
- created: 2024-03-28 14:15:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`env`:STRING,`isReact`:STRING,`search_id`:STRING,`productIds`:array ,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`value`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704791
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:14:57Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711653271251.events-archiver-480-35..34044c01-6a5b-4087-b60b-90ccac426425.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-58f3dccc4fc10d8124f54e670127bd92", "originalTimestamp": "2024-03-28T19:00:39.906Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711652438719, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ 215880, 227068, 218706, 215880, 215945, 215141, 234823, 219764, 232372, 232624, 230361, 202484, 231021, 227064, 210620, 215179 ], "products": [ { "distance": 2.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215880, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 1, "rank": 1, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227068, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Van Buren", "position": 2, "rank": 2, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28363143, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 38, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28363441, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 49, "promotion": "50% Off First Month!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28363188, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 85, "promotion": "50% Off First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 218706, "inNetwork": true, "isTopYielder": false, "name": "Prime Storage - Phoenix E. Indian School Road", "position": 3, "rank": 3, "reviewAverage": 4, "reviewCount": 52, "unitCount": 3, "units": [ { "id": 28746795, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 53, "promotion": "First Month FREE", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28748063, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 80, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28746617, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 141, "promotion": "First Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.9, "id": 215880, "inNetwork": true, "isTopYielder": true, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 4, "rank": 4, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215945, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1949 E Camelback Rd #21", "position": 5, "rank": 5, "reviewAverage": 5, "reviewCount": 20, "unitCount": 3, "units": [ { "id": 22599181, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 37, "promotion": "50% off 1st Month", "sizeText": "7' x 3'", "squareFootage": 21, "unitTypeText": "unit" }, { "id": 22599167, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 76, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22599170, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 143, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215141, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1808 W Camelback Rd", "position": 6, "rank": 6, "reviewAverage": 4.5, "reviewCount": 72, "unitCount": 3, "units": [ { "id": 22521770, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 33, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22884666, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 45, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22521783, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 123, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.2, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 234823, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 6344 - Phoenix - N 16th St", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 31349379, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 29, "promotion": "First Month Free", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 31349371, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 50, "promotion": "First Month Free", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 31349337, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 86, "promotion": "First Month Free", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 0.7, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 219764, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 841 E Jefferson St", "position": 8, "rank": 8, "reviewAverage": 5, "reviewCount": 7, "unitCount": 3, "units": [ { "id": 25066240, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 49, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25066215, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 64, "promotion": "50% off 1st Month", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25066210, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 73, "promotion": "$1 first month rent", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.2, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232372, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 0257 - Phoenix - N 7th Street", "position": 9, "rank": 9, "reviewAverage": 5, "reviewCount": 1, "unitCount": 3, "units": [ { "id": 30964352, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 34, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 30964355, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 67, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30964381, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 94, "promotion": "", "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit" } ] }, { "distance": 3.8, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232624, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 7246 - Phoenix - 27th Ave", "position": 10, "rank": 10, "reviewAverage": 5, "reviewCount": 2, "unitCount": 1, "units": [ { "id": 30981445, "maxBookingDate": "2024-03-30T02:23:00.000Z", "priceValue": 112, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 5.5, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 230361, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - 3406 - Phoenix - 48th St", "position": 11, "rank": 11, "reviewAverage": 4.5, "reviewCount": 14, "unitCount": 2, "units": [ { "id": 30375598, "maxBookingDate": "2024-04-10T02:27:53.000Z", "priceValue": 57, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30375591, "maxBookingDate": "2024-04-03T02:27:53.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 202484, "inNetwork": true, "isTopYielder": false, "name": "US Storage Centers - Phoenix - 2563 West Indian School Road", "position": 12, "rank": 12, "reviewAverage": 4.5, "reviewCount": 19, "unitCount": 3, "units": [ { "id": 18625367, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 28.5, "promotion": "1 Month 25% Off", "sizeText": "4' x 6'", "squareFootage": 24, "unitTypeText": "unit" }, { "id": 18625466, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 103.5, "promotion": "1 Month 25% Off", "sizeText": "7' x 7'", "squareFootage": 49, "unitTypeText": "unit" }, { "id": 18625496, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 105.5, "promotion": "1 Month 25% Off", "sizeText": "8' x 10'", "squareFootage": 80, "unitTypeText": "unit" } ] }, { "distance": 4.1, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 231021, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 1666 - Phoenix - Washington", "position": 13, "rank": 13, "reviewAverage": 0, "reviewCount": 0, "unitCount": 2, "units": [ { "id": 30948691, "maxBookingDate": "2024-04-10T10:00:41.000Z", "priceValue": 47, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30948695, "maxBookingDate": "2024-03-31T10:00:41.000Z", "priceValue": 93, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.8, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227064, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Portland", "position": 14, "rank": 14, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28122356, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 55, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28122603, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 68, "promotion": "$1 First Month!", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28122457, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 98, "promotion": "$1 First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 210620, "inNetwork": true, "isTopYielder": false, "name": "Storage Sense - Washington St.", "position": 15, "rank": 15, "reviewAverage": 4.5, "reviewCount": 59, "unitCount": 3, "units": [ { "id": 22944013, "maxBookingDate": "2024-04-10T01:58:47.000Z", "priceValue": 39, "promotion": "2nd Month Free!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22933729, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 59, "promotion": "2nd Month Free!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22931029, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 99, "promotion": "2nd Month Free!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 6, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215179, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 4725 N 43rd Ave", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 93, "unitCount": 3, "units": [ { "id": 22520966, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 22, "promotion": "$1 first month rent", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22520970, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 48, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22520962, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 94, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-28T19:00:40.671Z", "sentAt": "2024-03-28T19:00:39.913Z", "timestamp": "2024-03-28T19:00:40.664Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457875
- updated: 2024-03-28 14:16:18
-
Version 4704790
- created: 2024-03-28 14:07:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704790
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:06:59Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711652569627.events-archiver-480-6..69c273b9-f116-417f-a17a-fe8be5c35ec4.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-c9944fe603422465cb662f44c08a64b5", "originalTimestamp": "2024-03-28T18:45:45.777Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711651544794, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "products": [ { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 1, "rank": 1 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 2, "rank": 2 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 3, "rank": 3 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 4, "rank": 4 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 5, "rank": 5 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 6, "rank": 6 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 7, "rank": 7 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 8, "rank": 8 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 9, "rank": 9 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 10, "rank": 10 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 11, "rank": 11 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 12, "rank": 12 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 13, "rank": 13 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 14, "rank": 14 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 15, "rank": 15 } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 15 }, "receivedAt": "2024-03-28T18:45:46.293Z", "sentAt": "2024-03-28T18:45:45.784Z", "timestamp": "2024-03-28T18:45:46.286Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "string" ], "properties.products": [ { "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "inNetwork": "string", "isTopYielder": "string", "position": "string", "rank": "string" } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457836
- updated: 2024-03-28 14:13:03
-
Version 4704789
- created: 2024-03-28 14:06:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`env`:STRING,`search_id`:STRING,`isReact`:STRING,`productIds`:array ,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`value`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704789
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T19:06:03Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711652746896.events-archiver-480-22..28f5ebcb-dc3d-448f-a2a5-c7c5b041f215.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-72eaffa142dac45ef273786ef9664918", "originalTimestamp": "2024-03-28T18:59:36.231Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711652375020, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ 215880, 227068, 218706, 215880, 215945, 215141, 234823, 219764, 232372, 232624, 230361, 202484, 231021, 227064, 210620, 215179 ], "products": [ { "distance": 2.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215880, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 1, "rank": 1, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227068, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Van Buren", "position": 2, "rank": 2, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28363143, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 38, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28363441, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 49, "promotion": "50% Off First Month!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28363188, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 85, "promotion": "50% Off First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 218706, "inNetwork": true, "isTopYielder": false, "name": "Prime Storage - Phoenix E. Indian School Road", "position": 3, "rank": 3, "reviewAverage": 4, "reviewCount": 52, "unitCount": 3, "units": [ { "id": 28746795, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 53, "promotion": "First Month FREE", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28748063, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 80, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28746617, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 141, "promotion": "First Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.9, "id": 215880, "inNetwork": true, "isTopYielder": true, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 4, "rank": 4, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215945, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1949 E Camelback Rd #21", "position": 5, "rank": 5, "reviewAverage": 5, "reviewCount": 20, "unitCount": 3, "units": [ { "id": 22599181, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 37, "promotion": "50% off 1st Month", "sizeText": "7' x 3'", "squareFootage": 21, "unitTypeText": "unit" }, { "id": 22599167, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 76, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22599170, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 143, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215141, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1808 W Camelback Rd", "position": 6, "rank": 6, "reviewAverage": 4.5, "reviewCount": 72, "unitCount": 3, "units": [ { "id": 22521770, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 33, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22884666, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 45, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22521783, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 123, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.2, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 234823, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 6344 - Phoenix - N 16th St", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 31349379, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 29, "promotion": "First Month Free", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 31349371, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 50, "promotion": "First Month Free", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 31349337, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 86, "promotion": "First Month Free", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 0.7, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 219764, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 841 E Jefferson St", "position": 8, "rank": 8, "reviewAverage": 5, "reviewCount": 7, "unitCount": 3, "units": [ { "id": 25066240, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 49, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25066215, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 64, "promotion": "50% off 1st Month", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25066210, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 73, "promotion": "$1 first month rent", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.2, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232372, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 0257 - Phoenix - N 7th Street", "position": 9, "rank": 9, "reviewAverage": 5, "reviewCount": 1, "unitCount": 3, "units": [ { "id": 30964352, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 34, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 30964355, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 67, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30964381, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 94, "promotion": "", "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit" } ] }, { "distance": 3.8, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232624, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 7246 - Phoenix - 27th Ave", "position": 10, "rank": 10, "reviewAverage": 5, "reviewCount": 2, "unitCount": 1, "units": [ { "id": 30981445, "maxBookingDate": "2024-03-30T02:23:00.000Z", "priceValue": 112, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 5.5, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 230361, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - 3406 - Phoenix - 48th St", "position": 11, "rank": 11, "reviewAverage": 4.5, "reviewCount": 14, "unitCount": 2, "units": [ { "id": 30375598, "maxBookingDate": "2024-04-10T02:27:53.000Z", "priceValue": 57, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30375591, "maxBookingDate": "2024-04-03T02:27:53.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 202484, "inNetwork": true, "isTopYielder": false, "name": "US Storage Centers - Phoenix - 2563 West Indian School Road", "position": 12, "rank": 12, "reviewAverage": 4.5, "reviewCount": 19, "unitCount": 3, "units": [ { "id": 18625367, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 28.5, "promotion": "1 Month 25% Off", "sizeText": "4' x 6'", "squareFootage": 24, "unitTypeText": "unit" }, { "id": 18625466, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 103.5, "promotion": "1 Month 25% Off", "sizeText": "7' x 7'", "squareFootage": 49, "unitTypeText": "unit" }, { "id": 18625496, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 105.5, "promotion": "1 Month 25% Off", "sizeText": "8' x 10'", "squareFootage": 80, "unitTypeText": "unit" } ] }, { "distance": 4.1, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 231021, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 1666 - Phoenix - Washington", "position": 13, "rank": 13, "reviewAverage": 0, "reviewCount": 0, "unitCount": 2, "units": [ { "id": 30948691, "maxBookingDate": "2024-04-10T10:00:41.000Z", "priceValue": 47, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30948695, "maxBookingDate": "2024-03-31T10:00:41.000Z", "priceValue": 93, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.8, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227064, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Portland", "position": 14, "rank": 14, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28122356, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 55, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28122603, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 68, "promotion": "$1 First Month!", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28122457, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 98, "promotion": "$1 First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 210620, "inNetwork": true, "isTopYielder": false, "name": "Storage Sense - Washington St.", "position": 15, "rank": 15, "reviewAverage": 4.5, "reviewCount": 59, "unitCount": 3, "units": [ { "id": 22944013, "maxBookingDate": "2024-04-10T01:58:47.000Z", "priceValue": 39, "promotion": "2nd Month Free!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22933729, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 59, "promotion": "2nd Month Free!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22931029, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 99, "promotion": "2nd Month Free!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 6, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215179, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 4725 N 43rd Ave", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 93, "unitCount": 3, "units": [ { "id": 22520966, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 22, "promotion": "$1 first month rent", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22520970, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 48, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22520962, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 94, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-28T18:59:36.883Z", "sentAt": "2024-03-28T18:59:36.241Z", "timestamp": "2024-03-28T18:59:36.873Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457834
- updated: 2024-03-28 14:07:18
-
Version 4704788
- created: 2024-03-28 13:42:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704788
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T18:41:22Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711651213115.events-archiver-480-12..7f271020-5b76-41e2-881a-fa767043883b.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-f55283d155f53cc9d69d7a24a2c43ab3", "originalTimestamp": "2024-03-28T18:38:05.939Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711651085079, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "products": [ { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 1, "rank": 1 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 2, "rank": 2 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 3, "rank": 3 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 4, "rank": 4 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 5, "rank": 5 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 6, "rank": 6 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 7, "rank": 7 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 8, "rank": 8 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 9, "rank": 9 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 10, "rank": 10 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 11, "rank": 11 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 12, "rank": 12 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 13, "rank": 13 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 14, "rank": 14 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 15, "rank": 15 } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 15 }, "receivedAt": "2024-03-28T18:38:06.377Z", "sentAt": "2024-03-28T18:38:05.943Z", "timestamp": "2024-03-28T18:38:06.373Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "string" ], "properties.products": [ { "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "inNetwork": "string", "isTopYielder": "string", "position": "string", "rank": "string" } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457677
- updated: 2024-03-28 13:42:52
-
Version 4704784
- created: 2024-03-28 12:11:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`env`:STRING,`isReact`:STRING,`search_id`:STRING,`productIds`:array ,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`value`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704784
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T17:11:43Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711645785330.events-archiver-480-4..705cc364-0a2e-4b04-860e-82902d102479.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-1f82eec4aa5cec1f040e020dab3fcc60", "originalTimestamp": "2024-03-28T16:16:45.560Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711642604461, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ 215880, 227068, 218706, 215880, 215945, 215141, 234823, 219764, 232372, 232624, 230361, 202484, 231021, 227064, 210620, 215179 ], "products": [ { "distance": 2.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215880, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 1, "rank": 1, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227068, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Van Buren", "position": 2, "rank": 2, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28363143, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 38, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28363441, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 49, "promotion": "50% Off First Month!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28363188, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 85, "promotion": "50% Off First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 218706, "inNetwork": true, "isTopYielder": false, "name": "Prime Storage - Phoenix E. Indian School Road", "position": 3, "rank": 3, "reviewAverage": 4, "reviewCount": 52, "unitCount": 3, "units": [ { "id": 28746795, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 53, "promotion": "First Month FREE", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28748063, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 80, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28746617, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 141, "promotion": "First Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.9, "id": 215880, "inNetwork": true, "isTopYielder": true, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 4, "rank": 4, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215945, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1949 E Camelback Rd #21", "position": 5, "rank": 5, "reviewAverage": 5, "reviewCount": 20, "unitCount": 3, "units": [ { "id": 22599181, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 37, "promotion": "50% off 1st Month", "sizeText": "7' x 3'", "squareFootage": 21, "unitTypeText": "unit" }, { "id": 22599167, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 76, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22599170, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 143, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215141, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1808 W Camelback Rd", "position": 6, "rank": 6, "reviewAverage": 4.5, "reviewCount": 72, "unitCount": 3, "units": [ { "id": 22521770, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 33, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22884666, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 45, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22521783, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 123, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.2, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 234823, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 6344 - Phoenix - N 16th St", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 31349379, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 29, "promotion": "First Month Free", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 31349371, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 50, "promotion": "First Month Free", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 31349337, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 86, "promotion": "First Month Free", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 0.7, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 219764, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 841 E Jefferson St", "position": 8, "rank": 8, "reviewAverage": 5, "reviewCount": 7, "unitCount": 3, "units": [ { "id": 25066240, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 49, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25066215, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 64, "promotion": "50% off 1st Month", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25066210, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 73, "promotion": "$1 first month rent", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.2, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232372, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 0257 - Phoenix - N 7th Street", "position": 9, "rank": 9, "reviewAverage": 5, "reviewCount": 1, "unitCount": 3, "units": [ { "id": 30964352, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 34, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 30964355, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 67, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30964381, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 94, "promotion": "", "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit" } ] }, { "distance": 3.8, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232624, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 7246 - Phoenix - 27th Ave", "position": 10, "rank": 10, "reviewAverage": 5, "reviewCount": 2, "unitCount": 1, "units": [ { "id": 30981445, "maxBookingDate": "2024-03-30T02:23:00.000Z", "priceValue": 112, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 5.5, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 230361, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - 3406 - Phoenix - 48th St", "position": 11, "rank": 11, "reviewAverage": 4.5, "reviewCount": 14, "unitCount": 2, "units": [ { "id": 30375598, "maxBookingDate": "2024-04-10T02:27:53.000Z", "priceValue": 57, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30375591, "maxBookingDate": "2024-04-03T02:27:53.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 202484, "inNetwork": true, "isTopYielder": false, "name": "US Storage Centers - Phoenix - 2563 West Indian School Road", "position": 12, "rank": 12, "reviewAverage": 4.5, "reviewCount": 19, "unitCount": 3, "units": [ { "id": 18625367, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 28.5, "promotion": "1 Month 25% Off", "sizeText": "4' x 6'", "squareFootage": 24, "unitTypeText": "unit" }, { "id": 18625466, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 103.5, "promotion": "1 Month 25% Off", "sizeText": "7' x 7'", "squareFootage": 49, "unitTypeText": "unit" }, { "id": 18625496, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 105.5, "promotion": "1 Month 25% Off", "sizeText": "8' x 10'", "squareFootage": 80, "unitTypeText": "unit" } ] }, { "distance": 4.1, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 231021, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 1666 - Phoenix - Washington", "position": 13, "rank": 13, "reviewAverage": 0, "reviewCount": 0, "unitCount": 2, "units": [ { "id": 30948691, "maxBookingDate": "2024-04-10T10:00:41.000Z", "priceValue": 47, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30948695, "maxBookingDate": "2024-03-31T10:00:41.000Z", "priceValue": 93, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.8, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227064, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Portland", "position": 14, "rank": 14, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28122356, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 55, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28122603, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 68, "promotion": "$1 First Month!", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28122457, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 98, "promotion": "$1 First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 210620, "inNetwork": true, "isTopYielder": false, "name": "Storage Sense - Washington St.", "position": 15, "rank": 15, "reviewAverage": 4.5, "reviewCount": 59, "unitCount": 3, "units": [ { "id": 22944013, "maxBookingDate": "2024-04-10T01:58:47.000Z", "priceValue": 39, "promotion": "2nd Month Free!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22933729, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 59, "promotion": "2nd Month Free!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22931029, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 99, "promotion": "2nd Month Free!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 6, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215179, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 4725 N 43rd Ave", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 93, "unitCount": 3, "units": [ { "id": 22520966, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 22, "promotion": "$1 first month rent", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22520970, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 48, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22520962, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 94, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-28T16:16:46.372Z", "sentAt": "2024-03-28T16:16:45.568Z", "timestamp": "2024-03-28T16:16:46.364Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457401
- updated: 2024-03-28 12:12:33
-
Version 4704783
- created: 2024-03-28 12:06:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704783
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T17:06:28Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711645364468.events-archiver-480-6..232ad4e3-1b40-4bcd-80a1-949d50b6524f.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-fc363f665d64efe92a535d7212544d25", "originalTimestamp": "2024-03-28T16:07:45.470Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711642064480, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "products": [ { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 1, "rank": 1 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 2, "rank": 2 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 3, "rank": 3 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 4, "rank": 4 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 5, "rank": 5 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 6, "rank": 6 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 7, "rank": 7 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 8, "rank": 8 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 9, "rank": 9 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 10, "rank": 10 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 11, "rank": 11 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 12, "rank": 12 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 13, "rank": 13 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 14, "rank": 14 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 15, "rank": 15 } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 15 }, "receivedAt": "2024-03-28T16:07:46.076Z", "sentAt": "2024-03-28T16:07:45.479Z", "timestamp": "2024-03-28T16:07:46.067Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "string" ], "properties.products": [ { "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "inNetwork": "string", "isTopYielder": "string", "position": "string", "rank": "string" } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457389
- updated: 2024-03-28 12:07:07
-
Version 4704782
- created: 2024-03-28 12:02:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`env`:STRING,`search_id`:STRING,`isReact`:STRING,`productIds`:array ,`Hit_Timestamp`:STRING,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`value`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`userAgent`:STRING,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704782
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T17:02:15Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711645129000.events-archiver-480-56..650dcdec-3f7f-4df8-9b7a-d7671cb8070e.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-3e639637c62e4abdc2d2fdacad06014a", "originalTimestamp": "2024-03-28T16:15:19.147Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711642518864, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ 215880, 227068, 218706, 215880, 215945, 215141, 234823, 219764, 232372, 232624, 230361, 202484, 231021, 227064, 210620, 215179 ], "products": [ { "distance": 2.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215880, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 1, "rank": 1, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.9, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227068, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Van Buren", "position": 2, "rank": 2, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28363143, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 38, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28363441, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 49, "promotion": "50% Off First Month!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28363188, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 85, "promotion": "50% Off First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.9, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 218706, "inNetwork": true, "isTopYielder": false, "name": "Prime Storage - Phoenix E. Indian School Road", "position": 3, "rank": 3, "reviewAverage": 4, "reviewCount": 52, "unitCount": 3, "units": [ { "id": 28746795, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 53, "promotion": "First Month FREE", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28748063, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 80, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28746617, "maxBookingDate": "2024-04-10T01:43:57.000Z", "priceValue": 141, "promotion": "First Month FREE", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.9, "id": 215880, "inNetwork": true, "isTopYielder": true, "name": "Public Storage - Phoenix - 2421 N Black Canyon Hwy", "position": 4, "rank": 4, "reviewAverage": 5, "reviewCount": 68, "unitCount": 3, "units": [ { "id": 22593973, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 28, "promotion": "50% off 1st Month", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22593971, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 49, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22593980, "maxBookingDate": "2024-04-11T09:16:29.000Z", "priceValue": 88, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215945, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1949 E Camelback Rd #21", "position": 5, "rank": 5, "reviewAverage": 5, "reviewCount": 20, "unitCount": 3, "units": [ { "id": 22599181, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 37, "promotion": "50% off 1st Month", "sizeText": "7' x 3'", "squareFootage": 21, "unitTypeText": "unit" }, { "id": 22599167, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 76, "promotion": "50% off 1st Month", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22599170, "maxBookingDate": "2024-04-26T08:46:39.000Z", "priceValue": 143, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4.5, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215141, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 1808 W Camelback Rd", "position": 6, "rank": 6, "reviewAverage": 4.5, "reviewCount": 72, "unitCount": 3, "units": [ { "id": 22521770, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 33, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22884666, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 45, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22521783, "maxBookingDate": "2024-04-26T01:49:08.000Z", "priceValue": 123, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 2.2, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 234823, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 6344 - Phoenix - N 16th St", "position": 7, "rank": 7, "reviewAverage": 0, "reviewCount": 0, "unitCount": 3, "units": [ { "id": 31349379, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 29, "promotion": "First Month Free", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 31349371, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 50, "promotion": "First Month Free", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 31349337, "maxBookingDate": "2024-04-10T02:19:04.000Z", "priceValue": 86, "promotion": "First Month Free", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 0.7, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 219764, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 841 E Jefferson St", "position": 8, "rank": 8, "reviewAverage": 5, "reviewCount": 7, "unitCount": 3, "units": [ { "id": 25066240, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 49, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 25066215, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 64, "promotion": "50% off 1st Month", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 25066210, "maxBookingDate": "2024-04-26T01:42:32.000Z", "priceValue": 73, "promotion": "$1 first month rent", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.2, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232372, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 0257 - Phoenix - N 7th Street", "position": 9, "rank": 9, "reviewAverage": 5, "reviewCount": 1, "unitCount": 3, "units": [ { "id": 30964352, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 34, "promotion": "", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 30964355, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 67, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30964381, "maxBookingDate": "2024-03-30T09:15:21.000Z", "priceValue": 94, "promotion": "", "sizeText": "5' x 15'", "squareFootage": 75, "unitTypeText": "unit" } ] }, { "distance": 3.8, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 232624, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 7246 - Phoenix - 27th Ave", "position": 10, "rank": 10, "reviewAverage": 5, "reviewCount": 2, "unitCount": 1, "units": [ { "id": 30981445, "maxBookingDate": "2024-03-30T02:23:00.000Z", "priceValue": 112, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 5.5, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 230361, "inNetwork": true, "isTopYielder": false, "name": "Life Storage - 3406 - Phoenix - 48th St", "position": 11, "rank": 11, "reviewAverage": 4.5, "reviewCount": 14, "unitCount": 2, "units": [ { "id": 30375598, "maxBookingDate": "2024-04-10T02:27:53.000Z", "priceValue": 57, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30375591, "maxBookingDate": "2024-04-03T02:27:53.000Z", "priceValue": 97, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 4, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 202484, "inNetwork": true, "isTopYielder": false, "name": "US Storage Centers - Phoenix - 2563 West Indian School Road", "position": 12, "rank": 12, "reviewAverage": 4.5, "reviewCount": 19, "unitCount": 3, "units": [ { "id": 18625367, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 28.5, "promotion": "1 Month 25% Off", "sizeText": "4' x 6'", "squareFootage": 24, "unitTypeText": "unit" }, { "id": 18625466, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 103.5, "promotion": "1 Month 25% Off", "sizeText": "7' x 7'", "squareFootage": 49, "unitTypeText": "unit" }, { "id": 18625496, "maxBookingDate": "2024-04-03T02:16:47.000Z", "priceValue": 105.5, "promotion": "1 Month 25% Off", "sizeText": "8' x 10'", "squareFootage": 80, "unitTypeText": "unit" } ] }, { "distance": 4.1, "hasContactlessBadge": true, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 231021, "inNetwork": true, "isTopYielder": false, "name": "Extra Space Storage - 1666 - Phoenix - Washington", "position": 13, "rank": 13, "reviewAverage": 0, "reviewCount": 0, "unitCount": 2, "units": [ { "id": 30948691, "maxBookingDate": "2024-04-10T10:00:41.000Z", "priceValue": 47, "promotion": "", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 30948695, "maxBookingDate": "2024-03-31T10:00:41.000Z", "priceValue": 93, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 1.8, "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "id": 227064, "inNetwork": true, "isTopYielder": false, "name": "StorQuest - Phoenix / Portland", "position": 14, "rank": 14, "reviewAverage": 5, "reviewCount": 4, "unitCount": 3, "units": [ { "id": 28122356, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 55, "promotion": "$1 First Month!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 28122603, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 68, "promotion": "$1 First Month!", "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 28122457, "maxBookingDate": "2024-04-03T01:27:15.000Z", "priceValue": 98, "promotion": "$1 First Month!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 3.4, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 210620, "inNetwork": true, "isTopYielder": false, "name": "Storage Sense - Washington St.", "position": 15, "rank": 15, "reviewAverage": 4.5, "reviewCount": 59, "unitCount": 3, "units": [ { "id": 22944013, "maxBookingDate": "2024-04-10T01:58:47.000Z", "priceValue": 39, "promotion": "2nd Month Free!", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22933729, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 59, "promotion": "2nd Month Free!", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22931029, "maxBookingDate": "2024-04-03T01:58:47.000Z", "priceValue": 99, "promotion": "2nd Month Free!", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "distance": 6, "hasContactlessBadge": true, "hasOmiBadge": true, "hasOmibadgeBadge": false, "id": 215179, "inNetwork": true, "isTopYielder": false, "name": "Public Storage - Phoenix - 4725 N 43rd Ave", "position": 16, "rank": 16, "reviewAverage": 4.5, "reviewCount": 93, "unitCount": 3, "units": [ { "id": 22520966, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 22, "promotion": "$1 first month rent", "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "id": 22520970, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 48, "promotion": "$1 first month rent", "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "id": 22520962, "maxBookingDate": "2024-04-26T01:49:23.000Z", "priceValue": 94, "promotion": "", "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 16 }, "receivedAt": "2024-03-28T16:15:19.826Z", "sentAt": "2024-03-28T16:15:19.150Z", "timestamp": "2024-03-28T16:15:19.823Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ "string" ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457383
- updated: 2024-03-28 12:02:57
-
Version 4704777
- created: 2024-03-28 11:58:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array - hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed
- id: 4704777
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c552c7d935bd0001b8729c", "59c13cfcc84de40001a9cdcc" ], "unbundled": [] }, "_origin": "2024-03-28T16:58:51Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1711584000000/1711645110533.events-archiver-480-24..03ad3d16-4173-4edb-8fae-0870dc27d90b.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "d8a63ef7-a679-4c2a-9cbe-bb518d96822b", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.64.0" }, "locale": "en-US", "page": { "path": "/Phoenix-AZ-self-storage.html", "referrer": "http://localhost:9000/", "search": "?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373", "title": "15 Cheap Self-Storage Units Near Phoenix, AZ (From $10)", "url": "http://localhost:9000/Phoenix-AZ-self-storage.html?location=Phoenix%2C%20AZ%2C%20USA&latitude=33.4483771&longitude=-112.0740373" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "122" }, { "brand": "Not(A:Brand", "version": "24" }, { "brand": "Google Chrome", "version": "122" } ], "mobile": false, "platform": "macOS" } }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-next-4b19f95bf971de246147e2d4952975c4", "originalTimestamp": "2024-03-28T16:27:27.242Z", "projectId": "iHhi46PCMy", "properties": { "Hit Timestamp": 1711643246023, "category": "Phoenix, AZ-cityLandingPage", "env": "development", "isReact": true, "list_id": "search results: Phoenix, AZ, USA", "page": 1, "productIds": [ null, null, null, null, null, null, null, null, null, null, null, null, null, null, null ], "products": [ { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 1, "rank": 1 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 2, "rank": 2 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 3, "rank": 3 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 4, "rank": 4 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 5, "rank": 5 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 6, "rank": 6 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 7, "rank": 7 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 8, "rank": 8 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 9, "rank": 9 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 10, "rank": 10 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 11, "rank": 11 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 12, "rank": 12 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 13, "rank": 13 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 14, "rank": 14 }, { "hasContactlessBadge": false, "hasOmiBadge": false, "hasOmibadgeBadge": false, "inNetwork": true, "isTopYielder": false, "position": 15, "rank": 15 } ], "searchTerm": "Phoenix, AZ, USA", "search_id": "6d1f660468dc73ac76.22670099", "site_id": -1, "value": 15 }, "receivedAt": "2024-03-28T16:27:27.940Z", "sentAt": "2024-03-28T16:27:27.265Z", "timestamp": "2024-03-28T16:27:27.917Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "string" ], "properties.products": [ { "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "inNetwork": "string", "isTopYielder": "string", "position": "string", "rank": "string" } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1544
- schema_scan_id: 6457365
- updated: 2024-03-28 11:59:31
Schema Scans: 15
Last at 2024-03-29 10:24:36
-
Scan 6458370
- duration: 0:01:02.579436
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1354, "partitions_applied": false, "success": true } - id: 6458370
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-29/", "name": "dt", "type": "string", "value": "2024-03-29" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-29/1711725654840.events-archiver-480-0..60525b91-25ba-4bcb-aae6-fd4732c72344.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-29 10:24:36
- success: True
- trace_id: 9688513532691640140
-
Scan 6457964
- duration: 0:01:10.898650
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457964
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711656744011.events-archiver-480-3..167760de-e3f3-4747-8938-89b43813a4dc.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 15:15:34
- success: True
- trace_id: 6461969032314382922
-
Scan 6457950
- duration: 0:01:02.641391
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457950
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711655468095.events-archiver-480-9..e6ac9049-b947-4779-9843-02e6c40f10f2.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:53:37
- success: True
- trace_id: 11354657753204419610
-
Scan 6457930
- duration: 0:01:08.667689
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457930
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711654651672.events-archiver-480-45..8dab1e34-626a-482b-89f6-56a7ef348fdf.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:37:55
- success: True
- trace_id: 14024777587115103718
-
Scan 6457914
- duration: 0:01:08.062433
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457914
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711654094688.events-archiver-480-32..c63842b7-3b46-4e34-ac7c-bf26bae7acbb.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:28:54
- success: True
- trace_id: 11157745067338667722
-
Scan 6457898
- duration: 0:05:32.407094
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457898
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711653535861.events-archiver-480-50..20a92267-94c6-4651-b05f-a649fade7bc2.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:22:17
- success: True
- trace_id: 49057609539056238
-
Scan 6457879
- duration: 0:06:00.411389
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457879
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711653150246.events-archiver-480-3..801bef13-3a01-4297-a58c-64fc24616723.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:15:56
- success: True
- trace_id: 15314184991754569101
-
Scan 6457875
- duration: 0:01:10.022492
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457875
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711653271251.events-archiver-480-35..34044c01-6a5b-4087-b60b-90ccac426425.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:15:33
- success: True
- trace_id: 11251540617999701471
-
Scan 6457836
- duration: 0:05:50.376964
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457836
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711652569627.events-archiver-480-6..69c273b9-f116-417f-a17a-fe8be5c35ec4.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:07:01
- success: True
- trace_id: 258557192196044487
-
Scan 6457834
- duration: 0:01:08.018923
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457834
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711652746896.events-archiver-480-22..28f5ebcb-dc3d-448f-a2a5-c7c5b041f215.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 14:06:35
- success: True
- trace_id: 4507309571851724766
-
Scan 6457677
- duration: 0:01:10.718242
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457677
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711651213115.events-archiver-480-12..7f271020-5b76-41e2-881a-fa767043883b.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 13:42:06
- success: True
- trace_id: 13065815209183251688
-
Scan 6457401
- duration: 0:01:06.223357
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457401
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711645785330.events-archiver-480-4..705cc364-0a2e-4b04-860e-82902d102479.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 12:11:52
- success: True
- trace_id: 14708255094178276552
-
Scan 6457389
- duration: 0:01:02.617160
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457389
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711645364468.events-archiver-480-6..232ad4e3-1b40-4bcd-80a1-949d50b6524f.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 12:06:29
- success: True
- trace_id: 16528116818604732883
-
Scan 6457383
- duration: 0:01:06.183295
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457383
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711645129000.events-archiver-480-56..650dcdec-3f7f-4df8-9b7a-d7671cb8070e.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 12:02:16
- success: True
- trace_id: 6470367592944137427
-
Scan 6457365
- duration: 0:01:03.214256
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1353, "partitions_applied": false, "success": true } - id: 6457365
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2024-03-28/", "name": "dt", "type": "string", "value": "2024-03-28" }, "s3": { "bucket": "sfdl-segment-reactfoot-dev", "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2024-03-28/1711645110533.events-archiver-480-24..03ad3d16-4173-4edb-8fae-0870dc27d90b.json.gz" }, "schema": { "name": "sfdl_dev_segment.reactfoot_ProductListViewed", "type": "segment" } } - running: False
- schema_name_id: 1544
- start_time: 2024-03-28 11:58:53
- success: True
- trace_id: 8542955257007904842
- count: 4
- ddl:
[ "ALTER TABLE\n `sfdl_dev_segment.reactfoot_productlistviewed`\nADD\n\n\n PARTITION (dt='2025-02-03') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-03/'\n PARTITION (dt='2025-02-04') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-04/'\n PARTITION (dt='2025-02-05') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-05/'\n PARTITION (dt='2025-02-06') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-06/'\n;" ] - name: dt
- state:
[ { "info": { "id": 287377, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-03/", "name": "dt", "value": "2025-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-02-03 01:00:05", "last_data": "2025-02-03 12:03:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 287468, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-04/", "name": "dt", "value": "2025-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-02-03 23:41:04", "last_data": "2025-02-04 16:37:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 287831, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-05/", "name": "dt", "value": "2025-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-02-05 04:35:21", "last_data": "2025-02-05 05:12:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 287967, "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-06/", "name": "dt", "value": "2025-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-02-06 09:50:23", "last_data": "2025-02-06 10:34:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.list_id": "string", "properties.page": "string", "properties.productIds": [ "int" ], "properties.products": [ { "distance": "string", "hasContactlessBadge": "string", "hasOmiBadge": "string", "hasOmibadgeBadge": "string", "id": "string", "inNetwork": "string", "isTopYielder": "string", "name": "string", "position": "string", "rank": "string", "reviewAverage": "string", "reviewCount": "string", "unitCount": "string", "units": [ "string" ] } ], "properties.searchTerm": "string", "properties.search_id": "string", "properties.site_id": "string", "properties.value": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2024-03-29 10:24:38
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2021-02-12 11:16:22",
"disabled": false,
"format": "raw",
"id": 1544,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_segment",
"table": "reactfoot_productlistviewed"
},
"type": "segment"
},
"partition": {
"count": 4,
"ddl": [
"ALTER TABLE\n `sfdl_dev_segment.reactfoot_productlistviewed`\nADD\n\n\n PARTITION (dt='2025-02-03') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-03/'\n PARTITION (dt='2025-02-04') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-04/'\n PARTITION (dt='2025-02-05') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-05/'\n PARTITION (dt='2025-02-06') location 's3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-06/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 287377,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-03/",
"name": "dt",
"value": "2025-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-02-03 01:00:05",
"last_data": "2025-02-03 12:03:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 287468,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-04/",
"name": "dt",
"value": "2025-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-02-03 23:41:04",
"last_data": "2025-02-04 16:37:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 287831,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-05/",
"name": "dt",
"value": "2025-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-02-05 04:35:21",
"last_data": "2025-02-05 05:12:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 287967,
"location": "s3://sfdl-segment-reactfoot-dev/separated_dt/Product List Viewed/dt=2025-02-06/",
"name": "dt",
"value": "2025-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-02-06 09:50:23",
"last_data": "2025-02-06 10:34:33"
},
"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.campaign.content": "string",
"context.campaign.medium": "string",
"context.campaign.name": "string",
"context.campaign.source": "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",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.category": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.list_id": "string",
"properties.page": "string",
"properties.productIds": [
"int"
],
"properties.products": [
{
"distance": "string",
"hasContactlessBadge": "string",
"hasOmiBadge": "string",
"hasOmibadgeBadge": "string",
"id": "string",
"inNetwork": "string",
"isTopYielder": "string",
"name": "string",
"position": "string",
"rank": "string",
"reviewAverage": "string",
"reviewCount": "string",
"unitCount": "string",
"units": [
"string"
]
}
],
"properties.searchTerm": "string",
"properties.search_id": "string",
"properties.site_id": "string",
"properties.value": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2024-03-29 10:24:38",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_productlistviewed`\n(\n`type`STRING,`properties`struct<`products`:array>>,`env`:STRING,`value`:STRING,`search_id`:STRING,`isReact`:STRING,`productIds`:array,`searchTerm`:STRING,`list_id`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`category`:STRING,`page`:STRING>,`originalTimestamp`STRING,`messageId`STRING,`receivedAt`STRING,`_origin`STRING,`timestamp`STRING,`channel`STRING,`userId`STRING,`version`STRING,`sentAt`STRING,`event`STRING,`context`struct<`timezone`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`brands`:array>,`platform`:STRING,`mobile`:STRING>,`locale`:STRING,`userAgent`:STRING,`page`:struct<`path`:STRING,`referrer`:STRING,`title`:STRING,`url`:STRING,`search`:STRING>>,`projectId`STRING,`anonymousId`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-dev/separated_dt/Product List Viewed'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_productlistviewed`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_productlistviewed"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}