PMA vs native MCPs / TikTok Ads
Paid advertising · data points

TikTok Ads

Every PMA-queryable field across TikTok Ads campaigns, ad groups, ads, demographic breakdowns, country, platform and placement reports, plus account balance.

PMA: tiktok Native MCP: None 1 account connected 11 report types
In PMA

TikTok paid performance across every level

  • Campaign, ad group and ad performance with spend, clicks, impressions, conversions and ROAS
  • 148+ conversion event metrics including SKAN iOS attribution, e-commerce, lead gen and video engagement
  • Demographic breakdown by age and gender; geographic by country code; delivery by platform and placement
  • Dimension tables for campaigns, ad groups and ads with names and status
  • Account balance report for budget monitoring
Native MCP

No native MCP

  • No native MCP for TikTok Ads. Our social-insights MCP covers TikTok organic, not paid. PMA is our only source for TikTok Ads.

No native MCP

No native MCP for TikTok Ads. Our social-insights MCP covers TikTok organic, not paid. PMA is our only source for TikTok Ads.

PMA field catalogue

Every queryable field in PMA

Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.

Campaigns

report_type: campaigns · 148 metrics · 26 dimensions · showing 50 of 148 metrics retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
spendTotal costNUMBER
clicksClicksNUMBER
impressionsImpressionsNUMBER
reachReachNUMBER
frequencyFrequencyNUMBER
conversionConversionsNUMBER
resultResultNUMBER
real_time_conversionReal-time conversionsNUMBER
real_time_resultReal-time resultNUMBER
engagementsClicks destinationNUMBER
likesLikesNUMBER
commentsCommentsNUMBER
sharesPaid sharesNUMBER
followsFollowsNUMBER
profile_visitsProfile visitsNUMBER
ratingsRatingsNUMBER
average_video_playAverage video playNUMBER
checkoutCheckoutNUMBER
complete_paymentComplete paymentNUMBER
onsite_shoppingComplete payment (onsite)NUMBER
onsite_shopping_roasROAS (Shop)NUMBER
onsite_on_web_cartAdd to cart (onsite)NUMBER
onsite_initiate_checkout_countCheckouts initiated (Shop)NUMBER
purchaseUnique purchaseNUMBER
add_to_wishlistAdd to wishlistNUMBER
app_installApp installNUMBER
real_time_app_installReal time app installNUMBER
launch_appLaunch appNUMBER
registrationUnique registrationNUMBER
sales_leadUnique generate leadNUMBER
formFormNUMBER
loginLoginNUMBER
on_web_orderTotal place an orderNUMBER
on_web_subscribeSubscriptions (page)NUMBER
offline_contact_eventsContacts (offline)NUMBER
page_content_view_eventsPage content view eventsNUMBER
product_details_page_browseProduct details page browseNUMBER
skan_app_installSKAN app installNUMBER
skan_conversionSKAN conversionNUMBER
skan_add_to_cartSKAN add to cartNUMBER
skan_checkoutSKAN checkoutNUMBER
skan_add_payment_infoSKAN add payment infoNUMBER
skan_add_to_wishlistSKAN add to wishlistNUMBER
skan_achieve_levelSKAN achieve levelNUMBER
skan_complete_tutorialSKAN complete tutorialNUMBER
skan_create_gameroleUnique create role (SKAN)NUMBER
skan_create_groupUnique create group (SKAN)NUMBER
skan_in_app_ad_clickUnique in-app ad click (SKAN)NUMBER
skan_join_groupUnique join group (SKAN)NUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Ad groups

report_type: adgroups · 148 metrics · 27 dimensions · showing 50 of 148 metrics retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
spendTotal costNUMBER
clicksClicksNUMBER
impressionsImpressionsNUMBER
reachReachNUMBER
frequencyFrequencyNUMBER
conversionConversionsNUMBER
resultResultNUMBER
real_time_conversionReal-time conversionsNUMBER
real_time_resultReal-time resultNUMBER
engagementsClicks destinationNUMBER
likesLikesNUMBER
commentsCommentsNUMBER
sharesPaid sharesNUMBER
followsFollowsNUMBER
average_video_playAverage video playNUMBER
checkoutCheckoutNUMBER
complete_paymentComplete paymentNUMBER
purchaseUnique purchaseNUMBER
app_installApp installNUMBER
sales_leadUnique generate leadNUMBER
formFormNUMBER
onsite_shoppingComplete payment (onsite)NUMBER
onsite_shopping_roasROAS (Shop)NUMBER
skan_app_installSKAN app installNUMBER
skan_conversionSKAN conversionNUMBER
skan_in_app_ad_imprUnique in-app ad impr (SKAN)NUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
adgroup_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Ads

report_type: ads · 215 metrics · 28 dimensions · showing 50 of 215 metrics retrievable via API
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
CPCCPCformulaNUMBER
CPMCPMformulaNUMBER
CPACPAformulaNUMBER
conversion_rateConversion rateformulaNUMBER
non_real_time_cpaCPA (ads)formulaNUMBER
non_real_time_conversion_rateCVRformulaNUMBER
effect_costReal-time cost per resultformulaNUMBER
non_real_time_effect_costCost per resultformulaNUMBER
effect_rateReal-time result rateformulaNUMBER
non_real_time_effect_rateResult rateformulaNUMBER
complete_payment_roasComplete payment ROASformulaNUMBER
cost_per_generate_leadCost per generate leadformulaNUMBER
sales_lead_rateGenerate lead rateformulaNUMBER
value_per_complete_paymentValue per purchase (website)formulaNUMBER
cost_per_web_event_add_to_cartCost per add to cartformulaNUMBER
web_event_add_to_cart_rateAdd to cart rate (%)formulaNUMBER
cost_per_on_web_subscribeCost per subscription (page)formulaNUMBER
cost_per_user_registrationUser registration costformulaNUMBER
cost_per_formForm submission costformulaNUMBER
real_time_app_install_costCost per real-time app installformulaNUMBER
skan_result_rateResult rate (%) (SKAN)formulaNUMBER
skan_cost_per_resultCost per result (SKAN)formulaNUMBER
skan_conversion_rateCVR (%) (SKAN)formulaNUMBER
skan_cost_per_conversionCPA (SKAN)formulaNUMBER
cost_per_show_uv_milleCost per 1,000 unique user accounts reachedformulaNUMBER
spendTotal costNUMBER
clicksClicksNUMBER
impressionsImpressionsNUMBER
reachReachNUMBER
frequencyFrequencyNUMBER
conversionConversionsNUMBER
resultResultNUMBER
real_time_conversionReal-time conversionsNUMBER
likesLikesNUMBER
commentsCommentsNUMBER
sharesPaid sharesNUMBER
followsFollowsNUMBER
average_video_playAverage video playNUMBER
checkoutCheckoutNUMBER
complete_paymentComplete paymentNUMBER
purchaseUnique purchaseNUMBER
add_to_wishlistAdd to wishlistNUMBER
app_installApp installNUMBER
real_time_app_installReal time app installNUMBER
registrationUnique registrationNUMBER
sales_leadUnique generate leadNUMBER
formFormNUMBER
skan_app_installSKAN app installNUMBER
skan_conversionSKAN conversionNUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
ad_idAd IDSTRING
adgroup_idAd group IDSTRING
campaign_idCampaign IDSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Ads by age and gender

report_type: ads_age_gender · 17 metrics · 27 dimensions
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
CPCCPCformulaNUMBER
CPACPAformulaNUMBER
conversion_rateConversion rateformulaNUMBER
non_real_time_conversion_rateCVRformulaNUMBER
effect_costReal-time cost per resultformulaNUMBER
non_real_time_effect_costCost per resultformulaNUMBER
effect_rateReal-time result rateformulaNUMBER
non_real_time_effect_rateResult rateformulaNUMBER
cost_per_show_uv_milleCost per 1,000 unique user accounts reachedformulaNUMBER
spendTotal costNUMBER
clicksClicksNUMBER
impressionsImpressionsNUMBER
conversionConversionsNUMBER
real_time_conversionReal-time conversionsNUMBER
real_time_resultReal-time resultNUMBER
resultResultNUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
ageAgeSTRING
genderGenderSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Ads by country

report_type: ads_country_code · 17 metrics · 26 dimensions
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
CPCCPCformulaNUMBER
CPACPAformulaNUMBER
conversion_rateConversion rateformulaNUMBER
non_real_time_conversion_rateCVRformulaNUMBER
effect_costReal-time cost per resultformulaNUMBER
non_real_time_effect_costCost per resultformulaNUMBER
effect_rateReal-time result rateformulaNUMBER
non_real_time_effect_rateResult rateformulaNUMBER
cost_per_show_uv_milleCost per 1,000 unique user accounts reachedformulaNUMBER
spendTotal costNUMBER
clicksClicksNUMBER
impressionsImpressionsNUMBER
conversionConversionsNUMBER
real_time_conversionReal-time conversionsNUMBER
real_time_resultReal-time resultNUMBER
resultResultNUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
country_codeCountry codeSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Ads by platform

report_type: ads_platform · 17 metrics · 26 dimensions
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
CPCCPCformulaNUMBER
CPACPAformulaNUMBER
conversion_rateConversion rateformulaNUMBER
non_real_time_conversion_rateCVRformulaNUMBER
effect_costReal-time cost per resultformulaNUMBER
non_real_time_effect_costCost per resultformulaNUMBER
effect_rateReal-time result rateformulaNUMBER
non_real_time_effect_rateResult rateformulaNUMBER
cost_per_show_uv_milleCost per 1,000 unique user accounts reachedformulaNUMBER
spendTotal costNUMBER
clicksClicksNUMBER
impressionsImpressionsNUMBER
conversionConversionsNUMBER
real_time_conversionReal-time conversionsNUMBER
real_time_resultReal-time resultNUMBER
resultResultNUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
platformPlatformSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Ads by placement

report_type: ads_placement · 17 metrics · 26 dimensions
Metrics
Field nameLabelType
CTRCTRformulaNUMBER
CPCCPCformulaNUMBER
CPACPAformulaNUMBER
conversion_rateConversion rateformulaNUMBER
non_real_time_conversion_rateCVRformulaNUMBER
effect_costReal-time cost per resultformulaNUMBER
non_real_time_effect_costCost per resultformulaNUMBER
effect_rateReal-time result rateformulaNUMBER
non_real_time_effect_rateResult rateformulaNUMBER
cost_per_show_uv_milleCost per 1,000 unique user accounts reachedformulaNUMBER
spendTotal costNUMBER
clicksClicksNUMBER
impressionsImpressionsNUMBER
conversionConversionsNUMBER
real_time_conversionReal-time conversionsNUMBER
real_time_resultReal-time resultNUMBER
resultResultNUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
placement_idPlacement IDSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Balance

report_type: balance · 1 metric · 25 dimensions
Metrics
Field nameLabelType
balanceAccount balanceNUMBER
Dimensions
Field nameLabelType
configNameAccount nameSTRING
account_idAccount IDSTRING
dateDateSTRING
currencyCurrencySTRING
dataFreshnessData freshnessSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthformulaSTRING
weekWeekformulaSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
SubscriptionPMA subscription IDSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Dimension tables

report_type: campaigns_dimensions · adsgroups_dimensions · ads_dimensions · 0 metrics each · dimension-only lookup tables

These three report types contain no metrics — they are dimension-only tables providing name, status, objective and structural attributes for campaigns, ad groups and ads. Use them for JOIN lookups when querying performance reports.