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.
Ecommerce_Advertiser
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: Reporting API
Replication Type: API Key Based
| Name | Data Type | Description |
| campaign | STRING | Campaign name |
| campaign_id_external | STRING | External campaign ID |
| clicks | STRING | Number of ad clicks |
| conversions | STRING | Number of conversions |
| impressions | STRING | Number of ad impressions |
| ctr | STRING | Click-through rate (%) |
| ad | STRING | Ad creative name |
| ad_id | STRING | Ad ID |
| day | DATE | Date of data (YYYY-MM-DD) |
| ad_type | STRING | Type of ad (e.g., VIDEO) |
| chka_0d | STRING | Purchases within 0 days of click |
| chka_7d | STRING | Purchases within 7 days of click |
| chka_usd_0d | STRING | Revenue (USD) from purchases within 0 days |
| chka_usd_1d | STRING | Revenue (USD) from purchases within 1 days |
| chka_usd_2d | STRING | Revenue (USD) from purchases within 2 days |
| chka_usd_3d | STRING | Revenue (USD) from purchases within 3 days |
| chka_usd_7d | STRING | Revenue (USD) from purchases within 7 days |
| cost_per_chka_0d | STRING | Cost per purchase (0 day) |
| cost_per_chka_7d | STRING | Cost per purchase (7 day) |
| roas_0d | STRING | Return on ad spend (0 day) |
| roas_1d | STRING | Return on ad spend (1 day) |
| roas_2d | STRING | Return on ad spend (2 day) |
| roas_3d | STRING | Return on ad spend (3 day) |
| roas_7d | STRING | Return on ad spend (7 day) |
| sales | STRING | Total sales count |
| cost | STRING | Ad spend (USD) |
| ad_creative_type | STRING | Creative format/type |
| hour | TIME | Hour of the day (HH:MM) |
| creative_set | STRING | Creative set name |
| creative_set_id | STRING | This does not change if the creative set name changes. |
| device_type | STRING | phone,tablet or other |
| country | STRING | Two-letter country code |
| placement_type | STRING | Give information about what type of placement |
| campaign_type | STRING | The campaign optimization type |
| campaign_ad_type | STRING | Provides which type of campaigns |
| campaign_bid_goal | STRING | Campaign value |
| first_purchase | STRING | Users who purchased first time |
| platform | STRING | which type of platform android, ios or any other type |
| average_cpc | STRING | Average cost per click |
| sales_x | STRING | Sales during a particular time span |
| cpp_x | STRING | Cost per purchase during particular span time |
| custom_page_id | STRING | The iOS Custom Product Page or Android Store Listing associated with the creative set |
| nc_d0_checkouts | STRING | Number of checkouts made by new customers |
| nc_percent_d0_checkouts | STRING | Percentage of D0 checkouts generated by new customers |
| target_event | STRING | Name of the event the campaign is optimizing towards. |