File Dump of App-Ads.txt for Mobile Apps
42matters provides a data dump containing the App-Ads.txt data
for all apps on the Google Play, Apple App Store, Amazon, Roku, FireTV, tvOS, LG, Samsung, Vizio and Google TV. The bulk download solution is perfect
for digital advertisers to improve their ad-fraud detection capabilities based on the
Authorized Digital Sellers
standard from IAB.
The specification is designed to protect mobile app ad inventory by allowing apps
to list authorized sellers of their app’s ad inventory on their developer website.
See docs for v2.0
app-ads.txt file dumps.
Dump Types
Weekly Standard App-ads.txt Dump
Apple App Store Apps
All*
*: for all mobile apps implementing the App-Ads.txt standard on their listed
domain.
Sample Data Dump
Have a look at the weekly-updated App-Ads.txt samples.
Please login or register to download sample data dumps.
Data Format
Data is stored in two gzipped CSV files.
- One file contains all valid &
up-to-date app-ads.txt entries found in apps of the respective store.
- A file with "-outdated" suffix
contains any entries that were present in valid app-ads.txt files, but who are no longer available.
The
second file is delivered for completeness.
Each file has the following characteristics:
- The very first record is a header containing the list of field names
- Each line is a valid CSV record
- UTF-8 encoding
- Records are divided into fields separated by the "," (comma) delimiter
Schema for: playstore-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The domain name of the
advertising system, e.g. the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app package name (unique identifier) on the specific App Store (as listed in field
AppStoreId).
|
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: itunes-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The canonical domain name of the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app package name (unique identifier) on the specific App Store (as listed in field
AppStoreId).
|
TrackId |
String |
Numeric unique identifier for the app (as listed in field AppId) assigned by Apple on the
specific App Store.
|
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: amazon-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The domain name of the
advertising system, e.g. the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app package name (unique identifier) on the specific App Store (as listed in field
AppStoreId).
|
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: roku-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The canonical domain name of the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app id (unique identifier) on Roku ChannelStore. |
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
ChannelId |
String |
Channel id unique identifier for the app on Roku ChannelStore. |
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: tvos-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The canonical domain name of the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app package name (unique identifier) on the specific App Store (as listed in field
AppStoreId).
|
TrackId |
String |
Numeric unique identifier for the app (as listed in field AppId) assigned by Apple on the
specific App Store.
|
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: firetv-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The domain name of the
advertising system, e.g. the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app package name (unique identifier) on the specific App Store (as listed in field
AppStoreId).
|
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: lgtv-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The domain name of the
advertising system, e.g. the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app id (unique identifier) on the specific App Store (as listed in field AppStoreId). |
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: samsung-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The domain name of the
advertising system, e.g. the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app id (unique identifier) on the specific App Store (as listed in field AppStoreId). |
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: vizio-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The domain name of the
advertising system, e.g. the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app id (unique identifier) on the specific App Store (as listed in field AppStoreId). |
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Schema for: googletv-appads.csv
Name |
Type |
Description |
DateTime |
String |
The date when the app-ads.txt was crawled for the app (as listed in field AppId), format
"YYYY-MM-DD".
|
DomainName |
String |
The Domain name of associated to the app as listed in field AppId. |
AdDomainName |
String |
The domain name of the
advertising system, e.g. the
SSP, Exchange, Header Wrapper, etc system that
bidders connect to.
|
PubAccId |
String |
Publisher’s Account ID. The identifier associated with the seller
or reseller account within the advertising system in
field AdDomainName.
|
Relationship |
String |
A value of "DIRECT" states that the Publisher
directly controls the account
indicated in field PubAccId on the system in field AdDomainName. A value
of "RESELLER" states the Publisher has
authorized another entity to control the account.
|
CAId |
String |
Certification Authority is an ID that uniquely identifies the
advertising system within a certification authority
(this ID maps to the entity listed in field AdDomainName)
|
AppStoreId |
String |
The identifier of the App Store where the app is published. |
AppId |
String |
The app package name (unique identifier) on the specific App Store (as listed in field
AppStoreId).
|
MarketStatus |
String |
Status on the market
- PUBLISHED if the app is present
- UNPUBLISHED if the app was unpublished
|
InventoryPartnerDomain |
String |
Whether the entry came from inventory partner domain
- "" if the entry is from the root domain
- a domain if the entry is from an inventory partner domain
|
Last Modified: 17 Jan 2022