# Schema Information

## Tables/APIs&#x20;

The following is the list of tables or APIs associated with the Mercado Libre connector:

* ad\_metrics&#x20;
* ads&#x20;
* campaign\_metrics&#x20;
* campaigns&#x20;
* inventory\_items&#x20;
* orders&#x20;
* seller\_promotions&#x20;
* shipments&#x20;

### ad\_metrics &#x20;

The ad metrics API provides metrics and analytics related to advertisements.

For more information, see [Mercado Libr&#x65;**-** ad\_metrics](https://developers.mercadolibre.com.ar/en_us/product-ads#Ad-metrics).

**FIELDS**&#x20;

<table><thead><tr><th width="78">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>clicks</td><td>NUMERIC</td></tr><tr><td>impressions</td><td>NUMERIC</td></tr><tr><td>cost</td><td>NUMERIC</td></tr><tr><td>cpc</td><td>NUMERIC</td></tr><tr><td>ctr</td><td>NUMERIC</td></tr><tr><td>sold_quantity_direct</td><td>NUMERIC</td></tr><tr><td>sold_quantity_indirect</td><td>NUMERIC</td></tr><tr><td>sold_quantity_total</td><td>NUMERIC</td></tr><tr><td>amount_direct</td><td>NUMERIC</td></tr><tr><td>amount_indirect</td><td>NUMERIC</td></tr><tr><td>amount_total</td><td>NUMERIC</td></tr><tr><td>advertising_fee</td><td>NUMERIC</td></tr><tr><td>organic_orders_quantity</td><td>NUMERIC</td></tr><tr><td>share</td><td>NUMERIC</td></tr><tr><td>sold_items_quantity_direct</td><td>NUMERIC</td></tr><tr><td>sold_items_quantity_indirect</td><td>NUMERIC</td></tr><tr><td>sold_items_conversion</td><td>NUMERIC</td></tr><tr><td>organic_sold_items_quantity</td><td>NUMERIC</td></tr><tr><td>amount_indirect_usd</td><td>NUMERIC</td></tr></tbody></table>

### ads &#x20;

Deals with the management and retrieval of advertisement-related data, allowing you to create, update, or retrieve ads.

For more information, see [Mercado Libr&#x65;**-** ads](https://developers.mercadolibre.com.ar/en_us/product-ads).

**FIELDS**&#x20;

<table><thead><tr><th width="78">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>campaign_id</td><td>NUMERIC</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr><tr><td>site_id</td><td>STRING</td></tr><tr><td>cpc</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>price</td><td>NUMERIC</td></tr><tr><td>currency_id</td><td>STRING</td></tr><tr><td>permalink</td><td>STRING</td></tr><tr><td>thumbnail</td><td>STRING</td></tr><tr><td>picture_id</td><td>STRING</td></tr><tr><td>channel</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr></tbody></table>

### campaign\_metrics &#x20;

This API is similar to ad metrics, but specifically focused on campaign-level metrics for advertising efforts.

For more information, see [Mercado Libr&#x65;**-** campaign\_metrics](https://developers.mercadolibre.com.ar/en_us/product-ads#Campaign-metrics).

**FIELDS**&#x20;

<table><thead><tr><th width="124">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>clicks</td><td>NUMERIC</td></tr><tr><td>impressions</td><td>NUMERIC</td></tr><tr><td>ctr</td><td>NUMERIC</td></tr><tr><td>cost</td><td>BIGNUMERIC</td></tr><tr><td>cpc</td><td>NUMERIC</td></tr><tr><td>sold_quantity_direct</td><td>NUMERIC</td></tr><tr><td>sold_quantity_indirect</td><td>NUMERIC</td></tr><tr><td>sold_quantity_total</td><td>NUMERIC</td></tr><tr><td>amount_direct</td><td>NUMERIC</td></tr><tr><td>amount_indirect</td><td>NUMERIC</td></tr><tr><td>amount_total</td><td>NUMERIC</td></tr><tr><td>advertising_fee</td><td>NUMERIC</td></tr><tr><td>share</td><td>NUMERIC</td></tr><tr><td>sold_items_quantity_direct</td><td>NUMERIC</td></tr><tr><td>sold_items_quantity_indirect</td><td>NUMERIC</td></tr></tbody></table>

### campaigns &#x20;

Involves the management of advertising campaigns, allowing you to create, update, or retrieve information about advertising campaigns.

For more information, see [Mercado Libr&#x65;**-** campaigns](https://developers.mercadolibre.com.ar/en_us/product-ads#Create-a-campaign).

**FIELDS**&#x20;

<table><thead><tr><th width="78">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>advertiser_id</td><td>NUMERIC</td></tr><tr><td>budget</td><td>NUMERIC</td></tr><tr><td>official_store_id</td><td>STRING</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>target_take_rate</td><td>NUMERIC</td></tr><tr><td>acos_top_modifier</td><td>NUMERIC</td></tr><tr><td>bidding_strategy</td><td>STRING</td></tr><tr><td>channel</td><td>STRING</td></tr></tbody></table>

### inventory\_items &#x20;

Handles the management and retrieval of inventory items, including details like product descriptions, quantities, and prices.

For more information, see [Mercado Libr&#x65;**-** inventory\_items](https://developers.mercadolibre.com.mx/es_ar/stock-de-fulfillment).

**FIELDS**&#x20;

<table><thead><tr><th width="111">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>site_id</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>seller_id</td><td>NUMERIC</td></tr><tr><td>category_id</td><td>STRING</td></tr><tr><td>official_store_id</td><td>NUMERIC</td></tr><tr><td>price</td><td>NUMERIC</td></tr><tr><td>base_price</td><td>NUMERIC</td></tr><tr><td>currency_id</td><td>STRING</td></tr><tr><td>initial_quantity</td><td>NUMERIC</td></tr><tr><td>available_quantity</td><td>NUMERIC</td></tr><tr><td>sold_quantity</td><td>NUMERIC</td></tr><tr><td>sale_terms</td><td>RECORD</td></tr><tr><td>buying_mode</td><td>STRING</td></tr><tr><td>listing_type_id</td><td>STRING</td></tr><tr><td>start_time</td><td>TIMESTAMP</td></tr><tr><td>stop_time</td><td>TIMESTAMP</td></tr><tr><td>end_time</td><td>TIMESTAMP</td></tr><tr><td>expiration_time</td><td>TIMESTAMP</td></tr><tr><td>condition</td><td>STRING</td></tr><tr><td>permalink</td><td>STRING</td></tr><tr><td>thumbnail_id</td><td>STRING</td></tr><tr><td>thumbnail</td><td>STRING</td></tr><tr><td>secure_thumbnail</td><td>STRING</td></tr><tr><td>pictures</td><td>RECORD</td></tr><tr><td>accepts_mercadopago</td><td>BOOLEAN</td></tr><tr><td>shipping</td><td>RECORD</td></tr><tr><td>international_delivery_mode</td><td>STRING</td></tr><tr><td>seller_address</td><td>RECORD</td></tr><tr><td>geolocation</td><td>RECORD</td></tr><tr><td>attributes</td><td>RECORD</td></tr><tr><td>listing_source</td><td>STRING</td></tr><tr><td>variations</td><td>RECORD</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>warranty</td><td>STRING</td></tr><tr><td>domain_id</td><td>STRING</td></tr><tr><td>automatic_relist</td><td>BOOLEAN</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>health</td><td>NUMERIC</td></tr><tr><td>catalog_listing</td><td>BOOLEAN</td></tr><tr><td>channels</td><td>STRING</td></tr></tbody></table>

### orders &#x20;

Provides functionality to manage and retrieve information related to customer orders, including order details, status, and shipping information.

For more information, see [Mercado Libr&#x65;**-** orders](https://developers.mercadolibre.com.ar/en_us/order-management).

**FIELDS**&#x20;

<table><thead><tr><th width="78">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>payments</td><td>RECORD</td></tr><tr><td>fulfilled</td><td>BOOLEAN</td></tr><tr><td>expiration_date</td><td>TIMESTAMP</td></tr><tr><td>shipping</td><td>RECORD</td></tr><tr><td>date_closed</td><td>TIMESTAMP</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>order_items</td><td>RECORD</td></tr><tr><td>date_last_updated</td><td>TIMESTAMP</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>coupon</td><td>RECORD</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>buyer</td><td>RECORD</td></tr><tr><td>seller</td><td>RECORD</td></tr><tr><td>total_amount</td><td>NUMERIC</td></tr><tr><td>paid_amount</td><td>NUMERIC</td></tr><tr><td>mediations</td><td>RECORD</td></tr><tr><td>currency_id</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>cancel_detail</td><td>RECORD</td></tr><tr><td>context</td><td>RECORD</td></tr></tbody></table>

### seller\_promotions &#x20;

This API involves the creation and management of promotions offered by sellers to attract customers.

For more information, see [Mercado Libr&#x65;**-** seller\_promotions](https://developers.mercadolibre.com.mx/es_ar/central-de-promociones).

**FIELDS**&#x20;

<table><thead><tr><th width="124">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>start_date</td><td>TIMESTAMP</td></tr><tr><td>finish_date</td><td>TIMESTAMP</td></tr><tr><td>deadline_date</td><td>TIMESTAMP</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>benefits</td><td>RECORD</td></tr></tbody></table>

### shipments&#x20;

The Shipment API deals with the logistics and shipment information associated with orders, providing details on delivery status, tracking, etc.

For more information, see [Mercado Libr&#x65;**-** shipments](https://developers.mercadolibre.com.ar/en_us/shipping).

**FIELDS**&#x20;

<table><thead><tr><th width="78">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>snapshot_packing</td><td>RECORD</td></tr><tr><td>receiver_id</td><td>NUMERIC</td></tr><tr><td>base_cost</td><td>NUMERIC</td></tr><tr><td>status_history</td><td>RECORD</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>sender_id</td><td>NUMERIC</td></tr><tr><td>mode</td><td>STRING</td></tr><tr><td>order_cost</td><td>NUMERIC</td></tr><tr><td>service_id</td><td>NUMERIC</td></tr><tr><td>shipping_items</td><td>RECORD</td></tr><tr><td>tracking_number</td><td>STRING</td></tr><tr><td>cost_components</td><td>RECORD</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>tracking_method</td><td>STRING</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>date_first_printed</td><td>TIMESTAMP</td></tr><tr><td>created_by</td><td>STRING</td></tr><tr><td>shipping_option</td><td>RECORD</td></tr><tr><td>sender_address</td><td>RECORD</td></tr><tr><td>site_id</td><td>STRING</td></tr><tr><td>market_place</td><td>STRING</td></tr><tr><td>receiver_address</td><td>RECORD</td></tr><tr><td>order_id</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>logistic_type</td><td>STRING</td></tr></tbody></table>
