This section describes the list of available cubes and their dimensions and measures. The cubes are callable from cube.footfallcam.com using REST API or SQL API.
| Site_Summary | |
| This cube provides information for each main entrance area of each site. Users can narrow down site selection and time range for faster query load time. It returns all value combinations of selected dimensions and aggregates the selected measures. | |
| Dimensions | |
| CompanyName | The name of the company which owns the site. |
| SiteName | The name of the site. |
| SiteGroupName | The name of the group of the site. |
| Time | Local time of the site. Minutes data only appear for the last 60 days. Time granularity respects metric documentation. |
| Measures | All measures below are considered at main entrance only. For further details about them please refer to metric documentation: Appendix C - Metrics Definition V2 - FootfallCam. |
| A01 (Total Footfall In Count) | Number of footfalls count that go into the main entrance area of the site. |
| A02 (Total Footfall Out Count) | Number of footfalls count that exits the main entrance area of the site. |
| A03 (Average Occupancy) | Average number of people detected on that site. |
| A04 (Average Dwell Time) | Average time spent by people on that site. |
| A18 (Total Children Footfall In Count) | Number of children that go into the main entrance area of the site. |
| A05 (Total Outside Traffic Count) | Number of visitors that is detected through Wi-Fi discovery. |
| B02 (Average Visitor Returning Rate) | Fraction of visitors that return to the site in the past 60 days. |
| Area_Summary | |
| This cube provides information for each area within a site. Users can narrow down site, area, and time range for faster query load time. It returns all value combinations of selected dimensions and aggregates the selected measures. |
|
| Dimensions | |
| CompanyName | The name of the company that owns the area. |
| SiteName | The name of the site that owns the area. |
| AreaName | The name of the area of the site. |
| AreaGroupName | The name of the group that the area belongs in. |
| Time | Local time of the site. Minutes data only appear for the last 60 days. Time granularity respects metric documentation. |
| Measures | For further details about them please refer to metric documentation: Appendix C - Metrics Definition V2 - FootfallCam. |
| A01 (Total Footfall In Count) | Number of visitors that enter the area. |
| A02 (Total Footfall Out Count) | Number of visitors that exit the area. |
| A03 (Average Occupancy) | Number of visitors that is the detected within the area. |
| A04 (Average Visit Duration) | Average time spent by visitors within the area. |
| A18 (Total Children Footfall In Count) | Number of children that enter the area. |
| A05 (Total Outside Traffic Count) | Number of visitors that is detected outside the area. |
| B02 (Average Visitor Returning Rate) | Fraction of visitors that return to the area in the past 60 days. |
| Device_Summary | |
| This cube provides information for each device. Users can narrow down site and time range for faster query load time. It returns all value combinations of selected dimensions and aggregates the selected measures. |
|
| Dimensions | |
| CompanyId | The Id of the company which owns the device. |
| CompanyName | The name of the company which owns the device. |
| BranchId | The Id of the site which device is allocated to. |
| BranchName | The name of the site which device is allocated to. |
| CompanySerial | A serial assigned to the device. |
| Time | Local time of the site. Minutes data only appear for the last 60 days. Time granularity respects metric documentation. |
| Measures | For further details about them please refer to metric documentation: Appendix C - Metrics Definition V2 - FootfallCam. |
| A01 (Total Footfall In Count) | Number of visitors that pass through IN line of the device. |
| A02 (Total Footfall Out Count) | Number of visitors that pass through OUT line of the device. |
| A03 (Average Occupancy) | Number of visitors detected within device sensor's range. |
| A04 (Average Visit Duration) | Time spent by visitors within the device sensor's range. |
| A18 (Total Children Footfall In Count) | Number of children who pass through IN line of the device. |
| A05 (Total Outside Traffic Count) | Number of visitors detected by device's Wi-Fi sensor. |
|
C01 (Total Unscaled Individual Footfall In) |
Raw number of visitors that pass through IN line of the device. |
|
C02 (Total Unscaled Children Footfall In) |
Raw number of children that pass through IN line of the device. |
|
C03 (Total Unscaled Adult Footfall In) |
Raw number of adults that pass through IN line of the device. |
REST API Example
This section explains how to obtain data through REST API. User can use application like Postman to call the API. The query body is in JSON format. The REST API requires bearer token header which can be obtained via Access Token - FootfallCam.
URL: https://cube.footfallcam.com/API/v1/load
Header: 'Bearer [AToken]'
Body = {
"query":{
"measures": [
"ffc_site_summary.A01"
],
"dimensions": [
"ffc_site_summary.BranchId"
],
"segments": [],
"timeDimensions": [
{
"dimension": "ffc_site_summary.Time",
"granularity": "day",
"dateRange": [
"2024-10-01",
"2024-10-25"
]
}
],
"order": []
}
}
SQL API Example
URL: cube.footfallcam.com:6432
Driver: Postgresql
SQL Statement:
SELECT BranchId,DATE_TRUNC('day',Time),A01
FROM ffc_site_summary
WHERE Time BETWEEN '2024-10-01' AND '2024-10-25'