setApplicationName("Hello Analytics Reporting");
$client->setAuthConfig($KEY_FILE_LOCATION);
$client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
$analytics = new \Google_Service_AnalyticsReporting($client);
return $analytics;
}
public static function getInstance($dp){
if(isset(self::$insances[$dp])){
return self::$insances[$dp];
}else{
self::$insances[$dp]=self::initializeAnalytics($dp);
return self::$insances[$dp];
}
}
private function getViewId($dp){
return "155703065";
}
public function contentpages($dp,$start_at,$end_at){
$analytics=self::getInstance($dp);
$metricArr=[
'pageviews'=>"ga:pageviews",
'uniquePageviews'=>"ga:uniquePageviews",
'avgTimeOnPage'=>"ga:avgTimeOnPage",
'entrances'=>"ga:entrances",
'bounceRate'=>"ga:bounceRate",
'exitRate'=>"ga:exitRate",
'pageValue'=>"ga:pageValue",
];
$dimensionArr=[
'pagePath'=>'ga:pagePath',
'date'=>"ga:date",
];
$VIEW_ID = $this->getViewId($dp);//
$dateRange = new \Google_Service_AnalyticsReporting_DateRange();
$dateRange->setStartDate($start_at);
$dateRange->setEndDate($end_at);
$metrics=[];
$dimensions=[];
foreach($metricArr as $k=>$v){
$Metric = new \Google_Service_AnalyticsReporting_Metric();
$Metric->setExpression($v);
$Metric->setAlias($k);
array_push($metrics,$Metric);
}
foreach($dimensionArr as $k=>$v){
$Dimension = new \Google_Service_AnalyticsReporting_Dimension();
$Dimension->setName($v);
array_push($dimensions,$Dimension);
}
$pageviewsFilter = new \Google_Service_AnalyticsReporting_MetricFilter();
$pageviewsFilter->setMetricName("ga:pageviews");
$pageviewsFilter->setOperator("GREATER_THAN");
$pageviewsFilter->setComparisonValue("1");
$MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
$MetricFilterClause->setFilters(array($pageviewsFilter));
$segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
$segmentDimensions->setName("ga:segment");
array_push($dimensions,$segmentDimensions);
// Create Dimension Filter.
$dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
$dimensionFilter->setDimensionName("ga:pagePath");
$dimensionFilter->setOperator("REGEXP");
$dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));
// Create Segment Filter Clause.
$segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
$segmentFilterClause->setDimensionFilter($dimensionFilter);
// Create the Or Filters for Segment.
$orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
$orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
// Create the Simple Segment.
$simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
$simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
// Create the Segment Filters.
$segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
$segmentFilter->setSimpleSegment($simpleSegment);
$segmentFilter->setNot(True);
// Create the Segment Definition.
$segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
$segmentDefinition->setSegmentFilters(array($segmentFilter));
$dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
$dynamicSegment->setSessionSegment($segmentDefinition);
$dynamicSegment->setName('pagePath');
$segment = new \Google_Service_AnalyticsReporting_Segment();
$segment->setDynamicSegment($dynamicSegment);
$orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
$orderBy->setFieldName('ga:pageviews');
$orderBy->setSortOrder("DESCENDING");
$request = new \Google_Service_AnalyticsReporting_ReportRequest();
$request->setViewId($VIEW_ID);
$request->setDateRanges($dateRange);
$request->setMetrics($metrics);
$request->setDimensions($dimensions);
$request->setSegments(array($segment));
$request->setOrderBys($orderBy);
$request->setPageSize(5000);
$request->setMetricFilterClauses($MetricFilterClause);
$body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
$body->setReportRequests( array( $request) );
$reports= $analytics->reports->batchGet( $body );
$result=$this->getResults($reports);
return $result;
}
public function trafficsource($dp,$start_at,$end_at){
$analytics=self::getInstance($dp);
$metricArr=[
'users'=>"ga:users",
'newUsers'=>"ga:newUsers",
'sessions'=>"ga:sessions",
'bounceRate'=>"ga:bounceRate",
'pageviewsPerSession'=>"ga:pageviewsPerSession",
'avgSessionDuration'=>"ga:avgSessionDuration",
'transactionsPerVisit'=>"ga:transactionsPerVisit",
'transactions'=>"ga:transactions",
'transactionRevenue'=>"ga:transactionRevenue",
];
$dimensionArr=[
'pagePath'=>'ga:source',
'date'=>"ga:date",
'channelGrouping'=>"ga:channelGrouping",
'landingPagePath'=>"ga:landingPagePath",
'keyword'=>"ga:keyword",
'socialNetwork'=>"ga:socialNetwork",
];
$VIEW_ID = $this->getViewId($dp);//
$dateRange = new \Google_Service_AnalyticsReporting_DateRange();
$dateRange->setStartDate($start_at);
$dateRange->setEndDate($end_at);
$metrics=[];
$dimensions=[];
foreach($metricArr as $k=>$v){
$Metric = new \Google_Service_AnalyticsReporting_Metric();
$Metric->setExpression($v);
$Metric->setAlias($k);
array_push($metrics,$Metric);
}
foreach($dimensionArr as $k=>$v){
$Dimension = new \Google_Service_AnalyticsReporting_Dimension();
$Dimension->setName($v);
array_push($dimensions,$Dimension);
}
$segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
$segmentDimensions->setName("ga:segment");
array_push($dimensions,$segmentDimensions);
// Create Dimension Filter.
$dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
$dimensionFilter->setDimensionName("ga:source");
$dimensionFilter->setOperator("REGEXP");
$dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));
// Create Segment Filter Clause.
$segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
$segmentFilterClause->setDimensionFilter($dimensionFilter);
// Create the Or Filters for Segment.
$orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
$orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
// Create the Simple Segment.
$simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
$simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
// Create the Segment Filters.
$segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
$segmentFilter->setSimpleSegment($simpleSegment);
$segmentFilter->setNot(True);
// Create the Segment Definition.
$segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
$segmentDefinition->setSegmentFilters(array($segmentFilter));
$dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
$dynamicSegment->setSessionSegment($segmentDefinition);
$dynamicSegment->setName('trafficsources filter');
$segment = new \Google_Service_AnalyticsReporting_Segment();
$segment->setDynamicSegment($dynamicSegment);
$request = new \Google_Service_AnalyticsReporting_ReportRequest();
$request->setViewId($VIEW_ID);
$request->setDateRanges($dateRange);
$request->setMetrics($metrics);
$request->setDimensions($dimensions);
$request->setSegments(array($segment));
$request->setPageSize(5000);
// $request->setOrderBys($orderBy);
// $request->setMetricFilterClauses($MetricFilterClause);
$body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
$body->setReportRequests( array( $request) );
$reports= $analytics->reports->batchGet( $body );
$result=$this->getResults($reports);
return $result;
}
public function visitors_geo($dp,$start_at,$end_at){
$analytics=self::getInstance($dp);
$dimensionArr=[
'country'=>'ga:country',
'region'=>"ga:region",
];
$metricArr=[
'transactions'=>"ga:transactions",
'transactionRevenue'=>"ga:transactionRevenue",
];
$VIEW_ID = $this->getViewId($dp);//
$dateRange = new \Google_Service_AnalyticsReporting_DateRange();
$dateRange->setStartDate($start_at);
$dateRange->setEndDate($end_at);
$metrics=[];
$dimensions=[];
foreach($metricArr as $k=>$v){
$Metric = new \Google_Service_AnalyticsReporting_Metric();
$Metric->setExpression($v);
$Metric->setAlias($k);
array_push($metrics,$Metric);
}
foreach($dimensionArr as $k=>$v){
$Dimension = new \Google_Service_AnalyticsReporting_Dimension();
$Dimension->setName($v);
array_push($dimensions,$Dimension);
}
$orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
$orderBy->setFieldName('ga:transactions');
$orderBy->setSortOrder("DESCENDING");
$request = new \Google_Service_AnalyticsReporting_ReportRequest();
$request->setViewId($VIEW_ID);
$request->setDateRanges($dateRange);
$request->setMetrics($metrics);
$request->setDimensions($dimensions);
$request->setOrderBys($orderBy);
$body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
$body->setReportRequests( array( $request) );
$reports= $analytics->reports->batchGet( $body );
$result=$this->getResults($reports);
return $result;
}
public function productSku($dp,$start_at,$end_at){
$analytics=self::getInstance($dp);
$dimensionArr=[
'productSku'=>'ga:productSku',
];
$metricArr=[
'itemRevenue'=>"ga:itemRevenue",
'uniquePurchases'=>"ga:uniquePurchases",
'itemQuantity'=>"ga:itemQuantity",
];
$VIEW_ID = $this->getViewId($dp);//
$dateRange = new \Google_Service_AnalyticsReporting_DateRange();
$dateRange->setStartDate($start_at);
$dateRange->setEndDate($end_at);
$metrics=[];
$dimensions=[];
foreach($metricArr as $k=>$v){
$Metric = new \Google_Service_AnalyticsReporting_Metric();
$Metric->setExpression($v);
$Metric->setAlias($k);
array_push($metrics,$Metric);
}
foreach($dimensionArr as $k=>$v){
$Dimension = new \Google_Service_AnalyticsReporting_Dimension();
$Dimension->setName($v);
array_push($dimensions,$Dimension);
}
$orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
$orderBy->setFieldName('ga:itemQuantity');
$orderBy->setSortOrder("DESCENDING");
$request = new \Google_Service_AnalyticsReporting_ReportRequest();
$request->setViewId($VIEW_ID);
$request->setDateRanges($dateRange);
$request->setMetrics($metrics);
$request->setDimensions($dimensions);
$request->setOrderBys($orderBy);
$body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
$body->setReportRequests( array( $request) );
$reports= $analytics->reports->batchGet( $body );
$result=$this->getResults($reports);
return $result;
}
/**
* Queries the Analytics Reporting API V4.
*
* @param service An authorized Analytics Reporting API V4 service object.
* @return The Analytics Reporting API V4 response.
*/
function getContentReport($VIEW_ID,$analytics,$metricArr,$dimensionArr) {
}
function getResults($reports) {
$data=[];
for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
$item=[];
$report = $reports[ $reportIndex ];
$header = $report->getColumnHeader();
$dimensionHeaders = $header->getDimensions();
$metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
$rows = $report->getData()->getRows();
for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
$row = $rows[ $rowIndex ];
$dimensions = $row->getDimensions();
$metrics = $row->getMetrics();
if($dimensionHeaders&&$dimensions){
for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
$header = $dimensionHeaders[$i];
$header=str_replace('ga:','',$header);
$item[$header]=$dimensions[$i];
// print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r");
// echo"
";
}
// $date=$dimensions[0];
// $date=date('Y-m-d',strtotime($date));
}else{
continue;
}
if($metricHeaders&&$metrics){
for ($j = 0; $j < count($metrics); $j++) {
$values = $metrics[$j]->getValues();
for ($k = 0; $k < count($values); $k++) {
$entry = $metricHeaders[$k];
$item[$entry->getName()]=$values[$k];
// print($entry->getName() . ": " . $values[$k] . "\n\r");
// echo"
";
}
}
}
$data[]=$item;
}
}
return $data;
}
}