GA.php 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205
  1. <?php
  2. namespace app\lib;
  3. class GA{
  4. private static $insances=[];
  5. private static function initializeAnalytics($dp){
  6. $KEY_FILE_LOCATION = BASE_DIR . 'config/savvy-theory-278005-43552bf9fe94.json';
  7. $client = new \Google_Client();
  8. $client->setApplicationName("Hello Analytics Reporting");
  9. $client->setAuthConfig($KEY_FILE_LOCATION);
  10. $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
  11. $analytics = new \Google_Service_AnalyticsReporting($client);
  12. return $analytics;
  13. }
  14. public static function getInstance($dp){
  15. if(isset(self::$insances[$dp])){
  16. return self::$insances[$dp];
  17. }else{
  18. self::$insances[$dp]=self::initializeAnalytics($dp);
  19. return self::$insances[$dp];
  20. }
  21. }
  22. private function getViewId($dp){
  23. return "155703065";
  24. }
  25. public function contentpages($dp){
  26. $analytics=self::getInstance($dp);
  27. $metricArr=[
  28. 'pageviews'=>"ga:pageviews",
  29. 'uniquePageviews'=>"ga:uniquePageviews",
  30. 'avgTimeOnPage'=>"ga:avgTimeOnPage",
  31. 'entrances'=>"ga:entrances",
  32. 'bounceRate'=>"ga:bounceRate",
  33. 'exitRate'=>"ga:exitRate",
  34. 'pageValue'=>"ga:pageValue",
  35. ];
  36. $dimensionArr=[
  37. 'pagePath'=>'ga:pagePath',
  38. 'date'=>"ga:date",
  39. ];
  40. $VIEW_ID = $this->getViewId($dp);//
  41. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  42. $start_at=date('Y-m-d',time()-24*3600);
  43. $end_at=date('Y-m-d',time()-24*3600);
  44. $dateRange->setStartDate($start_at);
  45. $dateRange->setEndDate($end_at);
  46. $metrics=[];
  47. $dimensions=[];
  48. foreach($metricArr as $k=>$v){
  49. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  50. $Metric->setExpression($v);
  51. $Metric->setAlias($k);
  52. array_push($metrics,$Metric);
  53. }
  54. foreach($dimensionArr as $k=>$v){
  55. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  56. $Dimension->setName($v);
  57. array_push($dimensions,$Dimension);
  58. }
  59. // $pageviewsFilter = new \Google_Service_AnalyticsReporting_MetricFilter();
  60. // $pageviewsFilter->setMetricName("ga:pageviews");
  61. // $pageviewsFilter->setOperator("GREATER_THAN");
  62. // $pageviewsFilter->setComparisonValue("1");
  63. // $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
  64. // $MetricFilterClause->setFilters(array($pageviewsFilter));
  65. $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
  66. $segmentDimensions->setName("ga:segment");
  67. // Create Dimension Filter.
  68. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
  69. $dimensionFilter->setDimensionName("ga:pagePath");
  70. $dimensionFilter->setOperator("PARTIAL");
  71. $dimensionFilter->setExpressions(array("fbclid"));
  72. // Create Segment Filter Clause.
  73. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
  74. $segmentFilterClause->setDimensionFilter($dimensionFilter);
  75. // Create the Or Filters for Segment.
  76. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
  77. $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
  78. // Create the Simple Segment.
  79. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
  80. $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
  81. // Create the Segment Filters.
  82. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
  83. $segmentFilter->setSimpleSegment($simpleSegment);
  84. $segmentFilter->setNot(True);
  85. // Create the Segment Definition.
  86. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
  87. $segmentDefinition->setSegmentFilters(array($segmentFilter));
  88. $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
  89. $dynamicSegment->setSessionSegment($segmentDefinition);
  90. $dynamicSegment->setName('pagePath');
  91. $segment = new \Google_Service_AnalyticsReporting_Segment();
  92. $segment->setDynamicSegment($dynamicSegment);
  93. $orderBy=new \Google_Service_AnalyticsReporting_OrderBy;
  94. $orderBy->setFieldName('ga:pageviews');
  95. $orderBy->setSortOrder("DESCENDING");
  96. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  97. $request->setViewId($VIEW_ID);
  98. $request->setDateRanges($dateRange);
  99. $request->setMetrics($metrics);
  100. $request->setDimensions($dimensions);
  101. $request->setOrderBys($orderBy);
  102. $request->setMetricFilterClauses($MetricFilterClause);
  103. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  104. $body->setReportRequests( array( $request) );
  105. $reports= $analytics->reports->batchGet( $body );
  106. $result=$this->getResults($reports);
  107. echo "<pre>";
  108. print_r($result);exit;
  109. }
  110. /**
  111. * Queries the Analytics Reporting API V4.
  112. *
  113. * @param service An authorized Analytics Reporting API V4 service object.
  114. * @return The Analytics Reporting API V4 response.
  115. */
  116. function getContentReport($VIEW_ID,$analytics,$metricArr,$dimensionArr) {
  117. }
  118. function getResults($reports) {
  119. $data=[];
  120. for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
  121. $item=[];
  122. $report = $reports[ $reportIndex ];
  123. $header = $report->getColumnHeader();
  124. $dimensionHeaders = $header->getDimensions();
  125. $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  126. $rows = $report->getData()->getRows();
  127. for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  128. $row = $rows[ $rowIndex ];
  129. $dimensions = $row->getDimensions();
  130. $metrics = $row->getMetrics();
  131. if($dimensionHeaders&&$dimensions){
  132. for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  133. $header = $dimensionHeaders[$i];
  134. $header=str_replace('ga:','',$header);
  135. $item[$header]=$dimensions[$i];
  136. // print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r");
  137. // echo"<br/>";
  138. }
  139. // $date=$dimensions[0];
  140. // $date=date('Y-m-d',strtotime($date));
  141. }else{
  142. continue;
  143. }
  144. if($metricHeaders&&$metrics){
  145. for ($j = 0; $j < count($metrics); $j++) {
  146. $values = $metrics[$j]->getValues();
  147. for ($k = 0; $k < count($values); $k++) {
  148. $entry = $metricHeaders[$k];
  149. $item[$entry->getName()]=$values[$k];
  150. // print($entry->getName() . ": " . $values[$k] . "\n\r");
  151. // echo"<br/>";
  152. }
  153. }
  154. }
  155. $data[]=$item;
  156. }
  157. }
  158. return $data;
  159. }
  160. }