# API de informes

```
GET https://api.offer18.com/api/m/report
```

:link: [<mark style="color:azul;">**Haz clic para probar la API de informes**</mark>](https://offer18.readme.io/reference/reports-api)

### Parámetros comunes

<table data-header-hidden><thead><tr><th width="150">Consulta</th><th width="150"> </th><th> </th></tr></thead><tbody><tr><td><strong>Consulta</strong></td><td><strong>Tipo</strong></td><td><strong>Descripción</strong></td></tr><tr><td>mid</td><td>Entero</td><td>ID de cuenta de la red</td></tr><tr><td>api-key</td><td>Cadena</td><td>Clave API de la red</td></tr><tr><td>secret-key</td><td>Cadena</td><td>Clave secreta de la red</td></tr></tbody></table>

***

### Filtros

<table data-header-hidden><thead><tr><th width="168.4">Consulta</th><th width="150"> </th><th></th></tr></thead><tbody><tr><td><strong>Consulta</strong></td><td><strong>Tipo</strong></td><td><strong>Descripción</strong></td></tr><tr><td>date_from</td><td>Fecha</td><td>Fecha de inicio del informe (YYYY-MM-DD)</td></tr><tr><td>date_end</td><td>Fecha</td><td>Fecha de fin del informe (YYYY-MM-DD)</td></tr><tr><td>datetime_from</td><td>Fecha y hora</td><td>Fecha y hora de inicio del informe (YYYY-MM-DD hh:mm:ss)</td></tr><tr><td>datetime_end</td><td>Fecha y hora</td><td>Fecha y hora de fin del informe (YYYY-MM-DD hh:mm:ss)</td></tr><tr><td>results</td><td>Entero</td><td>N.º de resultados</td></tr><tr><td>page</td><td>Entero</td><td>N.º de página (comienza desde cero)</td></tr><tr><td>timezone</td><td>Decimal</td><td>Predeterminado 0.0 UTC</td></tr><tr><td>offer</td><td>Cadena</td><td>ID de la oferta</td></tr><tr><td>affiliate</td><td>Cadena</td><td>ID del afiliado</td></tr><tr><td>advertiser</td><td>Cadena</td><td>ID del anunciante</td></tr></tbody></table>

{% code overflow="wrap" %}

```
https://api.offer18.com/api/m/report?mid=000&api-key=000000&secret-key=000000000&date_from=0000-00-00&date_end=0000-00-00&offer=0000,1111,2222,3333&affiliate=0000,1111,2222&advertiser=0000,1111,2222&timezone=0.0&results=100
```

{% endcode %}

#### Obtener campos específicos

<table data-header-hidden><thead><tr><th width="150">Consulta</th><th width="158"> </th><th></th></tr></thead><tbody><tr><td><strong>Consulta</strong></td><td><strong>Tipo</strong></td><td><strong>Descripción</strong></td></tr><tr><td>fields</td><td>Cadena</td><td><span data-gb-custom-inline data-tag="emoji" data-code="1f517">🔗</span> <a href="../../../universal/valores-comunes#report-fields"><mark style="color:azul;">Ver campos</mark> </a></td></tr></tbody></table>

<pre data-overflow="wrap"><code><strong>https://api.offer18.com/api/m/report?mid=000&#x26;api-key=0000000&#x26;secret-key=00000000000&#x26;fields=tid,i_id,offer_name,advertiser,affiliate,advertiser_model,affiliate_model,advertiser_price,clicks,conversion,affiliate_price,date,time,hour,offer,s_affiliate,event,impressions,unique_clicks,affiliate_model,ip,currency,isp,country,conn_speed,location,browser,os,os_ver,device,device_brand,device_model,referral_domain,useragent,referral_url,aff_click_id,aff_sub1,aff_sub2,aff_sub3,aff_sub4,aff_sub5,aff_sub6,aff_sub7,aff_sub8,aff_sub9,aff_sub10,adv_sub4,adv_sub5,ios_idfa,source,google_aid,android_id,device_id,cr,ctr,epc,cpc,erpm,ecpm,e_cost_per_conversion,e_revenue_per_conversion,status,status_type,filter_log
</strong></code></pre>

#### Método de ordenación adicional

<table data-header-hidden><thead><tr><th width="150">Consulta</th><th width="150"> </th><th width="370.2"></th></tr></thead><tbody><tr><td><strong>Consulta</strong></td><td><strong>Tipo</strong></td><td><strong>Descripción</strong></td></tr><tr><td>sort_by</td><td>Cadena</td><td><strong>Valores permitidos:</strong> clicks, unique_clicks, conversions, date, time, hour<br>(Solo se permite usar una opción) </td></tr><tr><td>sort_type</td><td>Cadena</td><td><strong>Valores permitidos:</strong> asc y desc</td></tr></tbody></table>

{% code overflow="wrap" %}

```
https://api.offer18.com/api/m/report?mid=000&api-key=000&secret-key=000000000000&sort_by=clicks&sort_type=asc
```

{% endcode %}

***

### Ejemplo de solicitud de API

![](https://497363578-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F41f2EboJipeUA6flsLGK%2Fuploads%2FUor5xxul94HkiwEeEhGS%2Fimage.png?alt=media\&token=fb06940c-b346-48d3-94b0-ad515d55c946)

***

### Respuesta de la API

```
{
  "status": 200,
  "records": 100,
  "timezone": "+5:30",
  "reports": [
    {
      "TID": "D-1111-1630919271-34G126G155G34-WKBNIYP121890",
      "ID de impresión": "",
      "Fecha": "2021-09-06",
      "Hora": "2021-09-06 14:37:51",
      "Hora": "2021-09-06 14:00",
      "ID de oferta": 1111,
      "Nombre de la oferta": "",
      "Anunciante": 22,
      "Afiliado": 89,
      "Sub_afiliado": "",
      "Evento": "",
      "Impresiones": 0,
      "Clics": 1,
      "Clics únicos": 0,
      "Conversiones": 0,
      "Modelo_del_anunciante": "CPA",
      "Modelo_del_afiliado": "CPA",
      "Precio_del_anunciante": 0,
      "Precio_del_afiliado": 0,
      "IP": "1.1.1.1",
      "Moneda": "USD",
      "ISP": "Mountain_View_Communications",
      "País": "AU",
      "Velocidad_de_conexión": "cable_dsl",
      "Ubicación": "Australia, Oceanía",
      "Navegador": "ch",
      "SO": "windows",
      "Versión_SO": 10,
      "Dispositivo": "desktop",
      "Marca_del_dispositivo": "Lenovo",
      "Modelo_del_dispositivo": "ideapad-x310s-ua",
      "Dominio_de_referencia": "urlopener.net",
      "Agente_de_usuario": "Mozilla%2F5.0+%28Windows+NT+10.0%3B+Win64%3B+x64%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F93.0.4577.63+Safari%2F537.36",
      "URL_de_referencia": "https%3A%2F%2Fexample.net%2F",
      "ID_de_clic_del_afiliado": "",
      "Sub_1_del_afiliado": "",
      "Sub_2_del_afiliado": "",
      "Sub_3_del_afiliado": "",
      "Sub_4_del_afiliado": "",
      "Sub_5_del_afiliado": "",
      "Sub_4_del_anunciante": "",
      "Sub_5_del_anunciante": "",
      "IDFA_de_iOS": "",
      "Fuente": "",
      "AID_de_Google": "",
      "ID_de_Android": "",
      "ID_del_dispositivo": "",
      "Estado": "Aprobado",
      "Tipo_de_estado": "Directo",
      "Registro_de_filtro": "",
      "CTR": "0.000 %",
      "EPC": 0,
      "CPC": 0,
      "ERPM": 0,
      "ECPM": 0,
      "Costo_por_conversión_e": 0,
      "Ingresos_por_conversión_e": 0,
      "CR": "0%"
    }
  ]
}
```
