Every PMA-queryable field across TikTok Ads campaigns, ad groups, ads, demographic breakdowns, country, platform and placement reports, plus account balance.
No native MCP for TikTok Ads. Our social-insights MCP covers TikTok organic, not paid. PMA is our only source for TikTok Ads.
Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
spend | Total cost | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
reach | Reach | NUMBER |
frequency | Frequency | NUMBER |
conversion | Conversions | NUMBER |
result | Result | NUMBER |
real_time_conversion | Real-time conversions | NUMBER |
real_time_result | Real-time result | NUMBER |
engagements | Clicks destination | NUMBER |
likes | Likes | NUMBER |
comments | Comments | NUMBER |
shares | Paid shares | NUMBER |
follows | Follows | NUMBER |
profile_visits | Profile visits | NUMBER |
ratings | Ratings | NUMBER |
average_video_play | Average video play | NUMBER |
checkout | Checkout | NUMBER |
complete_payment | Complete payment | NUMBER |
onsite_shopping | Complete payment (onsite) | NUMBER |
onsite_shopping_roas | ROAS (Shop) | NUMBER |
onsite_on_web_cart | Add to cart (onsite) | NUMBER |
onsite_initiate_checkout_count | Checkouts initiated (Shop) | NUMBER |
purchase | Unique purchase | NUMBER |
add_to_wishlist | Add to wishlist | NUMBER |
app_install | App install | NUMBER |
real_time_app_install | Real time app install | NUMBER |
launch_app | Launch app | NUMBER |
registration | Unique registration | NUMBER |
sales_lead | Unique generate lead | NUMBER |
form | Form | NUMBER |
login | Login | NUMBER |
on_web_order | Total place an order | NUMBER |
on_web_subscribe | Subscriptions (page) | NUMBER |
offline_contact_events | Contacts (offline) | NUMBER |
page_content_view_events | Page content view events | NUMBER |
product_details_page_browse | Product details page browse | NUMBER |
skan_app_install | SKAN app install | NUMBER |
skan_conversion | SKAN conversion | NUMBER |
skan_add_to_cart | SKAN add to cart | NUMBER |
skan_checkout | SKAN checkout | NUMBER |
skan_add_payment_info | SKAN add payment info | NUMBER |
skan_add_to_wishlist | SKAN add to wishlist | NUMBER |
skan_achieve_level | SKAN achieve level | NUMBER |
skan_complete_tutorial | SKAN complete tutorial | NUMBER |
skan_create_gamerole | Unique create role (SKAN) | NUMBER |
skan_create_group | Unique create group (SKAN) | NUMBER |
skan_in_app_ad_click | Unique in-app ad click (SKAN) | NUMBER |
skan_join_group | Unique join group (SKAN) | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
spend | Total cost | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
reach | Reach | NUMBER |
frequency | Frequency | NUMBER |
conversion | Conversions | NUMBER |
result | Result | NUMBER |
real_time_conversion | Real-time conversions | NUMBER |
real_time_result | Real-time result | NUMBER |
engagements | Clicks destination | NUMBER |
likes | Likes | NUMBER |
comments | Comments | NUMBER |
shares | Paid shares | NUMBER |
follows | Follows | NUMBER |
average_video_play | Average video play | NUMBER |
checkout | Checkout | NUMBER |
complete_payment | Complete payment | NUMBER |
purchase | Unique purchase | NUMBER |
app_install | App install | NUMBER |
sales_lead | Unique generate lead | NUMBER |
form | Form | NUMBER |
onsite_shopping | Complete payment (onsite) | NUMBER |
onsite_shopping_roas | ROAS (Shop) | NUMBER |
skan_app_install | SKAN app install | NUMBER |
skan_conversion | SKAN conversion | NUMBER |
skan_in_app_ad_impr | Unique in-app ad impr (SKAN) | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
adgroup_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
CPC | CPCformula | NUMBER |
CPM | CPMformula | NUMBER |
CPA | CPAformula | NUMBER |
conversion_rate | Conversion rateformula | NUMBER |
non_real_time_cpa | CPA (ads)formula | NUMBER |
non_real_time_conversion_rate | CVRformula | NUMBER |
effect_cost | Real-time cost per resultformula | NUMBER |
non_real_time_effect_cost | Cost per resultformula | NUMBER |
effect_rate | Real-time result rateformula | NUMBER |
non_real_time_effect_rate | Result rateformula | NUMBER |
complete_payment_roas | Complete payment ROASformula | NUMBER |
cost_per_generate_lead | Cost per generate leadformula | NUMBER |
sales_lead_rate | Generate lead rateformula | NUMBER |
value_per_complete_payment | Value per purchase (website)formula | NUMBER |
cost_per_web_event_add_to_cart | Cost per add to cartformula | NUMBER |
web_event_add_to_cart_rate | Add to cart rate (%)formula | NUMBER |
cost_per_on_web_subscribe | Cost per subscription (page)formula | NUMBER |
cost_per_user_registration | User registration costformula | NUMBER |
cost_per_form | Form submission costformula | NUMBER |
real_time_app_install_cost | Cost per real-time app installformula | NUMBER |
skan_result_rate | Result rate (%) (SKAN)formula | NUMBER |
skan_cost_per_result | Cost per result (SKAN)formula | NUMBER |
skan_conversion_rate | CVR (%) (SKAN)formula | NUMBER |
skan_cost_per_conversion | CPA (SKAN)formula | NUMBER |
cost_per_show_uv_mille | Cost per 1,000 unique user accounts reachedformula | NUMBER |
spend | Total cost | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
reach | Reach | NUMBER |
frequency | Frequency | NUMBER |
conversion | Conversions | NUMBER |
result | Result | NUMBER |
real_time_conversion | Real-time conversions | NUMBER |
likes | Likes | NUMBER |
comments | Comments | NUMBER |
shares | Paid shares | NUMBER |
follows | Follows | NUMBER |
average_video_play | Average video play | NUMBER |
checkout | Checkout | NUMBER |
complete_payment | Complete payment | NUMBER |
purchase | Unique purchase | NUMBER |
add_to_wishlist | Add to wishlist | NUMBER |
app_install | App install | NUMBER |
real_time_app_install | Real time app install | NUMBER |
registration | Unique registration | NUMBER |
sales_lead | Unique generate lead | NUMBER |
form | Form | NUMBER |
skan_app_install | SKAN app install | NUMBER |
skan_conversion | SKAN conversion | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
ad_id | Ad ID | STRING |
adgroup_id | Ad group ID | STRING |
campaign_id | Campaign ID | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
CPC | CPCformula | NUMBER |
CPA | CPAformula | NUMBER |
conversion_rate | Conversion rateformula | NUMBER |
non_real_time_conversion_rate | CVRformula | NUMBER |
effect_cost | Real-time cost per resultformula | NUMBER |
non_real_time_effect_cost | Cost per resultformula | NUMBER |
effect_rate | Real-time result rateformula | NUMBER |
non_real_time_effect_rate | Result rateformula | NUMBER |
cost_per_show_uv_mille | Cost per 1,000 unique user accounts reachedformula | NUMBER |
spend | Total cost | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
conversion | Conversions | NUMBER |
real_time_conversion | Real-time conversions | NUMBER |
real_time_result | Real-time result | NUMBER |
result | Result | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
age | Age | STRING |
gender | Gender | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
CPC | CPCformula | NUMBER |
CPA | CPAformula | NUMBER |
conversion_rate | Conversion rateformula | NUMBER |
non_real_time_conversion_rate | CVRformula | NUMBER |
effect_cost | Real-time cost per resultformula | NUMBER |
non_real_time_effect_cost | Cost per resultformula | NUMBER |
effect_rate | Real-time result rateformula | NUMBER |
non_real_time_effect_rate | Result rateformula | NUMBER |
cost_per_show_uv_mille | Cost per 1,000 unique user accounts reachedformula | NUMBER |
spend | Total cost | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
conversion | Conversions | NUMBER |
real_time_conversion | Real-time conversions | NUMBER |
real_time_result | Real-time result | NUMBER |
result | Result | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
country_code | Country code | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
CPC | CPCformula | NUMBER |
CPA | CPAformula | NUMBER |
conversion_rate | Conversion rateformula | NUMBER |
non_real_time_conversion_rate | CVRformula | NUMBER |
effect_cost | Real-time cost per resultformula | NUMBER |
non_real_time_effect_cost | Cost per resultformula | NUMBER |
effect_rate | Real-time result rateformula | NUMBER |
non_real_time_effect_rate | Result rateformula | NUMBER |
cost_per_show_uv_mille | Cost per 1,000 unique user accounts reachedformula | NUMBER |
spend | Total cost | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
conversion | Conversions | NUMBER |
real_time_conversion | Real-time conversions | NUMBER |
real_time_result | Real-time result | NUMBER |
result | Result | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
platform | Platform | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
CTR | CTRformula | NUMBER |
CPC | CPCformula | NUMBER |
CPA | CPAformula | NUMBER |
conversion_rate | Conversion rateformula | NUMBER |
non_real_time_conversion_rate | CVRformula | NUMBER |
effect_cost | Real-time cost per resultformula | NUMBER |
non_real_time_effect_cost | Cost per resultformula | NUMBER |
effect_rate | Real-time result rateformula | NUMBER |
non_real_time_effect_rate | Result rateformula | NUMBER |
cost_per_show_uv_mille | Cost per 1,000 unique user accounts reachedformula | NUMBER |
spend | Total cost | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
conversion | Conversions | NUMBER |
real_time_conversion | Real-time conversions | NUMBER |
real_time_result | Real-time result | NUMBER |
result | Result | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
placement_id | Placement ID | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
balance | Account balance | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Account name | STRING |
account_id | Account ID | STRING |
date | Date | STRING |
currency | Currency | STRING |
dataFreshness | Data freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year monthformula | STRING |
week | Weekformula | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
Subscription | PMA subscription ID | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
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.