sitearea_footfallcounting_minuto
| Descripción | Almacenar nivel de minutos people counting datos |
| Nombre del cubo | sitearea_footfallcounting_minuto |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'minuto'. minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
sitearea_footfallcounting_hora
| Descripción | Nivel de horas de tienda people counting datos |
| Nombre del cubo | sitearea_footfallcounting_hora |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
sitegroup_footfallcounting_day
| Descripción | Nivel de día del grupo de sitios people counting datos |
| Nombre del cubo | sitegroup_footfallcounting_day |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'día'. día semana mes año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
sitegroup_footfallcounting_hour
| Descripción | Nivel de horas del grupo de sitios people counting datos |
| Nombre del cubo | sitegroup_footfallcounting_hour |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
site_footfallcounting_15minuto
| Descripción | Almacenar el nivel de minutos del sitio people counting datos que acumularon hasta 15 minutos |
| Nombre del cubo | site_footfallcounting_15minuto |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'minuto'. minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"site_footfallcounting_15minute.FC01_1_SUM",
"site_footfallcounting_15minute.FC02_1_SUM",
"site_footfallcounting_15minute.SO01_1_SUM"
],
"dimensiones": [
"site_footfallcounting_15minute.CompanyId",
"site_footfallcounting_15minute.CompanyName",
"site_footfallcounting_15minute.BranchId",
"site_footfallcounting_15minute.BranchName"
],
"filtros": [
{
"miembro": "site_footfallcounting_15minute.CompanyId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "site_footfallcounting_15minute.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "site_footfallcounting_15minute.isoperating",
"operador": "igual",
"valores": [
"cierto"
]
},
{
"miembro": "site_footfallcounting_15minute.IsSiteVerificado",
"operador": "igual",
"valores": [
"cierto"
]
}
],
"timeDimensions": [
{
"dimensión": "site_footfallcounting_15minute.Time",
"rango de fechas": [
"2022-01-01T00:00:00.000",
"2022-01-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"site_footfallcounting_15minute.BranchId",
"asc"
],
[
"site_footfallcounting_15minute.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_footfallcounting_15minute.CompanyId": "12345",
"site_footfallcounting_15minute.CompanyName": "DemoCompany",
"site_footfallcounting_15minute.BranchId": "22222",
"site_footfallcounting_15minute.BranchName": "Sucursal de demostración",
"site_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
"site_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
"site_footfallcounting_15minute.FC01_1_SUM": 0,
"site_footfallcounting_15minute.FC02_1_SUM": 0,
"site_footfallcounting_15minute.SO01_1_SUM": 0
},
{
"site_footfallcounting_15minute.CompanyId": "12345",
"site_footfallcounting_15minute.CompanyName": "DemoCompany",
"site_footfallcounting_15minute.BranchId": "22222",
"site_footfallcounting_15minute.BranchName": "Sucursal de demostración",
"site_footfallcounting_15minute.Time.minute": "2022-01-01T09:00:00.000",
"site_footfallcounting_15minute.Time": "2022-01-01T09:00:00.000",
"site_footfallcounting_15minute.FC01_1_SUM": 5,
"site_footfallcounting_15minute.FC02_1_SUM": 2,
"site_footfallcounting_15minute.SO01_1_SUM": 1
},
{
"site_footfallcounting_15minute.CompanyId": "12345",
"site_footfallcounting_15minute.CompanyName": "DemoCompany",
"site_footfallcounting_15minute.BranchId": "22222",
"site_footfallcounting_15minute.BranchName": "Sucursal de demostración",
"site_footfallcounting_15minute.Time.minute": "2022-01-01T09:30:00.000",
"site_footfallcounting_15minute.Time": "2022-01-01T09:30:00.000",
"site_footfallcounting_15minute.FC01_1_SUM": 3,
"site_footfallcounting_15minute.FC02_1_SUM": 4,
"site_footfallcounting_15minute.SO01_1_SUM": 0
}
],
...
}
|
site_footfallcounting_30minuto
| Descripción | Almacenar el nivel de minutos del sitio people counting datos que acumularon hasta 30 minutos |
| Nombre del cubo | site_footfallcounting_30minuto |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'minuto'. minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"site_footfallcounting_30minute.FC01_1_SUM",
"site_footfallcounting_30minute.FC02_1_SUM"
],
"dimensiones": [
"site_footfallcounting_30minute.CompanyId",
"site_footfallcounting_30minute.CompanyName",
"site_footfallcounting_30minute.BranchId",
"site_footfallcounting_30minute.BranchName"
],
"filtros": [
{
"miembro": "site_footfallcounting_30minute.CompanyId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "site_footfallcounting_30minute.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "site_footfallcounting_30minute.isoperating",
"operador": "igual",
"valores": [
"cierto"
]
}
],
"timeDimensions": [
{
"dimensión": "site_footfallcounting_30minute.Time",
"rango de fechas": [
"2022-01-01T00:00:00.000",
"2022-01-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"site_footfallcounting_30minute.BranchId",
"asc"
],
[
"site_footfallcounting_30minute.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_footfallcounting_30minute.CompanyId": "12345",
"site_footfallcounting_30minute.CompanyName": "DemoCompany",
"site_footfallcounting_30minute.BranchId": "22222",
"site_footfallcounting_30minute.BranchName": "Sucursal de demostración",
"site_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
"site_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
"site_footfallcounting_30minute.FC01_1_SUM": 0,
"site_footfallcounting_30minute.FC02_1_SUM": 0
},
{
"site_footfallcounting_30minute.CompanyId": "12345",
"site_footfallcounting_30minute.CompanyName": "DemoCompany",
"site_footfallcounting_30minute.BranchId": "22222",
"site_footfallcounting_30minute.BranchName": "Sucursal de demostración",
"site_footfallcounting_30minute.Time.minute": "2022-01-01T09:00:00.000",
"site_footfallcounting_30minute.Time": "2022-01-01T09:00:00.000",
"site_footfallcounting_30minute.FC01_1_SUM": 5,
"site_footfallcounting_30minute.FC02_1_SUM": 2
},
{
"site_footfallcounting_30minute.CompanyId": "12345",
"site_footfallcounting_30minute.CompanyName": "DemoCompany",
"site_footfallcounting_30minute.BranchId": "22222",
"site_footfallcounting_30minute.BranchName": "Sucursal de demostración",
"site_footfallcounting_30minute.Time.minute": "2022-01-01T09:30:00.000",
"site_footfallcounting_30minute.Time": "2022-01-01T09:30:00.000",
"site_footfallcounting_30minute.FC01_1_SUM": 3,
"site_footfallcounting_30minute.FC02_1_SUM": 4
}
],
...
}
|
area_footfallcounting_15minuto
| Descripción | Nivel de minutos del área de almacenamiento people counting datos que acumularon hasta 15 minutos |
| Nombre del cubo | area_footfallcounting_15minuto |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'minuto'. minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"area_footfallcounting_15minute.FC01_1_SUM",
"area_footfallcounting_15minute.FC02_1_SUM",
"area_footfallcounting_15minute.SO01_1_SUM"
],
"dimensiones": [
"area_footfallcounting_15minute.CompanyId",
"area_footfallcounting_15minute.CompanyName",
"area_footfallcounting_15minute.BranchId",
"area_footfallcounting_15minute.BranchName",
"area_footfallcounting_15minute.AreaId",
"area_footfallcounting_15minute.AreaName"
],
"filtros": [
{
"miembro": "area_footfallcounting_15minute.CompanyId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "area_footfallcounting_15minute.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "area_footfallcounting_15minute.isoperating",
"operador": "igual",
"valores": [
"cierto"
]
}
],
"timeDimensions": [
{
"dimensión": "area_footfallcounting_15minute.Time",
"rango de fechas": [
"2022-01-01T00:00:00.000",
"2022-01-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"area_footfallcounting_15minute.BranchId",
"asc"
],
[
"area_footfallcounting_15minute.AreaId",
"asc"
],
[
"area_footfallcounting_15minute.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"area_footfallcounting_15minute.CompanyId": "12345",
"area_footfallcounting_15minute.CompanyName": "DemoCompany",
"area_footfallcounting_15minute.BranchId": "22222",
"area_footfallcounting_15minute.BranchName": "Sucursal de demostración",
"area_footfallcounting_15minute.AreaId": "-1",
"area_footfallcounting_15minute.AreaName": nulo,
"area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
"area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
"area_footfallcounting_15minute.FC01_1_SUM": 0,
"area_footfallcounting_15minute.FC02_1_SUM": 0,
"area_footfallcounting_15minute.SO01_1_SUM": 0
},
{
"area_footfallcounting_15minute.CompanyId": "12345",
"area_footfallcounting_15minute.CompanyName": "DemoCompany",
"area_footfallcounting_15minute.BranchId": "22222",
"area_footfallcounting_15minute.BranchName": "Sucursal de demostración",
"area_footfallcounting_15minute.AreaId": "10101",
"area_footfallcounting_15minute.AreaName": "DemoArea1",
"area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
"area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
"area_footfallcounting_15minute.FC01_1_SUM": 0,
"area_footfallcounting_15minute.FC02_1_SUM": 0,
"area_footfallcounting_15minute.SO01_1_SUM": 0
},
{
"area_footfallcounting_15minute.CompanyId": "12345",
"area_footfallcounting_15minute.CompanyName": "DemoCompany",
"area_footfallcounting_15minute.BranchId": "22222",
"area_footfallcounting_15minute.BranchName": "Sucursal de demostración",
"area_footfallcounting_15minute.AreaId": "20202",
"area_footfallcounting_15minute.AreaName": "DemoArea2",
"area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
"area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
"area_footfallcounting_15minute.FC01_1_SUM": 0,
"area_footfallcounting_15minute.FC02_1_SUM": 0,
"area_footfallcounting_15minute.SO01_1_SUM": 0
}
],
...
}
|
area_footfallcounting_30minuto
| Descripción | Nivel de minutos del área de almacenamiento people counting datos que acumularon hasta 30 minutos |
| Nombre del cubo | area_footfallcounting_30minuto |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'minuto'. minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"area_footfallcounting_30minute.FC01_1_SUM",
"area_footfallcounting_30minute.FC02_1_SUM"
],
"dimensiones": [
"area_footfallcounting_30minute.CompanyId",
"area_footfallcounting_30minute.CompanyName",
"area_footfallcounting_30minute.BranchId",
"area_footfallcounting_30minute.BranchName",
"area_footfallcounting_30minute.AreaId",
"area_footfallcounting_30minute.AreaName"
],
"filtros": [
{
"miembro": "area_footfallcounting_30minute.CompanyId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "area_footfallcounting_30minute.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "area_footfallcounting_30minute.isoperating",
"operador": "igual",
"valores": [
"cierto"
]
}
],
"timeDimensions": [
{
"dimensión": "area_footfallcounting_30minute.Time",
"rango de fechas": [
"2022-01-01T00:00:00.000",
"2022-01-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"area_footfallcounting_30minute.BranchId",
"asc"
],
[
"area_footfallcounting_30minute.AreaId",
"asc"
],
[
"area_footfallcounting_30minute.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"area_footfallcounting_30minute.CompanyId": "12345",
"area_footfallcounting_30minute.CompanyName": "DemoCompany",
"area_footfallcounting_30minute.BranchId": "22222",
"area_footfallcounting_30minute.BranchName": "Sucursal de demostración",
"area_footfallcounting_30minute.AreaId": "-1",
"area_footfallcounting_30minute.AreaName": nulo,
"area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
"area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
"area_footfallcounting_30minute.FC01_1_SUM": 0,
"area_footfallcounting_30minute.FC02_1_SUM": 0
},
{
"area_footfallcounting_30minute.CompanyId": "12345",
"area_footfallcounting_30minute.CompanyName": "DemoCompany",
"area_footfallcounting_30minute.BranchId": "22222",
"area_footfallcounting_30minute.BranchName": "Sucursal de demostración",
"area_footfallcounting_30minute.AreaId": "10101",
"area_footfallcounting_30minute.AreaName": "DemoArea1",
"area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
"area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
"area_footfallcounting_30minute.FC01_1_SUM": 0,
"area_footfallcounting_30minute.FC02_1_SUM": 0
},
{
"area_footfallcounting_30minute.CompanyId": "12345",
"area_footfallcounting_30minute.CompanyName": "DemoCompany",
"area_footfallcounting_30minute.BranchId": "22222",
"area_footfallcounting_30minute.BranchName": "Sucursal de demostración",
"area_footfallcounting_30minute.AreaId": "20202",
"area_footfallcounting_30minute.AreaName": "DemoArea2",
"area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
"area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
"area_footfallcounting_30minute.FC01_1_SUM": 0,
"area_footfallcounting_30minute.FC02_1_SUM": 0
}
],
...
}
|
sitearea_footfallcounting_minuto_accumulate
| Descripción | Almacenar nivel de minutos people counting datos acumulados |
| Nombre del cubo | sitearea_footfallcounting_minuto_accumulate |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'minuto'. minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"sitearea_footfallcounting_minute_accumulate.SO05_1_MAX"
],
"dimensiones": [
"sitearea_footfallcounting_minute_accumulate.CompanyId",
"sitearea_footfallcounting_minute_accumulate.CompanyName",
"sitearea_footfallcounting_minute_accumulate.BranchId",
"sitearea_footfallcounting_minute_accumulate.BranchName",
"sitearea_footfallcounting_minute_accumulate.AreaId",
"sitearea_footfallcounting_minute_accumulate.AreaName"
],
"filtros": [
{
"miembro": "sitearea_footfallcounting_minute_accumulate.BranchId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "sitearea_footfallcounting_minute_accumulate.AreaId",
"operador": "igual",
"valores": [
"1111"
]
}
],
"timeDimensions": [
{
"dimensión": "sitearea_footfallcounting_minute_accumulate.Time",
"rango de fechas": [
"2022-02-01T00:00:00.000",
"2022-02-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"sitearea_footfallcounting_minute_accumulate.Time",
"desc"
]
],
"límite": 1
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"sitearea_footfallcounting_minute_accumulate.CompanyId": "10101",
"sitearea_footfallcounting_minute_accumulate.CompanyName": "DemoCompany",
"sitearea_footfallcounting_minute_accumulate.BranchId": "12345",
"sitearea_footfallcounting_minute_accumulate.BranchName": "DemoBranch",
"sitearea_footfallcounting_minute_accumulate.AreaId": "1111",
"sitearea_footfallcounting_minute_accumulate.AreaName": "Área de demostración",
"sitearea_footfallcounting_minute_accumulate.Time.minute": "2022-02-01T23:50:00.000",
"sitearea_footfallcounting_minute_accumulate.Time": "2022-02-01T23:50:00.000",
"sitearea_footfallcounting_minute_accumulate.SO05_1_MAX": 84
}
],
...
}
|
sitearea_buscounting_minuto
| Descripción | Almacenar datos de conteo de autobuses a nivel de minutos del sitio y del área |
| Nombre del cubo | sitearea_buscounting_minuto |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'minuto'. minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON | { "consulta": { "medidas": [ "sitearea_buscounting_minute.FC01_1_SUM", "sitearea_buscounting_minute.FC02_1_SUM", "sitearea_buscounting_minute.SO01_1_SUM" ], "dimensiones": [ "sitearea_buscounting_minute.TripId", "sitearea_buscounting_minute.ScheduledStartTime", "sitearea_buscounting_minute.Time", "sitearea_buscounting_minute.ActualArrivalDateTime", "sitearea_buscounting_minute.CompanyId", "sitearea_buscounting_minute.CompanyName", "sitearea_buscounting_minute.BranchId", "sitearea_buscounting_minute.BranchName", "sitearea_buscounting_minute.AreaId", "sitearea_buscounting_minute.AreaName" ], "timeDimensions": [ { "dimensión": "sitearea_buscounting_minute.Time", "rango de fechas": [ "2022-03-10T00:00:00.000", "2022-03-11" ], "granularidad": "minuto" } ], "filtros": [ { "miembro": "sitearea_buscounting_minute.CompanyId", "operador": "igual", "valores": [ "12345" ] }, { "miembro": "sitearea_buscounting_minute.BranchId", "operador": "igual", "valores": [ "11111", "22222" ] }, { "miembro": "sitearea_buscounting_minute.AreaId", "operador": "igual", "valores": [ "1101", "2202" ] }, { "miembro": "sitearea_buscounting_minute.AreaName", "operador": "igual", "valores": [ "Área1", "Área2" ] } ], "pedido": [ [ "sitearea_buscounting_minute.TripId", "asc" ], [ "sitearea_buscounting_minute.AreaId", "asc" ], [ "sitearea_buscounting_minute.ScheduledStartTime", "asc" ] ] } } |
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7",
"sitearea_buscounting_minute.StationId": "61025D6D-94A9-4DDE-AE23-BAD5D93BCC03",
"sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:12:00.000",
"sitearea_buscounting_minute.Time": "2022-03-10T18:18:46.000",
"sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:18:46.000",
"sitearea_buscounting_minute.CompanyId": 12345,
"sitearea_buscounting_minute.CompanyName": "Empresa1",
"sitearea_buscounting_minute.BranchId": 11111,
"sitearea_buscounting_minute.BranchName": "Sucursal1",
"sitearea_buscounting_minute.AreaId": 1101,
"sitearea_buscounting_minute.AreaName": "Área1",
"sitearea_buscounting_minute.Time.minute": "2022-03-10T18:18:00.000",
"sitearea_buscounting_minute.FC01_1_SUM": 8,
"sitearea_buscounting_minute.FC02_1_SUM": 6,
"sitearea_buscounting_minute.SO01_1_SUM": 2
},
{
"sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7",
"sitearea_buscounting_minute.StationId": "2D931974-2423-457C-B057-92BD31B5E9FF",
"sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:14:00.000",
"sitearea_buscounting_minute.Time": "2022-03-10T18:21:10.000",
"sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:21:10.000",
"sitearea_buscounting_minute.CompanyId": 12345,
"sitearea_buscounting_minute.CompanyName": "Empresa1",
"sitearea_buscounting_minute.BranchId": 11111,
"sitearea_buscounting_minute.BranchName": "Sucursal1",
"sitearea_buscounting_minute.AreaId": 1101,
"sitearea_buscounting_minute.AreaName": "Área1",
"sitearea_buscounting_minute.Time.minute": "2022-03-10T18:21:00.000",
"sitearea_buscounting_minute.FC01_1_SUM": 0,
"sitearea_buscounting_minute.FC02_1_SUM": 0,
"sitearea_buscounting_minute.SO01_1_SUM": 2
},
{
"sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7",
"sitearea_buscounting_minute.StationId": "E24E9D16-D6D9-432D-ABC8-A9D71C1A4FB1",
"sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:15:00.000",
"sitearea_buscounting_minute.Time": "2022-03-10T18:22:02.000",
"sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:22:02.000",
"sitearea_buscounting_minute.CompanyId": 12345,
"sitearea_buscounting_minute.CompanyName": "Empresa1",
"sitearea_buscounting_minute.BranchId": 11111,
"sitearea_buscounting_minute.BranchName": "Sucursal1",
"sitearea_buscounting_minute.AreaId": 1101,
"sitearea_buscounting_minute.AreaName": "Área1",
"sitearea_buscounting_minute.Time.minute": "2022-03-10T18:22:00.000",
"sitearea_buscounting_minute.FC01_1_SUM": 3,
"sitearea_buscounting_minute.FC02_1_SUM": 0,
"sitearea_buscounting_minute.SO01_1_SUM": 5
}
],
...
}
|
site_area_1d_joined_data
| Descripción | Datos de sitio y área con diferentes métricas |
| Nombre del cubo |
site_area_1d_joined_data
|
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'día'. día semana mes año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Segmentos |
Segmentos disponibles para filtrar datos:
*La consulta de datos a nivel de sitio sin utilizar IsSiteLevel puede provocar que se devuelvan datos incorrectos. |
| Cuerpo - Ejemplo JSON | {
"consulta": {
"medidas": [
"site_area_1d_joined_data.PFC01_11",
"site_area_1d_joined_data.PWA01",
"site_area_1d_joined_data.SWA02",
"site_area_1d_joined_data.PFC27",
"site_area_1d_joined_data.SWA04",
"site_area_1d_joined_data.SWA06"
],
"dimensiones": [
"site_area_1d_joined_data.CompanyId",
"site_area_1d_joined_data.CompanyName",
"site_area_1d_joined_data.BranchId",
"site_area_1d_joined_data.BranchName",
"site_area_1d_joined_data.Hora"
],
"filtros": [
{
"miembro": "site_area_1d_joined_data.BranchId",
"operador": "igual",
"valores": [
"1"
]
}
],
"timeDimensions": [
{
"dimensión": "site_area_1d_joined_data.Time",
"rango de fechas": [
"2024-01-19T00:00:00.000000",
"2024-01-20T23:59:59.000000"
],
"granularidad": "día"
}
],
"segmentos": [
"site_area_1d_joined_data.IsSiteLevel"
],
"orden": {
"site_area_1d_joined_data.Time": "asc"
}
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos":
[
{
"site_area_1d_joined_data.CompanyId": 1,
"site_area_1d_joined_data.CompanyName": "Empresa de demostración",
"site_area_1d_joined_data.BranchId": 1,
"site_area_1d_joined_data.BranchName": "Centro comercial",
"site_area_1d_joined_data.Time": "2024-01-19T00:00:00.000",
"site_area_1d_joined_data.Time.day": "2024-01-19T00:00:00.000",
"site_area_1d_joined_data.PFC01_11": 4958,
"site_area_1d_joined_data.PWA01": 6060,
"site_area_1d_joined_data.SWA02": 0.45,
"site_area_1d_joined_data.PFC27": 1234.56,
"site_area_1d_joined_data.SWA04": 0.66,
"site_area_1d_joined_data.SWA06": 0.34
},
{
"site_area_1d_joined_data.CompanyId": 1,
"site_area_1d_joined_data.CompanyName": "Empresa de demostración",
"site_area_1d_joined_data.BranchId": 1,
"site_area_1d_joined_data.BranchName": "Centro comercial",
"site_area_1d_joined_data.Time": "2024-01-20T00:00:00.000",
"site_area_1d_joined_data.Time.day": "2024-01-20T00:00:00.000",
"site_area_1d_joined_data.PFC01_11": 4929,
"site_area_1d_joined_data.PWA01": 7070,
"site_area_1d_joined_data.SWA02": 0.41,
"site_area_1d_joined_data.PFC27": 706.61,
"site_area_1d_joined_data.SWA04": 0.21,
"site_area_1d_joined_data.SWA06": 0.79
}
],
...
}
|
site_area_1h_joined_data
| Descripción | Datos de sitio y área con diferentes métricas |
| Nombre del cubo |
site_area_1h_joined_data
|
| Granularidades de tiempo |
La granularidad de tiempo de este cubo es "hora". Utilice site_area_1d_joined_data para obtener granularidades de tiempo mayores. |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Segmentos |
Segmentos disponibles para filtrar datos:
*La consulta de datos a nivel de sitio sin utilizar IsSiteLevel puede provocar que se devuelvan datos incorrectos. |
| Cuerpo - Ejemplo JSON | {
"consulta": {
"medidas": [
"site_area_1h_joined_data.PFC01_11",
"site_area_1h_joined_data.PWA01",
"site_area_1h_joined_data.SWA02",
"site_area_1h_joined_data.PFC27"
],
"dimensiones": [
"site_area_1h_joined_data.CompanyId",
"site_area_1h_joined_data.CompanyName",
"site_area_1h_joined_data.BranchId",
"site_area_1h_joined_data.BranchName",
"site_area_1h_joined_data.Hora"
],
"filtros": [
{
"miembro": "site_area_1h_joined_data.BranchId",
"operador": "igual",
"valores": [
"25610"
]
}
],
"timeDimensions": [
{
"dimensión": "site_area_1h_joined_data.Time",
"rango de fechas": [
"2024-01-19T10:00:00.000000",
"2024-01-19T13:59:59.000000"
],
"granularidad": "hora"
}
],
"segmentos": [
"site_area_1h_joined_data.IsSiteLevel"
],
"orden": {
"site_area_1h_joined_data.Time": "asc"
}
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos":
[
{
"site_area_1h_joined_data.CompanyId": 1,
"site_area_1h_joined_data.CompanyName": "Empresa de demostración",
"site_area_1h_joined_data.BranchId": 1,
"site_area_1h_joined_data.BranchName": "Centro comercial",
"site_area_1h_joined_data.Time": "2024-01-19T10:00:00.000",
"site_area_1h_joined_data.Time.hour": "2024-01-19T10:00:00.000",
"site_area_1h_joined_data.PFC01_11": 325,
"site_area_1h_joined_data.PWA01": 101,
"site_area_1h_joined_data.SWA02": 0.76,
"site_area_1h_joined_data.PFC27": 310.20
},
{
"site_area_1h_joined_data.CompanyId": 18330,
"site_area_1h_joined_data.CompanyName": "Empresa de demostración",
"site_area_1h_joined_data.BranchId": 25610,
"site_area_1h_joined_data.BranchName": "Centro comercial",
"site_area_1h_joined_data.Time": "2024-01-19T11:00:00.000",
"site_area_1h_joined_data.Time.hour": "2024-01-19T11:00:00.000",
"site_area_1h_joined_data.PFC01_11": 440,
"site_area_1h_joined_data.PWA01": 202,
"site_area_1h_joined_data.SWA02": 0.69,
"site_area_1h_joined_data.PFC27": 322.21
},
...
],
...
}
|
datos_de_ocupación_del_área_del_sitio
| Descripción | Almacene los datos de ocupación del sitio y el área (sensación espacial) |
| Nombre del cubo | datos_de_ocupación_del_área_del_sitio |
| Granularidades de tiempo |
A continuación se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'segundo'. segundo, minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"site_area_occupancy_data.PSO05_MIN",
"site_area_occupancy_data.PSO05_MAX",
"site_area_occupancy_data.PSO05_AVG"
],
"dimensiones": [
"site_area_occupancy_data.CompanyId",
"site_area_occupancy_data.CompanyName", "site_area_occupancy_data.BranchId", "site_area_occupancy_data.BranchName", "site_area_occupancy_data.AreaId", "site_area_occupancy_data.AreaName" ],
"filtros": [
{
"miembro": "site_area_occupancy_data.CompanyId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "site_area_occupancy_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{ "miembro": "site_area_occupancy_data.AreaId", "operador": "igual", "valores": [ "33333" ] } ],
"timeDimensions": [
{
"dimensión": "site_area_occupancy_data.Time",
"rango de fechas": [
"2022-01-01T00:00:00.000",
"2022-01-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"site_area_occupancy_data.BranchId",
"asc"
],
[
"site_area_occupancy_data.Tiempo",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_area_occupancy_data.CompanyId": "12345",
"site_area_occupancy_data.CompanyName": "DemoCompany",
"site_area_occupancy_data.BranchId": "22222",
"site_area_occupancy_data.BranchName": "DemoBranch",
"site_area_occupancy_data.AreaId": "33333",
"site_area_occupancy_data.AreaName": "Área de demostración",
"site_area_occupancy_data.Time.minute": "2022-01-01T00:00:00.000",
"site_area_occupancy_data.Time": "2022-01-01T00:00:00.000",
"site_area_occupancy_data.PSO05_MIN": 1,
"site_area_occupancy_data.PSO05_MAX": 1,
"site_area_occupancy_data.PSO05_AVG": 1
},
{
"site_area_occupancy_data.CompanyId": "12345",
"site_area_occupancy_data.CompanyName": "DemoCompany",
"site_area_occupancy_data.BranchId": "22222",
"site_area_occupancy_data.BranchName": "DemoBranch",
"site_area_occupancy_data.AreaId": "33333",
"site_area_occupancy_data.AreaName": "Área de demostración",
"site_area_occupancy_data.Time.minute": "2022-01-01T09:27:00.000",
"site_area_occupancy_data.Time": "2022-01-01T09:27:00.000",
"site_area_occupancy_data.PSO05_MIN": 0,
"site_area_occupancy_data.PSO05_MAX": 1,
"site_area_occupancy_data.PSO05_AVG": 0.6666666666666666
},
{
"site_area_occupancy_data.CompanyId": "12345",
"site_area_occupancy_data.CompanyName": "DemoCompany",
"site_area_occupancy_data.BranchId": "22222",
"site_area_occupancy_data.BranchName": "DemoBranch",
"site_area_occupancy_data.AreaId": "33333",
"site_area_occupancy_data.AreaName": "Área de demostración",
"site_area_occupancy_data.Time.minute": "2022-01-01T09:30:00.000",
"site_area_occupancy_data.Time": "2022-01-01T09:30:00.000",
"site_area_occupancy_data.PSO05_MIN": 0,
"site_area_occupancy_data.PSO05_MAX": 2,
"site_area_occupancy_data.PSO05_AVG": 1.2
}
],
...
}
|
area_aggregate_occupancy_data_15m
| Descripción | Almacenar datos de ocupación del sitio y del área (entrada y salida) |
| Nombre del cubo | area_aggregate_occupancy_data_15m |
| Granularidades de tiempo |
A continuación se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es de 15 minutos (continúe usando "minuto" como valor para el parámetro de granularidad de la API). minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta":
{
"medidas": [
"area_aggregate_occupancy_data_15m.PSO05_MIN",
"area_aggregate_occupancy_data_15m.PSO05_MAX",
"area_aggregate_occupancy_data_15m.PSO05_AVG"
],
"dimensiones": [
"area_aggregate_occupancy_data_15m.CompanyId",
"area_aggregate_occupancy_data_15m.CompanyName",
"area_aggregate_occupancy_data_15m.BranchId",
"area_aggregate_occupancy_data_15m.BranchName",
"area_aggregate_occupancy_data_15m.AreaId",
"area_aggregate_occupancy_data_15m.AreaName"
],
"filtros": [
{
"miembro": "area_aggregate_occupancy_data_15m.AreaId",
"operador": "igual",
"valores": [
"333333"
]
}
],
"timeDimensions": [
{
"dimensión": "area_aggregate_occupancy_data_15m.Time",
"rango de fechas": [
"2024-01-01T00:00:00.000",
"2024-01-02"
],
"granularidad": "minuto"
}
],
"orden": [
[
"area_aggregate_occupancy_data_15m.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_area_occupancy_data.CompanyId": "12345",
"site_area_occupancy_data.CompanyName": "DemoCompany",
"site_area_occupancy_data.BranchId": "22222",
"site_area_occupancy_data.BranchName": "DemoBranch",
"site_area_occupancy_data.AreaId": "33333",
"site_area_occupancy_data.AreaName": "Área de demostración",
"site_area_occupancy_data.Time.minute": "2022-01-01T00:00:00.000",
"site_area_occupancy_data.Time": "2022-01-01T00:00:00.000",
"site_area_occupancy_data.PSO05_MIN": 1,
"site_area_occupancy_data.PSO05_MAX": 1,
"site_area_occupancy_data.PSO05_AVG": 1
},
{
"site_area_occupancy_data.CompanyId": "12345",
"site_area_occupancy_data.CompanyName": "DemoCompany",
"site_area_occupancy_data.BranchId": "22222",
"site_area_occupancy_data.BranchName": "DemoBranch",
"site_area_occupancy_data.AreaId": "33333",
"site_area_occupancy_data.AreaName": "Área de demostración",
"site_area_occupancy_data.Time.minute": "2022-01-01T00:15:00.000",
"site_area_occupancy_data.Time": "2022-01-01T00:15:00.000",
"site_area_occupancy_data.PSO05_MIN": 0,
"site_area_occupancy_data.PSO05_MAX": 1,
"site_area_occupancy_data.PSO05_AVG": 0.6666666666666666
},
{
"site_area_occupancy_data.CompanyId": "12345",
"site_area_occupancy_data.CompanyName": "DemoCompany",
"site_area_occupancy_data.BranchId": "22222",
"site_area_occupancy_data.BranchName": "DemoBranch",
"site_area_occupancy_data.AreaId": "33333",
"site_area_occupancy_data.AreaName": "Área de demostración",
"site_area_occupancy_data.Time.minute": "2022-01-01T00:15:00.000",
"site_area_occupancy_data.Time": "2022-01-01T00:15:00.000",
"site_area_occupancy_data.PSO05_MIN": 0,
"site_area_occupancy_data.PSO05_MAX": 2,
"site_area_occupancy_data.PSO05_AVG": 1.2
}
],
...
}
|
site_area_1h_queue_counting
| Descripción | Almacenar datos de conteo de colas de sitios y áreas |
| Nombre del cubo |
site_area_1h_queue_counting
|
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo, consulte Definición de métricas para detalles métricos
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"site_area_1h_queue_counting.PQM01_MIN",
"site_area_1h_queue_counting.PQM01_MAX",
"site_area_1h_queue_counting.PQM01_AVG",
"site_area_1h_queue_counting.PQM01_SUM",
"site_area_1h_queue_counting.PQM03_MIN",
"site_area_1h_queue_counting.PQM03_MAX",
"site_area_1h_queue_counting.PQM03_AVG",
"site_area_1h_queue_counting.PQM03_SUM",
"site_area_1h_queue_counting.PQM04_MIN",
"site_area_1h_queue_counting.PQM04_MAX",
"site_area_1h_queue_counting.PQM04_AVG",
"site_area_1h_queue_counting.PQM04_SUM"
],
"dimensiones": [
"site_area_1h_queue_counting.CompanyId",
"site_area_1h_queue_counting.CompanyName",
"site_area_1h_queue_counting.BranchId",
"site_area_1h_queue_counting.BranchName",
"site_area_1h_queue_counting.BranchCode",
"site_area_1h_queue_counting.AreaId",
"site_area_1h_queue_counting.AreaName",
"site_area_1h_queue_counting.IsOperating",
"site_area_1h_queue_counting.Tiempo"
],
"filtros": [
{
"miembro": "site_area_1h_queue_counting.CompanyId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "site_area_1h_queue_counting.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "site_area_1h_queue_counting.AreaId",
"operador": "igual",
"valores": [
"33333"
]
}
],
"timeDimensions": [
{
"dimensión": "site_area_1h_queue_counting.Time",
"rango de fechas": [
"2023-01-01T00:00:00.000",
"2023-01-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"site_area_1h_queue_counting.BranchId",
"asc"
],
[
"site_area_1h_queue_counting.Tiempo",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_area_1h_queue_counting.CompanyId": 12345,
"site_area_1h_queue_counting.CompanyName": "DemoCompany",
"site_area_1h_queue_counting.BranchId": 22222,
"site_area_1h_queue_counting.BranchName": "Sucursal de demostración",
"site_area_1h_queue_counting.BranchCode": "demostración",
"site_area_1h_queue_counting.AreaId": 33333,
"site_area_1h_queue_counting.AreaName": "Área de demostración",
"site_area_1h_queue_counting.IsOperating": 0,
"site_area_1h_queue_counting.Time": "2023-01-01T00:00:00.000",
"site_area_1h_queue_counting.PQM01_MIN": 6,
"site_area_1h_queue_counting.PQM01_MAX": 23,
"site_area_1h_queue_counting.PQM01_AVG": 19.3312,
"site_area_1h_queue_counting.PQM01_SUM": 23,
"site_area_1h_queue_counting.PQM03_MIN": 2,
"site_area_1h_queue_counting.PQM03_MAX": 23,
"site_area_1h_queue_counting.PQM03_AVG": 11.3434,
"site_area_1h_queue_counting.PQM03_SUM": 29,
"site_area_1h_queue_counting.PQM04_MIN": 2,
"site_area_1h_queue_counting.PQM04_MAX": 12,
"site_area_1h_queue_counting.PQM04_AVG": 11.2222,
"site_area_1h_queue_counting.PQM04_SUM": 12333
},
{
"site_area_1h_queue_counting.CompanyId": 12345,
"site_area_1h_queue_counting.CompanyName": "DemoCompany",
"site_area_1h_queue_counting.BranchId": 22222,
"site_area_1h_queue_counting.BranchName": "Sucursal de demostración",
"site_area_1h_queue_counting.BranchCode": "demostración",
"site_area_1h_queue_counting.AreaId": 33333,
"site_area_1h_queue_counting.AreaName": "Área de demostración",
"site_area_1h_queue_counting.IsOperating": 1,
"site_area_1h_queue_counting.Time": "2023-01-01T00:00:00.000",
"site_area_1h_queue_counting.PQM01_MIN": 0,
"site_area_1h_queue_counting.PQM01_MAX": 12,
"site_area_1h_queue_counting.PQM01_AVG": 14.433,
"site_area_1h_queue_counting.PQM01_SUM": 234,
"site_area_1h_queue_counting.PQM03_MIN": 1,
"site_area_1h_queue_counting.PQM03_MAX": 212,
"site_area_1h_queue_counting.PQM03_AVG": 12.3445,
"site_area_1h_queue_counting.PQM03_SUM": 123,
"site_area_1h_queue_counting.PQM04_MIN": 3,
"site_area_1h_queue_counting.PQM04_MAX": 33,
"site_area_1h_queue_counting.PQM04_AVG": 123,
"site_area_1h_queue_counting.PQM04_SUM": 1234
}
],
...
}
|
site_area_1h_demographic_data
| Descripción | Almacenar datos demográficos del sitio y del área |
| Nombre del cubo |
site_area_1h_demographic_data
|
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"site_area_1h_demographic_data.Gender_Male_SUM",
"site_area_1h_demographic_data.Gender_Female_SUM",
"site_area_1h_demographic_data.Emotion_Angry_SUM",
"site_area_1h_demographic_data.Emotion_Contempt_SUM",
"site_area_1h_demographic_data.Emotion_Disgust_SUM",
"site_area_1h_demographic_data.Emotion_Fear_SUM",
"site_area_1h_demographic_data.Emotion_Sad_SUM",
"site_area_1h_demographic_data.Emotion_Neutral_SUM",
"site_area_1h_demographic_data.Emotion_Happy_SUM",
"site_area_1h_demographic_data.Emotion_Surprised_SUM",
"site_area_1h_demographic_data.Children_Age",
"site_area_1h_demographic_data.Teenagers_Age",
"site_area_1h_demographic_data.Young_Adults_Age",
"site_area_1h_demographic_data.Middle_Aged_Adults_Age",
"site_area_1h_demographic_data.Elderly_Age",
"site_area_1h_demographic_data.Kids_And_Adults_Age"
],
"dimensiones": [
"site_area_1h_demographic_data.CompanyId",
"site_area_1h_demographic_data.CompanyName",
"site_area_1h_demographic_data.BranchId",
"site_area_1h_demographic_data.BranchName",
"site_area_1h_demographic_data.BranchCode",
"site_area_1h_demographic_data.AreaId",
"site_area_1h_demographic_data.AreaName",
"site_area_1h_demographic_data.IsOperating",
"site_area_1h_demographic_data.Time"
],
"filtros": [
{
"miembro": "site_area_1h_demographic_data.CompanyId",
"operador": "igual",
"valores": [
"12345"
]
},
{
"miembro": "site_area_1h_demographic_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "site_area_1h_demographic_data.AreaId",
"operador": "igual",
"valores": [
"33333"
]
}
],
"timeDimensions": [
{
"dimensión": "site_area_1h_demographic_data.Time",
"rango de fechas": [
"2023-01-01T00:00:00.000",
"2023-01-02"
],
"granularidad": "minuto"
}
],
"pedido": [
[
"site_area_1h_demographic_data.BranchId",
"asc"
],
[
"site_area_1h_demographic_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_area_1h_demographic_data.CompanyId": 12345,
"site_area_1h_demographic_data.CompanyName": "DemoCompany",
"site_area_1h_demographic_data.BranchId": 22222,
"site_area_1h_demographic_data.BranchName": "Sucursal de demostración",
"site_area_1h_demographic_data.AreaId": 33333,
"site_area_1h_demographic_data.AreaName": "Área de demostración",
"site_area_1h_demographic_data.IsOperating": 1,
"site_area_1h_demographic_data.Time": "2023-01-01T00:00:00.000",
"site_area_1h_demographic_data.Gender_Male_SUM": 22,
"site_area_1h_demographic_data.Gender_Female_SUM": 13,
"site_area_1h_demographic_data.Emotion_Angry_SUM": 1,
"site_area_1h_demographic_data.Emotion_Contempt_SUM": 0,
"site_area_1h_demographic_data.Emotion_Disgust_SUM": 4,
"site_area_1h_demographic_data.Emotion_Fear_SUM": 2,
"site_area_1h_demographic_data.Emotion_Sad_SUM": 4,
"site_area_1h_demographic_data.Emotion_Neutral_SUM": 3,
"site_area_1h_demographic_data.Emotion_Happy_SUM": 2,
"site_area_1h_demographic_data.Emotion_Surprised_SUM": 5,
"site_area_1h_demographic_data.Children_Age": 4,
"site_area_1h_demographic_data.Teenagers_Age": 392,
"site_area_1h_demographic_data.Young_Adults_Age": 12,
"site_area_1h_demographic_data.Middle_Aged_Adults_Age": 14,
"site_area_1h_demographic_data.Elderly_Age": 2,
"site_area_1h_demographic_data.Kids_And_Adults_Age": 16
},
{
"site_area_1h_demographic_data.CompanyId": 12345,
"site_area_1h_demographic_data.CompanyName": "DemoCompany",
"site_area_1h_demographic_data.BranchId": 22222,
"site_area_1h_demographic_data.BranchName": "Sucursal de demostración",
"site_area_1h_demographic_data.AreaId": 33333,
"site_area_1h_demographic_data.AreaName": "Área de demostración",
"site_area_1h_demographic_data.IsOperating": 1,
"site_area_1h_demographic_data.Time": "2023-01-02T00:00:00.000",
"site_area_1h_demographic_data.Gender_Male_SUM": 14,
"site_area_1h_demographic_data.Gender_Female_SUM": 17,
"site_area_1h_demographic_data.Emotion_Angry_SUM": 0,
"site_area_1h_demographic_data.Emotion_Contempt_SUM": 3,
"site_area_1h_demographic_data.Emotion_Disgust_SUM": 2,
"site_area_1h_demographic_data.Emotion_Fear_SUM": 3,
"site_area_1h_demographic_data.Emotion_Sad_SUM": 3,
"site_area_1h_demographic_data.Emotion_Neutral_SUM": 4,
"site_area_1h_demographic_data.Emotion_Happy_SUM": 7,
"site_area_1h_demographic_data.Emotion_Surprised_SUM": 8,
"site_area_1h_demographic_data.Children_Age": 22,
"site_area_1h_demographic_data.Teenagers_Age": 12,
"site_area_1h_demographic_data.Young_Adults_Age": 78,
"site_area_1h_demographic_data.Middle_Aged_Adults_Age": 22,
"site_area_1h_demographic_data.Elderly_Age": 10,
"site_area_1h_demographic_data.Kids_And_Adults_Age": 100
}
],
...
}
|
área_ocupación_en vivo
| Descripción | Recuento de ocupación en vivo del sitio y el área de la tienda |
| Nombre del cubo |
área_ocupación_en vivo
|
| Granularidades de tiempo |
No se necesitan granularidades de tiempo para datos en vivo |
| Medidas |
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"area_occupancy_live.PSO05"
],
"dimensiones": [
"area_occupancy_live.CompanyId",
"area_occupancy_live.CompanyName",
"area_occupancy_live.BranchId",
"area_occupancy_live.BranchName",
"area_occupancy_live.AreaId",
"area_occupancy_live.AreaName",
"area_occupancy_live.AreaType"
],
"filtros": [
{
"miembro": "area_occupancy_live.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "area_occupancy_live.AreaId",
"operador": "igual",
"valores": [
"33333",
"44444"
]
}
],
"pedido": [
[
"area_occupancy_live.BranchId",
"asc"
],
[
"area_occupancy_live.Tiempo",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"area_occupancy_live.CompanyId": 12345,
"area_occupancy_live.CompanyName": "DemoCompany",
"area_occupancy_live.BranchId": 11111,
"area_occupancy_live.BranchName": "Sucursal de demostración",
"area_occupancy_live.AreaId": 33333,
"area_occupancy_live.AreaName": "Área de demostración",
"area_occupancy_live.AreaType": 1,
"area_occupancy_live.PSO05": 5632
},
{
"area_occupancy_live.CompanyId": 12345,
"area_occupancy_live.CompanyName": "DemoCompany",
"area_occupancy_live.BranchId": 22222,
"area_occupancy_live.BranchName": "Sucursal de demostración",
"area_occupancy_live.AreaId": 44444,
"area_occupancy_live.AreaName": "Área de demostración",
"area_occupancy_live.AreaType": 1,
"area_occupancy_live.PSO05": 2224
}
],
...
}
|
site_area_1d_kid_counting_data
| Descripción | Almacene datos de conteo de niños y adultos del sitio y el área |
| Nombre del cubo |
site_area_1d_kid_counting_data
|
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'día'. día semana mes año |
| Medidas |
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"site_area_1d_kid_counting_data.PFC01_3001",
"site_area_1d_kid_counting_data.PFC02_3001",
"site_area_1d_kid_counting_data.PFC01_5001",
"site_area_1d_kid_counting_data.PFC02_5001"
],
"dimensiones": [
"site_area_1d_kid_counting_data.CompanyId",
"site_area_1d_kid_counting_data.CompanyName",
"site_area_1d_kid_counting_data.BranchId",
"site_area_1d_kid_counting_data.BranchName",
"site_area_1d_kid_counting_data.AreaId",
"site_area_1d_kid_counting_data.AreaName",
"site_area_1d_kid_counting_data.AreaType"
],
"filtros": [
{
"miembro": "site_area_1d_kid_counting_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "site_area_1d_kid_counting_data.AreaId",
"operador": "igual",
"valores": [
"33333",
"44444"
]
}
],
"pedido": [
[
"site_area_1d_kid_counting_data.BranchId",
"asc"
],
[
"site_area_1d_kid_counting_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_area_1d_kid_counting_data.CompanyId": 12345,
"site_area_1d_kid_counting_data.CompanyName": "Empresa de demostración",
"site_area_1d_kid_counting_data.BranchId": 11111,
"site_area_1d_kid_counting_data.BranchName": "DemoSucursal",
"site_area_1d_kid_counting_data.AreaId": 33333,
"site_area_1d_kid_counting_data.AreaName": "Área de demostración",
"site_area_1d_kid_counting_data.AreaType": 1,
"site_area_1d_kid_counting_data.PFC01_3001": 5422,
"site_area_1d_kid_counting_data.PFC02_3001": 5420,
"site_area_1d_kid_counting_data.PFC01_5001": 12532,
"site_area_1d_kid_counting_data.PFC02_5001": 12529
},
{
"site_area_1d_kid_counting_data.CompanyId": 12345,
"site_area_1d_kid_counting_data.CompanyName": "Empresa de demostración",
"site_area_1d_kid_counting_data.BranchId": 22222,
"site_area_1d_kid_counting_data.BranchName": "DemoSucursal",
"site_area_1d_kid_counting_data.AreaId": 44444,
"site_area_1d_kid_counting_data.AreaName": "Área de demostración",
"site_area_1d_kid_counting_data.AreaType": 1,
"site_area_1d_kid_counting_data.PFC01_3001": 5428,
"site_area_1d_kid_counting_data.PFC02_3001": 5315,
"site_area_1d_kid_counting_data.PFC01_5001": 35147,
"site_area_1d_kid_counting_data.PFC02_5001": 32362
}
],
...
}
|
site_area_1h_kid_counting_data
| Descripción | Almacene datos de conteo de niños y adultos del sitio y el área |
| Nombre del cubo |
site_area_1h_kid_counting_data
|
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo - Ejemplo JSON |
{
"consulta": {
"medidas": [
"site_area_1h_kid_counting_data.PFC01_3001",
"site_area_1h_kid_counting_data.PFC02_3001",
"site_area_1h_kid_counting_data.PFC01_5001",
"site_area_1h_kid_counting_data.PFC02_5001"
],
"dimensiones": [
"site_area_1h_kid_counting_data.CompanyId",
"site_area_1h_kid_counting_data.CompanyName",
"site_area_1h_kid_counting_data.BranchId",
"site_area_1h_kid_counting_data.BranchName",
"site_area_1h_kid_counting_data.AreaId",
"site_area_1h_kid_counting_data.AreaName",
"site_area_1h_kid_counting_data.AreaType"
],
"filtros": [
{
"miembro": "site_area_1h_kid_counting_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
},
{
"miembro": "site_area_1h_kid_counting_data.AreaId",
"operador": "igual",
"valores": [
"33333",
"44444"
]
}
],
"pedido": [
[
"site_area_1h_kid_counting_data.BranchId",
"asc"
],
[
"site_area_1h_kid_counting_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta - Ejemplo JSON |
{
...
"datos": [
{
"site_area_1h_kid_counting_data.CompanyId": 12345,
"site_area_1h_kid_counting_data.CompanyName": "Empresa de demostración",
"site_area_1h_kid_counting_data.BranchId": 11111,
"site_area_1h_kid_counting_data.BranchName": "DemoSucursal",
"site_area_1h_kid_counting_data.AreaId": 33333,
"site_area_1h_kid_counting_data.AreaName": "Área de demostración",
"site_area_1h_kid_counting_data.AreaType": 1,
"site_area_1h_kid_counting_data.PFC01_3001": 5422,
"site_area_1h_kid_counting_data.PFC02_3001": 5420,
"site_area_1h_kid_counting_data.PFC01_5001": 12532,
"site_area_1h_kid_counting_data.PFC02_5001": 12529
},
{
"site_area_1h_kid_counting_data.CompanyId": 12345,
"site_area_1h_kid_counting_data.CompanyName": "Empresa de demostración",
"site_area_1h_kid_counting_data.BranchId": 22222,
"site_area_1h_kid_counting_data.BranchName": "DemoSucursal",
"site_area_1h_kid_counting_data.AreaId": 44444,
"site_area_1h_kid_counting_data.AreaName": "Área de demostración",
"site_area_1h_kid_counting_data.AreaType": 1,
"site_area_1h_kid_counting_data.PFC01_3001": 5428,
"site_area_1h_kid_counting_data.PFC02_3001": 5315,
"site_area_1h_kid_counting_data.PFC01_5001": 35147,
"site_area_1h_kid_counting_data.PFC02_5001": 32362
}
],
...
}
|
site_area_wifi_counting_metric_day_data
| Descripción | Almacenar datos de conteo wifi del sitio |
| Nombre del cubo | site_area_wifi_counting_metric_day_data |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'día'. día semana mes año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"queryType": "multi",
"consulta": {
"medidas": [
"site_area_wifi_counting_metric_day_data.PWA01",
"site_area_wifi_counting_metric_day_data.SWA02",
"site_area_wifi_counting_metric_day_data.PWA03",
"site_area_wifi_counting_metric_day_data.SWA04",
"site_area_wifi_counting_metric_day_data.SWA06"
],
"dimensiones": [
"site_area_wifi_counting_metric_day_data.Time",
"site_area_wifi_counting_metric_day_data.BranchId",
"site_area_wifi_counting_metric_day_data.BranchName",
"site_area_wifi_counting_metric_day_data.CompanyId",
"site_area_wifi_counting_metric_day_data.CompanyName"
],
"filtros": [ {
"miembro": "site_area_wifi_counting_metric_day_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"site_area_wifi_counting_metric_day_data.BranchId",
"asc"
],
[
"site_area_wifi_counting_metric_day_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"site_area_wifi_counting_metric_day_data.Time": "2022-01-01T00:00:00.000",
"site_area_wifi_counting_metric_day_data.BranchId": 11111,
"site_area_wifi_counting_metric_day_data.BranchName": "DemoSucursal",
"site_area_wifi_counting_metric_day_data.CompanyId": 12345,
"site_area_wifi_counting_metric_day_data.CompanyName": "Empresa de demostración",
"site_area_wifi_counting_metric_day_data.PWA01": 204,
"site_area_wifi_counting_metric_day_data.SWA02": 1.22,
"site_area_wifi_counting_metric_day_data.PWA03": 23.12,
"site_area_wifi_counting_metric_day_data.SWA04": 0.2367,
"site_area_wifi_counting_metric_day_data.SWA06": 0.7633
},
{
"site_area_wifi_counting_metric_day_data.Time": "2022-01-02T00:00:00.000",
"site_area_wifi_counting_metric_day_data.BranchId": 11111,
"site_area_wifi_counting_metric_day_data.BranchName": "DemoSucursal",
"site_area_wifi_counting_metric_day_data.CompanyId": 12345,
"site_area_wifi_counting_metric_day_data.CompanyName": "Empresa de demostración",
"site_area_wifi_counting_metric_day_data.PWA01": 137,
"site_area_wifi_counting_metric_day_data.SWA02": 4.16,
"site_area_wifi_counting_metric_day_data.PWA03": 15.18,
"site_area_wifi_counting_metric_day_data.SWA04": 0.1418,
"site_area_wifi_counting_metric_day_data.SWA06": 0.8582
}
],
...
}
|
site_area_wifi_counting_metric_hour_data
| Descripción | Almacenar datos de conteo wifi del sitio |
| Nombre del cubo | site_area_wifi_counting_metric_hour_data |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"site_area_wifi_counting_metric_hour_data.PWA01",
"site_area_wifi_counting_metric_hour_data.SWA02"
],
"dimensiones": [
"site_area_wifi_counting_metric_hour_data.Time",
"site_area_wifi_counting_metric_hour_data.BranchId",
"site_area_wifi_counting_metric_hour_data.BranchName",
"site_area_wifi_counting_metric_hour_data.CompanyId",
"site_area_wifi_counting_metric_hour_data.CompanyName"
],
"filtros": [ {
"miembro": "site_area_wifi_counting_metric_hour_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"site_area_wifi_counting_metric_hour_data.BranchId",
"asc"
],
[
"site_area_wifi_counting_metric_hour_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"site_area_wifi_counting_metric_hour_data.Time": "2022-01-01T00:00:00.000",
"site_area_wifi_counting_metric_hour_data.BranchId": 11111,
"site_area_wifi_counting_metric_hour_data.BranchName": "DemoSucursal",
"site_area_wifi_counting_metric_hour_data.CompanyId": 12345,
"site_area_wifi_counting_metric_hour_data.CompanyName": "Empresa de demostración",
"site_area_wifi_counting_metric_hour_data.PWA01": 204,
"site_area_wifi_counting_metric_hour_data.SWA02": 1.22
},
{
"site_area_wifi_counting_metric_hour_data.Time": "2022-01-01T01:00:00.000",
"site_area_wifi_counting_metric_hour_data.BranchId": 11111,
"site_area_wifi_counting_metric_hour_data.BranchName": "DemoSucursal",
"site_area_wifi_counting_metric_hour_data.CompanyId": 12345,
"site_area_wifi_counting_metric_hour_data.CompanyName": "Empresa de demostración",
"site_area_wifi_counting_metric_hour_data.PWA01": 137,
"site_area_wifi_counting_metric_hour_data.SWA02": 4.16
}
],
...
}
|
site_1d_footfall_wifi_sales_data
| Descripción | Almacenar datos de afluencia diaria |
| Nombre del cubo | site_1d_footfall_wifi_sales_data |
| Granularidades de tiempo |
A continuación, se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'día'. día semana mes año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"site_1d_footfall_wifi_sales_data.PFC01_11",
"site_1d_footfall_wifi_sales_data.PFC27",
"site_1d_footfall_wifi_sales_data.PWA01",
"site_1d_footfall_wifi_sales_data.SWA02",
"site_1d_footfall_wifi_sales_data.SWA04",
"site_1d_footfall_wifi_sales_data.SWA06"
],
"dimensiones": [
"site_1d_footfall_wifi_sales_data.Time",
"site_1d_footfall_wifi_sales_data.BranchId",
"site_1d_footfall_wifi_sales_data.BranchName",
"site_1d_footfall_wifi_sales_data.CompanyId",
"site_1d_footfall_wifi_sales_data.NombreEmpresa"
],
"filtros": [ {
"miembro": "site_1d_footfall_wifi_sales_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"site_1d_footfall_wifi_sales_data.BranchId",
"asc"
],
[
"site_1d_footfall_wifi_sales_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"site_1d_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000",
"site_1d_footfall_wifi_sales_data.BranchId": 11111,
"site_1d_footfall_wifi_sales_data.BranchName": "DemoSucursal",
"site_1d_footfall_wifi_sales_data.CompanyId": 12345,
"site_1d_footfall_wifi_sales_data.CompanyName": "Empresa de demostración",
"site_1d_footfall_wifi_sales_data.PFC01_11": 2366,
"site_1d_footfall_wifi_sales_data.PFC27": 1195.209,
"site_1d_footfall_wifi_sales_data.PWA01": 649,
"site_1d_footfall_wifi_sales_data.SWA02": 0.7847,
"site_1d_footfall_wifi_sales_data.SWA04": 0.6124,
"site_1d_footfall_wifi_sales_data.SWA06": 0.3876
},
{
"site_1d_footfall_wifi_sales_data.Time": "2022-01-02T00:00:00.000",
"site_1d_footfall_wifi_sales_data.BranchId": 11111,
"site_1d_footfall_wifi_sales_data.BranchName": "DemoSucursal",
"site_1d_footfall_wifi_sales_data.CompanyId": 12345,
"site_1d_footfall_wifi_sales_data.CompanyName": "Empresa de demostración",
"site_1d_footfall_wifi_sales_data.PFC01_11": 2171,
"site_1d_footfall_wifi_sales_data.PFC27": 937.0556,
"site_1d_footfall_wifi_sales_data.PWA01": 861,
"site_1d_footfall_wifi_sales_data.SWA02": 0.7160,
"site_1d_footfall_wifi_sales_data.SWA04": 0.6106,
"site_1d_footfall_wifi_sales_data.SWA06": 0.3894
}
],
...
}
|
site_area_1h_customer_journeys
| Descripción | Almacenar recorridos de clientes por horas |
| Nombre del cubo | site_area_1h_customer_journeys |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Segmentos | Se pueden utilizar los siguientes segmentos para consultar los datos correspondientes según la granularidad necesaria.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"site_area_1h_customer_journeys.JourneyCount"
],
"dimensiones": [
"site_area_1h_customer_journeys.DateTime",
"site_area_1h_customer_journeys.AreaId",
"site_area_1h_customer_journeys.AreaName",
"site_area_1h_customer_journeys.BranchId",
"site_area_1h_customer_journeys.BranchName",
"site_area_1h_customer_journeys.CompanyId",
"site_area_1h_customer_journeys.CompanyName",
"site_area_1h_customer_journeys.Viaje",
"site_area_1h_customer_journeys.JourneyIds"
],
"segmentos": [
"site_area_1h_customer_journeys.IsAreaLevel"
]
"filtros": [ {
"miembro": "site_area_1h_customer_journeys.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"site_area_1h_customer_journeys.BranchId",
"asc"
],
[
"site_area_1h_customer_journeys.DateTime",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"site_area_1h_customer_journeys.DateTime": "2022-01-01T00:00:00.000",
"site_area_1h_customer_journeys.AreaId": 13131,
"site_area_1h_customer_journeys.AreaName": "Área de demostración",
"site_area_1h_customer_journeys.BranchId": 11111,
"site_area_1h_customer_journeys.BranchName": "DemoSucursal",
"site_area_1h_customer_journeys.CompanyId": 12345,
"site_area_1h_customer_journeys.CompanyName": "Empresa de demostración",
"site_area_1h_customer_journeys.Journey": "DemoZone2",
"site_area_1h_customer_journeys.JourneyIds": "[2]",
"site_area_1h_customer_journeys.JourneyCount": 46
},
{
"site_area_1h_customer_journeys.DateTime": "2022-01-01T00:00:00.000",
"site_area_1h_customer_journeys.AreaId": 13131,
"site_area_1h_customer_journeys.AreaName": "Área de demostración",
"site_area_1h_customer_journeys.BranchId": 11111,
"site_area_1h_customer_journeys.BranchName": "DemoSucursal",
"site_area_1h_customer_journeys.CompanyId": 12345,
"site_area_1h_customer_journeys.CompanyName": "Empresa de demostración",
"site_area_1h_customer_journeys.Journey": "DemoZone1 -> DemoZone2",
"site_area_1h_customer_journeys.JourneyIds": "[1,2]",
"site_area_1h_customer_journeys.JourneyCount": 27
}
],
...
}
|
site_area_1h_counting_data_ext
| Descripción | Almacene datos de conteo horario y tiempo de permanencia |
| Nombre del cubo | site_area_1h_counting_data_ext |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Segmentos |
Se pueden utilizar los siguientes segmentos para consultar los datos correspondientes según la granularidad necesaria.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"site_area_1h_counting_data_ext.FC01_11",
"site_area_1h_counting_data_ext.PFC27"
],
"dimensiones": [
"site_area_1h_counting_data_ext.Time",
"site_area_1h_counting_data_ext.AreaId",
"site_area_1h_counting_data_ext.AreaName",
"site_area_1h_counting_data_ext.BranchId",
"site_area_1h_counting_data_ext.BranchName",
"site_area_1h_counting_data_ext.CompanyId",
"site_area_1h_counting_data_ext.NombreEmpresa"
],
"filtros": [ {
"miembro": "site_area_1h_counting_data_ext.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"site_area_1h_counting_data_ext.BranchId",
"asc"
],
[
"site_area_1h_counting_data_ext.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"site_area_1h_counting_data_ext.Time": "2022-01-01T00:00:00.000",
"site_area_1h_counting_data_ext.AreaId": 13131,
"site_area_1h_counting_data_ext.AreaName": "Área de demostración",
"site_area_1h_counting_data_ext.BranchId": 11111,
"site_area_1h_counting_data_ext.BranchName": "DemoBranch",
"site_area_1h_counting_data_ext.CompanyId": 12345,
"site_area_1h_counting_data_ext.CompanyName": "Empresa de demostración",
"site_area_1h_counting_data_ext.FC01_11": 204,
"site_area_1h_counting_data_ext.PFC27": 1320.34
},
{
"site_area_1h_counting_data_ext.Time": "2022-01-01T01:00:00.000",
"site_area_1h_counting_data_ext.AreaId": 13131,
"site_area_1h_counting_data_ext.AreaName": "Área de demostración",
"site_area_1h_counting_data_ext.BranchId": 11111,
"site_area_1h_counting_data_ext.BranchName": "DemoBranch",
"site_area_1h_counting_data_ext.CompanyId": 12345,
"site_area_1h_counting_data_ext.CompanyName": "Empresa de demostración",
"site_area_1h_counting_data_ext.FC01_11": 137,
"site_area_1h_counting_data_ext.PFC27": 1201.31
}
],
...
}
|
area_1h_footfall_wifi_sales_data
| Descripción | Almacenar datos de conteo de Wi-Fi de afluencia de área por horas |
| Nombre del cubo | area_1h_footfall_wifi_sales_data |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"area_1h_footfall_wifi_sales_data.PFC01_11",
"area_1h_footfall_wifi_sales_data.PFC27",
"area_1h_footfall_wifi_sales_data.PFH05"
],
"dimensiones": [
"area_1h_footfall_wifi_sales_data.Time",
"area_1h_footfall_wifi_sales_data.AreaId",
"area_1h_footfall_wifi_sales_data.AreaName",
"area_1h_footfall_wifi_sales_data.BranchId",
"area_1h_footfall_wifi_sales_data.BranchName",
"area_1h_footfall_wifi_sales_data.CompanyId",
"area_1h_footfall_wifi_sales_data.NombreEmpresa",
"area_1h_footfall_wifi_sales_data.Está funcionando"
],
"filtros": [ {
"miembro": "area_1h_footfall_wifi_sales_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"area_1h_footfall_wifi_sales_data.BranchId",
"asc"
],
[
"area_1h_footfall_wifi_sales_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"area_1h_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000",
"area_1h_footfall_wifi_sales_data.AreaId": 13131,
"area_1h_footfall_wifi_sales_data.AreaName": "Área de demostración",
"area_1h_footfall_wifi_sales_data.BranchId": 11111,
"area_1h_footfall_wifi_sales_data.BranchName": "DemoSucursal",
"area_1h_footfall_wifi_sales_data.CompanyId": 12345,
"area_1h_footfall_wifi_sales_data.CompanyName": "Empresa de demostración",
"area_1h_footfall_wifi_sales_data.IsOperating": 1,
"area_1h_footfall_wifi_sales_data.PFC01_11": 204,
"area_1h_footfall_wifi_sales_data.PFC27": 1320.34,
"area_1h_footfall_wifi_sales_data.PFH05": 19.7288
},
{
"area_1h_footfall_wifi_sales_data.Time": "2022-01-01T01:00:00.000",
"area_1h_footfall_wifi_sales_data.AreaId": 13131,
"area_1h_footfall_wifi_sales_data.AreaName": "Área de demostración",
"area_1h_footfall_wifi_sales_data.BranchId": 11111,
"area_1h_footfall_wifi_sales_data.BranchName": "DemoSucursal",
"area_1h_footfall_wifi_sales_data.CompanyId": 12345,
"area_1h_footfall_wifi_sales_data.CompanyName": "Empresa de demostración",
"area_1h_footfall_wifi_sales_data.IsOperating": 0,
"area_1h_footfall_wifi_sales_data.PFC01_11": 137,
"area_1h_footfall_wifi_sales_data.PFC27": 1201.31,
"area_1h_footfall_wifi_sales_data.PFH05": 21.4473
}
],
...
}
|
area_1h_footfall_wifi_sales_data_new
| Descripción | Almacenar datos de conteo de Wi-Fi de afluencia de área por horas |
| Nombre del cubo | area_1h_footfall_wifi_sales_data_new |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"area_1h_footfall_wifi_sales_data_new.VisitorIn"
],
"dimensiones": [
"area_1h_footfall_wifi_sales_data_new.__time",
"area_1h_footfall_wifi_sales_data_new.AreaId",
"area_1h_footfall_wifi_sales_data_new.AreaName",
"area_1h_footfall_wifi_sales_data_new.BranchId",
"area_1h_footfall_wifi_sales_data_new.BranchName",
"area_1h_footfall_wifi_sales_data_new.CompanyId",
"area_1h_footfall_wifi_sales_data_new.CompanyName",
"area_1h_footfall_wifi_sales_data_new.Dwelltime",
"area_1h_footfall_wifi_sales_data_new.IsOperating"
],
"filtros": [ {
"miembro": "area_1h_footfall_wifi_sales_data_new.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"area_1h_footfall_wifi_sales_data_new.BranchId",
"asc"
],
[
"area_1h_footfall_wifi_sales_data_new.__time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"area_1h_footfall_wifi_sales_data_new.__time": "2022-01-01T00:00:00.000",
"area_1h_footfall_wifi_sales_data_new.AreaId": 13131,
"area_1h_footfall_wifi_sales_data_new.AreaName": "Área de demostración",
"area_1h_footfall_wifi_sales_data_new.BranchId": 11111,
"area_1h_footfall_wifi_sales_data_new.BranchName": "DemoSucursal",
"area_1h_footfall_wifi_sales_data_new.CompanyId": 12345,
"area_1h_footfall_wifi_sales_data_new.CompanyName": "Empresa de demostración",
"area_1h_footfall_wifi_sales_data_new.VisitorIn": 204,
"area_1h_footfall_wifi_sales_data_new.Dwelltime": 1320.34,
"area_1h_footfall_wifi_sales_data_new.IsOperating": 1
},
{
"area_1h_footfall_wifi_sales_data_new.__time": "2022-01-01T01:00:00.000",
"area_1h_footfall_wifi_sales_data_new.AreaId": 13131,
"area_1h_footfall_wifi_sales_data_new.AreaName": "Área de demostración",
"area_1h_footfall_wifi_sales_data_new.BranchId": 11111,
"area_1h_footfall_wifi_sales_data_new.BranchName": "DemoSucursal",
"area_1h_footfall_wifi_sales_data_new.CompanyId": 12345,
"area_1h_footfall_wifi_sales_data_new.CompanyName": "Empresa de demostración",
"area_1h_footfall_wifi_sales_data_new.VisitorIn": 137,
"area_1h_footfall_wifi_sales_data_new.Dwelltime": 1201.31,
"area_1h_footfall_wifi_sales_data_new.IsOperating": 0
}
],
...
}
|
viajes_del_cliente
| Descripción | Almacenar los recorridos de los clientes |
| Nombre del cubo | viajes_del_cliente |
| Granularidades de tiempo |
A continuación se muestran las granularidades de tiempo disponibles para este cubo, la granularidad de tiempo mínima es 'segundo'. segundo, minuto, hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"viajes_clientes.Recuento"
],
"dimensiones": [
"customer_journeys.DateTime",
"customer_journeys.BranchId",
"customer_journeys.CompanyId",
"customer_journeys.IsOperating",
"customer_journeys.Viaje",
"customer_journeys.JourneyIds"
],
"filtros": [ {
"miembro": "customer_journeys.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"customer_journeys.BranchId",
"asc"
],
[
"customer_journeys.DateTime",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"customer_journeys.Time": "2022-01-01T00:00:00.000",
"viajes_cliente.BranchId": 11111,
"viajes_cliente.CompanyId": 12345,
"customer_journeys.IsOperating": 1,
"customer_journeys.Journey": "Cajero",
"customer_journeys.JourneyIds": "[1]",
"viajes_clientes.Recuento": 1
},
{
"customer_journeys.Time": "2022-01-01T01:00:00.000",
"viajes_cliente.BranchId": 11111,
"viajes_cliente.CompanyId": 12345,
"customer_journeys.IsOperating": 0,
"customer_journeys.Journey": "Refrigerador A -> Cajero",
"customer_journeys.JourneyIds": "[2]",
"viajes_clientes.Recuento": 2
}
],
...
}
|
site_1h_footfall_wifi_sales_data
| Descripción | Almacenar datos de afluencia por horas |
| Nombre del cubo | site_1h_footfall_wifi_sales_data |
| Granularidades de tiempo |
Los siguientes son los detalles de tiempo disponibles para este cubo, el detalle de tiempo mínimo es 'hora'. hora, día, semana, mes, año |
| Medidas |
Métricas disponibles para este cubo
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"medidas": [
"site_1h_footfall_wifi_sales_data.PFC01_11",
"site_1h_footfall_wifi_sales_data.PFC27",
"site_1h_footfall_wifi_sales_data.PWA01",
"site_1h_footfall_wifi_sales_data.SWA02"
],
"dimensiones": [
"site_1h_footfall_wifi_sales_data.Time",
"site_1h_footfall_wifi_sales_data.BranchId",
"site_1h_footfall_wifi_sales_data.BranchName",
"site_1h_footfall_wifi_sales_data.CompanyId",
"site_1h_footfall_wifi_sales_data.NombreEmpresa"
],
"filtros": [ {
"miembro": "site_1h_footfall_wifi_sales_data.BranchId",
"operador": "igual",
"valores": [
"11111",
"22222"
]
}
],
"pedido": [
[
"site_1h_footfall_wifi_sales_data.BranchId",
"asc"
],
[
"site_1h_footfall_wifi_sales_data.Time",
"asc"
]
],
"límite": 10
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"site_1h_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000",
"site_1h_footfall_wifi_sales_data.BranchId": 11111,
"site_1h_footfall_wifi_sales_data.BranchName": "DemoSucursal",
"site_1h_footfall_wifi_sales_data.CompanyId": 12345,
"site_1h_footfall_wifi_sales_data.CompanyName": "Empresa de demostración",
"site_1h_footfall_wifi_sales_data.PFC01_11": 204,
"site_1h_footfall_wifi_sales_data.PFC27": 1320.34,
"site_1h_footfall_wifi_sales_data.PWA01": 649,
"site_1h_footfall_wifi_sales_data.SWA02": 0.7847
},
{
"site_1h_footfall_wifi_sales_data.Time": "2022-01-01T01:00:00.000",
"site_1h_footfall_wifi_sales_data.BranchId": 11111,
"site_1h_footfall_wifi_sales_data.BranchName": "DemoSucursal",
"site_1h_footfall_wifi_sales_data.CompanyId": 12345,
"site_1h_footfall_wifi_sales_data.CompanyName": "Empresa de demostración",
"site_1h_footfall_wifi_sales_data.PFC01_11": 2171,
"site_1h_footfall_wifi_sales_data.PFC27": 937.0556,
"site_1h_footfall_wifi_sales_data.PWA01": 861,
"site_1h_footfall_wifi_sales_data.SWA02": 0.7160
}
],
...
}
|
sitio_1h_counting_prediction
| Descripción |
Afluencia histórica por hora y afluencia prevista para los 14 días anteriores y posteriores a la fecha de entrada. Para fechas pasadas, se devuelven las afluencias históricas y previstas para comparar la precisión. Para fechas futuras, solo se devuelven las afluencias previstas; se desconocen las afluencias históricas. Se utilizan datos históricos por hora de 56 días (mínimo 14 días) para predecir la afluencia por hora de los próximos 14 días. |
| Nombre del cubo | sitio_1h_counting_prediction |
| Granularidades de tiempo | Hora |
| Medidas |
Métricas disponibles para este cubo:
|
| Dimensiones |
Los siguientes campos se pueden utilizar para aplicar filtros y ordenar los datos.
|
| Cuerpo: ejemplos JSON |
{
"consulta": {
"dimensiones": [
"site_1h_counting_prediction.CompanyId",
"site_1h_counting_prediction.BranchId",
"site_1h_counting_prediction.BranchName",
"site_1h_counting_prediction.DayOfWeek",
"site_1h_counting_prediction.Time",
"site_1h_counting_prediction.StartDateTime",
"site_1h_counting_prediction.CurrentLocalTime",
"site_1h_counting_prediction.IsOperating",
"sitio_1h_counting_prediction.PFC01",
"site_1h_counting_prediction.PFC01_Prediction"
],
"filtros": [
{
"miembro": "site_1h_counting_prediction.BranchId",
"operador": "igual",
"valores": [
"11111"
]
},
{
"miembro": "site_1h_counting_prediction.StartDateTime",
"operador": "igual",
"valores": [
"2024-03-11"
]
},
{
"miembro": "site_1h_counting_prediction.IsOperating",
"operador": "igual",
"valores": [
"1"
]
}
],
"pedido": [
[
"site_1h_counting_prediction.Time",
"asc"
]
],
"límite": 50000,
"renewQuery": "VERDADERO"
}
}
|
| Respuesta: ejemplos JSON |
{
...
"datos": [
{
"site_1h_counting_prediction.CompanyId": 12345,
"site_1h_counting_prediction.BranchId": 11111,
"site_1h_counting_prediction.BranchName": "DemoBranch",
"site_1h_counting_prediction.DayOfWeek": 1,
"site_1h_counting_prediction.Time": "2024-02-26T09:00:00.000",
"site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000",
"site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000",
"site_1h_counting_prediction.IsOperating": "1",
"site_1h_counting_prediction.PFC01": 7,
"site_1h_counting_prediction.PFC01_Prediction": 24
},
...
{
"site_1h_counting_prediction.CompanyId": 12345,
"site_1h_counting_prediction.BranchId": 11111,
"site_1h_counting_prediction.BranchName": "DemoBranch",
"site_1h_counting_prediction.DayOfWeek": 1,
"site_1h_counting_prediction.Time": "2024-03-11T09:00:00.000",
"site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000",
"site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000",
"site_1h_counting_prediction.IsOperating": "1",
"site_1h_counting_prediction.PFC01": 22,
"site_1h_counting_prediction.PFC01_Prediction": 15
},
...
{
"site_1h_counting_prediction.CompanyId": 12345,
"site_1h_counting_prediction.BranchId": 11111,
"site_1h_counting_prediction.BranchName": "DemoBranch",
"site_1h_counting_prediction.DayOfWeek": 7,
"site_1h_counting_prediction.Time": "2024-03-24T18:00:00.000",
"site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000",
"site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000",
"site_1h_counting_prediction.IsOperating": "1",
"site_1h_counting_prediction.PFC01": nulo,
"site_1h_counting_prediction.PFC01_Prediction": 288
}
],
...
}
|