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.
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.
Mobile:
CTV:
Data Format
Data is stored in a single gzipped CSV file with 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
|
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
|
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
|
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. |
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
|
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
|
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
|
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
|
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
|
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
|
Last Modified: 07 Feb 2022