Querying the Reporting API

This guide explains how to call the Piwik API to request your web analytics data. There are two methods:

  • using the standard HTTP API
  • using Piwik's PHP code directly

Call the Piwik API using the HTTP API

If you want to request data in any language (PHP, Python, Ruby, ASP, C++, Java, etc.) you can use the HTTP API. It is a simple way to request data via an HTTP GET.

Security Notice

If the API call requires the token_auth and the HTTP request is sent over untrusted networks, we highly advise that you use an encrypted request. Otherwise, your token_auth is exposed to eavesdroppers. This can be done using https instead of http. In the following example, replace the string "http" by "https".

You can, for example, get the top 100 search engine keywords used to find your website during the current week. Here is an example in PHP:

exit; // REMOVE this line to run the script

// this token is used to authenticate your API request.
// You can get the token on the API page inside your Piwik interface
$token_auth = 'anonymous';

// we call the REST API and request the 100 first keywords for the last month for the idsite=7
$url = "http://demo.piwik.org/";
$url .= "?module=API&method=Referrers.getKeywords";
$url .= "&idSite=7&period=month&date=yesterday";
$url .= "&format=PHP&filter_limit=20";
$url .= "&token_auth=$token_auth";

$fetched = file_get_contents($url);
$content = unserialize($fetched);

// case error
if (!$content) {
    print("Error, content fetched = " . $fetched);

print("<h1>Keywords for the last month</h1>\n");
foreach ($content as $row) {
    $keyword = htmlspecialchars(html_entity_decode(urldecode($row['label']), ENT_QUOTES), ENT_QUOTES);
    $hits = $row['nb_visits'];

    print("<b>$keyword</b> ($hits hits)<br>\n");

Here is the output of this code:

<h1>Keywords for the last month</h1>
<b>Keyword not defined</b> (1167 hits)<br>
<b>pikik apk download</b> (2 hits)<br>
<b>?id=c2a0e1e2-6036-49db-a606-4f1745095f94&quot;&gt;      &lt;/uri&gt;</b> (1 hits)<br>
<b>how to get the visitor id of one database and msg on another</b> (1 hits)<br>
<b>http.xxx.com</b> (1 hits)<br>
<b>http://jp.myav.porn</b> (1 hits)<br>
<b>iis showing error 2032 but no problem in apache</b> (1 hits)<br>
<b>image viditor</b> (1 hits)<br>
<b>isp telecom ip adress</b> (1 hits)<br>
<b>livejasmin ch</b> (1 hits)<br>
<b>php  visitor unique id</b> (1 hits)<br>
<b>pikik</b> (1 hits)<br>
<b>piwik  connection reset by peer</b> (1 hits)<br>
<b>piwik joomla 1.5</b> (1 hits)<br>
<b>piwik sqlstate[42s22]: column not found</b> (1 hits)<br>
<b>show all webside</b> (1 hits)<br>
<b>telli xxx</b> (1 hits)<br>
<b>theip xxx</b> (1 hits)<br>
<b>websites visitors ip</b> (1 hits)<br>
<b>www.xxxxx.com</b> (1 hits)<br>

Call the Piwik API in PHP

If you want to request data in a PHP script that is on the same server as Piwik, you can use this simple technique. This is a more efficient solution as it doesn't require network calls. You directly call the PHP Piwik runtime and get the PHP data structure back.

If you are developing a plugin, you should be using this technique.

use Piwik\API\Request;
use Piwik\FrontController;

define('PIWIK_INCLUDE_PATH', realpath('../..'));
define('PIWIK_USER_PATH', realpath('../..'));
define('PIWIK_ENABLE_DISPATCH', false);

// if you prefer not to include 'index.php', you must also define here PIWIK_DOCUMENT_ROOT
// and include "libs/upgradephp/upgrade.php" and "core/Loader.php"
require_once PIWIK_INCLUDE_PATH . "/index.php";
require_once PIWIK_INCLUDE_PATH . "/core/API/Request.php";

$environment = new \Piwik\Application\Environment(null);


// This inits the API Request with the specified parameters
$request = new Request('
// Calls the API and fetch XML data back
$result = $request->process();
echo $result;

Here is the output of this script:

<?xml version="1.0" encoding="utf-8" ?>

Learn more

To learn more about all the options available when calling the reporting API, read the Reporting API reference.

You can also have a look at the list of client libraries available to call the reporting API.