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

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: 07 Feb 2022


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

Want to know more?

Schedule an appointment to see how our products can help grow your mobile business.


SCHEDULE A DEMO


Company

Products

Support

Free Tools

Legal

Our best content

App & CTV Store stats

Mobile App Country stats

Mobile Gaming Country stats

Top Android SDKs



Linkedin Facebook Twitter

Copyright © 2022 42matters AG - All rights reserved

Applications listed on 42matters.com are from the Google Play™ Store, the Apple App Store®, the Amazon AppStore®, the Tencent Myapp®, the Apple TV App Store®, the Amazon Fire TV®, and the Roku Channel Store® and all the rights belong to their respective owners. Android™ and Google Play™ are trademarks of Google Inc. App Store®, iTunes® and TV App Store® are trademarks of Apple Inc. Amazon®, Amazon AppStore® and Amazon Fire TV® are trademarks of Amazon Inc. Tencent® and Tencent Myapp® are trademarks of Tencent Holdings Limited. Roku® and Roku Channel Store® are trademarks of Roku Inc. Any third party trademark and/or logo displayed on this website, shall NOT be interpreted as any sponsorship, endorsement and/or affiliation with 42matters.