目录
此内容是否有帮助?

# 指標クエリAPI

# Product Metric API

As for the call method, please refer to the call method description in Open API

You can read the Product Metrics (opens new window) in the user manual to understand the usage scenario.

# List of Product Metrics

Interface URL

/open/metric-list?token=xxx

Request method

POST

Content-Type

application/json

Request Query parameter

Parameter name Sample value Parameter type Is required Parameter description
token
xxx
String
Yes
token

Request Body Parameter

{
  "projectId": 102,
  "metricName": "retention_1", 
  "metricDesc": "retention_day1",
  "metricModes" ["EVENT","RETENTION"],
  "createUser":"root""updateUser":"root",
  "timeParticleSize":"day"
}
Parameter name Sample value Parameter type Is required Parameter description
projectId
102
Integer
Yes
Project ID
metricName
retention_1
String
No
Metric Name
metricDesc
retention_day1
String
No
Display name
metricModes
["EVENT",
"RETENTION"]
List
No
Created from
EVENT
RETENTION
createUser
root
String
No
Login user name
updateUser
root
String
No
Login user name
timeParticle
day
String
No
Unit of the time period taken for analysis
minute:based on one minute
minute5: based on five minutes(supported since v3.5)
minute10: based on ten minutes (supported since v3.5)
hour: based on hours
day: based on days
week: based on weeks
month: based on months
total: total

Successful Response Example

{
    "data":
    [
        {
            "metricId": 1,
            "projectId": 2,
            "metricName": "retention_1",
            "metricDesc": "retention_day1",
            "metricRemark": "test_retention",
            "metricMode": "EVENT",
            "createUser": "root",
            "updateUser": "root",
            "createTime": "2022-12-12 10:10:00",
            "updateTime": "2022-12-12 10:10:00",
            "timeParticles":[ "minute"],
            "format": "FORMAT_FLOAT"
        }
    ],
    "return_code": 0,
    "return_message": "success"
}

# Product Metrics Query

Interface URL

/open/metric-data?token=xxx

Request method

POST

Content-Type

application/json

Request Query Parameter

Parameter name Sample value Parameter type Is required Parameter description
token
xxx
String
Yes
token

Request Body Parameter

{
    "eventView": {
        "comparedByTime": true,
        "comparedStartTime": "2021-12-14 00:00:00",
        "comparedEndTime": "2021-12-20 23:59:59",
        "comparedRecentDay": "8-14",
        "startTime": "2021-12-21 00:00:00",
        "endTime": "2021-12-27 23:59:59",
        "recentDay": "1-7",
        "timeParticleSize": "day",
        "groupBy": [{
            "columnDesc": "brand",
            "columnName": "brand",
            "propertyRange": "",
            "specifiedClusterDate": "2021-12-28",
            "tableType": "event"
        }],
        "relation": "and",
        "filts": [{
            "columnDesc": "brand",
            "columnName": "brand",
            "comparator": "equal",
            "filterType": "SIMPLE",
            "ftv": ["Apple", "Xiaomi"],
            "specifiedClusterDate": "2021-12-28",
            "tableType": "event",
            "timeUnit": ""
        }],
        "queryFeature": {
            "approximateOn": true,
            "globalQueryOn": false
        }
    },
    "metrics":["retention_1","dau"]
    "zoneOffset": 0
    "projectId": 377,
    "useSameResultKey": false,
    "useCache": true,
    "limit": 1000,
    "timeoutSeconds": 10
}
Parameter name Sample value Parameter type Is required Parameter description
eventView
-
Object
Yes
Metrics common attribute part.
comparedByTime true
Boolean
No
Whether to compare the time, TRUE: Yes, FALSE: No
comparedStartTime 2021-12-14 00:00:00
String
No
Contrast time start time (format: yyyy-MM-dd HH: mm: ss), the comparison time is valid when the relative time is empty
comparedEndTime 2021-12-20 23:59:59
String
No
Compare time end time (format: yyyy-MM-dd HH: mm: ss), valid when the comparison time is empty relative to time
comparedRecentDay 8-14
String
No
Comparison time relative time (when comparedByTime is TRUE, this item cannot be empty both with the start time and end time of the comparison time)
startTime 2021-12-21 00:00:00
String
No
Start time (format: yyyy-MM-dd HH: mm: ss), valid when the relative time is empty
endTime 2021-12-27 23:59:59
String
No
End time (format: yyyy-MM-dd HH: mm: ss), valid when the relative time is empty
recentDay 1-7
String
No
Relative time (this item cannot be empty both with the start time and the end time)
relation and
String
No
Logical relationship, and: logical and, or: logical or
timeParticleSize day
String
Yes
Unit of the time period taken for analysis
minute:based on one minute
minute5: based on five minutes(supported since v3.5)
minute10: based on ten minutes (supported since v3.5)
hour: based on hours
day: based on days
week: based on weeks
month: based on months
total: total
groupBy -
List
No
Grouping property part, zero or more
columnName brand
String
Yes
Field name
columnDesc Brand
String
No
Field display name
propertyRange String
No
Self-defined property interval
propertyRangeType String
No
Property interval type, which can be used as self-defined bucketing conditions when grouping numeric properties
def: default interval, divided by the system automatically
discrete: each value is an independent group
user_defined: defined by the user; the self-defined content is set in propertyRange
specifiedClusterDate 2021-12-28
String
No
Historical tag version of specified date
tableType event
String
Yes
Table type enumeration
filts -
List
No
Global filters parts
columnDesc Brand
String
No
Field display name
columnName brand
String
Yes
Field name
comparator equal
String
Yes
Reference: filtering expression of
model query API
filterType SIMPLE
String
No
Filtering mode, SIMPLE: simple, COMPOUND: compound, default as SIMPLE
ftv ["Apple", "Xiaomi"]
List
No
Property comparative with bound literial
specifiedClusterDate 2021-12-28
String
No
Historical tag version of specified date
tableType event
String
Yes
Table type enumeration
timeUnit String
No
Property filter unit, only valid to relativeEvent*:day,hour,minute
queryFeature -
Object
No
Query configuration
approximateOn true
Boolean
No
Enable approximate calculation or not
metrics
["retention_1","dau"]
list
Yes
List of Product Metrics
projectId
377
Integer
Yes
Project numeric identity
zoneOffset
0
Integer
No
Time zone
useCache
true
Boolean
No
Use cache, optional parameter, default value: true
limit
1000
Integer
No
Upper limit of the group number of each analysis object, optional parameter, default value: 1000, maximum value: 10000
timeoutSeconds
10
Integer
No
Request timeout parameter. Query task should be cancelled after the request times out.

Successful Response Example

{
    "data": {
        "result_generate_time": "2021-12-30 11:15:41", 
        "union_groups": [
            [
                "Safari", 
                "apple"
            ], 
            [
                "Firefox", 
                "xiaomi"
            ], 
            [
                "WeChat built-in browser", 
                "apple"
            ], 
            [
                "total", 
                "apple"
            ], 
            [
                "total", 
                "xiaomi"
            ]
        ], 
        "x": [
            "2021-12-23", 
            "2021-12-24", 
            "2021-12-25", 
            "2021-12-26", 
            "2021-12-27", 
            "2021-12-28", 
            "2021-12-29"
        ], 
        "x_compared": [
            "2021-12-16", 
            "2021-12-17", 
            "2021-12-18", 
            "2021-12-19", 
            "2021-12-20", 
            "2021-12-21", 
            "2021-12-22"
        ], 
        "y": [
            {
                "retention_1": [
                    {
                        "group_cols": [
                            "Safari", 
                            "apple"
                        ], 
                        "group_num": 3, 
                        "values": [
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0"
                        ], 
                        "values_compared": [
                            "447", 
                            "980", 
                            "1584", 
                            "321", 
                            "285", 
                            "74", 
                            "0"
                        ]
                    }, 
                    {
                        "group_cols": [
                            "Firefox", 
                            "xiaomi"
                        ], 
                        "group_num": 3, 
                        "values": [
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0"
                        ], 
                        "values_compared": [
                            "291", 
                            "818", 
                            "1128", 
                            "272", 
                            "219", 
                            "58", 
                            "0"
                        ]
                    }, 
                    {
                        "group_cols": [
                            "chrome", 
                            "apple"
                        ], 
                        "group_num": 3, 
                        "values": [
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0"
                        ], 
                        "values_compared": [
                            "231", 
                            "500", 
                            "764", 
                            "214", 
                            "155", 
                            "35", 
                            "0"
                        ]
                    }
                ]
            }, 
            {
                "dau": [
                    {
                        "group_cols": [
                            "total", 
                            "apple"
                        ], 
                        "group_num": 2, 
                        "values": [
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0"
                        ], 
                        "values_compared": [
                            "640", 
                            "811", 
                            "1251", 
                            "1253", 
                            "720", 
                            "113", 
                            "0"
                        ]
                    }, 
                    {
                        "group_cols": [
                            "total", 
                            "xiaomi"
                        ], 
                        "group_num": 2, 
                        "values": [
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0", 
                            "0"
                        ], 
                        "values_compared": [
                            "277", 
                            "439", 
                            "600", 
                            "666", 
                            "364", 
                            "59", 
                            "0"
                        ]
                    }
                ]
            }
        ]
    }, 
    "return_code": 0, 
    "return_message": "success"
}

Response Parameter Description

Parameter name Sample value Parameter type Parameter description
data
-
Object
Return results
result_generate_time 2021/12/29 12:00
String
Query result generation time
union_groups ["Apple"]
List
All Grouping Set
x ["2021-12-23"]
List
X-axile time
x_compared ["2021-12-16"]
List
X-axile comparison time
y -
List
Y-axile data list
{metricname} -
List
Y-axile metric information list
group_cols ["Apple"]
List
Y-axile metric group
group_num 3
Integer
Y-axile metric group number
values ["0"]
List
Y-axile metric value
values_compared ["447"]
List
Y-axile time comparison metric value
return_code
0
Integer
Return code
return_message
success
String
Return message