Skip to content

ad_load

An event that occurs when an ad creative is loaded on the client. You can use it to create metrics such as the number of ad loads and the load-to-impression conversion rate.

Attribute name Data type Description
dateTime TIMESTAMP Indicates the date and time when the event occurred. Recorded based on the event time, and can be used as the basis for aggregation by period unit (day/week/month/hour/minute) and date range queries. (Example: 2023-05-09 19:30:35)
eventName STRING Indicates the name that identifies the event. Because all events are loaded together into a single source log, this value identifies which event it is, and it can be used as the basis for querying data by event. (Example: app_login)
userId STRING Indicates the account-based identifier of the user who triggered the event. Recorded based on the user's unique ID in the app, and can be used to count unique users, such as AU, with a distinct count aggregation.
identifierProvider STRING Indicates the system that issued the user identifier. The value is always "hive".
deviceId STRING Indicates the device-based identifier of the user who triggered the event. Recorded based on the instance value issued for each device every time the app is installed, and can be used to count unique devices (such as the number of terms agreements) with a distinct count aggregation. (Example: 33333333)
appIdGroup STRING Indicates the project where the event occurred. Recorded based on the GAMEID value registered in Hive Console > Project Settings > App ID, and can be used to compare metrics by project when you query multiple projects together. (Example: com.sample.analytics)
appId STRING Indicates the unique ID of the app where the event occurred. Recorded based on the APPID registered in Hive Console > Project Settings > App ID, and can be used to distinguish metrics by app. (Example: com.sample.analytics.google.global.android.common)
country STRING Indicates the user's country identified when the event occurred. Recorded in ISO 3166-1 alpha-2 uppercase format, and can be used to compare the number of users, revenue, retention, and so on by country. (Example: KR, US)
serverId STRING Indicates the app server the user was connected to when the event occurred. Recorded based on the server identifier sent by the app, and can be used to compare the number of users, revenue, and retention by server. (Example: KR, GLOBAL)
model STRING Indicates the model name of the user's device when the event occurred. Recorded based on the device model value sent by the client, and can be used to compare metrics by device model. (Example: iPhone 12 Pro, SHW-M250S)
appVer STRING Indicates the app version when the event occurred. Recorded based on the app version information, and can be used with the os attribute to compare users by app version. (Example: 4.3.3, 1.6.5)
market STRING Indicates the market where the user installed the app when the event occurred. Recorded based on the market where the app is installed or serviced, and can be used to compare metrics by market. (Example: GO (Google Play), AP (Apple App Store), HS (direct distribution))
osVer STRING Indicates the OS version of the user's device when the event occurred. Recorded based on the device's operating system version, and can be used to compare metrics by OS version. (Example: 9.2, 16.3.1)
lang STRING Indicates the language value when the event occurred. Recorded based on the app or device language (ISO 639 alpha-2, lowercase), and can be used to compare metrics by language. (Example: ko, en)
os STRING Indicates the operating system of the user's device when the event occurred. Recorded based on the platform value sent by the client, and can be used to compare metrics by OS. (Example: A (Android), I (iOS))
clientIp STRING Indicates the IP of the user's device where the event occurred. Recorded with the last segment of the IP masked, and can be used to query data such as the number of devices by IP range. (Example: 127.0.0.x)
sdkVer STRING Indicates the Hive Axyl SDK version when the event occurred. Recorded based on the Hive Axyl SDK version applied to the client, and can be used to compare data collection status by SDK version. (Example: 1.0.0)
adNetwork STRING Indicates the ad network where the ad was displayed or viewed. Recorded based on the network that provided the ad, and can be used to compare ad metrics by network. (Example: admob)
uniqueSessionKey STRING Indicates the unique session key that identifies a single ad view. Recorded based on the ad view session key, and can be used to count unique ad view sessions with a distinct count aggregation.
adUnitId STRING Indicates the unique key of the ad unit of the viewed ad. Recorded based on the unique key that identifies the ad in the mediation, and can be used to compare metrics by ad unit.
rewardType STRING Indicates the type of reward item granted after the ad view. Recorded based on the reward item type when the ad reward is granted, and can be used to compare metrics by reward type. (Example: coins)
rewardAmount INT(FLOAT) Indicates the quantity of reward items granted after the ad view. Recorded based on the reward quantity when the ad reward is granted, and can be used to calculate the amount of rewards granted with a sum or average aggregation. (Example: 10.0)
adPlacement STRING Indicates the placement where the ad was displayed or viewed. Recorded based on the ad placement value sent by the app, and can be used to compare view and click metrics by ad placement. (Example: inapp_banner)
adSource STRING Indicates information about the ad module integrated with the ad. Recorded based on the ad module the app integrates, and can be used to compare metrics by ad module. (Example: ADOP, ADX)
ecpm INT(FLOAT) Indicates the estimated revenue per 1,000 ad impressions. Recorded based on the eCPM value calculated when ad revenue occurs, and can be used to compare profitability by ad network and ad placement. (Example: 10.0)