GA.php 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981
  1. <?php
  2. namespace app\lib;
  3. class GA{
  4. const SUPERNOVA_KEY_PATH= BASE_DIR . 'config/supernova.json';
  5. const ALIPEARL_KEY_PATH= BASE_DIR . 'config/alipearl.json';
  6. const WIGGINS_KEY_PATH= BASE_DIR . 'config/wiggins.json';
  7. const YOLISSA_KEY_PATH= BASE_DIR . 'config/yolissa.json';
  8. const ASTERIA_KEY_PATH= BASE_DIR . 'config/asteria.json';
  9. const WESTKISS_KEY_PATH= BASE_DIR . 'config/westkiss.json';
  10. private static $insances=[];
  11. private static function initializeAnalytics($dp){
  12. $KEY_FILE_LOCATION = self::getPath($dp);
  13. if(!$KEY_FILE_LOCATION){
  14. throw new \Exception("store 配置不存在");
  15. }
  16. $client = new \Google_Client();
  17. $client->setApplicationName("Hello Analytics Reporting");
  18. $client->setAuthConfig($KEY_FILE_LOCATION);
  19. $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
  20. $analytics = new \Google_Service_AnalyticsReporting($client);
  21. return $analytics;
  22. }
  23. public static function getInstance($dp){
  24. if(isset(self::$insances[$dp])){
  25. return self::$insances[$dp];
  26. }else{
  27. self::$insances[$dp]=self::initializeAnalytics($dp);
  28. return self::$insances[$dp];
  29. }
  30. }
  31. private function getViewId($dp){
  32. $VIEW_ID="";
  33. switch($dp){
  34. case "1"://supernovahair
  35. $VIEW_ID="155703065";
  36. break;
  37. case "2"://asteriahair
  38. $VIEW_ID="162723112";
  39. break;
  40. case "3"://alipearlhair
  41. $VIEW_ID="148377136";
  42. break;
  43. case "4"://alipearlhair
  44. $VIEW_ID="152302477";
  45. break;
  46. case "5"://yolissahair
  47. $VIEW_ID="157127813";
  48. break;
  49. case "6"://wiggins
  50. $VIEW_ID="154631720";
  51. break;
  52. }
  53. return $VIEW_ID;
  54. }
  55. public static function getPath($dp){
  56. $path="";
  57. switch($dp){
  58. case "1"://supernovahair
  59. $path=self::SUPERNOVA_KEY_PATH;
  60. break;
  61. case "2"://asteriahair
  62. $path=self::ASTERIA_KEY_PATH;
  63. break;
  64. case "3"://alipearlhair
  65. $path=self::ALIPEARL_KEY_PATH;
  66. break;
  67. case "4"://westkiss
  68. $path=self::WESTKISS_KEY_PATH;
  69. break;
  70. case "5"://yolissahair
  71. $path=self::YOLISSA_KEY_PATH;
  72. break;
  73. case "6"://alipearlhair
  74. $path=self::WIGGINS_KEY_PATH;
  75. break;
  76. }
  77. return $path;
  78. }
  79. /*进一步封装
  80. *$config=[
  81. 'dp'=>'',
  82. 'metricArr'=[],
  83. 'dimensionArr'=[],
  84. 'date'=[start_at,end_at]
  85. 'SegmentDimensionFilters'=>[[name,operate,expression]]
  86. 'oderBy'=>[name,order]
  87. ]
  88. *
  89. *
  90. *
  91. */
  92. public function getData($config){
  93. $dp=$config['dp']??"";
  94. if(!$dp|$date||empty($config['metricArr'])){
  95. return false;
  96. }
  97. $metricArr=$config['metricArr'];
  98. $dimensionArr=$config['dimensionArr']??[];
  99. $analytics=self::getInstance($dp);
  100. $VIEW_ID = $this->getViewId($dp);//
  101. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  102. $request->setViewId($VIEW_ID);
  103. $metrics=[];
  104. $dimensions=[];
  105. foreach($metricArr as $k=>$v){
  106. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  107. $Metric->setExpression($v);
  108. $Metric->setAlias($k);
  109. array_push($metrics,$Metric);
  110. }
  111. foreach($dimensionArr as $k=>$v){
  112. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  113. $Dimension->setName($v);
  114. array_push($dimensions,$Dimension);
  115. }
  116. $request->setMetrics($metrics);
  117. $request->setDimensions($dimensions);
  118. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  119. $dateRange->setStartDate($date['start_at']);
  120. $dateRange->setEndDate($date['end_at']);
  121. $request->setDateRanges($dateRange);
  122. $segment=[];
  123. if(isset($config['SegmentDimensionFilters'])&&!empty($config['SegmentDimensionFilters'])){
  124. foreach($config['SegmentDimensionFilters'] as $filter){
  125. $segment[]=$this->setSegmentDimensionFilter($filter);
  126. }
  127. }
  128. if(isset($config['SegmentMetricFilters'])&&!empty($config['SegmentMetricFilters'])){
  129. foreach($config['SegmentMetricFilters'] as $filter){
  130. $segment[]=$this->setSegmentMetricFilters($filter);
  131. }
  132. }
  133. if(!empty($segment)){
  134. $request->setSegments(array($segment));
  135. }
  136. if(isset($config['orderBy'])&&!empty($config['orderBy'])){
  137. $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
  138. $orderBy->setFieldName($config['orderBy']['name']);
  139. $orderBy->setSortOrder($config['orderBy']['order']);
  140. $request->setOrderBys($orderBy);
  141. }
  142. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  143. $body->setReportRequests( array( $request) );
  144. $reports= $analytics->reports->batchGet( $body );
  145. $result=$this->getResults($reports);
  146. return $result;
  147. }
  148. private function setSegmentDimensionFilter($param){
  149. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
  150. $dimensionFilter->setDimensionName($param['name']);
  151. $dimensionFilter->setOperator($param['operate']);
  152. $dimensionFilter->setExpressions($param['expression']);
  153. // Create Segment Filter Clause.
  154. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
  155. $segmentFilterClause->setDimensionFilter($dimensionFilter);
  156. // Create the Or Filters for Segment.
  157. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
  158. $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
  159. // Create the Simple Segment.
  160. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
  161. $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
  162. // Create the Segment Filters.
  163. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
  164. $segmentFilter->setSimpleSegment($simpleSegment);
  165. $segmentFilter->setNot(True);
  166. // Create the Segment Definition.
  167. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
  168. $segmentDefinition->setSegmentFilters(array($segmentFilter));
  169. $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
  170. $dynamicSegment->setSessionSegment($segmentDefinition);
  171. $dynamicSegment->setName($param['name']);
  172. $segment = new \Google_Service_AnalyticsReporting_Segment();
  173. $segment->setDynamicSegment($dynamicSegment);
  174. return $segment;
  175. }
  176. public function contentpages($dp,$start_at,$end_at){
  177. $analytics=self::getInstance($dp);
  178. $metricArr=[
  179. 'pageviews'=>"ga:pageviews",
  180. 'uniquePageviews'=>"ga:uniquePageviews",
  181. 'avgTimeOnPage'=>"ga:avgTimeOnPage",
  182. 'entrances'=>"ga:entrances",
  183. 'bounceRate'=>"ga:bounceRate",
  184. 'exitRate'=>"ga:exitRate",
  185. 'pageValue'=>"ga:pageValue",
  186. ];
  187. $dimensionArr=[
  188. 'pagePath'=>'ga:pagePath',
  189. 'date'=>"ga:date",
  190. ];
  191. $VIEW_ID = $this->getViewId($dp);//
  192. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  193. $dateRange->setStartDate($start_at);
  194. $dateRange->setEndDate($end_at);
  195. $metrics=[];
  196. $dimensions=[];
  197. foreach($metricArr as $k=>$v){
  198. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  199. $Metric->setExpression($v);
  200. $Metric->setAlias($k);
  201. array_push($metrics,$Metric);
  202. }
  203. foreach($dimensionArr as $k=>$v){
  204. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  205. $Dimension->setName($v);
  206. array_push($dimensions,$Dimension);
  207. }
  208. $pageviewsFilter = new \Google_Service_AnalyticsReporting_MetricFilter();
  209. $pageviewsFilter->setMetricName("ga:pageviews");
  210. $pageviewsFilter->setOperator("GREATER_THAN");
  211. $pageviewsFilter->setComparisonValue("1");
  212. $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
  213. $MetricFilterClause->setFilters(array($pageviewsFilter));
  214. $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
  215. $segmentDimensions->setName("ga:segment");
  216. array_push($dimensions,$segmentDimensions);
  217. // Create Dimension Filter.
  218. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
  219. $dimensionFilter->setDimensionName("ga:pagePath");
  220. $dimensionFilter->setOperator("REGEXP");
  221. $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));
  222. // Create Segment Filter Clause.
  223. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
  224. $segmentFilterClause->setDimensionFilter($dimensionFilter);
  225. // Create the Or Filters for Segment.
  226. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
  227. $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
  228. // Create the Simple Segment.
  229. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
  230. $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
  231. // Create the Segment Filters.
  232. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
  233. $segmentFilter->setSimpleSegment($simpleSegment);
  234. $segmentFilter->setNot(True);
  235. // Create the Segment Definition.
  236. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
  237. $segmentDefinition->setSegmentFilters(array($segmentFilter));
  238. $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
  239. $dynamicSegment->setSessionSegment($segmentDefinition);
  240. $dynamicSegment->setName('pagePath');
  241. $segment = new \Google_Service_AnalyticsReporting_Segment();
  242. $segment->setDynamicSegment($dynamicSegment);
  243. $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
  244. $orderBy->setFieldName('ga:pageviews');
  245. $orderBy->setSortOrder("DESCENDING");
  246. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  247. $request->setViewId($VIEW_ID);
  248. $request->setDateRanges($dateRange);
  249. $request->setMetrics($metrics);
  250. $request->setDimensions($dimensions);
  251. $request->setSegments(array($segment));
  252. $request->setOrderBys($orderBy);
  253. $request->setPageSize(5000);
  254. $request->setMetricFilterClauses($MetricFilterClause);
  255. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  256. $body->setReportRequests( array( $request) );
  257. $reports= $analytics->reports->batchGet( $body );
  258. $result=$this->getResults($reports);
  259. return $result;
  260. }
  261. public function trafficsource($dp,$start_at,$end_at){
  262. $analytics=self::getInstance($dp);
  263. $metricArr=[
  264. 'users'=>"ga:users",
  265. 'newUsers'=>"ga:newUsers",
  266. 'sessions'=>"ga:sessions",
  267. 'bounceRate'=>"ga:bounceRate",
  268. 'pageviewsPerSession'=>"ga:pageviewsPerSession",
  269. 'avgSessionDuration'=>"ga:avgSessionDuration",
  270. 'transactionsPerVisit'=>"ga:transactionsPerVisit",
  271. 'transactions'=>"ga:transactions",
  272. 'transactionRevenue'=>"ga:transactionRevenue",
  273. ];
  274. $dimensionArr=[
  275. 'pagePath'=>'ga:source',
  276. 'date'=>"ga:date",
  277. 'channelGrouping'=>"ga:channelGrouping",
  278. 'landingPagePath'=>"ga:landingPagePath",
  279. 'keyword'=>"ga:keyword",
  280. 'socialNetwork'=>"ga:socialNetwork",
  281. ];
  282. $VIEW_ID = $this->getViewId($dp);//
  283. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  284. $dateRange->setStartDate($start_at);
  285. $dateRange->setEndDate($end_at);
  286. $metrics=[];
  287. $dimensions=[];
  288. foreach($metricArr as $k=>$v){
  289. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  290. $Metric->setExpression($v);
  291. $Metric->setAlias($k);
  292. array_push($metrics,$Metric);
  293. }
  294. foreach($dimensionArr as $k=>$v){
  295. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  296. $Dimension->setName($v);
  297. array_push($dimensions,$Dimension);
  298. }
  299. $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
  300. $segmentDimensions->setName("ga:segment");
  301. array_push($dimensions,$segmentDimensions);
  302. // Create Dimension Filter.
  303. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
  304. $dimensionFilter->setDimensionName("ga:source");
  305. $dimensionFilter->setOperator("REGEXP");
  306. $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));
  307. // Create Segment Filter Clause.
  308. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
  309. $segmentFilterClause->setDimensionFilter($dimensionFilter);
  310. // Create the Or Filters for Segment.
  311. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
  312. $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));
  313. // Create the Simple Segment.
  314. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
  315. $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));
  316. // Create the Segment Filters.
  317. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
  318. $segmentFilter->setSimpleSegment($simpleSegment);
  319. $segmentFilter->setNot(True);
  320. // Create the Segment Definition.
  321. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
  322. $segmentDefinition->setSegmentFilters(array($segmentFilter));
  323. $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
  324. $dynamicSegment->setSessionSegment($segmentDefinition);
  325. $dynamicSegment->setName('trafficsources filter');
  326. $segment = new \Google_Service_AnalyticsReporting_Segment();
  327. $segment->setDynamicSegment($dynamicSegment);
  328. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  329. $request->setViewId($VIEW_ID);
  330. $request->setDateRanges($dateRange);
  331. $request->setMetrics($metrics);
  332. $request->setDimensions($dimensions);
  333. $request->setSegments(array($segment));
  334. $request->setPageSize(5000);
  335. // $request->setOrderBys($orderBy);
  336. // $request->setMetricFilterClauses($MetricFilterClause);
  337. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  338. $body->setReportRequests( array( $request) );
  339. $reports= $analytics->reports->batchGet( $body );
  340. $result=$this->getResults($reports);
  341. return $result;
  342. }
  343. public function visitors_geo($dp,$start_at,$end_at){
  344. $analytics=self::getInstance($dp);
  345. $dimensionArr=[
  346. 'country'=>'ga:country',
  347. 'region'=>"ga:region",
  348. ];
  349. $metricArr=[
  350. 'transactions'=>"ga:transactions",
  351. 'transactionRevenue'=>"ga:transactionRevenue",
  352. ];
  353. $VIEW_ID = $this->getViewId($dp);//
  354. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  355. $dateRange->setStartDate($start_at);
  356. $dateRange->setEndDate($end_at);
  357. $metrics=[];
  358. $dimensions=[];
  359. foreach($metricArr as $k=>$v){
  360. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  361. $Metric->setExpression($v);
  362. $Metric->setAlias($k);
  363. array_push($metrics,$Metric);
  364. }
  365. foreach($dimensionArr as $k=>$v){
  366. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  367. $Dimension->setName($v);
  368. array_push($dimensions,$Dimension);
  369. }
  370. $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
  371. $orderBy->setFieldName('ga:transactions');
  372. $orderBy->setSortOrder("DESCENDING");
  373. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  374. $request->setViewId($VIEW_ID);
  375. $request->setDateRanges($dateRange);
  376. $request->setMetrics($metrics);
  377. $request->setDimensions($dimensions);
  378. $request->setOrderBys($orderBy);
  379. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  380. $body->setReportRequests( array( $request) );
  381. $reports= $analytics->reports->batchGet( $body );
  382. $result=$this->getResults($reports);
  383. return $result;
  384. }
  385. public function product($dp,$start_at,$end_at){
  386. $analytics=self::getInstance($dp);
  387. $dimensionArr=[
  388. 'productName'=>'ga:productName',
  389. ];
  390. $metricArr=[
  391. 'itemRevenue'=>"ga:itemRevenue",
  392. 'uniquePurchases'=>"ga:uniquePurchases",
  393. 'itemQuantity'=>"ga:itemQuantity",
  394. ];
  395. $VIEW_ID = $this->getViewId($dp);//
  396. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  397. $dateRange->setStartDate($start_at);
  398. $dateRange->setEndDate($end_at);
  399. $metrics=[];
  400. $dimensions=[];
  401. foreach($metricArr as $k=>$v){
  402. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  403. $Metric->setExpression($v);
  404. $Metric->setAlias($k);
  405. array_push($metrics,$Metric);
  406. }
  407. foreach($dimensionArr as $k=>$v){
  408. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  409. $Dimension->setName($v);
  410. array_push($dimensions,$Dimension);
  411. }
  412. $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
  413. $orderBy->setFieldName('ga:itemQuantity');
  414. $orderBy->setSortOrder("DESCENDING");
  415. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  416. $request->setViewId($VIEW_ID);
  417. $request->setDateRanges($dateRange);
  418. $request->setMetrics($metrics);
  419. $request->setDimensions($dimensions);
  420. $request->setOrderBys($orderBy);
  421. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  422. $body->setReportRequests( array( $request) );
  423. $reports= $analytics->reports->batchGet( $body );
  424. $result=$this->getResults($reports);
  425. return $result;
  426. }
  427. public function visitors_type($dp,$start_at,$end_at){
  428. $analytics=self::getInstance($dp);
  429. $dimensionArr=[
  430. 'userType'=>'ga:userType',
  431. 'date'=>'ga:date',
  432. ];
  433. $metricArr=[
  434. 'users'=>"ga:users",
  435. 'newUsers'=>"ga:newUsers",
  436. ];
  437. $VIEW_ID = $this->getViewId($dp);//
  438. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  439. $dateRange->setStartDate($start_at);
  440. $dateRange->setEndDate($end_at);
  441. $metrics=[];
  442. $dimensions=[];
  443. foreach($metricArr as $k=>$v){
  444. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  445. $Metric->setExpression($v);
  446. $Metric->setAlias($k);
  447. array_push($metrics,$Metric);
  448. }
  449. foreach($dimensionArr as $k=>$v){
  450. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  451. $Dimension->setName($v);
  452. array_push($dimensions,$Dimension);
  453. }
  454. // $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
  455. // $orderBy->setFieldName('ga:itemQuantity');
  456. // $orderBy->setSortOrder("DESCENDING");
  457. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  458. $request->setViewId($VIEW_ID);
  459. $request->setDateRanges($dateRange);
  460. $request->setMetrics($metrics);
  461. $request->setDimensions($dimensions);
  462. // $request->setOrderBys($orderBy);
  463. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  464. $body->setReportRequests( array( $request) );
  465. $reports= $analytics->reports->batchGet( $body );
  466. $result=$this->getResults($reports);
  467. return $result;
  468. }
  469. public function productInfo($productName,$dp,$start_at,$end_at){
  470. $analytics=self::getInstance($dp);
  471. $dimensionArr=[
  472. 'productName'=>'ga:productName',
  473. ];
  474. $metricArr=[
  475. 'itemRevenue'=>"ga:itemRevenue",
  476. 'revenuePerItem'=>"ga:revenuePerItem",
  477. 'productRefundAmount'=>"ga:productRefundAmount",
  478. 'quantityAddedToCart'=>"ga:quantityAddedToCart",
  479. // 'quantityRemovedFromCart'=>"ga:quantityRemovedFromCart",
  480. 'itemQuantity'=>"ga:itemQuantity",
  481. 'productListViews'=>"ga:productListViews",
  482. 'productDetailViews'=>"ga:productDetailViews",
  483. 'productAddsToCart'=>"ga:productAddsToCart",
  484. // 'productRemovesFromCart'=>"ga:productRemovesFromCart",
  485. 'productCheckouts'=>"ga:productCheckouts",
  486. 'uniquePurchases'=>"ga:uniquePurchases",
  487. ];
  488. $VIEW_ID = $this->getViewId($dp);//
  489. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  490. $dateRange->setStartDate($start_at);
  491. $dateRange->setEndDate($end_at);
  492. $metrics=[];
  493. $dimensions=[];
  494. foreach($metricArr as $k=>$v){
  495. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  496. $Metric->setExpression($v);
  497. $Metric->setAlias($k);
  498. array_push($metrics,$Metric);
  499. }
  500. foreach($dimensionArr as $k=>$v){
  501. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  502. $Dimension->setName($v);
  503. array_push($dimensions,$Dimension);
  504. }
  505. $skuFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
  506. $skuFilter->setDimensionName("ga:productName");
  507. $skuFilter->setOperator("EXACT");
  508. $skuFilter->setExpressions([$productName]);
  509. $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
  510. $MetricFilterClause->setFilters(array($skuFilter));
  511. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  512. $request->setViewId($VIEW_ID);
  513. $request->setDateRanges($dateRange);
  514. $request->setMetrics($metrics);
  515. $request->setDimensions($dimensions);
  516. $request->setDimensionFilterClauses($MetricFilterClause);
  517. // $request->setOrderBys($orderBy);
  518. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  519. $body->setReportRequests( array( $request) );
  520. $reports= $analytics->reports->batchGet( $body );
  521. $result=$this->getResults($reports);
  522. return $result;
  523. }
  524. public function goals($dp,$metricArr,$start_at,$end_at){
  525. $analytics=self::getInstance($dp);
  526. $dimensionArr=[
  527. // 'date'=>'ga:date',
  528. // 'sessionCount'=>'ga:sessionCount',
  529. ];
  530. $VIEW_ID = $this->getViewId($dp);//
  531. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  532. $dateRange->setStartDate($start_at);
  533. $dateRange->setEndDate($end_at);
  534. $metrics=[];
  535. $dimensions=[];
  536. foreach($metricArr as $k=>$v){
  537. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  538. $Metric->setExpression($v);
  539. $Metric->setAlias($k);
  540. array_push($metrics,$Metric);
  541. }
  542. foreach($dimensionArr as $k=>$v){
  543. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  544. $Dimension->setName($v);
  545. array_push($dimensions,$Dimension);
  546. }
  547. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  548. $request->setViewId($VIEW_ID);
  549. $request->setDateRanges($dateRange);
  550. $request->setMetrics($metrics);
  551. $request->setDimensions($dimensions);
  552. // $request->setOrderBys($orderBy);
  553. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  554. $body->setReportRequests( array( $request) );
  555. $reports= $analytics->reports->batchGet( $body );
  556. $result=$this->getResults($reports);
  557. return $result;
  558. }
  559. public function regionProduct($region,$dp,$start_at,$end_at){
  560. $analytics=self::getInstance($dp);
  561. $dimensionArr=[
  562. 'region'=>'ga:region',
  563. ];
  564. $metricArr=[
  565. 'itemRevenue'=>"ga:itemRevenue",
  566. 'revenuePerItem'=>"ga:revenuePerItem",
  567. 'productRefundAmount'=>"ga:productRefundAmount",
  568. 'quantityAddedToCart'=>"ga:quantityAddedToCart",
  569. // 'quantityRemovedFromCart'=>"ga:quantityRemovedFromCart",
  570. 'itemQuantity'=>"ga:itemQuantity",
  571. 'productListViews'=>"ga:productListViews",
  572. 'productDetailViews'=>"ga:productDetailViews",
  573. 'productAddsToCart'=>"ga:productAddsToCart",
  574. // 'productRemovesFromCart'=>"ga:productRemovesFromCart",
  575. 'productCheckouts'=>"ga:productCheckouts",
  576. // 'uniquePurchases'=>"ga:uniquePurchases",
  577. 'transactions'=>"ga:transactions",
  578. ];
  579. $VIEW_ID = $this->getViewId($dp);//
  580. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  581. $dateRange->setStartDate($start_at);
  582. $dateRange->setEndDate($end_at);
  583. $metrics=[];
  584. $dimensions=[];
  585. foreach($metricArr as $k=>$v){
  586. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  587. $Metric->setExpression($v);
  588. $Metric->setAlias($k);
  589. array_push($metrics,$Metric);
  590. }
  591. foreach($dimensionArr as $k=>$v){
  592. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  593. $Dimension->setName($v);
  594. array_push($dimensions,$Dimension);
  595. }
  596. $regionFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
  597. $regionFilter->setDimensionName("ga:region");
  598. $regionFilter->setOperator("EXACT");
  599. $regionFilter->setExpressions([$region]);
  600. $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
  601. $MetricFilterClause->setFilters(array($regionFilter));
  602. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  603. $request->setViewId($VIEW_ID);
  604. $request->setDateRanges($dateRange);
  605. $request->setMetrics($metrics);
  606. $request->setDimensions($dimensions);
  607. $request->setDimensionFilterClauses($MetricFilterClause);
  608. // $request->setOrderBys($orderBy);
  609. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  610. $body->setReportRequests( array( $request) );
  611. $reports= $analytics->reports->batchGet( $body );
  612. $result=$this->getResults($reports);
  613. return $result;
  614. }
  615. public function storeData($dp,$start_at,$end_at){
  616. $analytics=self::getInstance($dp);
  617. $dimensionArr=[
  618. // 'campaign'=>'ga:campaign'
  619. ];
  620. $metricArr=[
  621. '销量'=>"ga:itemQuantity",
  622. '订单量'=>"ga:transactions",
  623. '订单金额'=>"ga:transactionRevenue",
  624. '广告点击次数'=>"ga:adClicks",//点击次数
  625. '广告花费'=>"ga:adCost",//成本
  626. 'CTR'=>"ga:CTR",//点击率
  627. 'ROAS'=>"ga:ROAS",//回报率
  628. ];
  629. $VIEW_ID = $this->getViewId($dp);//
  630. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  631. $dateRange->setStartDate($start_at);
  632. $dateRange->setEndDate($end_at);
  633. $metrics=[];
  634. $dimensions=[];
  635. foreach($metricArr as $k=>$v){
  636. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  637. $Metric->setExpression($v);
  638. $Metric->setAlias($k);
  639. array_push($metrics,$Metric);
  640. }
  641. foreach($dimensionArr as $k=>$v){
  642. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  643. $Dimension->setName($v);
  644. array_push($dimensions,$Dimension);
  645. }
  646. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  647. $request->setViewId($VIEW_ID);
  648. $request->setDateRanges($dateRange);
  649. $request->setMetrics($metrics);
  650. $request->setDimensions($dimensions);
  651. // $request->setOrderBys($orderBy);
  652. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  653. $body->setReportRequests( array( $request) );
  654. $reports= $analytics->reports->batchGet( $body );
  655. $result=$this->getResults($reports);
  656. return $result[0]??[];
  657. }
  658. public function storeSellData($dp,$start_at,$end_at,$type="day"){
  659. $analytics=self::getInstance($dp);
  660. switch($type){
  661. case "day":
  662. $dimensionArr=[
  663. 'date'=>'ga:date',
  664. ];
  665. break;
  666. case "hour":
  667. $dimensionArr=[
  668. 'date'=>'ga:date',
  669. 'hour'=>'ga:hour'
  670. ];
  671. break;
  672. case "week":
  673. $dimensionArr=[
  674. 'year'=>'ga:isoYear',
  675. 'week'=>'ga:isoWeek',
  676. ];
  677. break;
  678. case "month":
  679. $dimensionArr=[
  680. 'year'=>'ga:year',
  681. 'month'=>'ga:month',
  682. ];
  683. break;
  684. }
  685. $metricArr=[
  686. 'itemQuantity'=>"ga:itemQuantity",
  687. ];
  688. $VIEW_ID = $this->getViewId($dp);//
  689. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  690. $dateRange->setStartDate($start_at);
  691. $dateRange->setEndDate($end_at);
  692. $metrics=[];
  693. $dimensions=[];
  694. foreach($metricArr as $k=>$v){
  695. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  696. $Metric->setExpression($v);
  697. $Metric->setAlias($k);
  698. array_push($metrics,$Metric);
  699. }
  700. foreach($dimensionArr as $k=>$v){
  701. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  702. $Dimension->setName($v);
  703. array_push($dimensions,$Dimension);
  704. }
  705. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  706. $request->setViewId($VIEW_ID);
  707. $request->setDateRanges($dateRange);
  708. $request->setMetrics($metrics);
  709. $request->setDimensions($dimensions);
  710. // $request->setOrderBys($orderBy);
  711. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  712. $body->setReportRequests( array( $request) );
  713. $reports= $analytics->reports->batchGet( $body );
  714. $result=$this->getResults($reports);
  715. return $result;
  716. }
  717. public function trafficsource_overview($dp,$start_at,$end_at){
  718. $analytics=self::getInstance($dp);
  719. $dimensionArr=[
  720. 'channelGrouping'=>'ga:channelGrouping',
  721. ];
  722. $metricArr=[
  723. 'users'=>"ga:users",
  724. 'newUsers'=>"ga:newUsers",
  725. 'sessions'=>"ga:sessions",
  726. 'bounceRate'=>"ga:bounceRate",
  727. 'transactionsPerSession'=>"ga:transactionsPerSession",
  728. 'transactionRevenue'=>"ga:transactionRevenue",
  729. 'transactions'=>"ga:transactions",
  730. ];
  731. $VIEW_ID = $this->getViewId($dp);//
  732. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  733. $dateRange->setStartDate($start_at);
  734. $dateRange->setEndDate($end_at);
  735. $metrics=[];
  736. $dimensions=[];
  737. foreach($metricArr as $k=>$v){
  738. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  739. $Metric->setExpression($v);
  740. $Metric->setAlias($k);
  741. array_push($metrics,$Metric);
  742. }
  743. foreach($dimensionArr as $k=>$v){
  744. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  745. $Dimension->setName($v);
  746. array_push($dimensions,$Dimension);
  747. }
  748. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  749. $request->setViewId($VIEW_ID);
  750. $request->setDateRanges($dateRange);
  751. $request->setMetrics($metrics);
  752. $request->setDimensions($dimensions);
  753. // $request->setOrderBys($orderBy);
  754. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  755. $body->setReportRequests( array( $request) );
  756. $reports= $analytics->reports->batchGet( $body );
  757. $result=$this->getResults($reports);
  758. return $result;
  759. }
  760. public function googleAds(){
  761. $analytics=self::getInstance($dp);
  762. $dimensionArr=[
  763. 'adwordsCampaignID'=>'ga:adwordsCampaignID',
  764. ];
  765. $metricArr=[
  766. 'adClicks'=>"ga:adClicks",
  767. 'adCost'=>"ga:adCost",
  768. 'CPC'=>"ga:CPC",
  769. 'users'=>"ga:users",
  770. 'sessions'=>"ga:sessions",
  771. 'bounceRate'=>"ga:bounceRate",
  772. 'transactionsPerSession'=>"ga:transactionsPerSession",
  773. 'transactionRevenue'=>"ga:transactionRevenue",
  774. 'transactions'=>"ga:transactions",
  775. ];
  776. $VIEW_ID = $this->getViewId($dp);//
  777. $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  778. $dateRange->setStartDate($start_at);
  779. $dateRange->setEndDate($end_at);
  780. $metrics=[];
  781. $dimensions=[];
  782. foreach($metricArr as $k=>$v){
  783. $Metric = new \Google_Service_AnalyticsReporting_Metric();
  784. $Metric->setExpression($v);
  785. $Metric->setAlias($k);
  786. array_push($metrics,$Metric);
  787. }
  788. foreach($dimensionArr as $k=>$v){
  789. $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
  790. $Dimension->setName($v);
  791. array_push($dimensions,$Dimension);
  792. }
  793. $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  794. $request->setViewId($VIEW_ID);
  795. $request->setDateRanges($dateRange);
  796. $request->setMetrics($metrics);
  797. $request->setDimensions($dimensions);
  798. // $request->setOrderBys($orderBy);
  799. $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  800. $body->setReportRequests( array( $request) );
  801. $reports= $analytics->reports->batchGet( $body );
  802. $result=$this->getResults($reports);
  803. return $result;
  804. }
  805. function getResults($reports) {
  806. $data=[];
  807. for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
  808. $item=[];
  809. $report = $reports[ $reportIndex ];
  810. $header = $report->getColumnHeader();
  811. $dimensionHeaders = $header->getDimensions();
  812. $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  813. $rows = $report->getData()->getRows();
  814. for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  815. $row = $rows[ $rowIndex ];
  816. $dimensions = $row->getDimensions();
  817. $metrics = $row->getMetrics();
  818. if($dimensionHeaders&&$dimensions){
  819. for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  820. $header = $dimensionHeaders[$i];
  821. $header=str_replace('ga:','',$header);
  822. $item[$header]=$dimensions[$i];
  823. // print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r");
  824. // echo"<br/>";
  825. }
  826. // $date=$dimensions[0];
  827. // $date=date('Y-m-d',strtotime($date));
  828. }
  829. if($metricHeaders&&$metrics){
  830. for ($j = 0; $j < count($metrics); $j++) {
  831. $values = $metrics[$j]->getValues();
  832. for ($k = 0; $k < count($values); $k++) {
  833. $entry = $metricHeaders[$k];
  834. $item[$entry->getName()]=$values[$k];
  835. // print($entry->getName() . ": " . $values[$k] . "\n\r");
  836. // echo"<br/>";
  837. }
  838. }
  839. }
  840. $data[]=$item;
  841. }
  842. }
  843. return $data;
  844. }
  845. }