42matters is now part of the Similarweb family. Learn more here

Documentation

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, Fire TV, 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

Sample Data Dump

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

Access Credentials

In order to obtain your Access Credentials, please read the File Dumps page or contact us.

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: 03 May 2023


Automate Your Workflow With 42matters’ APIs


Integrate app data and intelligence into your existing workflows, dashboards, CRM platforms, messaging platforms, and more! Below is a selection of the third-party services that are compatible with 42matters’ APIs:



Salesforce

Salesforce

HubSpot

HubSpot

Slack

Slack

Intercom

Intercom

Pipedrive

Pipedrive

Zendesk

Zendesk

Gekoboard

Gekoboard

Klipfolio

Klipfolio

Dynamics

Dynamics


And many more!


CONTACT SALES