Last updated: July 31, 2026
64 dimensions
60 metrics
Supported destinations:
Google Sheets
Claude
BigQuery
Dimensions
Dimensions are the attributes you can use to segment and group your Mercado Ads data.Most Used
Advertiser ID | Unique identifier of the advertiser who invests budget to create and distribute ads. Field Name: advertiser_idType: dimension |
Advertiser Name | Name of the advertiser account. Field Name: advertiser_nameType: dimension |
Campaign ID | Unique identifier for the advertising campaign. Field Name: campaign_idType: dimension |
Campaign Name | Name assigned to the advertising campaign. Field Name: campaign_nameType: dimension |
Ad Type | Type of advertisement format being used: Brand Ads, Product Ads & Display Ads Field Name: ad_typeType: dimension |
Common Dimensions
Site ID | Country identifier (e.g., MLB for Brazil, MLM for Mexico, MLA for Argentina). Field Name: site_idType: dimension |
Country Name | Name of the country where the campaign is running. Field Name: country_nameType: dimension |
Campaign Currency | Currency used for the campaign budget and costs. Field Name: campaign_currencyType: dimension |
Campaign Status | Current state of the campaign. Values: active, paused, disabled. Field Name: campaign_statusType: dimension |
Campaign Budget | Daily budget allocated for the campaign. Unused budget rolls over to following days within the month. Field Name: campaign_budgetType: dimension |
Product Ads
Campaign Strategy | Campaign objective strategy. Values: PROFITABILITY (5-15% ACOS), INCREASE (15-30% ACOS), VISIBILITY (>30% ACOS). Field Name: campaign_strategyType: dimension |
Campaign Channel | Sales channel for the campaign. Values: marketplace (Mercado Libre), mshops (Mercado Shops). Field Name: campaign_channelType: dimension |
Campaign ACOS Target | Target Advertising Cost of Sales percentage. Algorithm uses this to optimize bidding and budget allocation. Field Name: campaign_acos_targetType: dimension |
Campaign ACOS Top Search Target | Target ACOS specifically for top search positions. Field Name: campaign_acos_top_search_targetType: dimension |
Campaign Salesforce Event ID | Field Name: campaign_salesforce_event_idType: dimension |
Campaign Automatic Budget | Indicates if the campaign uses automatic budget management. Field Name: campaign_automatic_budgetType: dimension |
Campaign Last Updated | Date and time when the campaign was last modified. Field Name: campaign_last_updatedType: dimension |
Campaign Date Created | Date and time when the campaign was created. Field Name: campaign_date_createdType: dimension |
Brand Ads
Campaign Type | Type of Brand Ads campaign. Values: custom (user-managed), automatic (platform-managed). Field Name: campaign_typeType: dimension |
Campaign Headline | Title or tagline displayed in the Brand Ads advertising space. Field Name: campaign_headlineType: dimension |
Campaign End Date | Date when the campaign is scheduled to end. Field Name: campaign_end_dateType: dimension |
Campaign Moderation Status | Review status of the campaign content. Field Name: campaign_moderation_statusType: dimension |
Display Ads
Campaign Goal | Campaign objective. Values: awareness, consideration, conversion, guaranteed. Field Name: campaign_goalType: dimension |
Campaign Start Date | Date when the campaign begins running. Field Name: campaign_start_dateType: dimension |
Product
Product Item ID | Unique identifier of the product item. Field Name: product_item_idType: dimension |
Product Title | Name or title of the advertised product. Field Name: product_titleType: dimension |
Product Price | Current selling price of the product. Field Name: product_priceType: dimension |
Product Thumbnail | Image Thumbnail IMAGE sheets formula Field Name: product_thumbnailType: dimension |
Product Thumbnail URL | URL of the product thumbnail image. Field Name: product_thumbnail_urlType: dimension |
Product Status | Current status of the product listing. Values: active, paused, hold, idle, delegated, revoked. Field Name: product_statusType: dimension |
Product Permalink | Permanent URL link to the product listing page. Field Name: product_permalinkType: dimension |
Product Brand Value ID | Unique identifier of the product brand. Field Name: product_brand_value_idType: dimension |
Product Brand Value Name | Brand name associated with the product. Field Name: product_brand_value_nameType: dimension |
Product Condition | Condition of the product. Values: new, used. Field Name: product_conditionType: dimension |
Product Tags | Tags or labels associated with the product. Field Name: product_tagsType: dimension |
Product Has Discount | Indicates if the product has an active discount. Based on difference between regular and sale price. Field Name: product_has_discountType: dimension |
Product Catalog Listing | Indicates if the product is part of the catalog listing. Field Name: product_catalog_listingType: dimension |
Product Logistic Type | Type of shipping logistics for the product. Field Name: product_logistic_typeType: dimension |
Product Listing Type ID | Type of product listing (e.g., gold_pro, gold_special). Field Name: product_listing_type_idType: dimension |
Product Domain ID | Product category domain identifier. Field Name: product_domain_idType: dimension |
Product Buy Box Winner | Indicates if the product wins the catalog buy box. Prioritized in catalog competition. Field Name: product_buy_box_winnerType: dimension |
Product Channel | Sales channel for the product. Values: marketplace, mshops. Field Name: product_channelType: dimension |
Product Official Store ID | Identifier of the official store selling the product. Field Name: product_official_store_idType: dimension |
Product Current Level | Seller reputation level for the product. Field Name: product_current_levelType: dimension |
Product Deferred Stock | Indicates if product has manufacturing time. Products with immediate stock are prioritized. Field Name: product_deferred_stockType: dimension |
Product User Product ID | Field Name: product_user_product_idType: dimension |
Product User Product Name | Field Name: product_user_product_nameType: dimension |
Product Recommended | Product Ads recommendation flag. Indicates good performance potential if advertising is activated. Field Name: product_recommendedType: dimension |
Product Date Created | Date when the product listing was created. Field Name: product_date_createdType: dimension |
Keyword
Keyword Term | Search term or keyword phrase used for campaign targeting. Field Name: keyword_termType: dimension |
Keyword Type | Type of keyword. Values: custom (user-defined), suggested (platform-recommended). Field Name: keyword_typeType: dimension |
Keyword Match Type | How closely the search query must match the keyword. Values: phrase, exact, broad. Field Name: keyword_match_typeType: dimension |
Keyword Is Negative | Indicates if keyword is negative (campaign won’t show for this keyword). Field Name: keyword_is_negativeType: dimension |
Keyword Goal CPC Max | Maximum cost-per-click bid for the keyword. Falls back to campaign CPC if not set. Field Name: keyword_goal_cpc_maxType: dimension |
Keyword Is Deleted | Indicates if the keyword has been deleted from the campaign. Field Name: keyword_is_deletedType: dimension |
Line Item
Line Item ID | Unique identifier for the line item within a campaign. Field Name: line_item_idType: dimension |
Line Item Name | Name of the line item configuration. Field Name: line_item_nameType: dimension |
Line Item Status | Current status of the line item. Values: active, paused. Field Name: line_item_statusType: dimension |
Line Item Type | Type based on creative format. Values: Display, Social (vertical video), Video (horizontal). Field Name: line_item_typeType: dimension |
Line Item Start Date | Date when the line item begins running. Field Name: line_item_start_dateType: dimension |
Line Item End Date | Date when the line item stops running. Field Name: line_item_end_dateType: dimension |
Creative
Creative ID | Unique identifier for the creative asset. Field Name: creative_idType: dimension |
Creative Name | Name of the creative element. Field Name: creative_nameType: dimension |
Creative Status | Review status of the creative. Values: active, in review, rejected. Field Name: creative_statusType: dimension |
Metrics
Metrics are the numerical values you can measure and analyze from your Mercado Ads campaigns.Most Used
Cost | Total amount spent on advertising. Also referred to as consumed budget or investment. Field Name: costType: metric |
Clicks | Number of times users clicked on your ads. Field Name: clicksType: metric |
Impressions | Number of times your ads were displayed to users. Field Name: impressionsType: metric |
CPC | Cost Per Click - average amount paid for each click. Formula: cost / clicks. Field Name: cpcType: metric |
CTR | Click-Through Rate - percentage of impressions that resulted in clicks. Formula: (clicks / impressions) * 100. Field Name: ctrType: metric |
CVR | Conversion Rate - percentage of clicks that resulted in conversions. Formula: (conversions / clicks) * 100. Field Name: cvrType: metric |
ACOS | Advertising Cost of Sales - advertising spend as percentage of revenue. Formula: (cost / revenue) * 100. Field Name: acosType: metric |
Product Ads
TACoS | Total Advertising Cost of Sales - ad spend as a percentage of TOTAL revenue (organic + ad-attributed). Formula: (cost / total revenue) * 100. Unlike ACoS, which only uses ad-attributed revenue. Product Ads only. Field Name: tacosType: metric |
Direct Amount | Revenue from direct sales attributed to your Product Ads. Field Name: direct_amountType: metric |
Indirect Amount | Revenue from indirect/assisted sales influenced by your ads. Field Name: indirect_amountType: metric |
Total Amount | Total revenue from all sales attributed to your Product Ads (direct + indirect). Field Name: total_amountType: metric |
Direct Units Quantity | Number of units sold in direct sales from advertising. Field Name: direct_units_quantityType: metric |
Indirect Units Quantity | Number of units sold in indirect/assisted sales from advertising. Field Name: indirect_units_quantityType: metric |
Units Quantity | Total units sold attributed to your ads across all purchases. Field Name: units_quantityType: metric |
Direct Items Quantity | Number of direct sales transactions from advertising. Field Name: direct_items_quantityType: metric |
Indirect Items Quantity | Number of indirect/assisted sales transactions from advertising. Field Name: indirect_items_quantityType: metric |
Advertising Items Quantity | Total number of sales transactions attributed to advertising. Field Name: advertising_items_quantityType: metric |
Organic Units Quantity | Number of units sold without advertising (organic sales). Field Name: organic_units_quantityType: metric |
Organic Items Quantity | Number of sales transactions without advertising (organic sales). Field Name: organic_items_quantityType: metric |
Organic Units Amount | Revenue from sales without advertising (organic revenue). Field Name: organic_units_amountType: metric |
ROAS | Return on Ad Spend - revenue generated per unit of ad spend. Formula: revenue / cost. Field Name: roasType: metric |
SOV | Share of Voice - percentage of advertising sales over total sales. Field Name: sovType: metric |
Impression Share | Percentage of impressions won out of total eligible impressions. Shows how often your ads appeared. Field Name: impression_shareType: metric |
Top Impression Share | Percentage of auctions won in top search positions out of total eligible auctions. Field Name: top_impression_shareType: metric |
Lost Impression Share By Budget | Percentage of impressions lost due to insufficient budget. Consider increasing budget. Field Name: lost_impression_share_by_budgetType: metric |
Lost Impression Share By Ad Rank | Percentage of impressions lost due to low ad rank. Consider improving CPC or product quality. Field Name: lost_impression_share_by_ad_rankType: metric |
ACOS Benchmark | Target ACOS used by successful ads with good impressions and sales performance. Field Name: acos_benchmarkType: metric |
Brand Ads
Attribution Order Conversions | Number of purchases made after users clicked on your Brand Ads. Field Name: attribution_order_conversionsType: metric |
Attribution Order Amount | Total revenue from sales attributed to your Brand Ads clicks. Field Name: attribution_order_amountType: metric |
Leads | Number of potential buyers who asked questions or contacted via WhatsApp after clicking ads. Field Name: leadsType: metric |
Won Auctions | Percentage of times a keyword won the auction for ad placement. Field Name: won_auctionsType: metric |
Display Ads
CPM | Cost Per Thousand Impressions - average cost for 1,000 ad impressions. Field Name: cpmType: metric |
Reach | Number of unique users who saw your ads. Field Name: reachType: metric |
Active Views | Times users viewed the first 6 seconds of Social and Video ads. Field Name: active_viewsType: metric |
Completed Views | Times users watched your complete Social and Video ads. Field Name: completed_viewsType: metric |
Average Frequency | Average number of times a unique user saw your ads. Field Name: average_frequencyType: metric |
Event Time CPA Order | Cost per order acquisition based on event date. Formula: cost / orders. Field Name: event_time_cpa_orderType: metric |
Event Time CPA PPV | Cost per product page view based on event date. Formula: cost / page views. Field Name: event_time_cpa_ppvType: metric |
Event Time ROAS | Return on ad spend attributed by event date. Formula: revenue / cost. Field Name: event_time_roasType: metric |
Event Time Units Quantity | Units sold attributed to the exact date of the action. Field Name: event_time_units_quantityType: metric |
Event Time Direct Amount | Direct revenue attributed to the exact date of purchase. Field Name: event_time_direct_amountType: metric |
Event Time Direct Item Quantity | Direct sales count attributed to the exact date of purchase. Field Name: event_time_direct_item_quantityType: metric |
Event Time Attribution PPV | Product page views after ad interaction, attributed by event date. Field Name: event_time_attribution_ppvType: metric |
Event Time Attribution Add To Cart | Add to cart actions after ad interaction, attributed by event date. Field Name: event_time_attribution_add_to_cartType: metric |
Event Time Attribution Bookmark | Product bookmarks/favorites after ad interaction, attributed by event date. Field Name: event_time_attribution_bookmarkType: metric |
Event Time Attribution Checkout | Checkout starts after ad interaction, attributed by event date. Field Name: event_time_attribution_checkoutType: metric |
Event Time Attribution Leads | Leads generated after ad interaction, attributed by event date. Field Name: event_time_attribution_leadsType: metric |
Event Time CPL | Cost per lead based on event date. Formula: cost / leads. Field Name: event_time_cplType: metric |
Touch Point CPA Order | Cost per order attributed to ad click/impression date. Formula: cost / orders. Field Name: touch_point_cpa_orderType: metric |
Touch Point CPA PPV | Cost per page view attributed to ad click/impression date. Formula: cost / page views. Field Name: touch_point_cpa_ppvType: metric |
Touch Point ROAS | Return on ad spend attributed to ad click/impression date. Formula: revenue / cost. Field Name: touch_point_roasType: metric |
Touch Point Units Quantity | Units sold attributed to the date of ad click or impression. Field Name: touch_point_units_quantityType: metric |
Touch Point Direct Amount | Direct revenue attributed to the date of ad click or impression. Field Name: touch_point_direct_amountType: metric |
Touch Point Direct Item Quantity | Direct sales count attributed to the date of ad click or impression. Field Name: touch_point_direct_item_quantityType: metric |
Touch Point Attribution PPV | Product page views attributed to ad click/impression date. Field Name: touch_point_attribution_ppvType: metric |
Touch Point Attribution Add To Cart | Add to cart actions attributed to ad click/impression date. Field Name: touch_point_attribution_add_to_cartType: metric |
Touch Point Attribution Bookmark | Product bookmarks attributed to ad click/impression date. Field Name: touch_point_attribution_bookmarkType: metric |
Touch Point Attribution Checkout | Checkout starts attributed to ad click/impression date. Field Name: touch_point_attribution_checkoutType: metric |
Touch Point Attribution Leads | Leads generated attributed to ad click/impression date. Field Name: touch_point_attribution_leadsType: metric |
Touch Point CPL | Cost per lead attributed to ad click/impression date. Formula: cost / leads. Field Name: touch_point_cplType: metric |
Related
Fields Catalog
Browse all platforms
Meta Ads Fields
Meta Ads metrics & dimensions
Google Ads Fields
Google Ads metrics & dimensions
TikTok Ads Fields
TikTok Ads metrics & dimensions