Last updated: August 5, 2025
45 dimensions
55 metrics
This reference covers all available dimensions and metrics for Mercado Ads data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets

​
Dimensions

Dimensions are the attributes you can use to segment and group your Mercado Ads data.

​
Most Used

Advertiser Id
Unique identifier for the advertiser.

Field Name: advertiser_id
Type: dimension
Advertiser Name
The name of the advertiser concatenated with it’s country.

Field Name: advertiser_name
Type: dimension
Country Name
Country Name of the advertiser.

Field Name: country_name
Type: dimension
Country Id
Country ID of the advertiser.

Field Name: site_id
Type: dimension
Campaign Id
The unique identifier for the campaign.

Field Name: campaign_id
Type: dimension
Campaign Name
The name of the campaign.

Field Name: campaign_name
Type: dimension
Campaign Status
The campaign status: active, paused.

Field Name: campaign_status
Type: dimension
Campaign Type (Display only)
Programatic or Guaranteed.

Field Name: campaign_type
Type: dimension
Currency


Field Name: currency
Type: dimension
Ad Type
Brand, Product or Display Ads

Field Name: ad_type
Type: dimension

​
Keyword

Keyword Term
Brand Ads only

Field Name: keywordTerm
Type: dimension
Keyword Type
Brand Ads only

Field Name: keywordType
Type: dimension
Keyword Match Type
Brand Ads only

Field Name: keywordMatchType
Type: dimension
Keyword Is Negative
Brand Ads only

Field Name: keywordIsNegative
Type: dimension

​
Line Item

Line Item Id
Display Ads only

Field Name: lineItemId
Type: dimension
Line Item Id
Display Ads only

Field Name: line_item_id
Type: dimension
Line Item Name
Display Ads only

Field Name: line_item_name
Type: dimension
Line Item Status
Display Ads only

Field Name: line_item_status
Type: dimension
Line Item Type
Display Ads only

Field Name: line_item_type
Type: dimension
Line Item Start Date
Display Ads only

Field Name: line_item_start_date
Type: dimension
Line Item End Date
Display Ads only

Field Name: line_item_end_date
Type: dimension

​
Product

Currency Id
Currency identifier.

Field Name: currency_id
Type: dimension
Last Updated
The last time the product data was updated.

Field Name: last_updated
Type: dimension
Date Created
The creation date of the product.

Field Name: date_created
Type: dimension
ACoS Target
Target ACoS (Advertising Cost of Sales).

Field Name: acos_target
Type: dimension
Strategy
The product strategy being used.

Field Name: strategy
Type: dimension
ACoS Top Search Target
Target ACoS for top search results.

Field Name: acos_top_search_target
Type: dimension
Channel
The channel where the product is advertised.

Field Name: channel
Type: dimension
Has Discount
Indicates if the product has a discount.

Field Name: has_discount
Type: dimension
Item Id
Unique identifier for the product item.

Field Name: item_id
Type: dimension
Product Price
The price of the product.

Field Name: product_price
Type: dimension
Product Title
The title of the product.

Field Name: product_title
Type: dimension
Status
The status of the product.

Field Name: status
Type: dimension
Catalog Listing
Indicates if the product is in the catalog listing.

Field Name: catalog_listing
Type: dimension
Logistic Type
The logistic type for the product.

Field Name: logistic_type
Type: dimension
Domain Id
Domain identifier for the product.

Field Name: domain_id
Type: dimension
Buy Box Winner
Indicates if the product is the buy box winner.

Field Name: buy_box_winner
Type: dimension
Tags
Tags associated with the product.

Field Name: tags
Type: dimension
Brand Value Name
The brand value associated with the product.

Field Name: brand_value_name
Type: dimension
Condition
The condition of the product.

Field Name: condition
Type: dimension
Current Level
The current stock level of the product.

Field Name: current_level
Type: dimension
Deferred Stock
Deferred stock quantity.

Field Name: deferred_stock
Type: dimension
Thumbnail
Thumbnail image of the product.

Field Name: thumbnail
Type: dimension
Permalink
Permanent link to the product.

Field Name: permalink
Type: dimension
Recommended
Indicates if the product is recommended.

Field Name: recommended
Type: dimension

​
Metrics

Metrics are the numerical values you can measure and analyze from your Mercado Ads campaigns.

​
Most Used

Spend
Amount in account’s currency.

Field Name: consumed_budget
Type: metric
Clicks
Click on your ads.

Field Name: clicks
Type: metric
Reach (Display only)
Number of unique people who saw your ads.

Field Name: reach
Type: metric
Impressions
Number of times your ads where shown.

Field Name: prints
Type: metric

​
Ratio

CTR


Field Name: ctr
Type: metric
CPC


Field Name: cpc
Type: metric
Average Frequency


Field Name: average_frequency
Type: metric
ACOS


Field Name: acos
Type: metric
ROAS


Field Name: roas
Type: metric
CVR


Field Name: cvr
Type: metric
SOV


Field Name: sov
Type: metric

​
Touch Point Display

Purchases (Touch Point)
Touch Point Metrics are attributed to the date of the ad click or impression.

Field Name: touch_point_direct_item_quantity
Type: metric
Revenue (Touch Point)
Total sales value attributed to your ads.

Field Name: touch_point_direct_amount
Type: metric
Product Page Views (Touch Point)
Number of times users viewed your product page after engaging with your ads.

Field Name: touch_point_attribution_ppv
Type: metric
Add to Carts (Touch Point)
Number of times users added your products to their shopping cart after engaging with your ads.

Field Name: touch_point_attribution_add_to_cart
Type: metric
Bookmarks (Touch Point)
Number of times users added your products to their favorites after engaging with your ads.

Field Name: touch_point_attribution_bookmark
Type: metric
Checkouts (Touch Point)
Number of times users initiated the purchase process for your products after engaging with your ads.

Field Name: touch_point_attribution_checkout
Type: metric

​
Touch Point

Item Purchases (Touch Point) (Display And Brand)
Number of units sold attributed to your ads.

Field Name: touch_point_units_quantity
Type: metric

​
Event Time Display

Purchases (Event Time)
Event Time Metrics attributed to the exact date the action (e.g., sale) was performed.

Field Name: event_time_direct_item_quantity
Type: metric
Revenue (Event Time)
Total sales value attributed to your ads.

Field Name: event_time_direct_amount
Type: metric
Product Page Views (Event Time)
Number of times users viewed your product page after engaging with your ads.

Field Name: event_time_attribution_ppv
Type: metric
Add to Carts (Event Time)
Number of times users added your products to their shopping cart after engaging with your ads.

Field Name: event_time_attribution_add_to_cart
Type: metric
Bookmarks (Event Time)
Number of times users added your products to their favorites after engaging with your ads.

Field Name: event_time_attribution_bookmark
Type: metric
Checkouts (Event Time)
Number of times users initiated the purchase process for your products after engaging with your ads.

Field Name: event_time_attribution_checkout
Type: metric

​
Event Time

Item Purchases (Event Time) (Display and Brand)
Number of units sold attributed to your ads.

Field Name: event_time_units_quantity
Type: metric

​
Event Time Brand

Revenue (Event Time)
Total revenue attributed to your ads during the event time, split by brand.

Field Name: event_time_units_amount
Type: metric
Items Sold (Event Time)
Total number of items sold attributed to your ads during the event time, split by brand.

Field Name: event_time_items_quantity
Type: metric
Product Page Views (Event Time)
Number of product page views attributed to your ads during the event time, split by brand.

Field Name: event_time_ppv_conversions
Type: metric
Bookmarks Added (Event Time)
Number of times users added your products to their favorites during the event time, split by brand.

Field Name: event_time_bookmark_conversions
Type: metric
Add to Cart Conversions (Event Time)
Number of times users added products to their shopping cart during the event time, split by brand.

Field Name: event_time_cart_conversions
Type: metric
Checkouts Started (Event Time)
Number of times users initiated the purchase process for your products during the event time, split by brand.

Field Name: event_time_checkout_conversions
Type: metric
Leads (Questions) (Event Time)
Number of leads generated from questions attributed to your ads during the event time, split by brand.

Field Name: event_time_leads_question_conversions
Type: metric
Leads (Instant Messages) (Event Time)
Number of leads generated from instant messages attributed to your ads during the event time, split by brand.

Field Name: event_time_leads_im_conversions
Type: metric
eShop Conversions (Event Time)
Number of conversions on your eShop attributed to your ads during the event time, split by brand.

Field Name: event_time_eshop_conversions
Type: metric

​
Touch Point Brand

Revenue (Touch Point)
Total revenue attributed to touch point interactions for your ads, split by brand.

Field Name: touch_point_units_amount
Type: metric
Items Sold (Touch Point)
Total number of items sold attributed to touch point interactions for your ads, split by brand.

Field Name: touch_point_items_quantity
Type: metric
Product Page Views (Touch Point)
Number of product page views attributed to touch point interactions for your ads, split by brand.

Field Name: touch_point_ppv_conversions
Type: metric
Bookmarks Added (Touch Point)
Number of times users added your products to their favorites through touch point interactions, split by brand.

Field Name: touch_point_bookmark_conversions
Type: metric
Add to Cart Conversions (Touch Point)
Number of times users added products to their shopping cart through touch point interactions, split by brand.

Field Name: touch_point_cart_conversions
Type: metric
Checkouts Started (Touch Point)
Number of times users initiated the checkout process through touch point interactions, split by brand.

Field Name: touch_point_checkout_conversions
Type: metric
Leads (Questions) (Touch Point)
Number of leads generated from user questions through touch point interactions, split by brand.

Field Name: touch_point_leads_question_conversions
Type: metric
Leads (Instant Messages) (Touch Point)
Number of leads generated from instant messages through touch point interactions, split by brand.

Field Name: touch_point_leads_im_conversions
Type: metric
eShop Conversions (Touch Point)
Number of conversions on your eShop attributed to touch point interactions for your ads, split by brand.

Field Name: touch_point_eshop_conversions
Type: metric

​
Product Ads

Organic Units Sold
Total number of units sold organically (not attributed to ads).

Field Name: organic_units_quantity
Type: metric
Organic Revenue
Total revenue generated organically (not attributed to ads).

Field Name: organic_units_amount
Type: metric
Organic Items Sold
Total number of individual items sold organically (not attributed to ads).

Field Name: organic_items_quantity
Type: metric
Direct Items Sold
Total number of items sold directly attributed to your ads.

Field Name: direct_items_quantity
Type: metric
Indirect Items Sold
Total number of items sold indirectly attributed to your ads.

Field Name: indirect_items_quantity
Type: metric
Advertising Items Sold
Total number of items sold attributed to your advertising efforts.

Field Name: advertising_items_quantity
Type: metric
Direct Units Sold
Total number of units sold directly attributed to your ads.

Field Name: direct_units_quantity
Type: metric
Indirect Units Sold
Total number of units sold indirectly attributed to your ads.

Field Name: indirect_units_quantity
Type: metric
Total Units Sold
Total number of units sold through all channels (direct and indirect).

Field Name: units_quantity
Type: metric
Direct Revenue
Total revenue generated directly attributed to your ads.

Field Name: direct_amount
Type: metric
Indirect Revenue
Total revenue generated indirectly attributed to your ads.

Field Name: indirect_amount
Type: metric
Total Revenue
Total revenue generated from all channels (direct and indirect).

Field Name: total_amount
Type: metric