Schema Information for Applovin
Schema Information for Applovin
In this article, we will look at the schema information of the supported APIs and tables for Applovin.
Find the links to other articles related to Applovin below:
Tables/APIs Supported
The tables and APIs associated with the Applovin connector are as follows.
Audience
Purpose: The AppLovin Ecommerce Reporting API provides performance metrics and attribution data for ecommerce campaigns to help advertisers analyze and optimize their ad spend.
Source API Documentation: https://developers.axon.ai/en/ecommerce/reporting-api
Replication Type: Key Based
| Name | Data Type | Description |
| campaign | String | Campaign name |
| campaign_id_external | String | External campaign ID |
| clicks | Integer | Number of ad clicks |
| conversions | Integer | Number of conversions |
| impressions | Integer | Number of ad impressions |
| ctr | Float | Click-through rate (%) |
| ad | String | Ad creative name |
| ad_id | String | Ad ID |
| day | String (Date) | Date of data (YYYY-MM-DD) |
| ad_type | String | Type of ad (e.g., VIDEO) |
| chka_0d | Integer | Purchases within 0 days of click |
| chka_7d | Integer | Purchases within 7 days of click |
| chka_usd_0d | Float | Revenue (USD) from purchases within 0 days |
| chka_usd_7d | Float | Revenue (USD) from purchases within 7 days |
| cost_per_chka_0d | Float | Cost per purchase (0 day) |
| cost_per_chka_7d | Float | Cost per purchase (7 day) |
| roas_0d | Float | Return on ad spend (0 day) |
| roas_7d | Float | Return on ad spend (7 day) |
| sales | Integer | Total sales count |
| cost | Float | Ad spend (USD) |
| ad_creative_type | String | Creative format/type |
| hour | String (Time) | Hour of the day (HH:MM) |