GA.php 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  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. array_push($dimensions,$segmentDimensions);
  68. // Create Dimension Filter.
  69. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
  70. $dimensionFilter->setDimensionName("ga:pagePath");
  71. $dimensionFilter->setOperator("PARTIAL");
  72. $dimensionFilter->setExpressions(array("fbclid"));
  73. // Create Segment Filter Clause.
  74. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
  75. $segmentFilterClause->setDimensionFilter($dimensionFilter);
  76. // Create the Or Filters for Segment.
  77. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
  78. $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
  79. // Create the Simple Segment.
  80. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
  81. $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
  82. // Create the Segment Filters.
  83. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
  84. $segmentFilter->setSimpleSegment($simpleSegment);
  85. $segmentFilter->setNot(True);
  86. $segmentFilter2=$this->segmentFilters();
  87. // Create the Segment Definition.
  88. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
  89. $segmentDefinition->setSegmentFilters(array($segmentFilter,$segmentFilter2));
  90. $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
  91. $dynamicSegment->setSessionSegment($segmentDefinition);
  92. $dynamicSegment->setName('pagePath');
  93. $segment = new \Google_Service_AnalyticsReporting_Segment();
  94. $segment->setDynamicSegment($dynamicSegment);
  95. $orderBy=new \Google_Service_AnalyticsReporting_OrderBy;
  96. $orderBy->setFieldName('ga:pageviews');
  97. $orderBy->setSortOrder("DESCENDING");
  98. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  99. $request->setViewId($VIEW_ID);
  100. $request->setDateRanges($dateRange);
  101. $request->setMetrics($metrics);
  102. $request->setDimensions($dimensions);
  103. $request->setSegments(array($segment));
  104. $request->setOrderBys($orderBy);
  105. // $request->setMetricFilterClauses($MetricFilterClause);
  106. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  107. $body->setReportRequests( array( $request) );
  108. $reports= $analytics->reports->batchGet( $body );
  109. $result=$this->getResults($reports);
  110. echo "<pre>";
  111. print_r($result);exit;
  112. }
  113. function segmentFilters(){
  114. $metricFilter = new \Google_Service_AnalyticsReporting_SegmentMetricFilter();
  115. $metricFilter->setMetricName("ga:pageviews");
  116. $metricFilter->setOperator("GREATER_THAN");
  117. $metricFilter->setComparisonValue("1");
  118. // Create Segment Filter Clause.
  119. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
  120. $segmentFilterClause->setMetricFilter($metricFilter);
  121. // Create the Or Filters for Segment.
  122. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
  123. $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
  124. // Create the Simple Segment.
  125. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
  126. $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
  127. // Create the Segment Filters.
  128. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
  129. $segmentFilter->setSimpleSegment($simpleSegment);
  130. return $segmentFilter;
  131. }
  132. /**
  133. * Queries the Analytics Reporting API V4.
  134. *
  135. * @param service An authorized Analytics Reporting API V4 service object.
  136. * @return The Analytics Reporting API V4 response.
  137. */
  138. function getContentReport($VIEW_ID,$analytics,$metricArr,$dimensionArr) {
  139. }
  140. function getResults($reports) {
  141. $data=[];
  142. for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
  143. $item=[];
  144. $report = $reports[ $reportIndex ];
  145. $header = $report->getColumnHeader();
  146. $dimensionHeaders = $header->getDimensions();
  147. $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  148. $rows = $report->getData()->getRows();
  149. for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  150. $row = $rows[ $rowIndex ];
  151. $dimensions = $row->getDimensions();
  152. $metrics = $row->getMetrics();
  153. if($dimensionHeaders&&$dimensions){
  154. for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  155. $header = $dimensionHeaders[$i];
  156. $header=str_replace('ga:','',$header);
  157. $item[$header]=$dimensions[$i];
  158. // print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r");
  159. // echo"<br/>";
  160. }
  161. // $date=$dimensions[0];
  162. // $date=date('Y-m-d',strtotime($date));
  163. }else{
  164. continue;
  165. }
  166. if($metricHeaders&&$metrics){
  167. for ($j = 0; $j < count($metrics); $j++) {
  168. $values = $metrics[$j]->getValues();
  169. for ($k = 0; $k < count($values); $k++) {
  170. $entry = $metricHeaders[$k];
  171. $item[$entry->getName()]=$values[$k];
  172. // print($entry->getName() . ": " . $values[$k] . "\n\r");
  173. // echo"<br/>";
  174. }
  175. }
  176. }
  177. $data[]=$item;
  178. }
  179. }
  180. return $data;
  181. }
  182. }