AI Glassdoor Review Analysis for Workplace Discrimination Patterns
4d433fa2-f835-46a5-9b82-05619c78db1d
Latency
21596ms
Cost
$0.0086
Tokens
3,537
Status
successgemini-3-flash-preview
Workflow Graph
Trace
[
{
"data": {
"nodeType": "manualTrigger"
},
"event": "node_start",
"nodeId": "b508ab50-158a-4cbf-a52e-f53e1804e770",
"timestamp": 1783470086494
},
{
"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": 1783470086494
},
{
"data": {
"status": "ok",
"nodeType": "manualTrigger"
},
"event": "node_end",
"nodeId": "b508ab50-158a-4cbf-a52e-f53e1804e770",
"timestamp": 1783470086494
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "11a1a2d5-a274-44f7-97ca-5666a59fcb31",
"timestamp": 1783470086499
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470086499
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470086499
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0021853000000000003,
"provider": "openai",
"latencyMs": 5003,
"promptTokens": 1,
"completionTokens": 874
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783470091504
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "11a1a2d5-a274-44f7-97ca-5666a59fcb31",
"timestamp": 1783470091504
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "395f7b67-c914-4aae-8727-0573fdbfc6ad",
"timestamp": 1783470091517
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470091517
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470091517
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0025503,
"provider": "openai",
"latencyMs": 5719,
"promptTokens": 1,
"completionTokens": 1020
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783470097238
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "395f7b67-c914-4aae-8727-0573fdbfc6ad",
"timestamp": 1783470097238
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "1eba1dd7-a164-4c70-8c75-759532bd16a0",
"timestamp": 1783470097243
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470097243
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470097243
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0009427999999999999,
"provider": "openai",
"latencyMs": 2327,
"promptTokens": 1,
"completionTokens": 377
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783470099571
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "1eba1dd7-a164-4c70-8c75-759532bd16a0",
"timestamp": 1783470099571
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "f25f1b07-cded-4ca7-9655-8b8f463089ab",
"timestamp": 1783470099575
},
{
"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": 1783470099575
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "f25f1b07-cded-4ca7-9655-8b8f463089ab",
"timestamp": 1783470099575
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "87264a93-ab97-4e39-8d40-43365189f704",
"timestamp": 1783470099578
},
{
"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": 1783470099578
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "87264a93-ab97-4e39-8d40-43365189f704",
"timestamp": 1783470099578
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "862f1c77-44a8-4d79-abac-33351ebb731b",
"timestamp": 1783470099581
},
{
"event": "fetching GET https://app.scrapingbee.com/api/v1",
"nodeId": "http",
"timestamp": 1783470099581
},
{
"data": {
"url": "https://app.scrapingbee.com/api/v1",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470099581
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470100032
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "862f1c77-44a8-4d79-abac-33351ebb731b",
"timestamp": 1783470100032
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "4c9bf05e-9c50-4895-b20b-b7c329104615",
"timestamp": 1783470100038
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470100038
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "4c9bf05e-9c50-4895-b20b-b7c329104615",
"timestamp": 1783470100038
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "d20bb0e7-4ca7-41d0-a3e9-41abc811b064",
"timestamp": 1783470100041
},
{
"event": "fetching GET https://app.scrapingbee.com/api/v1",
"nodeId": "http",
"timestamp": 1783470100041
},
{
"data": {
"url": "https://app.scrapingbee.com/api/v1",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470100041
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470100190
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "d20bb0e7-4ca7-41d0-a3e9-41abc811b064",
"timestamp": 1783470100190
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "fce70cab-8ce3-4ce2-b040-ce80d66b1e62",
"timestamp": 1783470100195
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470100195
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "fce70cab-8ce3-4ce2-b040-ce80d66b1e62",
"timestamp": 1783470100195
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "d2e7fee9-e3d4-42bf-8be6-38b352371273",
"timestamp": 1783470100201
},
{
"event": "fetching GET https://app.scrapingbee.com/api/v1",
"nodeId": "http",
"timestamp": 1783470100201
},
{
"data": {
"url": "https://app.scrapingbee.com/api/v1",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470100201
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470100350
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "d2e7fee9-e3d4-42bf-8be6-38b352371273",
"timestamp": 1783470100350
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "851305ba-0837-4be9-943d-7282e8d74aee",
"timestamp": 1783470100356
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470100356
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "851305ba-0837-4be9-943d-7282e8d74aee",
"timestamp": 1783470100356
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "0c322823-0569-4bd5-9c4e-af3de0f8d7b4",
"timestamp": 1783470100360
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1783470100360
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "0c322823-0569-4bd5-9c4e-af3de0f8d7b4",
"timestamp": 1783470100360
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "ae164f6e-04e7-4d8b-951e-a17085956f4b",
"timestamp": 1783470100364
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470100364
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470100364
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0014453,
"provider": "openai",
"latencyMs": 2911,
"promptTokens": 1,
"completionTokens": 578
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783470103277
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "ae164f6e-04e7-4d8b-951e-a17085956f4b",
"timestamp": 1783470103277
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "cf9a6ee2-53b5-4fbf-a36c-4b9dab53b795",
"timestamp": 1783470103285
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470103285
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470103285
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0006628,
"provider": "openai",
"latencyMs": 2026,
"promptTokens": 1,
"completionTokens": 265
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783470105313
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "cf9a6ee2-53b5-4fbf-a36c-4b9dab53b795",
"timestamp": 1783470105313
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "c8d9e45c-7d41-47bd-b9a9-0fa70de5d154",
"timestamp": 1783470105320
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470105320
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "c8d9e45c-7d41-47bd-b9a9-0fa70de5d154",
"timestamp": 1783470105320
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "8ea03017-d5d6-46ef-a5f1-dae4372f6256",
"timestamp": 1783470105327
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470105327
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "8ea03017-d5d6-46ef-a5f1-dae4372f6256",
"timestamp": 1783470105327
},
{
"data": {
"nodeType": "merge"
},
"event": "node_start",
"nodeId": "6ab194a9-b869-4296-aea9-19afcbffc0d7",
"timestamp": 1783470105330
},
{
"data": {
"inputCount": 2
},
"event": "merged 2 inputs",
"nodeId": "merge",
"timestamp": 1783470105330
},
{
"data": {
"status": "ok",
"nodeType": "merge"
},
"event": "node_end",
"nodeId": "6ab194a9-b869-4296-aea9-19afcbffc0d7",
"timestamp": 1783470105330
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "fd9026ef-e993-410a-87d6-40a3ad10b7a7",
"timestamp": 1783470105338
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470105338
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "fd9026ef-e993-410a-87d6-40a3ad10b7a7",
"timestamp": 1783470105338
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "0570d531-8480-4446-8f02-18640b4b891e",
"timestamp": 1783470105338
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading 'p_scores')",
"nodeId": "code",
"timestamp": 1783470105341
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470105341
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "0570d531-8480-4446-8f02-18640b4b891e",
"timestamp": 1783470105341
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "85536931-839a-476b-b0dd-fa6d01c6d5c1",
"timestamp": 1783470105341
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading 'z_scores')",
"nodeId": "code",
"timestamp": 1783470105344
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470105344
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "85536931-839a-476b-b0dd-fa6d01c6d5c1",
"timestamp": 1783470105344
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "0bdb9732-67ef-440d-bdd2-42c4f64ff6b6",
"timestamp": 1783470105348
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470105348
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "0bdb9732-67ef-440d-bdd2-42c4f64ff6b6",
"timestamp": 1783470105348
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "957b9f6c-7cf8-4ec6-aec7-a7d59ed3a4ad",
"timestamp": 1783470105350
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783470105350
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "957b9f6c-7cf8-4ec6-aec7-a7d59ed3a4ad",
"timestamp": 1783470105350
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "ede1931e-bac8-4279-b3a7-5980a190e324",
"timestamp": 1783470105352
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "quickchart",
"latencyMs": 250,
"operation": "run",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470105604
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "ede1931e-bac8-4279-b3a7-5980a190e324",
"timestamp": 1783470105604
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "a39cdbe7-d6ae-4a84-98c7-52ebf98242f3",
"timestamp": 1783470105611
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783470105611
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783470105611
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0007744,
"provider": "openai",
"latencyMs": 2303,
"promptTokens": 123,
"completionTokens": 295
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783470107915
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "a39cdbe7-d6ae-4a84-98c7-52ebf98242f3",
"timestamp": 1783470107915
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "a937132c-43fc-4fa0-ae35-885da89e51d1",
"timestamp": 1783470107920
},
{
"event": "fetching GET https://quickchart.io/chart",
"nodeId": "http",
"timestamp": 1783470107921
},
{
"data": {
"url": "https://quickchart.io/chart",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783470107921
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "http-400",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783470108090
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "a937132c-43fc-4fa0-ae35-885da89e51d1",
"timestamp": 1783470108090
}
]