用户统计
1. TOP操作系统
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | topOsData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"newCount"
],
"dimensions": [
"osId",
"osVersionId"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "osVersionId",
"value": [
0
],
"operator": "!="
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"orderByExprs": "newCount desc",
"render": "list",
"limit": 10
}
2. TOP渠道
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | topChannelData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"newCount"
],
"dimensions": [
"channelId"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "channelId",
"value": [
0
],
"operator": "!="
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"orderByExprs": "newCount desc",
"render": "list",
"limit": 10
}
3. TOP版本
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | topMobileAppVersionData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"newCount"
],
"dimensions": [
"mobileAppVersionId"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "mobileAppVersionId",
"value": [
0
],
"operator": "!="
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"orderByExprs": "newCount desc",
"render": "list",
"limit": 10
}
4. TOP设备
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
Query params:
| Key | Value |
|---|---|
| label | topManufacturerData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"newCount"
],
"dimensions": [
"manufacturerModelId"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "manufacturerModelId",
"value": [
0
],
"operator": "!="
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"orderByExprs": "newCount desc",
"render": "list",
"limit": 10
}
5. TOP厂商
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
Query params:
| Key | Value |
|---|---|
| label | topManufacturerData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"newCount"
],
"dimensions": [
"manufacturerId"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "manufacturerModelId",
"value": [
0
],
"operator": "!="
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"orderByExprs": "newCount desc",
"render": "list",
"limit": 10
}
6. 使用时长趋势
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | userTimeData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"useTimeHistogram"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "sampleType",
"value": [
"active"
],
"operator": "IN"
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
},
{
"name": "moduleType",
"value": [
2
],
"operator": "="
}
],
"render": "list"
}
7. 启动次数趋势
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query/zero-filling
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | userTrendData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"launchCount"
],
"dimensions": [
"timeStr"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"render": "list"
}
8. 新增用户数趋势
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query/zero-filling
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | userTrendData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"newCount"
],
"dimensions": [
"timeStr"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"render": "list"
}
9. 日活跃设备数趋势-30天
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/userstat/dayLive
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"deviceCount"
],
"dimensions": [
"timeStr",
"dataType"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "dataType",
"value": [
1,
2
],
"operator": "IN"
}
],
"render": "list"
}
10. 月活跃设备数趋势-1年
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/userstat/monthLive
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"deviceCount"
],
"dimensions": [
"timeStr",
"dataType"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "dataType",
"value": [
1,
2
],
"operator": "IN"
}
],
"render": "list"
}
11. 活跃设备数趋势
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query/zero-filling
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | userTrendData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"deviceCount"
],
"dimensions": [
"timeStr"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
}
],
"render": "list"
}
12. 用户统计-信息卡片
Endpoint:
Method: POST
Type: RAW
URL: {{host}}/adhoc/query
Headers:
| Key | Value |
|---|---|
| Accept | application/json, text/plain, / |
| Content-Type | application/json |
Query params:
| Key | Value |
|---|---|
| label | cardData |
Body:
{
"timePeriod": {{timePeriod}},
"endTime": {{endTime}},
"datasource": "APP_DEVICE_DATA",
"metrics": [
"newCount",
"deviceCount",
"launchCount",
"useTime"
],
"filters": [
{
"name": "mobileAppId",
"value": [
{{mobileAppId}}
],
"operator": "IN"
},
{
"name": "dataType",
"value": [
2
],
"operator": "="
},
{
"name": "sessionDurationTime",
"value": [
0
],
"operator": ">="
}
],
"render": "list",
"limit": -1
}