View and download query result reports, event detail reports, and custom query task results from the Download Hub.
This document is an introduction to Quick Tracking and technical integration and is not used as a sales basis. For specific products and technical services purchased by an enterprise, the commercial purchase contract shall prevail.
Overview
In the Download Hub, you can view and download the following three types of reports:
-
Query result report: When you export query results from an analysis model and the data volume is large, the system automatically creates an offline download task. You can view and download the results in this report.
-
Event Details Report: When you query events, you can retrieve the event log details for a specific result indicator value and download them from this report.
-
Custom Query Task: When you export query results from a custom SQL query, the system automatically creates an offline download task. You can view and download the results in this report.
You can only view export tasks created by the current account. Tasks from other accounts in the same organization or application are not visible.
Query result report
When you click 「Export Data」 in an analysis model and the data volume is large, the system automatically creates an offline download task. You can view and download the results in this report.
Event Detail Report
When you perform an event analysis query, you can retrieve the event log details for a specific result indicator value and download them from this report.
Example: After you obtain query results, click 「Retrieve Event Details」 for a specific metric value to retrieve the logs involved in calculating that metric.
The following table describes the fields in the event details file:
|
Parameter |
Type |
Field |
Description |
|
app_id |
String |
app ID |
Consists of the appkey @ platform type |
|
tenant_id |
String |
The DataWorks tenant ID. |
|
|
client_code |
String |
The name of the application |
|
|
platform |
Nullable(String) |
Platform Type |
|
|
eid |
String |
Entity ID |
QuickTracking IDs generated by mapping rules |
|
utdid |
String |
The device ID. |
Is the unique identifier of the device generated by the device ID |
|
ll_userid |
Nullable(String) |
The ID of the account. |
Is the account unique identifier level for custom uploads |
|
event_code |
String |
Event code |
|
|
event_id |
String |
The ID of the event type. |
2001 -page view; 2101 -control click; 2201 -Control Exposure; 19999 -Custom Event |
|
event_kv_json |
String |
The custom properties. |
kv json format, a collection of reported custom attributes |
|
page |
Nullable(String) |
Page encoding |
|
|
refer_page |
Nullable(String) |
Source page encoding |
|
|
server_timestamp |
Int64 |
Time on the NTP server |
Server timestamp (ms) |
|
stat_date |
Date |
Server Date |
from server_timestamp. |
|
stat_hour |
Nullable(String) |
Server Hours |
from server_timestamp. |
|
stat_minute |
Nullable(String) |
server minutes |
from server_timestamp. |
|
local_timestamp |
Int64 |
Client Time |
Client timestamp (ms) |
|
screen |
Nullable(String) |
Desktop Resolution |
|
|
os_version |
Nullable(String) |
The version of the operating system. |
|
|
device_brand |
Nullable(String) |
Device brand |
|
|
device_model |
Nullable(String) |
Device model |
|
|
device_type |
Nullable(String) |
Device Type |
|
|
access |
Nullable(String) |
Network type |
|
|
os |
Nullable(String) |
Operating System, |
|
|
web_browser |
Nullable(String) |
Browser Type |
|
|
carrier |
String |
Device Operator |
|
|
is_new_install |
String |
New and old users |
1 means "Yes", 0 means "No" |
|
scene |
Nullable(String) |
Scenario |
Mini program scenario values |
|
imei |
Nullable(String) |
imei |
International Mobile Equipment Identity Code, which is the phone's serial number |
|
imsi |
Nullable(String) |
imsi |
An international mobile subscriber identity code used to identify a mobile subscriber in a mobile communications network. |
|
idfa |
Nullable(String) |
idfa |
An advertising identifier used to track users, which can be used to break down ads between different apps. If the user is not authorized, it may not be obtained. |
|
mac |
String |
mac |
|
|
idfv |
String |
idfv |
|
|
oid |
String |
oid |
|
|
android_id |
String |
android_id |
|
|
oaid |
String |
oaid |
|
|
unionid |
String |
unionid |
|
|
openid |
String |
openid |
|
|
user_agent |
Nullable(String) |
User-Agent |
|
|
ip |
String |
ip |
|
|
country_name |
Nullable(String) |
The country. |
The country that is resolved by IP address, such as CN |
|
province_name |
Nullable(String) |
Province |
Provinces parsed by IP, such as Shandong Province |
|
city_name |
Nullable(String) |
The city. |
Cities parsed through IP, such as Jinan |
|
app_channel |
Nullable(String) |
The app channel |
App Market |
|
sdk_version |
Nullable(String) |
The version of the SDK. |
|
|
app_version |
Nullable(String) |
The app version. |
|
|
first_install_channel |
String |
Initial installation channel |
|
|
first_install_app_version |
String |
Initial installed app version |
|
|
first_install_datetime |
String |
Initial installation time |
|
|
is_first_day |
String |
Start on the first day |
Device level |
|
is_first_time |
String |
Whether to trigger for the first time |
Device level |
|
is_first_login |
Nullable(String) |
Indicates whether this is the first logon of the user. |
Account Level |
|
is_utdid_null |
LowCardinality(String) |
Whether the device ID is empty |
|
|
duration |
Nullable(Float32) |
Session Duration |
Only the application exit (preset) and page exit (preset) events on the APP side have this property value, indicating the duration of a single application access or page stay |
Custom query task
When you click 「Save」 Query Results in a custom SQL query, the system automatically creates an offline download task. You can view and download the results in this report.
