GA.php 9.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259
  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("REGEXP");
  72. $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));
  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. // Create the Segment Definition.
  87. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
  88. $segmentDefinition->setSegmentFilters(array($segmentFilter));
  89. $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
  90. $dynamicSegment->setSessionSegment($segmentDefinition);
  91. $dynamicSegment->setName('pagePath');
  92. $segment = new \Google_Service_AnalyticsReporting_Segment();
  93. $segment->setDynamicSegment($dynamicSegment);
  94. $orderBy=new \Google_Service_AnalyticsReporting_OrderBy;
  95. $orderBy->setFieldName('ga:pageviews');
  96. $orderBy->setSortOrder("DESCENDING");
  97. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  98. $request->setViewId($VIEW_ID);
  99. $request->setDateRanges($dateRange);
  100. $request->setMetrics($metrics);
  101. $request->setDimensions($dimensions);
  102. $request->setSegments(array($segment));
  103. $request->setOrderBys($orderBy);
  104. $request->setMetricFilterClauses($MetricFilterClause);
  105. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  106. $body->setReportRequests( array( $request) );
  107. $reports= $analytics->reports->batchGet( $body );
  108. $result=$this->getResults($reports);
  109. return $result;
  110. }
  111. public function trafficsource(){
  112. $analytics=self::getInstance($dp);
  113. $metricArr=[
  114. 'users'=>"ga:users",
  115. 'uniquePageviews'=>"ga:newUsers",
  116. 'sessions'=>"ga:sessions",
  117. // 'entrances'=>"ga:entrances",
  118. // 'bounceRate'=>"ga:bounceRate",
  119. // 'exitRate'=>"ga:exitRate",
  120. // 'pageValue'=>"ga:pageValue",
  121. ];
  122. $dimensionArr=[
  123. 'pagePath'=>'ga:source',
  124. 'date'=>"ga:date",
  125. 'acquisitionTrafficChannel'=>"ga:acquisitionTrafficChannel",
  126. 'landingPagePath'=>"ga:landingPagePath",
  127. 'keyword'=>"ga:keyword",
  128. 'socialNetwork'=>"ga:socialNetwork",
  129. ];
  130. $VIEW_ID = $this->getViewId($dp);//
  131. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  132. $start_at=date('Y-m-d',time()-24*3600);
  133. $end_at=date('Y-m-d',time()-24*3600);
  134. $dateRange->setStartDate($start_at);
  135. $dateRange->setEndDate($end_at);
  136. $metrics=[];
  137. $dimensions=[];
  138. foreach($metricArr as $k=>$v){
  139. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  140. $Metric->setExpression($v);
  141. $Metric->setAlias($k);
  142. array_push($metrics,$Metric);
  143. }
  144. foreach($dimensionArr as $k=>$v){
  145. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  146. $Dimension->setName($v);
  147. array_push($dimensions,$Dimension);
  148. }
  149. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  150. $request->setViewId($VIEW_ID);
  151. $request->setDateRanges($dateRange);
  152. $request->setMetrics($metrics);
  153. $request->setDimensions($dimensions);
  154. // $request->setSegments(array($segment));
  155. // $request->setOrderBys($orderBy);
  156. // $request->setMetricFilterClauses($MetricFilterClause);
  157. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  158. $body->setReportRequests( array( $request) );
  159. $reports= $analytics->reports->batchGet( $body );
  160. $result=$this->getResults($reports);
  161. echo "<pre>";
  162. print_r($result);exit;
  163. return $result;
  164. }
  165. /**
  166. * Queries the Analytics Reporting API V4.
  167. *
  168. * @param service An authorized Analytics Reporting API V4 service object.
  169. * @return The Analytics Reporting API V4 response.
  170. */
  171. function getContentReport($VIEW_ID,$analytics,$metricArr,$dimensionArr) {
  172. }
  173. function getResults($reports) {
  174. $data=[];
  175. for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
  176. $item=[];
  177. $report = $reports[ $reportIndex ];
  178. $header = $report->getColumnHeader();
  179. $dimensionHeaders = $header->getDimensions();
  180. $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  181. $rows = $report->getData()->getRows();
  182. for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  183. $row = $rows[ $rowIndex ];
  184. $dimensions = $row->getDimensions();
  185. $metrics = $row->getMetrics();
  186. if($dimensionHeaders&&$dimensions){
  187. for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  188. $header = $dimensionHeaders[$i];
  189. $header=str_replace('ga:','',$header);
  190. $item[$header]=$dimensions[$i];
  191. // print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r");
  192. // echo"<br/>";
  193. }
  194. // $date=$dimensions[0];
  195. // $date=date('Y-m-d',strtotime($date));
  196. }else{
  197. continue;
  198. }
  199. if($metricHeaders&&$metrics){
  200. for ($j = 0; $j < count($metrics); $j++) {
  201. $values = $metrics[$j]->getValues();
  202. for ($k = 0; $k < count($values); $k++) {
  203. $entry = $metricHeaders[$k];
  204. $item[$entry->getName()]=$values[$k];
  205. // print($entry->getName() . ": " . $values[$k] . "\n\r");
  206. // echo"<br/>";
  207. }
  208. }
  209. }
  210. $data[]=$item;
  211. }
  212. }
  213. return $data;
  214. }
  215. }