AI Glassdoor Review Analysis for Workplace Discrimination Patterns
208b9de5-bdd3-408b-b65a-bf810c4145bd
Latency
130437ms
Cost
$0.0009
Tokens
476
Status
partialgemini-2.5-flash
Workflow Graph
Trace
[
{
"data": {
"nodeType": "manualTrigger"
},
"event": "node_start",
"nodeId": "b508ab50-158a-4cbf-a52e-f53e1804e770",
"timestamp": 1783469955214
},
{
"data": {
"initialData": {
"output": {
"average_rating": 4,
"asian_average_rating": 4.2,
"total_number_of_reviews": 700,
"asian_total_number_of_reviews": 150,
"1_star_distribution_percentage": 3.5,
"2_star_distribution_percentage": 5,
"3_star_distribution_percentage": 10.5,
"4_star_distribution_percentage": 25.8,
"5_star_distribution_percentage": 55.2
},
"std_dev": 0.8,
"url_path": "/Reviews/TechSolutions-Inc-Reviews-E12345.htm",
"company_name": {
"toLowerCase": "techsolutions inc"
},
"average_rating": 4,
"review_summary": "TechSolutions Inc. is a rapidly growing tech company known for its innovative products and fast-paced environment. Employees generally praise the challenging projects and opportunities for learning. However, some reviews mention concerns about work-life balance and occasional communication breakdowns between departments. The company has a diverse workforce, and efforts are being made to foster an inclusive culture.",
"population_analysis": {
"p_scores": {
"asian": 0.02,
"black": 0.15,
"other": 0.05,
"white": 0.01,
"hispanic": 0.08
},
"z_scores": {
"asian": 2.05,
"black": 1.03,
"other": 1.96,
"white": 2.33,
"hispanic": 1.75
},
"effect_sizes": {
"asian": 0.3,
"black": 0.18,
"other": 0.28,
"white": 0.35,
"hispanic": 0.25
},
"review_count": {
"asian": 150,
"black": 120,
"other": 50,
"white": 300,
"hispanic": 80
}
},
"demographics_content": {
"asian_average_rating": 4.2,
"black_average_rating": 3.5,
"other_average_rating": 3.9,
"white_average_rating": 4.1,
"hispanic_average_rating": 3.8,
"asian_total_number_of_reviews": 150,
"black_total_number_of_reviews": 120,
"other_total_number_of_reviews": 50,
"white_total_number_of_reviews": 300,
"hispanic_total_number_of_reviews": 80
},
"contribution_to_variance": {
"values": [
0.1,
0.05,
0.2,
0.15,
0.08
]
}
}
},
"event": "triggered",
"nodeId": "manualTrigger",
"timestamp": 1783469955214
},
{
"data": {
"status": "ok",
"nodeType": "manualTrigger"
},
"event": "node_end",
"nodeId": "b508ab50-158a-4cbf-a52e-f53e1804e770",
"timestamp": 1783469955214
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "11a1a2d5-a274-44f7-97ca-5666a59fcb31",
"timestamp": 1783469955220
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783469955220
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783469955220
},
{
"data": {
"error": "Google Gemini API error (500): {\n \"error\": {\n \"code\": 500,\n \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n \"status\": \"INTERNAL\"\n }\n}\n",
"status": "error",
"degraded": true,
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "11a1a2d5-a274-44f7-97ca-5666a59fcb31",
"timestamp": 1783469980527
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "395f7b67-c914-4aae-8727-0573fdbfc6ad",
"timestamp": 1783469980531
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783469980531
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783469980531
},
{
"data": {
"error": "Google Gemini API error (500): {\n \"error\": {\n \"code\": 500,\n \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n \"status\": \"INTERNAL\"\n }\n}\n",
"status": "error",
"degraded": true,
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "395f7b67-c914-4aae-8727-0573fdbfc6ad",
"timestamp": 1783470005829
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "1eba1dd7-a164-4c70-8c75-759532bd16a0",
"timestamp": 1783470005834
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470005834
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470005834
},
{
"data": {
"error": "Google Gemini API error (500): {\n \"error\": {\n \"code\": 500,\n \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n \"status\": \"INTERNAL\"\n }\n}\n",
"status": "error",
"degraded": true,
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "1eba1dd7-a164-4c70-8c75-759532bd16a0",
"timestamp": 1783470031230
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "f25f1b07-cded-4ca7-9655-8b8f463089ab",
"timestamp": 1783470031237
},
{
"data": {
"inputKeys": [
"company_name",
"url_path",
"review_summary",
"demographics_content",
"output",
"contribution_to_variance",
"population_analysis",
"average_rating",
"std_dev"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470031237
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "f25f1b07-cded-4ca7-9655-8b8f463089ab",
"timestamp": 1783470031237
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "87264a93-ab97-4e39-8d40-43365189f704",
"timestamp": 1783470031241
},
{
"data": {
"inputKeys": [
"company_name",
"url_path",
"review_summary",
"demographics_content",
"output",
"contribution_to_variance",
"population_analysis",
"average_rating",
"std_dev"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470031241
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "87264a93-ab97-4e39-8d40-43365189f704",
"timestamp": 1783470031241
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "862f1c77-44a8-4d79-abac-33351ebb731b",
"timestamp": 1783470031246
},
{
"event": "fetching GET https://app.scrapingbee.com/api/v1",
"nodeId": "http",
"timestamp": 1783470031246
},
{
"data": {
"url": "https://app.scrapingbee.com/api/v1",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470031246
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470031766
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "862f1c77-44a8-4d79-abac-33351ebb731b",
"timestamp": 1783470031766
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "4c9bf05e-9c50-4895-b20b-b7c329104615",
"timestamp": 1783470031778
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470031778
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "4c9bf05e-9c50-4895-b20b-b7c329104615",
"timestamp": 1783470031778
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "d20bb0e7-4ca7-41d0-a3e9-41abc811b064",
"timestamp": 1783470031781
},
{
"event": "fetching GET https://app.scrapingbee.com/api/v1",
"nodeId": "http",
"timestamp": 1783470031781
},
{
"data": {
"url": "https://app.scrapingbee.com/api/v1",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470031781
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470031932
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "d20bb0e7-4ca7-41d0-a3e9-41abc811b064",
"timestamp": 1783470031932
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "fce70cab-8ce3-4ce2-b040-ce80d66b1e62",
"timestamp": 1783470031938
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470031938
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "fce70cab-8ce3-4ce2-b040-ce80d66b1e62",
"timestamp": 1783470031938
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "d2e7fee9-e3d4-42bf-8be6-38b352371273",
"timestamp": 1783470031941
},
{
"event": "fetching GET https://app.scrapingbee.com/api/v1",
"nodeId": "http",
"timestamp": 1783470031941
},
{
"data": {
"url": "https://app.scrapingbee.com/api/v1",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470031941
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470032090
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "d2e7fee9-e3d4-42bf-8be6-38b352371273",
"timestamp": 1783470032090
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "851305ba-0837-4be9-943d-7282e8d74aee",
"timestamp": 1783470032096
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470032096
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "851305ba-0837-4be9-943d-7282e8d74aee",
"timestamp": 1783470032096
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "0c322823-0569-4bd5-9c4e-af3de0f8d7b4",
"timestamp": 1783470032101
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470032101
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "0c322823-0569-4bd5-9c4e-af3de0f8d7b4",
"timestamp": 1783470032101
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "ae164f6e-04e7-4d8b-951e-a17085956f4b",
"timestamp": 1783470032105
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470032105
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470032105
},
{
"data": {
"error": "Google Gemini API error (500): {\n \"error\": {\n \"code\": 500,\n \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n \"status\": \"INTERNAL\"\n }\n}\n",
"status": "error",
"degraded": true,
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "ae164f6e-04e7-4d8b-951e-a17085956f4b",
"timestamp": 1783470057503
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "cf9a6ee2-53b5-4fbf-a36c-4b9dab53b795",
"timestamp": 1783470057512
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470057512
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470057512
},
{
"data": {
"error": "Google Gemini API error (500): {\n \"error\": {\n \"code\": 500,\n \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n \"status\": \"INTERNAL\"\n }\n}\n",
"status": "error",
"degraded": true,
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "cf9a6ee2-53b5-4fbf-a36c-4b9dab53b795",
"timestamp": 1783470082993
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "c8d9e45c-7d41-47bd-b9a9-0fa70de5d154",
"timestamp": 1783470082996
},
{
"data": {
"inputKeys": [],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470082996
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "c8d9e45c-7d41-47bd-b9a9-0fa70de5d154",
"timestamp": 1783470082996
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "8ea03017-d5d6-46ef-a5f1-dae4372f6256",
"timestamp": 1783470082999
},
{
"data": {
"inputKeys": [],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470082999
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "8ea03017-d5d6-46ef-a5f1-dae4372f6256",
"timestamp": 1783470082999
},
{
"data": {
"nodeType": "merge"
},
"event": "node_start",
"nodeId": "6ab194a9-b869-4296-aea9-19afcbffc0d7",
"timestamp": 1783470083002
},
{
"data": {
"inputCount": 2
},
"event": "merged 2 inputs",
"nodeId": "merge",
"timestamp": 1783470083002
},
{
"data": {
"status": "ok",
"nodeType": "merge"
},
"event": "node_end",
"nodeId": "6ab194a9-b869-4296-aea9-19afcbffc0d7",
"timestamp": 1783470083002
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "fd9026ef-e993-410a-87d6-40a3ad10b7a7",
"timestamp": 1783470083008
},
{
"data": {
"inputKeys": [
"0",
"1"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470083008
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "fd9026ef-e993-410a-87d6-40a3ad10b7a7",
"timestamp": 1783470083008
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "0570d531-8480-4446-8f02-18640b4b891e",
"timestamp": 1783470083008
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading 'p_scores')",
"nodeId": "code",
"timestamp": 1783470083010
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470083010
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "0570d531-8480-4446-8f02-18640b4b891e",
"timestamp": 1783470083011
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "85536931-839a-476b-b0dd-fa6d01c6d5c1",
"timestamp": 1783470083011
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading 'z_scores')",
"nodeId": "code",
"timestamp": 1783470083012
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470083012
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "85536931-839a-476b-b0dd-fa6d01c6d5c1",
"timestamp": 1783470083013
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "0bdb9732-67ef-440d-bdd2-42c4f64ff6b6",
"timestamp": 1783470083014
},
{
"data": {
"inputKeys": [
"0",
"1"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470083014
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "0bdb9732-67ef-440d-bdd2-42c4f64ff6b6",
"timestamp": 1783470083014
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "957b9f6c-7cf8-4ec6-aec7-a7d59ed3a4ad",
"timestamp": 1783470083016
},
{
"data": {
"inputKeys": [
"0",
"1"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470083016
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "957b9f6c-7cf8-4ec6-aec7-a7d59ed3a4ad",
"timestamp": 1783470083016
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "ede1931e-bac8-4279-b3a7-5980a190e324",
"timestamp": 1783470083018
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "quickchart",
"latencyMs": 250,
"operation": "run",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470083270
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "ede1931e-bac8-4279-b3a7-5980a190e324",
"timestamp": 1783470083270
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "a39cdbe7-d6ae-4a84-98c7-52ebf98242f3",
"timestamp": 1783470083276
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470083277
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470083277
},
{
"data": {
"model": "gemini-2.5-flash",
"costUsd": 0.0009194,
"provider": "openai",
"latencyMs": 2167,
"promptTokens": 123,
"completionTokens": 353
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783470085445
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "a39cdbe7-d6ae-4a84-98c7-52ebf98242f3",
"timestamp": 1783470085445
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "a937132c-43fc-4fa0-ae35-885da89e51d1",
"timestamp": 1783470085450
},
{
"event": "fetching GET https://quickchart.io/chart",
"nodeId": "http",
"timestamp": 1783470085450
},
{
"data": {
"url": "https://quickchart.io/chart",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470085450
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470085651
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "a937132c-43fc-4fa0-ae35-885da89e51d1",
"timestamp": 1783470085651
}
]