NBRed5.com - Red5 Analytics Demo - A brief overview and links to a demo of Red5 Analytics

Red Analytics Demo

Page 1, 2, 3, 4, 5

FPDF Library - PDF Generator

With all the charting functionality sorted and coded I turned my attention to the issue of generating exportable reports of the charts and data. The only real options here are server based and as I was using PHP a PHP solution was what was required. Once again using the power of Google I came across the FPDF Library which after giving it a try proved just right in terms of it's ease of use and the features it supported.

A simple example is shown below:

require('fpdf.php');

$pdf=new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',16);
$pdf->Cell(40,10,'Hello World!');
$pdf->Output();

The following is a more complex example showing the generation of the pdf report for the dashboard:

include './inc/lib.php';
include './inc/analytics_api.php';
include './fpdp/fpdf.php';

error_reporting (E_ALL ^E_NOTICE); 

if (!isset($_REQUEST["email"]) || !isset($_REQUEST["passwd"]) || !isset($_REQUEST["id"])) h(400,true);
$email=xyz@abc.com;
$passwd=xxxxxx;
$id = 123456;
$startdate = false;
$enddate = false;

$api = new analytics_api();
if($api->login($email, $passwd)) {
   $results = $api->data($id, 'ga:date', 'ga:visits,ga:pageviews,ga:bounces,ga:entrances,ga:timeOnSite,ga:newVisits,ga:visitors', 'ga:date', $startdate, $enddate, 100);

   $bounces = 0;
   $entrances = 0;
   $timeonsite = 0;
   $newvisits = 0;
   foreach($results as $key => &$value){
   		$visits_values[] = (int)$value["ga:visits"];
	    $pageviews_values[] = (int)$value["ga:pageviews"];
	    $tmp = (int)$value["ga:pageviews"]/(int)$value["ga:visits"];
        $pageviewsvisits_values[] = round($tmp,2);
		$bounces += (int)$value["ga:bounces"];
		$entrances += (int)$value["ga:entrances"];
        $tmp = ((int)$value["ga:bounces"]/(int)$value["ga:entrances"])*100;
        $bouncerate_values[] = round($tmp,2);
	    $tmp = (int)$value["ga:timeOnSite"]/(int)$value["ga:visits"];
		$timeonsite += (int)$value["ga:timeOnSite"];
        $avgtime_values[] = round($tmp);
	    $tmp = ((int)$value["ga:newVisits"]/(int)$value["ga:visits"])*100;
        $newvisits_values[] = round($tmp,2);
		$newvisits += (int)$value["ga:newVisits"];
		$visitors_values[] = (int)$value["ga:visitors"];
   }
   $totalvisits = array_sum($visits_values);
   $url_visits = 'http://chart.apis.google.com/chart?cht=ls&chs=75x15&chco=3764A0&chls=1,1,0&chm=B,CCD6EC,0,0,0&chd='.simpleEncode($visits_values, max($visits_values) + 10);
   $totalpageviews = array_sum($pageviews_values);
   $url_pageviews = 'http://chart.apis.google.com/chart?cht=ls&chs=75x15&chco=3764A0&chls=1,1,0&chm=B,CCD6EC,0,0,0&chd='.simpleEncode($pageviews_values, max($pageviews_values) + 10);
   $tmp = $totalpageviews/$totalvisits;
   $totalpageviewsvisits = round($tmp,2);
   $url_pageviewsvisits = 'http://chart.apis.google.com/chart?cht=ls&chs=75x15&chco=3764A0&chls=1,1,0&chm=B,CCD6EC,0,0,0&chd='.simpleEncode($pageviewsvisits_values, max($pageviewsvisits_values) + 1);
   $tmp = $bounces/$entrances*100;
   $totalbouncerate = round($tmp,2);
   $url_bouncerate = 'http://chart.apis.google.com/chart?cht=ls&chs=75x15&chco=3764A0&chls=1,1,0&chm=B,CCD6EC,0,0,0&chd='.simpleEncode($bouncerate_values, max($bouncerate_values) + 10);
   $totalavgtime = $api->sec2hms(round($tmp), true);
   $url_avgtime = 'http://chart.apis.google.com/chart?cht=ls&chs=75x15&chco=3764A0&chls=1,1,0&chm=B,CCD6EC,0,0,0&chd='.simpleEncode($avgtime_values, max($avgtime_values) + 10);
   $tmp = $newvisits/$totalvisits*100;
   $totalnewvisits = round($tmp,2);
   $url_newvisits = 'http://chart.apis.google.com/chart?cht=ls&chs=75x15&chco=3764A0&chls=1,1,0&chm=B,CCD6EC,0,0,0&chd='.simpleEncode($newvisits_values, max($newvisits_values) + 10);
   $totalvisitors = array_sum($visitors_values);
   $results = $api->data($id, 'ga:country', 'ga:visits', '-ga:visits', $startdate, $enddate, 100);
   $tmp = '';
   $values = array();
   foreach($results as $key => &$value){
        $tmp .= $countries[$key];
        $values[] = (int)$value["ga:visits"];
   }
   $url_map = 'http://chart.apis.google.com/chart?cht=t&chtm=world&chs=440x220&chco=FFFFFF,E0FFD4,A5EF63,50AA00,267114&chf=bg,s,EAF7FE&chld='.$tmp;
   $url_map .= '&chd='.simpleEncode($values, max($values));
   $results = $api->data($id, 'ga:pagePath', 'ga:pageviews', '-ga:pageviews', $startdate, $enddate, 5);
   $totalpageviews1=0;
   foreach($results as $key => &$value){
        $totalpageviews1 += (int)$value["ga:pageviews"];
   }
   $values = array();
   foreach($results as $key => &$value){
        $percent= round(((int)$value["ga:pageviews"]/$totalpageviews1)*100, 2);
        $tmp = array('Page'=>$key, 'Pageviews'=>(int)$value["ga:pageviews"], 'Pageviews_percent'=>"$percent"."%");
        $values[] = $tmp;
   }
   $api->load_accounts();
   foreach($api->accounts as $key => &$value){
		if ($value["tableId"] == $id) {
			$accountname = $key;
			break;
		}
   }
}
$pdf = new FPDF();
$pdf->SetFont('Arial','',10);
$pdf->SetTextColor(124,124,124);
$pdf->SetMargins(15,15);
$pdf->AddPage();
$pdf->SetDisplayMode("real");
$pdf->SetFont('','B',10);  
$pdf->Cell(50,5, $accountname);
$pdf->SetFont('','B',12);
$pdf->Cell(0,5, date('M j, Y',strtotime($startdate)).' - '.date('M j, Y',strtotime($enddate)),0,1,'R');
$pdf->SetFont('','B',14);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(50,5, "Dashboard");
$pdf->SetTextColor(188,188,188);
$pdf->SetFont('','',10);
$pdf->Cell(0,5, "Comparing to: Site",0,1,"R");
$pdf->Line($pdf->GetX(),$pdf->GetY(), $pdf->GetX()+180, $pdf->GetY());
$pdf->Ln();
$pdf->Image("tmp_imgs/visits_chart.png",null,null,180);
$pdf->Ln();
$pdf->SetFillColor(145,145,145);
$pdf->SetTextColor(255,255,255);
$pdf->SetFont('','B',10);
$pdf->Cell(180,5, "Site Usage",0,1,"L",true);
$pdf->Ln();
$tmpY = $pdf->GetY();
$pdf->Image($url_visits);
$pdf->SetTextColor(0,0,0);
$pdf->SetY($tmpY+1);
$pdf->SetX(45);
$pdf->Cell(20,5, $totalvisits." Visits",0,0,"L");
$pdf->SetX(107.5);
$pdf->Image($url_bouncerate);
$pdf->SetTextColor(0,0,0);
$pdf->SetY($tmpY+1);
$pdf->SetX(137.5);
$pdf->Cell(20,5, $totalbouncerate."% Bounce Rate",0,1,"L");
$pdf->Ln();
$tmpY = $pdf->GetY();
$pdf->Image($url_pageviews);
$pdf->SetTextColor(0,0,0);
$pdf->SetY($tmpY+1);
$pdf->SetX(45);
$pdf->Cell(20,5, number_format($totalpageviews)." Pageviews",0,0,"L");
$pdf->SetX(107.5);
$pdf->Image($url_avgtime);
$pdf->SetTextColor(0,0,0);
$pdf->SetY($tmpY+1);
$pdf->SetX(137.5);
$pdf->Cell(20,5, $totalavgtime." Avg. Time on Site",0,1,"L");
$pdf->Ln();
$tmpY = $pdf->GetY();
$pdf->Image($url_pageviewsvisits);
$pdf->SetTextColor(0,0,0);
$pdf->SetY($tmpY+1);
$pdf->SetX(45);
$pdf->Cell(20,5, $totalpageviewsvisits." Pages/Visit",0,0,"L");
$pdf->SetX(107.5);
$pdf->Image($url_newvisits);
$pdf->SetTextColor(0,0,0);
$pdf->SetY($tmpY+1);
$pdf->SetX(137.5);
$pdf->Cell(20,5, $totalnewvisits."% % New Visits",0,1,"L");
$pdf->Ln();
$pdf->SetFillColor(145,145,145);
$pdf->SetTextColor(255,255,255);
$pdf->SetFont('','B',10);
$pdf->Cell(87.5,5, "Visitors Overview",0,0,"L",true);
$pdf->SetX(107.5);
$pdf->Cell(87.5,5, "Map Overlay",0,1,"L",true);
$pdf->SetDrawColor(188,188,188);
$pdf->Rect($pdf->GetX(),$pdf->GetY(), 87.4, 35);
$pdf->Rect($pdf->GetX()+92.5,$pdf->GetY(), 87.4, 35);
$pdf->Ln();
$tmpY = $pdf->GetY();
$pdf->Image("tmp_imgs/visitors_chart.png",17,null,85);
$pdf->Image($url_map,108.5,$tmpY-4,85,33);
$pdf->Ln();
$pdf->SetTextColor(0,0,0);
$pdf->SetX(17);
$pdf->Cell(20,5, number_format($totalvisitors)." Visitors",0,1,"L");
$pdf->Ln();
$pdf->SetTextColor(255,255,255);
$pdf->SetFont('','B',10);
$pdf->Cell(87.5,5, "Traffic Sources Overview",0,0,"L",true);
$pdf->SetX(107.5);
$pdf->Cell(87.5,5, "Content Overview",0,1,"L",true);
$tmpY = $pdf->GetY();
$pdf->SetDrawColor(188,188,188);
$pdf->Rect($pdf->GetX(),$pdf->GetY(), 87.4, 35);
$pdf->Rect($pdf->GetX()+92.5,$pdf->GetY(), 87.4, 35);
$pdf->Ln();
$pdf->Image("tmp_imgs/traffic_chart.png",17,null,85);
$pdf->SetFillColor(225,225,225);
$pdf->SetY($tmpY);
$pdf->SetX(107.5);
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('','',6);
$pdf->Cell(50,5, " ",1,0,"L",true);
$pdf->Cell(19.5,5, " ",1,0,"R",true);
$pdf->Cell(18,5, " ",1,0,"R",true);
$pdf->SetFillColor(255,255,255);
$pdf->Rect(107.5,$tmpY, 49.8, 2.5, "F");
$pdf->Rect(157.8,$tmpY, 19.1, 2.5, "F");
$pdf->Rect(177.3,$tmpY, 17.6, 2.5, "F");
$pdf->SetX(107.5);
$pdf->Cell(50,5, "Pages",0,0,"L");
$pdf->Cell(19.5,5, "Pageviews ",0,0,"R");
$pdf->Cell(18,5, "% Pageviews ",0,1,"R");
foreach($values as &$value){
	$pdf->SetX(107.5);
	$pdf->Cell(50,5, shorten($value['Page'],45),"B",0,"L");
	$pdf->Cell(19.5,5, $value['Pageviews'],"B",0,"R");
	$pdf->Cell(18,5, $value['Pageviews_percent'],"B",1,"R");
}
$pdf->Output('tmp_pdf/Dashboard_'.date('dmY').'.pdf','F');

Page 1, 2, 3, 4, 5

Links:

Red5 Analytics Demo

Ext 2.2.1 API

Ext JS Home

Ext JS Forums

Google Gears

Google Analytics Data Export API

Google Analytics API PHP Class

Open Flash Chart 2

Google Visualization API

Google Chart API

FPDF Library

Red Analytics Demo

FPDF Library - PDF Generator

Links:

Bookmark with: