Apple Search Ads Fields

Dimensions (58)

Adam Id

API Name: AppAdamId
NinjaCat System ID: apple_search_ads:DIM_AppAdamId
Data Type: text

Ad Channel Type

API Name: AdChannelType
NinjaCat System ID: apple_search_ads:DIM_AdChannelType
Data Type: text

Ad Display Status

API Name: AdDisplayStatus
NinjaCat System ID: apple_search_ads:DIM_AdDisplayStatus
Data Type: text

Ad Group Deleted

API Name: AdGroupDeleted
NinjaCat System ID: apple_search_ads:DIM_AdGroupDeleted
Data Type: boolean

Ad Group Display Status

API Name: AdGroupDisplayStatus
NinjaCat System ID: apple_search_ads:DIM_AdGroupDisplayStatus
Data Type: text

Ad Group Id

API Name: AdGroupId
NinjaCat System ID: apple_search_ads:DIM_AdGroupId
Data Type: text

Ad Group Name

API Name: AdGroupName
NinjaCat System ID: apple_search_ads:DIM_AdGroupName
Data Type: text

Ad Group Serving State Reasons

API Name: AdGroupServingStateReasons
NinjaCat System ID: apple_search_ads:DIM_AdGroupServingStateReasons
Data Type: text

Ad Group Serving Status

API Name: AdGroupServingStatus
NinjaCat System ID: apple_search_ads:DIM_AdGroupServingStatus
Data Type: text

Ad Group Status

API Name: AdGroupStatus
NinjaCat System ID: apple_search_ads:DIM_AdGroupStatus
Data Type: text

Ad Id

API Name: AdId
NinjaCat System ID: apple_search_ads:DIM_AdId
Data Type: text

Ad Name

API Name: AdName
NinjaCat System ID: apple_search_ads:DIM_AdName
Data Type: text

Ad Serving State Reasons

API Name: AdServingStateReasons
NinjaCat System ID: apple_search_ads:DIM_AdServingStateReasons
Data Type: text

Ad Serving Status

API Name: AdServingStatus
NinjaCat System ID: apple_search_ads:DIM_AdServingStatus
Data Type: text

Ad Status

API Name: AdStatus
NinjaCat System ID: apple_search_ads:DIM_AdStatus
Data Type: text

App Name

API Name: AppAppName
NinjaCat System ID: apple_search_ads:DIM_AppAppName
Data Type: text

Automated Keywords Opt-In

API Name: AutomatedKeywordsOptIn
NinjaCat System ID: apple_search_ads:DIM_AutomatedKeywordsOptIn
Data Type: boolean

Bid Currency

API Name: BidAmountCurrency
NinjaCat System ID: apple_search_ads:DIM_BidAmountCurrency
Data Type: text

Billing Event

API Name: BillingEvent
NinjaCat System ID: apple_search_ads:DIM_BillingEvent
Data Type: text

Campaign Group

API Name: CampaignGroup
NinjaCat System ID: apple_search_ads:DIM_CampaignGroup
Data Type: text
Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Id

API Name: CampaignId
NinjaCat System ID: apple_search_ads:DIM_CampaignId
Data Type: text

Campaign Name

API Name: CampaignName
NinjaCat System ID: apple_search_ads:DIM_CampaignName
Data Type: text

Campaign Status

API Name: CampaignStatus
NinjaCat System ID: apple_search_ads:DIM_CampaignStatus
Data Type: text

Countries Or Regions

API Name: CountriesOrRegions
NinjaCat System ID: apple_search_ads:DIM_CountriesOrRegions
Data Type: text

Country Or Region Serving State Reasons

API Name: CountryOrRegionServingStateReasons
NinjaCat System ID: apple_search_ads:DIM_CountryOrRegionServingStateReasons
Data Type: text

CPA Goal Currency

API Name: CpaGoalCurrency
NinjaCat System ID: apple_search_ads:DIM_CpaGoalCurrency
Data Type: text

Creation Time

API Name: CreationTime
NinjaCat System ID: apple_search_ads:DIM_CreationTime
Data Type: text

Creative Id

API Name: CreativeId
NinjaCat System ID: apple_search_ads:DIM_CreativeId
Data Type: text

Creative Name

API Name: CreativeName
NinjaCat System ID: apple_search_ads:DIM_CreativeName
Data Type: text

Creative State

API Name: CreativeState
NinjaCat System ID: apple_search_ads:DIM_CreativeState
Data Type: text

Creative Type

API Name: CreativeType
NinjaCat System ID: apple_search_ads:DIM_CreativeType
Data Type: text

Daily Budget Currency

API Name: DailyBudgetCurrency
NinjaCat System ID: apple_search_ads:DIM_DailyBudgetCurrency
Data Type: text

Date

API Name: Date
NinjaCat System ID: apple_search_ads:DIM_Date
Data Type: date
Aggregates To: DIM_DATE

Day of Week

NinjaCat System ID: apple_search_ads:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

Default Bid Currency

API Name: DefaultBidAmountCurrency
NinjaCat System ID: apple_search_ads:DIM_DefaultBidAmountCurrency
Data Type: text

Display Status

API Name: DisplayStatus
NinjaCat System ID: apple_search_ads:DIM_DisplayStatus
Data Type: text

End Time

API Name: EndTime
NinjaCat System ID: apple_search_ads:DIM_EndTime
Data Type: text

Keyword

API Name: Keyword
NinjaCat System ID: apple_search_ads:DIM_Keyword
Data Type: text

Keyword Display Status

API Name: KeywordDisplayStatus
NinjaCat System ID: apple_search_ads:DIM_KeywordDisplayStatus
Data Type: text

Keyword Id

API Name: KeywordId
NinjaCat System ID: apple_search_ads:DIM_KeywordId
Data Type: text

Keyword Status

API Name: KeywordStatus
NinjaCat System ID: apple_search_ads:DIM_KeywordStatus
Data Type: text

Language

API Name: Language
NinjaCat System ID: apple_search_ads:DIM_Language
Data Type: text

Local Spend Currency

API Name: LocalSpendCurrency
NinjaCat System ID: apple_search_ads:DIM_LocalSpendCurrency
Data Type: text

Match Type

API Name: MatchType
NinjaCat System ID: apple_search_ads:DIM_MatchType
Data Type: text

Modification Time

API Name: ModificationTime
NinjaCat System ID: apple_search_ads:DIM_ModificationTime
Data Type: text

Month of Year

NinjaCat System ID: apple_search_ads:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Org Id

API Name: OrgId
NinjaCat System ID: apple_search_ads:DIM_OrgId
Data Type: text

Org Name

API Name: OrgName
NinjaCat System ID: apple_search_ads:DIM_OrgName
Data Type: text

Pricing Model

API Name: PricingModel
NinjaCat System ID: apple_search_ads:DIM_PricingModel
Data Type: text

Product Page Id

API Name: ProductPageId
NinjaCat System ID: apple_search_ads:DIM_ProductPageId
Data Type: text

Search Term Source

API Name: SearchTermSource
NinjaCat System ID: apple_search_ads:DIM_SearchTermSource
Data Type: text

Search Term Text

API Name: SearchTermText
NinjaCat System ID: apple_search_ads:DIM_SearchTermText
Data Type: text

Serving State Reasons

API Name: ServingStateReasons
NinjaCat System ID: apple_search_ads:DIM_ServingStateReasons
Data Type: text

Serving Status

API Name: ServingStatus
NinjaCat System ID: apple_search_ads:DIM_ServingStatus
Data Type: text

Start Time

API Name: StartTime
NinjaCat System ID: apple_search_ads:DIM_StartTime
Data Type: text

Status

API Name: Status
NinjaCat System ID: apple_search_ads:DIM_Status
Data Type: text

Supply Sources

API Name: SupplySources
NinjaCat System ID: apple_search_ads:DIM_SupplySources
Data Type: text

Total Budget Currency

API Name: TotalBudgetCurrency
NinjaCat System ID: apple_search_ads:DIM_TotalBudgetCurrency
Data Type: text

Metrics (24)

Bid Amount

API Name: BidAmountAmount
NinjaCat System ID: apple_search_ads:MET_BidAmountAmount
Data Type: decimal
Display As: currency

Conversion Rate

NinjaCat System ID: apple_search_ads:MET_CR
Data Type: decimal
Display As: percent
Formula: (apple_search_ads:MET_TotalInstalls / apple_search_ads:MET_Taps)

CPA Goal Amount

API Name: CpaGoalAmount
NinjaCat System ID: apple_search_ads:MET_CpaGoalAmount
Data Type: decimal
Display As: currency

CPI

NinjaCat System ID: apple_search_ads:MET_CPI
Data Type: decimal
Display As: currency
Formula: (apple_search_ads:MET_LocalSpendAmount / apple_search_ads:MET_TotalInstalls)

CPM

NinjaCat System ID: apple_search_ads:MET_CPM
Data Type: decimal
Display As: currency
Formula: (apple_search_ads:MET_LocalSpendAmount / apple_search_ads:MET_Impressions * 1000)

CPT

NinjaCat System ID: apple_search_ads:MET_CPT
Data Type: decimal
Display As: currency
Formula: (apple_search_ads:MET_LocalSpendAmount / apple_search_ads:MET_Taps)

Daily Budget Amount

API Name: DailyBudgetAmount
NinjaCat System ID: apple_search_ads:MET_DailyBudgetAmount
Data Type: decimal
Display As: currency

Default Bid Amount

API Name: DefaultBidAmountAmount
NinjaCat System ID: apple_search_ads:MET_DefaultBidAmountAmount
Data Type: decimal
Display As: currency

Impressions

API Name: Impressions
NinjaCat System ID: apple_search_ads:MET_Impressions
Data Type: integer

Local Spend Amount

API Name: LocalSpendAmount
NinjaCat System ID: apple_search_ads:MET_LocalSpendAmount
Data Type: decimal
Display As: currency

Tap Install Rate

API Name: TapInstallRate
NinjaCat System ID: apple_search_ads:MET_TapInstallRate
Data Type: decimal

Tap Installs

API Name: TapInstalls
NinjaCat System ID: apple_search_ads:MET_TapInstalls
Data Type: integer

Tap New Downloads

API Name: TapNewDownloads
NinjaCat System ID: apple_search_ads:MET_TapNewDownloads
Data Type: integer

Tap Redownloads

API Name: TapRedownloads
NinjaCat System ID: apple_search_ads:MET_TapRedownloads
Data Type: integer

Taps

API Name: Taps
NinjaCat System ID: apple_search_ads:MET_Taps
Data Type: integer

Total Budget Amount

API Name: TotalBudgetAmount
NinjaCat System ID: apple_search_ads:MET_TotalBudgetAmount
Data Type: decimal
Display As: currency

Total Install Rate

API Name: TotalInstallRate
NinjaCat System ID: apple_search_ads:MET_TotalInstallRate
Data Type: decimal

Total Installs

API Name: TotalInstalls
NinjaCat System ID: apple_search_ads:MET_TotalInstalls
Data Type: integer

Total New Downloads

API Name: TotalNewDownloads
NinjaCat System ID: apple_search_ads:MET_TotalNewDownloads
Data Type: integer

Total Redownloads

API Name: TotalRedownloads
NinjaCat System ID: apple_search_ads:MET_TotalRedownloads
Data Type: integer

TTR

API Name: TTR
NinjaCat System ID: apple_search_ads:MET_TTR
Data Type: decimal

View Installs

API Name: ViewInstalls
NinjaCat System ID: apple_search_ads:MET_ViewInstalls
Data Type: integer

View New Downloads

API Name: ViewNewDownloads
NinjaCat System ID: apple_search_ads:MET_ViewNewDownloads
Data Type: integer

View Redownloads

API Name: ViewRedownloads
NinjaCat System ID: apple_search_ads:MET_ViewRedownloads
Data Type: integer