123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259 |
- <?php
- namespace app\lib;
- class GA{
- private static $insances=[];
- private static function initializeAnalytics($dp){
- $KEY_FILE_LOCATION = BASE_DIR . 'config/savvy-theory-278005-43552bf9fe94.json';
- $client = new \Google_Client();
- $client->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){
- $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();
- $start_at=date('Y-m-d',time()-24*3600);
- $end_at=date('Y-m-d',time()-24*3600);
- $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->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(){
- $analytics=self::getInstance($dp);
- $metricArr=[
- 'users'=>"ga:users",
- 'uniquePageviews'=>"ga:newUsers",
- 'sessions'=>"ga:sessions",
- // 'entrances'=>"ga:entrances",
- // 'bounceRate'=>"ga:bounceRate",
- // 'exitRate'=>"ga:exitRate",
- // 'pageValue'=>"ga:pageValue",
- ];
- $dimensionArr=[
- 'pagePath'=>'ga:source',
- 'date'=>"ga:date",
- 'acquisitionTrafficChannel'=>"ga:acquisitionTrafficChannel",
- 'landingPagePath'=>"ga:landingPagePath",
- 'keyword'=>"ga:keyword",
- 'socialNetwork'=>"ga:socialNetwork",
- ];
- $VIEW_ID = $this->getViewId($dp);//
- $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
- $start_at=date('Y-m-d',time()-24*3600);
- $end_at=date('Y-m-d',time()-24*3600);
- $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);
- }
- $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->setMetricFilterClauses($MetricFilterClause);
-
- $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
- $body->setReportRequests( array( $request) );
- $reports= $analytics->reports->batchGet( $body );
- $result=$this->getResults($reports);
- echo "<pre>";
- print_r($result);exit;
- 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"<br/>";
- }
- // $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"<br/>";
- }
- }
- }
- $data[]=$item;
- }
- }
- return $data;
- }
-
- }
-
|