首页 > 用户手册 > 导出报表数据——留存分析

导出报表数据——留存分析

1.新增用户数据

POST _SJK_API_PATH_/api-v2/retention/calculate_new

请求参数:

字段 格式 说明 是否必需 示例
access_token string 通过oauth认证获取的token
platform_id int 平台id web:1 H5:2 IOS:3 Android:4 微信小程序:5
retention_id int 自定义留存id 通过base/retentions接口获取
predicates array 筛选条件 predicates[0][values][]=搜索引擎&predicates[0][op]=eq&predicates[0][name]=channel_type 即为筛选访问渠道类型等于搜索引擎的数据。其中op操作符可能出现的值:eq / ne / gt / ge / lt / le / like / nlike / between / null / not null
dimensions array 维度(即属性),用于分组查询 数据通过 base/attrs接口获取 dimensions[]=channel 即为按访问渠道名称分组
relation string 多个筛选条件(predicates)之间的关系 可能出现的值:and / or 若筛选条件不足2个,默认and
granularity string 查询的时间粒度 可能出现的值:month / week / day
time_range array 查询的时间范围 time_range[]=2019-08-06&time_range[]=2019-08-12需要有起始时间和结束时间2个值且结束时间不能小于起始时间

调用示例:

curl -d 'access_token=_TOKEN_&retention_id=10&dimensions[]=channel&relation=and&granularity=day&time_range[]=2019-08-05&time_range[]=2019-08-11' https://a.shujike.com/api-v2/retention/calculate_new

Response:

{
  "status": 0,
  "msg": {
    "msg": "success",
    "desc": ""
  },
  "data": [
    [
      "2019-08-05",
      "\u767e\u5ea6\u641c\u7d22",
      451
    ],
    [
      "2019-08-05",
      "www.5688.com.cn",
      1
    ],
    [
      "2019-08-06",
      "wap.sogou.com",
      1
    ],
    [
      "2019-08-06",
      "\u767e\u5ea6\u641c\u7d22",
      521
    ],
    [
      "2019-08-07",
      "\u65b0\u6d6a\u535a\u5ba2",
      1
    ],
    [
      "2019-08-07",
      "www.moodao.com",
      1
    ],
    [
      "2019-08-08",
      "\u767e\u5ea6\u641c\u7d22",
      365
    ],
    [
      "2019-08-09",
      "huaban.com",
      1
    ],
    [
      "2019-08-10",
      "\u767e\u5ea6\u624b\u673a\u7248",
      180
    ],
    [
      "2019-08-11",
      "BING",
      24
    ]
  ]
}

字段介绍:[时间,维度,新增用户数]

2.后续留存用户数据

POST _SJK_API_PATH_/api-v2/retention/calculate_retention

请求参数:同retention/calculate_new

调用示例:

curl -d 'access_token=_TOKEN_&retention_id=10&dimensions[]=channel&relation=and&granularity=day&time_range[]=2019-08-05&time_range[]=2019-08-11' https://a.shujike.com/api-v2/retention/calculate_retention

Response:

{
  "status": 0,
  "msg": {
    "msg": "success",
    "desc": ""
  },
  "data": [
    [
      "2019-08-05",
      "GOOGLE",
      "2019-08-09",
      2
    ],
    [
      "2019-08-05",
      "\u767e\u5ea6\u624b\u673a\u7248",
      "2019-08-05",
      4
    ],
    [
      "2019-08-06",
      "\u7b80\u4e66",
      "2019-08-06",
      1
    ],
    [
      "2019-08-06",
      "\u767e\u5ea6\u641c\u7d22",
      "2019-08-09",
      2
    ],
    [
      "2019-08-06",
      "GOOGLE",
      "2019-08-06",
      3
    ],
    [
      "2019-08-07",
      "\u767e\u5ea6\u641c\u7d22",
      "2019-08-08",
      5
    ],
    [
      "2019-08-07",
      "GOOGLE",
      "2019-08-12",
      1
    ],
    [
      "2019-08-08",
      "GOOGLE",
      "2019-08-08",
      1
    ],
    [
      "2019-08-08",
      "\u5fae\u4fe1\u597d\u53cb\u5206\u4eab",
      "2019-08-09",
      1
    ],
    [
      "2019-08-09",
      "\u767e\u5ea6\u641c\u7d22",
      "2019-08-12",
      2
    ],
    [
      "2019-08-09",
      "\u767e\u5ea6\u641c\u7d22",
      "2019-08-09",
      11
    ],
    [
      "2019-08-10",
      "GOOGLE",
      "2019-08-11",
      1
    ],
    [
      "2019-08-10",
      "\u767e\u5ea6\u624b\u673a\u7248",
      "2019-08-10",
      3
    ],
    [
      "2019-08-11",
      "\u767e\u5ea6\u641c\u7d22",
      "2019-08-12",
      2
    ]
  ]
}

字段介绍:[作为新增用户出现时间,维度,再次访问时间,再次访问用户数]

3.新增用户明细

POST _SJK_API_PATH_/api-v2/retention/new_detail

请求参数:

字段 格式 说明 是否必需 示例
access_token string 通过oauth认证获取的token
platform_id int 平台id web:1 H5:2 IOS:3 Android:4 微信小程序:5
retention_id int 自定义留存id 通过base/retentions接口获取
predicates array 筛选条件 predicates[0][values][]=搜索引擎&predicates[0][op]=eq&predicates[0][name]=channel_type 即为筛选访问渠道类型等于搜索引擎的数据。其中op操作符可能出现的值:eq / ne / gt / ge / lt / le / like / nlike / between / null / not null
dimensions array 维度(即属性),用于分组查询 数据通过 base/attrs接口获取 dimensions[]=channel 即为按访问渠道名称分组
relation string 多个筛选条件(predicates)之间的关系 可能出现的值:and / or 若筛选条件不足2个,默认and
granularity string 查询的时间粒度 可能出现的值:month / week / day
time_range array 查询的时间范围 time_range[]=2019-08-06&time_range[]=2019-08-12需要有起始时间和结束时间2个值且结束时间不能小于起始时间
predicates2 array 具体查询明细的时间和维度条件 predicates2[0][name]=channel&predicates2[0][op]=eq&predicates2[0][values][]=BING&predicates2[1][name]=dd&predicates2[1][op]=eq&predicates2[1][values][]=2019-08-12 必须由时间维度和所选的dimensions的具体值组成限定条件

调用示例:

curl -d 'access_token=_TOKEN_&retention_id=10&dimensions[]=channel&predicates2[0][name]=channel&predicates2[0][op]=eq&predicates2[0][values][]=简书&predicates2[1][name]=dd&predicates2[1][op]=eq&predicates2[1][values][]=2019-08-05&relation=and&granularity=day&time_range[]=2019-08-05&time_range[]=2019-08-11' https://a.shujike.com/api-v2/retention/new_detail

Response:

{
  "status": 0,
  "msg": {
    "msg": "success",
    "desc": ""
  },
  "data": [
    [
      "1f466c2a2316f209",
      "-",
      "2019-08-05 12:54:00",
      "\u65b0\u8bbf\u5ba2",
      "\u672a\u6ce8\u518c\u7528\u6237",
      "\u5916\u94fe",
      "\u7b80\u4e66",
      "\u6d59\u6c5f",
      "-"
    ],
    [
      "1f466c2a2316f209",
      "-",
      "2019-08-05 12:53:00",
      "\u65b0\u8bbf\u5ba2",
      "\u672a\u6ce8\u518c\u7528\u6237",
      "\u5916\u94fe",
      "\u7b80\u4e66",
      "\u6d59\u6c5f",
      "-"
    ],
    [
      "1f466c2a2316f209",
      "-",
      "2019-08-05 12:52:00",
      "\u65b0\u8bbf\u5ba2",
      "\u672a\u6ce8\u518c\u7528\u6237",
      "\u5916\u94fe",
      "\u7b80\u4e66",
      "\u6d59\u6c5f",
      "-"
    ],
    [
      "1f466c2a2316f209",
      "-",
      "2019-08-05 12:51:00",
      "\u65b0\u8bbf\u5ba2",
      "\u672a\u6ce8\u518c\u7528\u6237",
      "\u5916\u94fe",
      "\u7b80\u4e66",
      "\u6d59\u6c5f",
      "-"
    ],
    [
      "b4dc48f92156fa3c",
      "-",
      "2019-08-05 14:42:00",
      "\u65b0\u8bbf\u5ba2",
      "\u672a\u6ce8\u518c\u7528\u6237",
      "\u5916\u94fe",
      "\u7b80\u4e66",
      "\u5317\u4eac",
      "\u5317\u4eac"
    ]
  ]
}

字段含义 [[数极客ID,用户ID,最近访问时间,访客类型,注册类型,渠道类型,渠道名称,所在省份,所在城市]..]

4.留存用户明细

POST _SJK_API_PATH_/api-v2/retention/retention_detail

请求参数:同retention/new_detail 接口

调用示例:

curl -d 'access_token=_TOKEN_&retention_id=10&dimensions[]=channel&predicates2[0][name]=channel&predicates2[0][op]=eq&predicates2[0][values][]=百度手机版&predicates2[1][name]=first_dd&predicates2[1][op]=eq&predicates2[1][values][]=2019-08-05&predicates2[2][name]=dd&predicates2[2][op]=eq&predicates2[2][values][]=2019-08-06&relation=and&granularity=day&time_range[]=2019-08-05&time_range[]=2019-08-11' https://a.shujike.com/api-v2/retention/retention_detail

Response:

{
  "status": 0,
  "msg": {
    "msg": "success",
    "desc": ""
  },
  "data": [
    [
      "75370fc6a04cfe7c",
      "-",
      "2019-08-06 11:28:00",
      "\u56de\u8bbf\u8bbf\u5ba2",
      "\u672a\u6ce8\u518c\u7528\u6237",
      "\u641c\u7d22\u5f15\u64ce",
      "\u767e\u5ea6\u624b\u673a\u7248",
      "\u5e7f\u4e1c",
      "\u6df1\u5733"
    ],
    [
      "8380914874464e53",
      "-",
      "2019-08-06 00:35:00",
      "\u56de\u8bbf\u8bbf\u5ba2",
      "\u672a\u6ce8\u518c\u7528\u6237",
      "\u641c\u7d22\u5f15\u64ce",
      "\u767e\u5ea6\u624b\u673a\u7248",
      "\u6e56\u5357",
      "\u957f\u6c99"
    ]
  ]
}

字段含义 [[数极客ID,用户ID,最近访问时间,访客类型,注册类型,渠道类型,渠道名称,所在省份,所在城市]..]

results matching ""

    No results matching ""