Merhabalar. Google Analytics verilerini çekmek istiyorum ve kullandığım fonksiyonlar bunlar..
analytics.class.php
<?php
class analytics{
private $_sUser;
private $_sPass;
private $_sAuth;
private $_sProfileId;
private $_sStartDate;
private $_sEndDate;
private $_bUseCache;
private $_iCacheAge;
/**
* public constructor
*
* @param string $sUser
* @param string $sPass
* @return analytics
*/
public function __construct($sUser, $sPass){
$this->_sUser = $sUser;
$this->_sPass = $sPass;
$this->_bUseCache = false;
$this->auth();
}
/**
* Google Authentification, returns session when set
*/
private function auth(){
if (isset($_SESSION['auth'])){
$this->_sAuth = $_SESSION['auth'];
return;
}
$aPost = array ( 'accountType' => 'GOOGLE',
'Email' => $this->_sUser,
'Passwd' => $this->_sPass,
'service' => 'analytics',
'source' => 'SWIS-Webbeheer-4.0');
$sResponse = $this->getUrl('https://www.google.com/accounts/ClientLogin', $aPost);
$_SESSION['auth'] = '';
if (strpos($sResponse, "\n") !== false){
$aResponse = explode("\n", $sResponse);
foreach ($aResponse as $sResponse){
if (substr($sResponse, 0, 4) == 'Auth'){
$_SESSION['auth'] = trim(substr($sResponse, 5));
}
}
}
if ($_SESSION['auth'] == ''){
unset($_SESSION['auth']);
throw new Exception('Retrieving Auth hash failed!');
}
$this->_sAuth = $_SESSION['auth'];
}
/**
* Use caching (bool)
* Whether or not to store GA data in a session for a given period
*
* @param bool $bCaching (true/false)
* @param int $iCacheAge seconds (default: 10 minutes)
*/
public function useCache($bCaching = true, $iCacheAge = 600){
$this->_bUseCache = $bCaching;
$this->_iCacheAge = $iCacheAge;
if ($bCaching && !isset($_SESSION['cache'])){
$_SESSION['cache'] = array();
}
}
/**
* Get GA XML with auth key
*
* @param string $sUrl
* @return string XML
*/
private function getXml($sUrl){
return $this->getUrl($sUrl, array(), array('Authorization: GoogleLogin auth=' . $this->_sAuth));
}
/**
* Sets GA Profile ID (Example: ga:12345)
*/
public function setProfileById($sProfileId){
$this->_sProfileId = $sProfileId;
}
/**
* Sets Profile ID by a given accountname
*
*/
public function setProfileByName($sAccountName){
if (isset($_SESSION['profile'])){
$this->_sProfileId = $_SESSION['profile'];
return;
}
$this->_sProfileId = '';
$sXml = $this->getXml('https://www.google.com/analytics/feeds/accounts/default');
$aAccounts = $this->parseAccountList($sXml);
foreach($aAccounts as $aAccount){
if (isset($aAccount['accountName']) && $aAccount['accountName'] == $sAccountName){
if (isset($aAccount['tableId'])){
$this->_sProfileId = $aAccount['tableId'];
}
}
}
if ($this->_sProfileId == ''){
throw new Exception('No profile ID found!');
}
$_SESSION['profile'] = $this->_sProfileId;
}
/**
* Returns an array with profileID => accountName
*
*/
public function getProfileList(){
$sXml = $this->getXml('https://www.google.com/analytics/feeds/accounts/default');
$aAccounts = $this->parseAccountList($sXml);
$aReturn = array();
foreach($aAccounts as $aAccount){
$aReturn[$aAccount['tableId']] = $aAccount['title'];
}
return $aReturn;
}
/**
* get resulsts from cache if set and not older then cacheAge
*
* @param string $sKey
* @return mixed cached data
*/
private function getCache($sKey){
if ($this->_bUseCache === false){
return false;
}
if (!isset($_SESSION['cache'][$this->_sProfileId])){
$_SESSION['cache'][$this->_sProfileId] = array();
}
if (isset($_SESSION['cache'][$this->_sProfileId][$sKey])){
if (time() - $_SESSION['cache'][$this->_sProfileId][$sKey]['time'] < $this->_iCacheAge){
return $_SESSION['cache'][$this->_sProfileId][$sKey]['data'];
}
}
return false;
}
/**
* Cache data in session
*
* @param string $sKey
* @param mixed $mData Te cachen data
*/
private function setCache($sKey, $mData){
if ($this->_bUseCache === false){
return false;
}
if (!isset($_SESSION['cache'][$this->_sProfileId])){
$_SESSION['cache'][$this->_sProfileId] = array();
}
$_SESSION['cache'][$this->_sProfileId][$sKey] = array( 'time' => time(),
'data' => $mData);
}
/**
* Parses GA XML to an array (dimension => metric)
* Check http://code.google.com/intl/nl/apis/analytics/docs/gdata/gdataReferenceDimensionsMetrics.html
* for usage of dimensions and metrics
*
* @param array $aProperties (GA properties: metrics & dimensions)
*
* @return array result
*/
public function getData($aProperties = array()){
$aParams = array();
foreach($aProperties as $sKey => $sProperty){
$aParams[] = $sKey . '=' . $sProperty;
}
$sUrl = 'https://www.google.com/analytics/feeds/data?ids=' . $this->_sProfileId .
'&start-date=' . $this->_sStartDate .
'&end-date=' . $this->_sEndDate . '&' .
implode('&', $aParams);
$aCache = $this->getCache($sUrl);
if ($aCache !== false){
return $aCache;
}
$sXml = $this->getXml($sUrl);
$aResult = array();
$oDoc = new DOMDocument();
$oDoc->loadXML($sXml);
$oEntries = $oDoc->getElementsByTagName('entry');
foreach($oEntries as $oEntry){
$oTitle = $oEntry->getElementsByTagName('title');
$sTitle = $oTitle->item(0)->nodeValue;
$oMetric = $oEntry->getElementsByTagName('metric');
// Fix the array key when multiple dimensions are given
if (strpos($sTitle, ' | ') !== false && strpos($aProperties['dimensions'], ',') !== false){
$aDimensions = explode(',', $aProperties['dimensions']);
$aDimensions[] = '|';
$aDimensions[] = '=';
$sTitle = preg_replace('/\s\s+/', ' ', trim(str_replace($aDimensions, '', $sTitle)));
}
$sTitle = str_replace($aProperties['dimensions'] . '=', '', $sTitle);
$aResult[$sTitle] = $oMetric->item(0)->getAttribute('value');
}
// cache the results (if caching is true)
$this->setCache($sUrl, $aResult);
return $aResult;
}
/**
* Parse XML from account list
*
* @param string $sXml
*/
private function parseAccountList($sXml){
$oDoc = new DOMDocument();
$oDoc->loadXML($sXml);
$oEntries = $oDoc->getElementsByTagName('entry');
$i = 0;
$aProfiles = array();
foreach($oEntries as $oEntry){
$aProfiles[$i] = array();
$oTitle = $oEntry->getElementsByTagName('title');
$aProfiles[$i]["title"] = $oTitle->item(0)->nodeValue;
$oEntryId = $oEntry->getElementsByTagName('id');
$aProfiles[$i]["entryid"] = $oEntryId->item(0)->nodeValue;
$oProperties = $oEntry->getElementsByTagName('property');
foreach($oProperties as $oProperty){
if (strcmp($oProperty->getAttribute('name'), 'ga:accountId') == 0){
$aProfiles[$i]["accountId"] = $oProperty->getAttribute('value');
}
if (strcmp($oProperty->getAttribute('name'), 'ga:accountName') == 0){
$aProfiles[$i]["accountName"] = $oProperty->getAttribute('value');
}
if (strcmp($oProperty->getAttribute('name'), 'ga:profileId') == 0){
$aProfiles[$i]["profileId"] = $oProperty->getAttribute('value');
}
if (strcmp($oProperty->getAttribute('name'), 'ga:webPropertyId') == 0){
$aProfiles[$i]["webPropertyId"] = $oProperty->getAttribute('value');
}
}
$oTableId = $oEntry->getElementsByTagName('tableId');
$aProfiles[$i]["tableId"] = $oTableId->item(0)->nodeValue;
$i++;
}
return $aProfiles;
}
/**
* Get data from given URL
* Uses Curl if installed, falls back to file_get_contents if not
*
* @param string $sUrl
* @param array $aPost
* @param array $aHeader
* @return string Response
*/
private function getUrl($sUrl, $aPost = array(), $aHeader = array()){
if (count($aPost) > 0){
// build POST query
$sMethod = 'POST';
$sPost = http_build_query($aPost);
$aHeader[] = 'Content-type: application/x-www-form-urlencoded';
$aHeader[] = 'Content-Length: ' . strlen($sPost);
$sContent = $aPost;
} else {
$sMethod = 'GET';
$sContent = null;
}
if (function_exists('curl_init')){
// If Curl is installed, use it!
$rRequest = curl_init();
curl_setopt($rRequest, CURLOPT_URL, $sUrl);
curl_setopt($rRequest, CURLOPT_RETURNTRANSFER, 1);
if ($sMethod == 'POST'){
curl_setopt($rRequest, CURLOPT_POST, 1);
curl_setopt($rRequest, CURLOPT_POSTFIELDS, $aPost);
} else {
curl_setopt($rRequest, CURLOPT_HTTPHEADER, $aHeader);
}
$sOutput = curl_exec($rRequest);
if ($sOutput === false){
throw new Exception('Curl error (' . curl_error($rRequest) . ')');
}
$aInfo = curl_getinfo($rRequest);
if ($aInfo['http_code'] != 200){
// not a valid response from GA
if ($aInfo['http_code'] == 400){
throw new Exception('Bad request (' . $aInfo['http_code'] . ') url: ' . $sUrl);
}
if ($aInfo['http_code'] == 403){
throw new Exception('Access denied (' . $aInfo['http_code'] . ') url: ' . $sUrl);
}
throw new Exception('Not a valid response (' . $aInfo['http_code'] . ') url: ' . $sUrl);
}
curl_close($rRequest);
} else {
// Curl is not installed, use file_get_contents
// create headers and post
$aContext = array('http' => array ( 'method' => $sMethod,
'header'=> implode("\r\n", $aHeader) . "\r\n",
'content' => $sContent));
$rContext = stream_context_create($aContext);
$sOutput = @file_get_contents($sUrl, 0, $rContext);
if (strpos($http_response_header[0], '200') === false){
// not a valid response from GA
throw new Exception('Not a valid response (' . $http_response_header[0] . ') url: ' . $sUrl);
}
}
return $sOutput;
}
/**
* Sets the date range for GA data
*
* @param string $sStartDate (YYY-MM-DD)
* @param string $sEndDate (YYY-MM-DD)
*/
public function setDateRange($sStartDate, $sEndDate){
$this->_sStartDate = $sStartDate;
$this->_sEndDate = $sEndDate;
}
/**
* Sets de data range to a given month
*
* @param int $iMonth
* @param int $iYear
*/
public function setMonth($iMonth, $iYear){
$this->_sStartDate = date('Y-m-d', strtotime($iYear . '-' . $iMonth . '-01'));
$this->_sEndDate = date('Y-m-d', strtotime($iYear . '-' . $iMonth . '-' . date('t', strtotime($iYear . '-' . $iMonth . '-01'))));
}
/**
* Get visitors for given period
*
*/
public function getVisitors(){
return $this->getData(array( 'dimensions' => 'ga:day',
'metrics' => 'ga:visits',
'sort' => 'ga:day'));
}
/**
* Get pageviews for given period
*
*/
public function getPageviews(){
return $this->getData(array( 'dimensions' => 'ga:day',
'metrics' => 'ga:pageviews',
'sort' => 'ga:day'));
}
/**
* Get visitors per hour for given period
*
*/
public function getVisitsPerHour(){
return $this->getData(array( 'dimensions' => 'ga:hour',
'metrics' => 'ga:visits',
'sort' => 'ga:hour'));
}
/**
* Get Browsers for given period
*
*/
public function getBrowsers(){
$aData = $this->getData(array( 'dimensions' => 'ga:browser,ga:browserVersion',
'metrics' => 'ga:visits',
'sort' => 'ga:visits'));
arsort($aData);
return $aData;
}
/**
* Get Operating System for given period
*
*/
public function getOperatingSystem(){
$aData = $this->getData(array( 'dimensions' => 'ga:operatingSystem',
'metrics' => 'ga:visits',
'sort' => 'ga:visits'));
// sort descending by number of visits
arsort($aData);
return $aData;
}
/**
* Get screen resolution for given period
*
*/
public function getScreenResolution(){
$aData = $this->getData(array( 'dimensions' => 'ga:screenResolution',
'metrics' => 'ga:visits',
'sort' => 'ga:visits'));
// sort descending by number of visits
arsort($aData);
return $aData;
}
/**
* Get referrers for given period
*
*/
public function getReferrers(){
$aData = $this->getData(array( 'dimensions' => 'ga:source',
'metrics' => 'ga:visits',
'sort' => 'ga:source'));
// sort descending by number of visits
arsort($aData);
return $aData;
}
/**
* Get search words for given period
*
*/
public function getSearchWords(){
$aData = $this->getData(array( 'dimensions' => 'ga:keyword',
'metrics' => 'ga:visits',
'sort' => 'ga:keyword'));
// sort descending by number of visits
arsort($aData);
return $aData;
}
}
?>bu da index.php dosyam..
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<title></title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.9.0.min.js"></script>
</head>
<body>
<?php
require "analytics.class.php";
try {
$analytics = new analytics("mail adresim", "parolam");
$analytics->useCache();
# Profil id'sini ayarlayalım
$analytics->setProfileById('ga:profilid');
# Tarih Aralığını Belirtelim
$analytics->setMonth(date("m"), date("Y"));
# Tekil ve Çoğul Hitleri Alalım
$tekil = $analytics->getVisitors();
$cogul = $analytics->getPageviews();
} catch (Exception $hata){
echo "Hata: ".$hata->getMessage();
}
?>
<script src="http://code.highcharts.com/highcharts.js"></script>
<script src="http://code.highcharts.com/modules/exporting.js"></script>
<div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div>
<script type="text/javascript">
$(function () {
var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'container',
type: 'area'
},
title: {
text: 'Tekil ve Çoğul Hit'
},
xAxis: {
tickInterval: 1
},
yAxis: {
title: {
text: 'Google Analytics Verileri'
},
labels: {
formatter: function() {
return this.value / 1000 +'k';
}
}
},
tooltip: {
formatter: function() {
return this.series.name +': <b>'+
Highcharts.numberFormat(this.y, 0) +'</b><br /><?php echo date("Y.d"); ?>.'+ this.x;
}
},
plotOptions: {
area: {
pointStart: 1,
marker: {
enabled: false,
symbol: 'circle',
radius: 2,
states: {
hover: {
enabled: true
}
}
}
}
},
series: [{
name: 'Tekil Hit',
data: [<?php echo implode(",", $tekil); ?>]
}, {
name: 'Çoğul Hit',
data: [<?php echo implode(",", $cogul); ?>]
}]
});
});
});
</script>
</body>
</html>Böyle yaptığımda şu hatayı alıyorum neden acaba ?
Hata: Curl error (SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed)
Şimdiden teşekkürler. Elinde Çalışan Script Olan Varsa Paylaşırsa Sevinirim.
Edit : Localde Xampp kullanıyorum. Bir ayarın falan açılmasımı lazım ?