2019-09-12 9:07:34 - DEBUG --> Today: 2019-09-12 09:07:34 
2019-09-12 9:07:34 - DEBUG --> 30 Days Ago: 2019-08-13 09:07:34 
2019-09-12 9:07:34 - DEBUG --> Start: 2019-08-13 09:07:34 
2019-09-12 9:07:34 - DEBUG --> End:2019-09-12 09:07:34 
2019-09-12 9:07:46 - DEBUG --> Today: 2019-09-12 09:07:46 
2019-09-12 9:07:46 - DEBUG --> 30 Days Ago: 2019-08-13 09:07:46 
2019-09-12 9:07:46 - DEBUG --> Start: 2019-08-13 09:07:46 
2019-09-12 9:07:46 - DEBUG --> End:2019-09-12 09:07:46 
2019-09-13 15:26:37 - ERROR --> Bad Request 
2019-09-13 15:30:29 - ERROR --> Bad Request 
2019-09-13 15:30:39 - ERROR --> Bad Request 
2019-09-13 15:30:58 - ERROR --> Bad Request 
2019-09-13 15:31:02 - ERROR --> Bad Request 
2022-04-11 15:26:45 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:26:45 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:30:40 - DEBUG --> 2022-03-12 21:30:40 
2022-04-11 15:30:40 - DEBUG --> 2022-04-11 20:30:40 
2022-04-11 15:30:45 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:30:45 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:32:00 - DEBUG --> 2022-03-12 21:32:00 
2022-04-11 15:32:00 - DEBUG --> 2022-04-11 20:32:00 
2022-04-11 15:32:19 - DEBUG --> 2022-03-12 21:32:19 
2022-04-11 15:32:19 - DEBUG --> 2022-04-11 20:32:19 
2022-04-11 15:32:44 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:32:44 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:36:04 - DEBUG --> 2022-03-12 21:36:04 
2022-04-11 15:36:04 - DEBUG --> 2022-04-11 20:36:04 
2022-04-11 15:37:44 - DEBUG --> 2022-03-12 21:37:43 
2022-04-11 15:37:44 - DEBUG --> 2022-04-11 20:37:43 
2022-04-11 15:40:44 - DEBUG --> 2022-03-12 21:40:44 
2022-04-11 15:40:44 - DEBUG --> 2022-04-11 20:40:44 
2022-04-11 15:41:21 - DEBUG --> 2022-03-12 21:41:21 
2022-04-11 15:41:21 - DEBUG --> 2022-04-11 20:41:21 
2022-04-11 15:42:42 - DEBUG --> 2022-03-12 21:42:42 
2022-04-11 15:42:42 - DEBUG --> 2022-04-11 20:42:42 
2022-04-11 15:43:21 - DEBUG --> 2022-03-12 21:43:21 
2022-04-11 15:43:21 - DEBUG --> 2022-04-11 20:43:21 
2022-04-11 15:44:36 - DEBUG --> 2022-03-12 21:44:36 
2022-04-11 15:44:36 - DEBUG --> 2022-04-11 20:44:36 
2022-04-11 15:46:16 - DEBUG --> 2022-03-12 21:46:16 
2022-04-11 15:46:16 - DEBUG --> 2022-04-11 20:46:16 
2022-04-11 15:47:18 - DEBUG --> 2022-03-12 21:47:18 
2022-04-11 15:47:18 - DEBUG --> 2022-04-11 20:47:18 
2022-04-11 15:48:08 - DEBUG --> 2022-03-12 21:48:08 
2022-04-11 15:48:08 - DEBUG --> 2022-04-11 20:48:08 
2022-04-11 15:48:33 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:48:33 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:49:32 - DEBUG --> 2022-03-12 21:49:32 
2022-04-11 15:49:32 - DEBUG --> 2022-04-11 20:49:32 
2022-04-11 15:49:37 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:49:37 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:50:18 - DEBUG --> 2022-03-12 21:50:18 
2022-04-11 15:50:18 - DEBUG --> 2022-04-11 20:50:18 
2022-04-11 15:50:22 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:50:22 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:51:58 - DEBUG --> 2022-03-12 21:51:58 
2022-04-11 15:51:58 - DEBUG --> 2022-04-11 20:51:58 
2022-04-11 15:54:13 - DEBUG --> 2022-03-12 21:54:13 
2022-04-11 15:54:13 - DEBUG --> 2022-04-11 20:54:13 
2022-04-11 15:56:04 - DEBUG --> 2022-03-12 21:56:04 
2022-04-11 15:56:04 - DEBUG --> 2022-04-11 20:56:04 
2022-04-11 15:56:59 - DEBUG --> 2022-03-12 21:56:59 
2022-04-11 15:56:59 - DEBUG --> 2022-04-11 20:56:59 
2022-04-11 15:57:04 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:57:04 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:57:17 - DEBUG --> 2022-01-01 06:00:00 
2022-04-11 15:57:17 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:57:27 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:57:27 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:57:37 - DEBUG --> 2022-03-12 21:57:37 
2022-04-11 15:57:37 - DEBUG --> 2022-04-11 20:57:37 
2022-04-11 15:57:44 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 15:57:44 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 15:58:00 - DEBUG --> 2022-04-01 05:00:00 
2022-04-11 15:58:00 - DEBUG --> 2022-05-01 04:59:59 
2022-04-11 16:06:19 - DEBUG --> 2022-03-12 22:06:19 
2022-04-11 16:06:19 - DEBUG --> 2022-04-11 21:06:19 
2022-04-11 16:08:33 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:08:33 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 16:08:41 - DEBUG --> 2022-03-12 22:08:41 
2022-04-11 16:08:41 - DEBUG --> 2022-04-11 21:08:41 
2022-04-11 16:08:46 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:08:46 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 16:08:59 - DEBUG --> 2022-03-12 22:08:59 
2022-04-11 16:08:59 - DEBUG --> 2022-04-11 21:08:59 
2022-04-11 16:09:05 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:09:05 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 16:14:04 - DEBUG --> 2022-03-12 22:14:04 
2022-04-11 16:14:04 - DEBUG --> 2022-04-11 21:14:04 
2022-04-11 16:14:10 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:14:10 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 16:14:59 - DEBUG --> 2022-03-12 22:14:59 
2022-04-11 16:14:59 - DEBUG --> 2022-04-11 21:14:59 
2022-04-11 16:15:07 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:15:07 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 16:16:06 - DEBUG --> 2022-03-12 22:16:06 
2022-04-11 16:16:06 - DEBUG --> 2022-04-11 21:16:06 
2022-04-11 16:16:13 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:16:13 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 16:17:27 - DEBUG --> 2022-03-12 22:17:27 
2022-04-11 16:17:27 - DEBUG --> 2022-04-11 21:17:27 
2022-04-11 16:17:46 - DEBUG --> 2022-03-12 22:17:46 
2022-04-11 16:17:46 - DEBUG --> 2022-04-11 21:17:46 
2022-04-11 16:17:49 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:17:49 - DEBUG --> 2022-04-12 04:59:59 
2022-04-11 16:19:20 - DEBUG --> 2022-03-12 22:19:19 
2022-04-11 16:19:20 - DEBUG --> 2022-04-11 21:19:19 
2022-04-11 16:19:24 - DEBUG --> 2022-01-11 06:00:00 
2022-04-11 16:19:24 - DEBUG --> 2022-04-12 04:59:59 
2025-12-04 16:20:51 - INFO  --> ==== STARTING SURVEY AI ANALYSIS ==== 
2025-12-04 16:20:51 - DEBUG --> Connected to store: pc00 
2025-12-04 16:20:51 - DEBUG --> Querying for survey data (limit 500) 
2025-12-04 16:20:51 - INFO  --> Found 0 survey records for analysis 
2025-12-04 16:20:51 - ERROR --> No survey data found 
2025-12-04 16:23:52 - INFO  --> ==== STARTING SURVEY AI ANALYSIS ==== 
2025-12-04 16:23:52 - DEBUG --> Connected to store: pc00 
2025-12-04 16:23:52 - DEBUG --> Querying for survey data (limit 500) 
2025-12-04 16:23:53 - INFO  --> Found 0 survey records for analysis 
2025-12-04 16:23:53 - ERROR --> No survey data found 
2025-12-04 16:24:37 - INFO  --> ==== STARTING SURVEY AI ANALYSIS ==== 
2025-12-04 16:24:37 - DEBUG --> Connected to store: pc00 
2025-12-04 16:24:37 - DEBUG --> Querying for survey data (limit 500) 
2025-12-04 16:24:37 - INFO  --> Found 500 survey records for analysis 
2025-12-04 16:24:37 - DEBUG --> Converting data to CSV format 
2025-12-04 16:24:37 - INFO  --> CSV data size: 62.78 KB 
2025-12-04 16:24:37 - DEBUG --> CSV data sample (header + 5 records):
[id],[customerID],[buyID],[step1],[step2],[step3],[step4],[step5],[step6],[step6Comment],[dateSubmitted],[type],[comments],[firstName],[lastName],[buyerFirstName],[buyerLastName],[buyerID],[sorterLastName],[sorterFirstName],[sorterID]
1161,31350,66408,2,3,3,5,0,1,,2025-12-02 00:32:01,1,,Camila,Gomesbarsanti,,,,,,
1160,24584,66264,2,1,0,4,0,1,Around ,2025-11-27 07:31:41,1,Overall good experience! ,Julia,Velichko,,,,,,
1159,31276,66209,2,3,0,4,0,6,,2025-11-25 18:28:09,1,,Wanda,Chin,,,,,,
1158,22017,66086,2,-1,0,4,0,2,,2025-11-22 01:33:23,1,I was very happy 9 of my items were purchased but they miscounted and only said 8 so I am glad I double checked the number so they could correct it. ,Rachel,Bresnick,,,,,,
1157,31188,65982,2,3,0,5,0,2,,2025-11-18 00:25:27,1,,Kelene,Richart,,,,,, 
2025-12-04 16:24:37 - DEBUG --> Preparing OpenAI API request 
2025-12-04 16:24:37 - INFO  --> Sending request to OpenAI API - GPT-4-Turbo model 
2025-12-04 16:24:37 - INFO  --> OpenAI request payload size: 65.86 KB 
2025-12-04 16:24:37 - DEBUG --> Executing OpenAI API request... 
2025-12-04 16:34:05 - INFO  --> Fetching cached survey analysis for: ou00 
2025-12-04 16:34:05 - INFO  --> No cached analysis found for: ou00 
2025-12-04 16:38:52 - INFO  --> Fetching cached survey analysis for: ou00 
2025-12-04 16:38:52 - INFO  --> No cached analysis found for: ou00 
2025-12-04 16:40:02 - INFO  --> Fetching cached survey analysis for: ou00 
2025-12-04 16:40:02 - INFO  --> No cached analysis found for: ou00 
2025-12-04 16:41:35 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:41:35 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:42:36 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:42:36 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:43:53 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:43:53 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:43:57 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:43:57 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:44:31 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:44:31 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:46:29 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:46:29 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:48:27 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:48:27 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:48:29 - INFO  --> ==== STARTING SURVEY AI ANALYSIS ==== 
2025-12-04 16:48:29 - DEBUG --> Connected to store: pc00 
2025-12-04 16:48:29 - DEBUG --> Querying for survey data (limit 500) 
2025-12-04 16:48:29 - INFO  --> Found 500 survey records for analysis 
2025-12-04 16:48:29 - DEBUG --> Converting data to CSV format 
2025-12-04 16:48:29 - INFO  --> CSV data size: 62.78 KB 
2025-12-04 16:48:29 - DEBUG --> CSV data sample (header + 5 records):
[id],[customerID],[buyID],[step1],[step2],[step3],[step4],[step5],[step6],[step6Comment],[dateSubmitted],[type],[comments],[firstName],[lastName],[buyerFirstName],[buyerLastName],[buyerID],[sorterLastName],[sorterFirstName],[sorterID]
1161,31350,66408,2,3,3,5,0,1,,2025-12-02 00:32:01,1,,Camila,Gomesbarsanti,,,,,,
1160,24584,66264,2,1,0,4,0,1,Around ,2025-11-27 07:31:41,1,Overall good experience! ,Julia,Velichko,,,,,,
1159,31276,66209,2,3,0,4,0,6,,2025-11-25 18:28:09,1,,Wanda,Chin,,,,,,
1158,22017,66086,2,-1,0,4,0,2,,2025-11-22 01:33:23,1,I was very happy 9 of my items were purchased but they miscounted and only said 8 so I am glad I double checked the number so they could correct it. ,Rachel,Bresnick,,,,,,
1157,31188,65982,2,3,0,5,0,2,,2025-11-18 00:25:27,1,,Kelene,Richart,,,,,, 
2025-12-04 16:48:29 - DEBUG --> Preparing OpenAI API request 
2025-12-04 16:48:29 - INFO  --> Sending request to OpenAI API - GPT-4-Turbo model 
2025-12-04 16:48:29 - INFO  --> OpenAI request payload size: 65.86 KB 
2025-12-04 16:48:29 - DEBUG --> Executing OpenAI API request... 
2025-12-04 16:54:51 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:54:51 - INFO  --> No cached analysis found for: pc00 
2025-12-04 16:59:41 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 16:59:41 - INFO  --> No cached analysis found for: pc00 
2025-12-04 17:02:16 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:02:16 - INFO  --> No cached analysis found for: pc00 
2025-12-04 17:02:19 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:02:19 - INFO  --> No cached analysis found for: pc00 
2025-12-04 17:03:08 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:03:08 - INFO  --> No cached analysis found for: pc00 
2025-12-04 17:03:15 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:03:15 - INFO  --> No cached analysis found for: pc00 
2025-12-04 17:03:19 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:03:19 - INFO  --> No cached analysis found for: pc00 
2025-12-04 17:05:29 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:05:29 - INFO  --> No cached analysis found for: pc00 
2025-12-04 17:05:37 - INFO  --> ==== STARTING SURVEY AI ANALYSIS ==== 
2025-12-04 17:05:37 - DEBUG --> Connected to store: pc00 
2025-12-04 17:05:37 - DEBUG --> Querying for survey data (limit 500) 
2025-12-04 17:05:37 - INFO  --> Found 500 survey records for analysis 
2025-12-04 17:05:37 - DEBUG --> Converting data to CSV format 
2025-12-04 17:05:37 - INFO  --> CSV data size: 62.78 KB 
2025-12-04 17:05:37 - DEBUG --> CSV data sample (header + 5 records):
[id],[customerID],[buyID],[step1],[step2],[step3],[step4],[step5],[step6],[step6Comment],[dateSubmitted],[type],[comments],[firstName],[lastName],[buyerFirstName],[buyerLastName],[buyerID],[sorterLastName],[sorterFirstName],[sorterID]
1161,31350,66408,2,3,3,5,0,1,,2025-12-02 00:32:01,1,,Camila,Gomesbarsanti,,,,,,
1160,24584,66264,2,1,0,4,0,1,Around ,2025-11-27 07:31:41,1,Overall good experience! ,Julia,Velichko,,,,,,
1159,31276,66209,2,3,0,4,0,6,,2025-11-25 18:28:09,1,,Wanda,Chin,,,,,,
1158,22017,66086,2,-1,0,4,0,2,,2025-11-22 01:33:23,1,I was very happy 9 of my items were purchased but they miscounted and only said 8 so I am glad I double checked the number so they could correct it. ,Rachel,Bresnick,,,,,,
1157,31188,65982,2,3,0,5,0,2,,2025-11-18 00:25:27,1,,Kelene,Richart,,,,,, 
2025-12-04 17:05:37 - DEBUG --> Preparing OpenAI API request 
2025-12-04 17:05:37 - INFO  --> Sending request to OpenAI API - GPT-4-Turbo model 
2025-12-04 17:05:37 - INFO  --> OpenAI request payload size: 65.86 KB 
2025-12-04 17:05:37 - DEBUG --> Executing OpenAI API request... 
2025-12-04 17:06:06 - INFO  --> OpenAI API response received. HTTP Code: 200. Duration: 29.02 seconds 
2025-12-04 17:06:06 - INFO  --> OpenAI response size: 4.36 KB 
2025-12-04 17:06:06 - DEBUG --> Processing OpenAI response... 
2025-12-04 17:06:06 - DEBUG --> Analysis sample (first 500 chars): {
  "step1Analysis": {
    "commonResponses": [
      {
        "rating": 2,
        "count": 678
      },
      {
        "rating": 1,
        "count": 322
      },
      {
        "rating": 0,
        "count": 138
      }
    ],
    "actionableInsights": [
      "Enhance greeting protocols to ensure a consistently positive first impression.",
      "Train staff to engage more actively and warmly with customers upon their arrival."
    ]
  },
  "step2Analysis": {
    "commonResponses": [
      ... 
2025-12-04 17:06:06 - INFO  --> Response structure: ["id","object","created","model","choices","usage","service_tier","system_fingerprint"] 
2025-12-04 17:06:06 - INFO  --> Contains 'choices'?: Yes 
2025-12-04 17:06:06 - INFO  --> First choice keys: ["index","message","logprobs","finish_reason"] 
2025-12-04 17:06:06 - INFO  --> Message keys: ["role","content","refusal","annotations"] 
2025-12-04 17:06:06 - INFO  --> Analysis JSON structure: ["step1Analysis","step2Analysis","step3Analysis","step4Analysis","recurringPositiveThemes","recurringNegativeThemes","recommendedActions","overallSummary"] 
2025-12-04 17:06:06 - INFO  --> Analysis successfully parsed as JSON. Returning to client. 
2025-12-04 17:06:06 - INFO  --> Analysis cached in Redis with key: survey_analysis:pc00 
2025-12-04 17:06:06 - INFO  --> ==== SURVEY AI ANALYSIS COMPLETED ==== 
2025-12-04 17:06:06 - INFO  --> Total process duration: 29.07 seconds 
2025-12-04 17:07:01 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:07:01 - INFO  --> Found cached analysis for: pc00 
2025-12-04 17:08:56 - INFO  --> Fetching cached survey analysis for: pc00 
2025-12-04 17:08:56 - INFO  --> Found cached analysis for: pc00 
2025-12-08 11:39:04 - DEBUG --> New Survey for ou00 
2025-12-08 11:39:04 - DEBUG --> BuyID Check Executed 
2025-12-08 11:39:04 - DEBUG --> BuyID Check Passed 
2025-12-08 11:39:04 - DEBUG --> Text Me Check Execute 
2025-12-08 11:39:04 - DEBUG --> Text Me Is a Go 
2025-12-08 11:39:04 - DEBUG --> Survey URL: https://v2ts.co/s/fbc71035 
2025-12-08 11:39:04 - DEBUG --> Phone: 3308020412 
2025-12-08 11:39:04 - DEBUG --> Sending survey SMS via store's text messaging service 
2025-12-08 11:39:04 - DEBUG --> Add Text To Database 
2025-12-08 11:39:04 - DEBUG --> Text was counted 
2026-02-11 12:44:17 - INFO  --> Fetching cached survey analysis for: pc00 
2026-02-11 12:44:17 - INFO  --> No cached analysis found for: pc00 
2026-02-13 17:08:36 - DEBUG --> New Survey for pc00 
2026-02-13 17:08:36 - DEBUG --> BuyID Check Executed 
2026-02-13 17:08:36 - DEBUG --> BuyID Check Passed 
2026-02-13 17:08:36 - DEBUG --> Text Me Check Execute 
2026-02-13 17:08:36 - DEBUG --> Text Me Is a Go 
2026-02-13 17:08:36 - DEBUG --> Survey URL: https://v2ts.co/s/fd7b43b3 
2026-02-13 17:08:36 - DEBUG --> Phone: 6502189797 
2026-02-13 17:08:36 - DEBUG --> Sending survey SMS via store's text messaging service 
2026-02-13 17:08:54 - DEBUG --> New Survey for pc00 
2026-02-13 17:08:54 - DEBUG --> BuyID Check Executed 
2026-02-13 17:08:54 - DEBUG --> BuyID Check Passed 
2026-02-13 17:08:54 - DEBUG --> Text Me Check Execute 
2026-02-13 17:08:54 - DEBUG --> Text Me Is a Go 
2026-02-13 17:08:54 - DEBUG --> Survey URL: https://v2ts.co/s/dec79f67 
2026-02-13 17:08:54 - DEBUG --> Phone: 1567123184 
2026-02-13 17:08:54 - DEBUG --> Sending survey SMS via store's text messaging service