Reporting API

Use this Reporting API to get aggregated campaign data in either JSON or CSV format.

Request Format

Make report requests by sending HTTP GET requests to the following base URL:

• https://r.applovin.com/report

Required Parameters

Parameters	Purpose
api_key	Your Report Key You can find this Report Key in the Keys tab of the account page in your AppLovin dashboard.
start1	The start date of the report Accepts a date in YYYY-MM-DD format or a Unix timestamp. For example, 2012-10-05 or 1336608000.
end1	The end date of the report Accepts a date in YYYY-MM-DD format or a Unix timestamp. For example, 2012-10-05 or 1336608000 or now.
format	The format for the report Accepts json or csv. See details on request format below.
columns	A comma-separated list of columns for the report See the allowed columns below. For example, ad_id,day,campaign.
report_type	advertiser (required)

¹ This API has a request window of 45 days. Make sure the date parameters are within the last 45 days.

Optional Parameters

Parameters	Purpose
day_column	Metrics are realtime by default; set this to day when you want to pull metrics under cohort (metrics are attributed back to serve time).
limit	The limit on the number of rows returned; for example, 500
offset	The offset to begin fetching rows at; for example, 100
having	Allows complex filtering on numeric values. This parameter accepts URL-encoded values of numeric columns, comparison operators, and logical operators, for example: impressions%20%3E%200%20AND%20cost%20%3E%200 (“impressions > 0 AND cost > 0”). Note: This slows down the response and increases the likelihood of timeouts.
not_zero	Set this to 1 to filter results in which all numerical metrics have a value of 0.

Recommended Columns

Column Name	Contains
ad	Ad name
ad_id	Ad ID. This does not change if the ad name changes.
campaign	Campaign name
campaign_id_external	Unique reference to a campaign This does not change when the campaign is renamed. It is the same value as the {CAMPAIGN_ID} click macro.
cost	Advertiser spend
country	Two letter country code
creative_set	Creative set name
creative_set_id	Creative set ID. This does not change if the creative set name changes.
day	Date of reporting data
hour	Hour of reporting data (only available for the past 30 days)

Optional Columns

Column Name	Contains
ad_creative_type	GRAPHIC, VIDEO, PLAY, VIDEO_PLAY, REWARDED_VIDEO, REWARDED_PLAY, REWARDED_VIDEO_PLAY
ad_type	APPOPEN, GRAPHIC, PLAY, REWARD, or VIDEO
average_cpc	Average cost per click
campaign_bid_goal	The campaign bid goal, expressed as a dollar value ($), for CPP and CPE campaigns. You must also request the campaign column when you request this one.
chka_0d	Attributed checkouts that occurred within 24 hours since the impression time
chka_1d	Attributed checkouts that occurred within 48 hours since the impression time
chka_2d	Attributed checkouts that occurred within 72 hours since the impression time
chka_3d	Attributed checkouts that occurred within 96 hours since the impression time
chka_7d	Attributed checkouts that occurred within 192 hours since the impression time
chka_usd_0d	Total attributed checkout revenue that occurred within 24 hours since the impression time
chka_usd_1d	Total attributed checkout revenue that occurred within 48 hours since the impression time
chka_usd_2d	Total attributed checkout revenue that occurred within 72 hours since the impression time
chka_usd_3d	Total attributed checkout revenue that occurred within 96 hours since the impression time
chka_usd_7d	Total attributed checkout revenue that occurred within 192 hours since the impression time
clicks	Number of clicks
cost_per_chka_0d	CPP within 24 hours since the impression time
cost_per_chka_1d	CPP within 48 hours since the impression time
cost_per_chka_2d	CPP within 72 hours since the impression time
cost_per_chka_3d	CPP within 96 hours since the impression time
cost_per_chka_7d	CPP within 192 hours since the impression time
ctr	Number of clicks ÷ number of impressions
custom_page_id	The specific landing page
impressions	Number of impressions
platform	android, ios, fireos, or tvos
roas_0d	Checkout ROAS generated within 24 hours since the impression time
roas_1d	Checkout ROAS generated within 48 hours since the impression time
roas_2d	Checkout ROAS generated within 72 hours since the impression time
roas_3d	Checkout ROAS generated within 96 hours since the impression time
roas_7d	Checkout ROAS generated within 192 hours since the impression time
sales	Count of attributed sales events
size	Ad size (BANNER, INTER, LEADER, MREC, NATIVE, or PRELOAD)

Filtering Columns

You can filter reports by any column. When you do so, you search for a direct match to any of the filters.

To filter by a column, add the following URL parameter: filter_columnname=onefilter,anotherfilter,thirdfilter

For example, if you want to see data only for the Android platform, set the following URL parameter: filter_platform=Android

See the table above for a list of all columns.

Some columns support negative filters via filter_not_columnname=onefilter,anotherfilter. Additionally, the custom_page_id column supports filter_null_custom_page_id, filter_blank_custom_page_id, filter_not_null_custom_page_id, and filter_not_blank_custom_page_id options. These options do not require a value, i.e. …&filter_not_null_custom_page_id=&filter_not_blank_custom_page_id=&…

Sorting Columns

You sort reports in a similar way to how you filter reports.

For example, to sort a report by campaign, add the following URL parameter: sort_campaign=ASC

The accepted values are ASC for ascending or DESC for descending. All sorts are lexicographical sort.

Report Formats

You can request reports in two formats: JSON or CSV.

Time Zone

All data in the reporting API is in UTC (Coordinated Universal Time).

Example Request

https://r.applovin.com/report?api_key=«YOUR_REPORT_KEY»&start=2024-04-20&end=now&columns=day,campaign,impressions,clicks,ctr,cost,sales&format=json&report_type=advertiser