GA.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305
  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. 'bounceRate'=>"ga:bounceRate",
  118. 'avgPageviews'=>"ga:avgPageviews",
  119. 'avgSessionTime'=>"ga:avgSessionTime",
  120. 'transactionsPerVisit'=>"ga:transactionsPerVisit",
  121. 'transactions'=>"ga:transactions",
  122. 'transactionRevenue'=>"ga:transactionRevenue",
  123. ];
  124. $dimensionArr=[
  125. 'pagePath'=>'ga:source',
  126. 'date'=>"ga:date",
  127. 'channelGrouping'=>"ga:channelGrouping",
  128. 'landingPagePath'=>"ga:landingPagePath",
  129. 'keyword'=>"ga:keyword",
  130. 'socialNetwork'=>"ga:socialNetwork",
  131. ];
  132. $VIEW_ID = $this->getViewId($dp);//
  133. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  134. $start_at=date('Y-m-d',time()-24*3600);
  135. $end_at=date('Y-m-d',time()-24*3600);
  136. $dateRange->setStartDate($start_at);
  137. $dateRange->setEndDate($end_at);
  138. $metrics=[];
  139. $dimensions=[];
  140. foreach($metricArr as $k=>$v){
  141. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  142. $Metric->setExpression($v);
  143. $Metric->setAlias($k);
  144. array_push($metrics,$Metric);
  145. }
  146. foreach($dimensionArr as $k=>$v){
  147. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  148. $Dimension->setName($v);
  149. array_push($dimensions,$Dimension);
  150. }
  151. $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
  152. $segmentDimensions->setName("ga:segment");
  153. array_push($dimensions,$segmentDimensions);
  154. // Create Dimension Filter.
  155. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
  156. $dimensionFilter->setDimensionName("ga:source");
  157. $dimensionFilter->setOperator("REGEXP");
  158. $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));
  159. // Create Segment Filter Clause.
  160. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
  161. $segmentFilterClause->setDimensionFilter($dimensionFilter);
  162. // Create the Or Filters for Segment.
  163. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
  164. $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
  165. // Create the Simple Segment.
  166. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
  167. $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
  168. // Create the Segment Filters.
  169. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
  170. $segmentFilter->setSimpleSegment($simpleSegment);
  171. $segmentFilter->setNot(True);
  172. // Create the Segment Definition.
  173. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
  174. $segmentDefinition->setSegmentFilters(array($segmentFilter));
  175. $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
  176. $dynamicSegment->setSessionSegment($segmentDefinition);
  177. $dynamicSegment->setName('trafficsources filter');
  178. $segment = new \Google_Service_AnalyticsReporting_Segment();
  179. $segment->setDynamicSegment($dynamicSegment);
  180. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  181. $request->setViewId($VIEW_ID);
  182. $request->setDateRanges($dateRange);
  183. $request->setMetrics($metrics);
  184. $request->setDimensions($dimensions);
  185. $request->setSegments(array($segment));
  186. // $request->setOrderBys($orderBy);
  187. // $request->setMetricFilterClauses($MetricFilterClause);
  188. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  189. $body->setReportRequests( array( $request) );
  190. $reports= $analytics->reports->batchGet( $body );
  191. $result=$this->getResults($reports);
  192. echo "<pre>";
  193. print_r($result);exit;
  194. return $result;
  195. }
  196. /**
  197. * Queries the Analytics Reporting API V4.
  198. *
  199. * @param service An authorized Analytics Reporting API V4 service object.
  200. * @return The Analytics Reporting API V4 response.
  201. */
  202. function getContentReport($VIEW_ID,$analytics,$metricArr,$dimensionArr) {
  203. }
  204. function getResults($reports) {
  205. $data=[];
  206. for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
  207. $item=[];
  208. $report = $reports[ $reportIndex ];
  209. $header = $report->getColumnHeader();
  210. $dimensionHeaders = $header->getDimensions();
  211. $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  212. $rows = $report->getData()->getRows();
  213. for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  214. $row = $rows[ $rowIndex ];
  215. $dimensions = $row->getDimensions();
  216. $metrics = $row->getMetrics();
  217. if($dimensionHeaders&&$dimensions){
  218. for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  219. $header = $dimensionHeaders[$i];
  220. $header=str_replace('ga:','',$header);
  221. $item[$header]=$dimensions[$i];
  222. // print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r");
  223. // echo"<br/>";
  224. }
  225. // $date=$dimensions[0];
  226. // $date=date('Y-m-d',strtotime($date));
  227. }else{
  228. continue;
  229. }
  230. if($metricHeaders&&$metrics){
  231. for ($j = 0; $j < count($metrics); $j++) {
  232. $values = $metrics[$j]->getValues();
  233. for ($k = 0; $k < count($values); $k++) {
  234. $entry = $metricHeaders[$k];
  235. $item[$entry->getName()]=$values[$k];
  236. // print($entry->getName() . ": " . $values[$k] . "\n\r");
  237. // echo"<br/>";
  238. }
  239. }
  240. }
  241. $data[]=$item;
  242. }
  243. }
  244. return $data;
  245. }
  246. }