Apple SearchAds Predefined Reports
  • 8 Minutes to read
  • Dark
    Light
  • PDF

Apple SearchAds Predefined Reports

  • Dark
    Light
  • PDF

Article summary

Predefined Reports

The Apple Ads datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Source-Level Selections

Apple Ads has two source-level selections: Accounts and Campaigns. These options will filter down each report within the river to only the selected data.

Campaigns Country Code

The Campaigns Country Code report pulls campaign dimensions and metrics aggregated over the country code field. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
date system schemaStringDimension
countryCode system schemaStringDimension
adChannelTypeStringDimension
avgCPA_currencyStringDimension
avgCPM_amountStringDimension
avgCPM_currencyStringDimension
avgCPT_amountStringDimension
avgCPT_currencyStringDimension
billingEventStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
avgCPA_amountStringDimension
campaignNameStringDimension
campaignStatusStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
countriesOrRegionsStringDimension
app_appNameStringDimension
coversionsIntegerMetric
dailyBudget_amountStringDimension
dailyBudget_currencyStringDimension
app_adamIdIntegerMetric
deletedBooleanDimension
displayStatusStringDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
orgIdIntegerMetric
redownloadsIntegerMetric
servingStateReasonsStringDimension
servingStatusStringDimension
storefrontStringDimension
supplySourcesStringDimension
tapsIntegerMetric
totalBudget_amountStringDimension
totalBudget_currencyStringDimension
ttrFloatMetric

Campaigns Country Region

The Campaigns Country Code report pulls campaign dimensions and metrics aggregated over the country region field. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
date system schemaStringDimension
countryOrRegion system schemaStringDimension
countriesOrRegions system schemaStringDimension
adChannelTypeStringDimension
avgCPM_amountStringDimension
avgCPM_currencyStringDimension
avgCPT_amountStringDimension
avgCPT_currencyStringDimension
billingEventStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
avgCPA_currencyStringDimension
campaignNameStringDimension
campaignStatusStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
avgCPA_amountStringDimension
app_appNameStringDimension
coversionsIntegerMetric
dailyBudget_amountStringDimension
dailyBudget_currencyStringDimension
app_adamIdIntegerMetric
deletedBooleanDimension
displayStatusStringDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
orgIdIntegerMetric
redownloadsIntegerMetric
servingStateReasonsStringDimension
servingStatusStringDimension
storefrontStringDimension
supplySourcesStringDimension
tapsIntegerMetric
totalBudget_amountStringDimension
totalBudget_currencyStringDimension
ttrFloatMetric

Keywords

The Keyword report pulls dimensions and metrics for targeted keywords in the campaigns. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
adGroupId system schemaIntegerDimension
keywordId system schemaIntegerDimension
date system schemaStringDimension
adGroupDeletedBooleanDimension
avgCPT_amountStringDimension
avgCPT_currencyStringDimension
bidAmount_amountStringDimension
bidAmount_currencyStringDimension
bidRecommendation_bidMaxStringDimension
bidRecommendation_bidMax_amountStringDimension
bidRecommendation_bidMax_currencyStringDimension
bidRecommendation_bidMinStringDimension
bidRecommendation_bidMin_amountStringDimension
bidRecommendation_bidMin_currencyStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
avgCPA_currencyStringDimension
campaignNameStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
coversionsIntegerMetric
avgCPA_amountStringDimension
deletedBooleanDimension
impressionsIntegerMetric
installsIntegerMetric
keywordStringDimension
keywordDisplayStatusStringDimension
adGroupNameStringDimension
keywordStatusStringDimension
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
matchTypeStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
redownloadsIntegerMetric
tapsIntegerMetric
ttrFloatMetric

Keywords Country Region

The Keyword Country Region report pulls dimensions and metrics for targeted keywords in the campaigns aggregated over the country region field. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
adGroupId system schemaIntegerDimension
keywordId system schemaIntegerDimension
date system schemaStringDimension
countryOrRegion system schemaStringDimension
adGroupDeletedBooleanDimension
avgCPT_currencyStringDimension
bidAmount_amountStringDimension
bidAmount_currencyStringDimension
bidRecommendation_bidMaxStringDimension
bidRecommendation_bidMax_amountStringDimension
bidRecommendation_bidMax_currencyStringDimension
bidRecommendation_bidMinStringDimension
bidRecommendation_bidMin_amountStringDimension
bidRecommendation_bidMin_currencyStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
avgCPT_amountStringDimension
campaignNameStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
avgCPA_currencyStringDimension
coversionsIntegerMetric
avgCPA_amountStringDimension
deletedBooleanDimension
impressionsIntegerMetric
installsIntegerMetric
keywordStringDimension
keywordDisplayStatusStringDimension
adGroupNameStringDimension
keywordStatusStringDimension
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
matchTypeStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
redownloadsIntegerMetric
storefrontStringDimension
tapsIntegerMetric
ttrFloatMetric

Search Terms

The Search Terms report pulls dimensions and metrics for the search terms in the campaigns. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
adGroupId system schemaIntegerDimension
searchTermText system schemaStringDimension
keywordId system schemaIntegerDimension
date system schemaStringDimension
adGroupDeletedBooleanDimension
avgCPT_currencyStringDimension
bidAmount_amountStringDimension
bidAmount_currencyStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
avgCPT_amountStringDimension
campaignNameStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
coversionsIntegerMetric
avgCPA_currencyStringDimension
deletedBooleanDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
keywordStringDimension
keywordDisplayStatusStringDimension
avgCPA_amountStringDimension
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
matchTypeStringDimension
newDownloadsIntegerMetric
redownloadsIntegerMetric
searchTermSourceStringDimension
adGroupNameStringDimension
tapsIntegerMetric
ttrFloatMetric

Search Terms Country Region

The Search Terms Country Region report pulls dimensions and metrics for the search terms in the campaigns aggregated over the country region field. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
adGroupId system schemaIntegerDimension
searchTermText system schemaStringDimension
keywordId system schemaIntegerDimension
date system schemaStringDimension
countryOrRegion system schemaStringDimension
adGroupDeletedBooleanDimension
bidAmount_amountStringDimension
bidAmount_currencyStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
avgCPT_currencyStringDimension
campaignNameStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
avgCPT_amountStringDimension
coversionsIntegerMetric
avgCPA_currencyStringDimension
deletedBooleanDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
keywordStringDimension
keywordDisplayStatusStringDimension
avgCPA_amountStringDimension
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
matchTypeStringDimension
newDownloadsIntegerMetric
redownloadsIntegerMetric
searchTermSourceStringDimension
adGroupNameStringDimension
storefrontStringDimension
tapsIntegerMetric
ttrFloatMetric

Adgroups Country Code

The Adgroups Country Code report pulls ad group level dimensions and metrics aggregated over the country code field. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
adGroupId system schemaIntegerDimension
date system schemaStringDimension
countryCode system schemaStringDimension
adGroupDisplayStatusStringDimension
adGroupStatusStringDimension
automatedKeywordsOptInBooleanDimension
avgCPA_amountStringDimension
avgCPA_currencyStringDimension
avgCPM_amountStringDimension
avgCPM_currencyStringDimension
avgCPT_amountStringDimension
avgCPT_currencyStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
adGroupServingStatusStringDimension
campaignNameStringDimension
adGroupServingStateReasonsStringDimension
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
conversionRateFloatMetric
coversionsIntegerMetric
cpaGoalStringDimension
adGroupNameStringDimension
defaultBidAmount_amountStringDimension
defaultBidAmount_currencyStringDimension
deletedBooleanDimension
endTimeStringDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
orgIdIntegerMetric
pricingModelStringDimension
redownloadsIntegerMetric
startTimeStringDimension
tapsIntegerMetric
ttrFloatMetric

Adgroups Country Region

The Adgroups Country Region report pulls ad group level dimensions and metrics aggregated over the country region field. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignId system schemaIntegerDimension
adGroupId system schemaIntegerDimension
date system schemaStringDimension
countryOrRegion system schemaStringDimension
adGroupDisplayStatusStringDimension
adGroupStatusStringDimension
automatedKeywordsOptInBooleanDimension
avgCPA_amountStringDimension
avgCPA_currencyStringDimension
avgCPM_amountStringDimension
avgCPM_currencyStringDimension
avgCPT_amountStringDimension
avgCPT_currencyStringDimension
campaignGroupIdIntegerMetric
campaignGroupNameStringDimension
adGroupServingStatusStringDimension
campaignNameStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
adGroupServingStateReasonsStringDimension
coversionsIntegerMetric
cpaGoalStringDimension
cpaGoal_amountStringDimension
cpaGoal_currencyStringDimension
adGroupNameStringDimension
defaultBidAmount_amountStringDimension
defaultBidAmount_currencyStringDimension
deletedBooleanDimension
endTimeStringDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
orgIdIntegerMetric
pricingModelStringDimension
redownloadsIntegerMetric
startTimeStringDimension
storefrontStringDimension
tapsIntegerMetric
ttrFloatMetric

Creative Sets

The Creative Sets report pulls dimensions and metrics for the creatives in the campaigns. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignGroupId system schemaIntegerDimension
date system schemaStringDimension
adGroupId system schemaIntegerDimension
creativeSetId system schemaIntegerDimension
campaignId system schemaIntegerDimension
adFormatStringDimension
avgCPT_currencyStringDimension
avgCPT_amountStringDimension
campaignGroupNameStringDimension
avgCPA_currencyStringDimension
campaignNameStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
coversionsIntegerMetric
creationTimeStringDimension
avgCPA_amountStringDimension
creativeSetLanguageDisplayNameStringDimension
creativeSetNameStringDimension
adGroupCreativeSetIdIntegerMetric
deletedBooleanDimension
displayStatusStringDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
orgIdIntegerMetric
redownloadsIntegerMetric
statusStringDimension
tapsIntegerMetric
ttrFloatMetric

Creative Sets Country Region

The Creative Sets Country Region report pulls dimensions and metrics for the creatives in the campaigns aggregated over the country region field. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
campaignGroupId system schemaIntegerDimension
date system schemaStringDimension
adGroupId system schemaIntegerDimension
adFormat system schemaStringDimension
creativeSetId system schemaIntegerDimension
countryOrRegion system schemaStringDimension
campaignId system schemaIntegerDimension
creativeSetLanguageDisplayNameStringDimension
campaignGroupNameStringDimension
avgCPT_currencyStringDimension
campaignNameStringDimension
conversionRateFloatMetric
conversionsLATOffIntegerMetric
conversionsLATOnIntegerMetric
conversionsNewDownloadsIntegerMetric
conversionsRedownloadsIntegerMetric
avgCPT_amountStringDimension
coversionsIntegerMetric
creationTimeStringDimension
avgCPA_currencyStringDimension
avgCPA_amountStringDimension
creativeSetNameStringDimension
adGroupCreativeSetIdIntegerMetric
deletedBooleanDimension
displayStatusStringDimension
impressionsIntegerMetric
insightsStringDimension
installsIntegerMetric
latOffInstallsIntegerMetric
latOnInstallsIntegerMetric
localSpend_amountStringDimension
localSpend_currencyStringDimension
modificationTimeStringDimension
newDownloadsIntegerMetric
orgIdIntegerMetric
redownloadsIntegerMetric
statusStringDimension
storefrontStringDimension
tapsIntegerMetric
ttrFloatMetric

Was this article helpful?