跳到主要内容

间隔分析模型 API

最近更新 2026/10/05

调用方法请参见Open API文档中的调用方法描述。

可阅读使用手册中 间隔分析 了解使用场景。

1. 间隔分析查询​

接口URL

/open/interval-analyze?token=xxx

请求方式

POST

Content-Type

application/json

请求Query参数

参数名示例值参数类型是否必填参数描述
tokenxxxString是查询密钥

请求Body参数​

{
  "eventView": {
    "endTime": "2021-10-05 23:59:59",
    "filts": [
      {
        "columnDesc": "品牌",
        "columnName": "brand",
        "comparator": "equal",
        "filterType": "SIMPLE",
        "ftv": [
          "苹果",
          "华为"
        ],
        "specifiedClusterDate": "2022-01-24",
        "tableType": "event",
        "timeUnit": ""
      }
    ],
    "groupBy": [
      {
        "columnDesc": "品牌",
        "columnName": "brand",
        "propertyRange": "",
        "specifiedClusterDate": "2022-01-24",
        "tableType": "event"
      }
    ],
    "recentDay": "114-115",
    "relation": "and",
    "startTime": "2021-10-04 00:00:00",
    "taIdMeasureVo": {
      "columnDesc": "用户唯一ID",
      "columnName": "#user_id",
      "tableType": "event"
    },
    "timeParticleSize": "day",
    "windowsGapUnit": "hour",
    "windowsGapValue": 1
  },
  "events": [
    {
      "eventName": "activity_attend",
      "eventNameDisplay": "",
      "filts": [
      ],
      "relation": "and",
      "relationProp": {
        "property": {
          "columnDesc": "品牌",
          "columnName": "brand",
          "specifiedClusterDate": "2022-01-24",
          "tableType": "event"
        }
      },
      "type": "first"
    },
    {
      "eventName": "payment",
      "eventNameDisplay": "",
      "filts": [
      ],
      "relation": "and",
      "relationProp": {
        "property": {
          "columnDesc": "品牌",
          "columnName": "brand",
          "specifiedClusterDate": "2022-01-24",
          "tableType": "event"
        },
        "relationOperatorValue": 0,
        "relationPropNumberOperator": "r_eq"
      },
      "type": "second"
    }
  ],
  "projectId": 377,
  "limit": 10,
  "timeoutSeconds": 10,
  "useCache": true,
  "zoneOffset": 10
}

请求参数说明​

$$参数名示例值参数类型是否必填参数描述
eventView-Object是指标公共属性部分
eventView.endTime2021-10-05 23:59:59String否结束时间（格式：yyyy-MM-dd HH:mm:ss），相对时间为空时有效
eventView.filts-List否全局筛选项
eventView.filts.columnDesc品牌String否字段显示名
eventView.filts.columnNamebrandString是字段名
eventView.filts.comparatorequalString是参考： 模型查询API的筛选表达式
eventView.filts.filterTypeSIMPLEString否过滤模式，SIMPLE：简单，COMPOUND：复合
eventView.filts.ftv["苹果"]List否用于属性比较边界的字面常量
eventView.filts.specifiedClusterDate2022-01-24String否指定对应日期的标签历史版本
eventView.filts.tableTypeeventString是表类型枚举值
eventView.filts.timeUnitString否属性对比值单位，仅对relativeEvent*有效：day，hour，minute
eventView.groupBy-List否分组属性，可以有零个或者多个
eventView.groupBy.columnDesc品牌String否字段显示名
eventView.groupBy.columnNamebrandString是字段名
eventView.groupBy.propertyRangeString否自定义属性区间
eventView.groupBy.specifiedClusterDate2022-01-24String否指定对应日期的标签历史版本
eventView.groupBy.tableTypeeventString是表类型枚举值
eventView.recentDay114-115String否相对时间（此项不可与起始时间和结束时间同时为空）
eventView.relationandString否逻辑关系，and：逻辑与，or：逻辑或
eventView.startTime2021-10-04 00:00:00String否起始时间（格式：yyyy-MM-dd HH:mm:ss），相对时间为空时有效
eventView.taIdMeasureVo-Object否分析主体配置
eventView.taIdMeasureVo.columnDesc用户唯一IDString否字段显示名
eventView.taIdMeasureVo.columnName#user_idString是字段名
eventView.taIdMeasureVo.tableTypeeventString是表类型枚举值
eventView.timeParticleSizeday

String

是

分析的时间单位

  • minute：按分钟
  • hour：按小时
  • day：按天
  • week：按周
  • month：按月
  • total：总计
eventView.firstDayOfWeekInteger否当timeParticleSize为week时，指定周首日，1：星期一，2：星期二， ..，7：星期日，最小1，最大7
eventView.windowsGapUnithourString否窗口时长单位
eventView.windowsGapValue1Integer否窗口时长
events-List是事件指标列表
events.eventNameactivity_attendString是事件名称，特别的，可以使用 anyEvent 表示任意事件
events.eventNameDisplayString否事件显示名
events.filts-List否条件列表列表
events.relationandString否逻辑关系，and：逻辑与，or：逻辑或
events.relationProp-Object否关联属性
events.relationProp.property-Object否关联属性
events.relationProp.property.columnDesc品牌String否字段显示名
events.relationProp.property.columnNamebrandString否字段名
events.relationProp.property.specifiedClusterDate2022-01-24String否指定对应日期的标签历史版本
events.relationProp.property.tableTypeeventString否表类型枚举值
events.relationProp.relationOperatorValue0Integer否关系操作值
events.relationProp.relationPropNumberOperatorr_eqString否

关系操作符，

  • r_eq：相等
  • r_high：高
  • r_low：低
events.typefirstString是事件类型，first：起点事件，second：终点事件
projectId377Integer是项目ID
limit10Integer否每分析对象的分组数上限，可选参数，默认为1000，最大为10000
timeoutSeconds10Integer否请求超时参数，超时则取消查询任务
useCachetrueBoolean是true为使用缓存
zoneOffset10Integer否时区

成功响应示例​

{
  "data": {
    "distributionInterval": [
      ",300",
      "300,600",
      "600,900",
      "900,1200",
      "1200,1500",
      "1500,1800",
      "1800,2100",
      "2100,2400",
      "2400,2700",
      "2700,3000",
      "3000,3300",
      "3300,"
    ],
    "groupCols": [
      [
        "苹果"
      ],
      [
        "华为"
      ]
    ],
    "intervalData": {
      "dateEntities": [
        {
          "dateString": "2021-10-04",
          "groupEntities": [
            {
              "groups": [
                "苹果"
              ],
              "intervalAggValue": {
                "avgValue": 40,
                "eventNum": 6646,
                "maxValue": 354,
                "midValue": 28,
                "minValue": 2,
                "quarterValue": 16,
                "threeQuarterValue": 49,
                "userNum": 838
              },
              "intervalDistributions": [
                {
                  "distribution": "300,600",
                  "intervalDistributionValue": {
                    "eventNum": 5,
                    "userNum": 5
                  }
                },
                {
                  "distribution": ",300",
                  "intervalDistributionValue": {
                    "eventNum": 6641,
                    "userNum": 838
                  }
                }
              ]
            },
            {
              "groups": [
                "华为"
              ],
              "intervalAggValue": {
                "avgValue": 39,
                "eventNum": 5439,
                "maxValue": 313,
                "midValue": 28,
                "minValue": 2,
                "quarterValue": 15,
                "threeQuarterValue": 50,
                "userNum": 683
              },
              "intervalDistributions": [
                {
                  "distribution": "300,600",
                  "intervalDistributionValue": {
                    "eventNum": 2,
                    "userNum": 2
                  }
                },
                {
                  "distribution": ",300",
                  "intervalDistributionValue": {
                    "eventNum": 5437,
                    "userNum": 683
                  }
                }
              ]
            }
          ],
          "intervalAggValue": {
            "avgValue": 39,
            "eventNum": 12085,
            "maxValue": 354,
            "midValue": 28,
            "minValue": 2,
            "quarterValue": 16,
            "threeQuarterValue": 49,
            "userNum": 1520
          },
          "intervalDistributions": [
            {
              "distribution": "300,600",
              "intervalDistributionValue": {
                "eventNum": 7,
                "userNum": 7
              }
            },
            {
              "distribution": ",300",
              "intervalDistributionValue": {
                "eventNum": 12078,
                "userNum": 1520
              }
            }
          ]
        },
        {
          "dateString": "2021-10-05",
          "groupEntities": [
            {
              "groups": [
                "苹果"
              ],
              "intervalAggValue": {
                "avgValue": 39,
                "eventNum": 5700,
                "maxValue": 303,
                "midValue": 28,
                "minValue": 2,
                "quarterValue": 16,
                "threeQuarterValue": 49,
                "userNum": 710
              },
              "intervalDistributions": [
                {
                  "distribution": "300,600",
                  "intervalDistributionValue": {
                    "eventNum": 1,
                    "userNum": 1
                  }
                },
                {
                  "distribution": ",300",
                  "intervalDistributionValue": {
                    "eventNum": 5699,
                    "userNum": 710
                  }
                }
              ]
            },
            {
              "groups": [
                "华为"
              ],
              "intervalAggValue": {
                "avgValue": 40,
                "eventNum": 4779,
                "maxValue": 374,
                "midValue": 28,
                "minValue": 2,
                "quarterValue": 15,
                "threeQuarterValue": 51,
                "userNum": 603
              },
              "intervalDistributions": [
                {
                  "distribution": "300,600",
                  "intervalDistributionValue": {
                    "eventNum": 3,
                    "userNum": 3
                  }
                },
                {
                  "distribution": ",300",
                  "intervalDistributionValue": {
                    "eventNum": 4776,
                    "userNum": 603
                  }
                }
              ]
            }
          ],
          "intervalAggValue": {
            "avgValue": 39,
            "eventNum": 10479,
            "maxValue": 374,
            "midValue": 28,
            "minValue": 2,
            "quarterValue": 16,
            "threeQuarterValue": 50,
            "userNum": 1313
          },
          "intervalDistributions": [
            {
              "distribution": "300,600",
              "intervalDistributionValue": {
                "eventNum": 4,
                "userNum": 4
              }
            },
            {
              "distribution": ",300",
              "intervalDistributionValue": {
                "eventNum": 10475,
                "userNum": 1313
              }
            }
          ]
        }
      ],
      "groupEntities": [
        {
          "groups": [
            "苹果"
          ],
          "intervalAggValue": {
            "avgValue": 39,
            "eventNum": 12346,
            "maxValue": 354,
            "midValue": 28,
            "minValue": 2,
            "quarterValue": 16,
            "threeQuarterValue": 49,
            "userNum": 1542
          },
          "intervalDistributions": [
            {
              "distribution": "300,600",
              "intervalDistributionValue": {
                "eventNum": 6,
                "userNum": 6
              }
            },
            {
              "distribution": ",300",
              "intervalDistributionValue": {
                "eventNum": 12340,
                "userNum": 1542
              }
            }
          ]
        },
        {
          "groups": [
            "华为"
          ],
          "intervalAggValue": {
            "avgValue": 39,
            "eventNum": 10218,
            "maxValue": 374,
            "midValue": 28,
            "minValue": 2,
            "quarterValue": 15,
            "threeQuarterValue": 50,
            "userNum": 1282
          },
          "intervalDistributions": [
            {
              "distribution": "300,600",
              "intervalDistributionValue": {
                "eventNum": 5,
                "userNum": 5
              }
            },
            {
              "distribution": ",300",
              "intervalDistributionValue": {
                "eventNum": 10213,
                "userNum": 1282
              }
            }
          ]
        }
      ],
      "intervalAggValue": {
        "avgValue": 39,
        "eventNum": 22564,
        "maxValue": 374,
        "midValue": 28,
        "minValue": 2,
        "quarterValue": 16,
        "threeQuarterValue": 49,
        "userNum": 2817
      },
      "intervalDistributions": [
        {
          "distribution": "300,600",
          "intervalDistributionValue": {
            "eventNum": 11,
            "userNum": 11
          }
        },
        {
          "distribution": ",300",
          "intervalDistributionValue": {
            "eventNum": 22553,
            "userNum": 2817
          }
        }
      ]
    },
    "intervalType": "def",
    "timeArray": [
      "2021-10-04",
      "2021-10-05"
    ]
  },
  "return_code": 0,
  "return_message": "success"
}

响应参数说明​

$$参数名示例值参数类型参数描述
return_code0Integer返回码
return_messagesuccessString返回信息
data-Object返回结果
data.distributionInterval[",300","300,"]List分布间隔
data.groupCols[["苹果"],["华为"]]List<List>分组
data.intervalData-Object日期数据
data.intervalData.dateEntities-List日期列表
data.intervalData.dateEntities.dateString2021-10-04String日期
data.intervalData.groupEntities-List分组列表
data.intervalData.groupEntities.groups["苹果"]List分组值列表
data.intervalData.intervalAggValue-Object聚合值
data.intervalData.intervalAggValue.avgValue39Long平均值
data.intervalData.intervalAggValue.eventNum22564Long事件数
data.intervalData.intervalAggValue.maxValue374Long最大值
data.intervalData.intervalAggValue.midValue28Long中位数
data.intervalData.intervalAggValue.minValue2Long最小值
data.intervalData.intervalAggValue.quarterValue16Long上四分位
data.intervalData.intervalAggValue.threeQuarterValue49Long下四分位
data.intervalData.intervalAggValue.userNum2817Long用户数
data.intervalData.intervalDistributions-List分布区间列表
data.intervalData.intervalDistributions.distribution300,600String分布区间
data.intervalData.intervalDistributions.intervalDistributionValue-Object分布区间值
data.intervalData.intervalDistributions.intervalDistributionValue.eventNum11Long事件数
data.intervalData.intervalDistributions.intervalDistributionValue.userNum11Long用户数

data.intervalType

defString

类型

  • discrete：离散数字
  • def：默认区间
  • user_defined：用户自定义
data.timeArray["2021-10-04"]List事件列表

错误响应示例

{
    "return_code": -1008,
    "return_message": "参数(token)为空"
}
参数名示例值参数类型参数描述
return_code-1008Integer返回码
return_message参数(token)为空String返回信息

2. 间隔分析全量下载​

接口URL

/open/streaming-download/interval-analyze?token=xxx

请求方式

POST

Content-Type

application/json

请求Query参数

参数名示例值参数类型是否必填参数描述
tokenxxxString是查询密钥

请求Body参数​

{
        "eventView": {
                "endTime": "2022-03-07 17:17:04",
                "filts": [],
                "groupBy": [],
                "recentDay": "1-7",
                "relation": "and",
                "startTime": "2022-03-01 17:17:04",
                "taIdMeasureVo": {
                        "columnDesc": "User ID",
                        "columnName": "#user_id",
                        "tableType": "event"
                },
                "timeParticleSize": "day",
                "windowsGapUnit": "hour",
                "windowsGapValue": 1
        },
        "events": [{
                "eventName": "Login",
                "eventNameDisplay": "",
                "filts": [],
                "relation": "and",
                "type": "first"
        }, {
                "eventName": "Recharge",
                "eventNameDisplay": "",
                "filts": [],
                "relation": "and",
                "type": "second"
        }],
        "projectId": 319,
        "format": "AGG_TABLE",
        "zoneOffset": 10
}

请求参数说明​

$$参数名示例值参数类型是否必填参数描述
eventView-Object是指标公共属性部分，参数内容与间隔分析查询接口一致
events-List是事件指标列表
projectId377Integer是项目ID
formatAGG_TABLEString是

AGG_TABLE 盒须图转换表格

DISTRIBUTION_TABLE 转换分布表格

interval[1]array否全部区间
zoneOffset10Integer否时区

响应​

同AE系统间隔分析全量下载

3. 间隔分析用户列表​

接口URL

/open/interval-user-list?token=xxx

请求方式

POST

Content-Type

application/json

请求Query参数

参数名示例值参数类型是否必填参数描述
tokenxxxString是查询密钥

请求Body参数​

{
  "eventView": {
    "endTime": "2021-10-05 23:59:59",
    "filts": [
      {
        "columnDesc": "品牌",
        "columnName": "brand",
        "comparator": "equal",
        "filterType": "SIMPLE",
        "ftv": [
          "苹果",
          "华为"
        ],
        "specifiedClusterDate": "2022-01-24",
        "tableType": "event",
        "timeUnit": ""
      }
    ],
    "groupBy": [
      {
        "columnDesc": "品牌",
        "columnName": "brand",
        "propertyRange": "",
        "specifiedClusterDate": "2022-01-24",
        "tableType": "event"
      }
    ],
    "recentDay": "114-115",
    "relation": "and",
    "startTime": "2021-10-04 00:00:00",
    "taIdMeasureVo": {
      "columnDesc": "用户唯一ID",
      "columnName": "#user_id",
      "tableType": "event"
    },
    "timeParticleSize": "day",
    "windowsGapUnit": "hour",
    "windowsGapValue": 1
  },
  "events": [
    {
      "eventName": "activity_attend",
      "eventNameDisplay": "",
      "filts": [
      ],
      "relation": "and",
      "relationProp": {
        "property": {
          "columnDesc": "品牌",
          "columnName": "brand",
          "specifiedClusterDate": "2022-01-24",
          "tableType": "event"
        }
      },
      "type": "first"
    },
    {
      "eventName": "payment",
      "eventNameDisplay": "",
      "filts": [
      ],
      "relation": "and",
      "relationProp": {
        "property": {
          "columnDesc": "品牌",
          "columnName": "brand",
          "specifiedClusterDate": "2022-01-24",
          "tableType": "event"
        },
        "relationOperatorValue": 0,
        "relationPropNumberOperator": "r_eq"
      },
      "type": "second"
    }
  ],
  "projectId": 377,
  "timeoutSeconds": 10,
  "interval": "2,3",
  "sliceDate": "",
  "sliceGroupVal": ["苹果", "华为"],
  "zoneOffset": 10
}

请求参数说明​

$$参数名示例值参数类型是否必填参数描述
eventView-Object是参数内容与间隔分析查询接口一致
events-List是参数内容与间隔分析查询接口一致
projectId377Integer是项目ID
timeoutSeconds10Integer否请求超时参数，超时则取消查询任务
interval2,3String否哪个区间进行下钻
sliceDate2021-10-21String否哪个日期进行下钻
sliceGroupVal["苹果", "华为"]List否哪个分组进行下钻
zoneOffset10Integer否时区

成功响应示例​

{
  "data": {
    "columMeta": {
      "country": "国家",
      "education": "学历",
      "birthdate": "出生日期",
      "gender": "性别",
      "last_login_time": "last_login_time",
      "city": "城市",
      "nation": "民族",
      "channel": "用户操作类型",
      "weight": "体重（KG）",
      "#distinct_id": "访客ID",
      "firstcharge": "是否首充",
      "register_time": "register_time",
      "#account_id": "账户ID",
      "companynature": "工作单位性质",
      "accountbalance": "余额",
      "maritalstatus": "婚姻状况",
      "interest": "兴趣爱好",
      "name": "姓名",
      "accountpoint": "积分项",
      "rank": "会员等级",
      "first_login_time": "first_login_time",
      "email": "邮箱",
      "height": "身高（CM）"
    },
    "datalist": [
      {
        "country": "中国",
        "birthdate": "2013-05-21",
        "education": "大专",
        "last_login_time": "2021-12-04 02:18:46.111",
        "gender": "男",
        "city": "上海市",
        "nation": "汉族",
        "#user_id": 795692987887919100,
        "channel": "微信",
        "weight": "125",
        "#distinct_id": "5694fdd8-e1dc-4459-97dd-33b10df01400",
        "firstcharge": false,
        "register_time": "2021-10-06 00:00:23.000",
        "#account_id": "b406f8a7-424d-4909-a08a-7b00191b7493",
        "companynature": "国有企业",
        "accountbalance": "42606",
        "maritalstatus": "未婚",
        "interest": [
          "旅行",
          "运动",
          "运动"
        ],
        "accountpoint": "81910",
        "name": "UaLEhzdn",
        "rank": "金卡",
        "first_login_time": "2021-10-06 00:01:56.000",
        "email": "ElqqXwdL@thinkingdata.cn",
        "height": "174"
      },
      {
        "country": "中国",
        "birthdate": "1964-12-26",
        "education": "大专",
        "last_login_time": "2021-10-05 00:02:35.000",
        "gender": "男",
        "city": "上海市",
        "nation": "汉族",
        "#user_id": 795692395992715300,
        "channel": "官网",
        "weight": "197",
        "#distinct_id": "5caf9f1a-3253-4279-9723-49c950a48020",
        "firstcharge": true,
        "register_time": "2021-10-05 00:00:30.000",
        "#account_id": "cb6ab625-f45d-4977-bbae-973ead82acba",
        "companynature": "外资",
        "accountbalance": "49013",
        "maritalstatus": "未婚",
        "interest": [
          "运动",
          "唱歌",
          "运动"
        ]
      }
    ],
    "totalNum": 2
  },
  "return_code": 0,
  "return_message": "success"
}

响应参数说明​

$$参数名示例值参数类型参数描述
return_code0Integer返回码
return_messagesuccessString返回信息
data-Object返回结果
data.datalist-List<Map>用户信息
data.columMeta-Map字段含义映射
data.totalNum2Integer总数

错误响应示例

{
    "return_code": -1008,
    "return_message": "参数(token)为空"
}
参数名示例值参数类型参数描述
return_code-1008Integer返回码
return_message参数(token)为空String返回信息

4. 间隔分析用户列表下载​

接口URL

/open/streaming-download/interval-user-list?token=xxx

请求方式

POST

Content-Type

application/json

请求Query参数

参数名示例值参数类型是否必填参数描述
tokenxxxString是查询密钥

请求Body参数​

{
    "eventView": {
        "endTime": "2022-03-07 17:17:04",
        "filts": [],
        "groupBy": [],
        "recentDay": "1-7",
        "relation": "and",
        "startTime": "2022-03-01 17:17:04",
        "taIdMeasureVo": {
            "columnDesc": "User ID",
            "columnName": "#user_id",
            "tableType": "event"
        },
        "timeParticleSize": "day",
        "windowsGapUnit": "hour",
        "windowsGapValue": 1
    },
    "events": [
        {
            "eventName": "Login",
            "eventNameDisplay": "",
            "filts": [],
            "relation": "and",
            "type": "first"
        },
        {
            "eventName": "Recharge",
            "eventNameDisplay": "",
            "filts": [],
            "relation": "and",
            "type": "second"
        }
    ],
    "projectId": 319,
    "sliceGroupVal": null,
    "sliceDate": "2022-03-01",
    "selectedColumns": [
        "#account_id",
        "#distinct_id",
        "accountid"
    ],
    "zoneOffset": 10
}

请求参数说明​

$$参数名示例值参数类型是否必填参数描述
eventView-Object是参数内容与间隔分析查询接口一致
events-List是参数内容与间隔分析查询接口一致
projectId377Integer是项目ID
selectedColumns["#account_id"]array是需要下载的项
interval2,3String哪个区间进行下钻
sliceDate2021-10-21String否哪个日期进行下钻
sliceGroupVal["苹果", "华为"]List否哪个分组进行下钻
zoneOffset10Integer否时区

响应​

同 AE 系统间隔分析用户列表下载

这篇文档对你有帮助吗？
本页内容