setApplicationName("Hello Analytics Reporting"); $client->setAuthConfig($KEY_FILE_LOCATION); $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']); $analytics = new \Google_Service_AnalyticsReporting($client); return $analytics; } public static function getInstance($dp){ if(isset(self::$insances[$dp])){ return self::$insances[$dp]; }else{ self::$insances[$dp]=self::initializeAnalytics($dp); return self::$insances[$dp]; } } private function getViewId($dp){ return "155703065"; } public function contentpages($dp,$start_at,$end_at){ $analytics=self::getInstance($dp); $metricArr=[ 'pageviews'=>"ga:pageviews", 'uniquePageviews'=>"ga:uniquePageviews", 'avgTimeOnPage'=>"ga:avgTimeOnPage", 'entrances'=>"ga:entrances", 'bounceRate'=>"ga:bounceRate", 'exitRate'=>"ga:exitRate", 'pageValue'=>"ga:pageValue", ]; $dimensionArr=[ 'pagePath'=>'ga:pagePath', 'date'=>"ga:date", ]; $VIEW_ID = $this->getViewId($dp);// $dateRange = new \Google_Service_AnalyticsReporting_DateRange(); $dateRange->setStartDate($start_at); $dateRange->setEndDate($end_at); $metrics=[]; $dimensions=[]; foreach($metricArr as $k=>$v){ $Metric = new \Google_Service_AnalyticsReporting_Metric(); $Metric->setExpression($v); $Metric->setAlias($k); array_push($metrics,$Metric); } foreach($dimensionArr as $k=>$v){ $Dimension = new \Google_Service_AnalyticsReporting_Dimension(); $Dimension->setName($v); array_push($dimensions,$Dimension); } $pageviewsFilter = new \Google_Service_AnalyticsReporting_MetricFilter(); $pageviewsFilter->setMetricName("ga:pageviews"); $pageviewsFilter->setOperator("GREATER_THAN"); $pageviewsFilter->setComparisonValue("1"); $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause(); $MetricFilterClause->setFilters(array($pageviewsFilter)); $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension(); $segmentDimensions->setName("ga:segment"); array_push($dimensions,$segmentDimensions); // Create Dimension Filter. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter(); $dimensionFilter->setDimensionName("ga:pagePath"); $dimensionFilter->setOperator("REGEXP"); $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)")); // Create Segment Filter Clause. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause(); $segmentFilterClause->setDimensionFilter($dimensionFilter); // Create the Or Filters for Segment. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment(); $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause)); // Create the Simple Segment. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment(); $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment)); // Create the Segment Filters. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter(); $segmentFilter->setSimpleSegment($simpleSegment); $segmentFilter->setNot(True); // Create the Segment Definition. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition(); $segmentDefinition->setSegmentFilters(array($segmentFilter)); $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment(); $dynamicSegment->setSessionSegment($segmentDefinition); $dynamicSegment->setName('pagePath'); $segment = new \Google_Service_AnalyticsReporting_Segment(); $segment->setDynamicSegment($dynamicSegment); $orderBy=new \Google_Service_AnalyticsReporting_OrderBy(); $orderBy->setFieldName('ga:pageviews'); $orderBy->setSortOrder("DESCENDING"); $request = new \Google_Service_AnalyticsReporting_ReportRequest(); $request->setViewId($VIEW_ID); $request->setDateRanges($dateRange); $request->setMetrics($metrics); $request->setDimensions($dimensions); $request->setSegments(array($segment)); $request->setOrderBys($orderBy); $request->setPageSize(5000); $request->setMetricFilterClauses($MetricFilterClause); $body = new \Google_Service_AnalyticsReporting_GetReportsRequest(); $body->setReportRequests( array( $request) ); $reports= $analytics->reports->batchGet( $body ); $result=$this->getResults($reports); return $result; } public function trafficsource($dp,$start_at,$end_at){ $analytics=self::getInstance($dp); $metricArr=[ 'users'=>"ga:users", 'newUsers'=>"ga:newUsers", 'sessions'=>"ga:sessions", 'bounceRate'=>"ga:bounceRate", 'pageviewsPerSession'=>"ga:pageviewsPerSession", 'avgSessionDuration'=>"ga:avgSessionDuration", 'transactionsPerVisit'=>"ga:transactionsPerVisit", 'transactions'=>"ga:transactions", 'transactionRevenue'=>"ga:transactionRevenue", ]; $dimensionArr=[ 'pagePath'=>'ga:source', 'date'=>"ga:date", 'channelGrouping'=>"ga:channelGrouping", 'landingPagePath'=>"ga:landingPagePath", 'keyword'=>"ga:keyword", 'socialNetwork'=>"ga:socialNetwork", ]; $VIEW_ID = $this->getViewId($dp);// $dateRange = new \Google_Service_AnalyticsReporting_DateRange(); $dateRange->setStartDate($start_at); $dateRange->setEndDate($end_at); $metrics=[]; $dimensions=[]; foreach($metricArr as $k=>$v){ $Metric = new \Google_Service_AnalyticsReporting_Metric(); $Metric->setExpression($v); $Metric->setAlias($k); array_push($metrics,$Metric); } foreach($dimensionArr as $k=>$v){ $Dimension = new \Google_Service_AnalyticsReporting_Dimension(); $Dimension->setName($v); array_push($dimensions,$Dimension); } $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension(); $segmentDimensions->setName("ga:segment"); array_push($dimensions,$segmentDimensions); // Create Dimension Filter. $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter(); $dimensionFilter->setDimensionName("ga:source"); $dimensionFilter->setOperator("REGEXP"); $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)")); // Create Segment Filter Clause. $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause(); $segmentFilterClause->setDimensionFilter($dimensionFilter); // Create the Or Filters for Segment. $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment(); $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause)); // Create the Simple Segment. $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment(); $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment)); // Create the Segment Filters. $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter(); $segmentFilter->setSimpleSegment($simpleSegment); $segmentFilter->setNot(True); // Create the Segment Definition. $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition(); $segmentDefinition->setSegmentFilters(array($segmentFilter)); $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment(); $dynamicSegment->setSessionSegment($segmentDefinition); $dynamicSegment->setName('trafficsources filter'); $segment = new \Google_Service_AnalyticsReporting_Segment(); $segment->setDynamicSegment($dynamicSegment); $request = new \Google_Service_AnalyticsReporting_ReportRequest(); $request->setViewId($VIEW_ID); $request->setDateRanges($dateRange); $request->setMetrics($metrics); $request->setDimensions($dimensions); $request->setSegments(array($segment)); $request->setPageSize(5000); // $request->setOrderBys($orderBy); // $request->setMetricFilterClauses($MetricFilterClause); $body = new \Google_Service_AnalyticsReporting_GetReportsRequest(); $body->setReportRequests( array( $request) ); $reports= $analytics->reports->batchGet( $body ); $result=$this->getResults($reports); return $result; } public function visitors_geo($dp,$start_at,$end_at){ $analytics=self::getInstance($dp); $dimensionArr=[ 'country'=>'ga:country', 'region'=>"ga:region", ]; $metricArr=[ 'transactions'=>"ga:transactions", 'transactionRevenue'=>"ga:transactionRevenue", ]; $VIEW_ID = $this->getViewId($dp);// $dateRange = new \Google_Service_AnalyticsReporting_DateRange(); $dateRange->setStartDate($start_at); $dateRange->setEndDate($end_at); $metrics=[]; $dimensions=[]; foreach($metricArr as $k=>$v){ $Metric = new \Google_Service_AnalyticsReporting_Metric(); $Metric->setExpression($v); $Metric->setAlias($k); array_push($metrics,$Metric); } foreach($dimensionArr as $k=>$v){ $Dimension = new \Google_Service_AnalyticsReporting_Dimension(); $Dimension->setName($v); array_push($dimensions,$Dimension); } $orderBy=new \Google_Service_AnalyticsReporting_OrderBy(); $orderBy->setFieldName('ga:transactions'); $orderBy->setSortOrder("DESCENDING"); $request = new \Google_Service_AnalyticsReporting_ReportRequest(); $request->setViewId($VIEW_ID); $request->setDateRanges($dateRange); $request->setMetrics($metrics); $request->setDimensions($dimensions); $request->setOrderBys($orderBy); $body = new \Google_Service_AnalyticsReporting_GetReportsRequest(); $body->setReportRequests( array( $request) ); $reports= $analytics->reports->batchGet( $body ); $result=$this->getResults($reports); return $result; } public function productSku($dp,$start_at,$end_at){ $analytics=self::getInstance($dp); $dimensionArr=[ 'productSku'=>'ga:productSku', ]; $metricArr=[ 'itemRevenue'=>"ga:itemRevenue", 'uniquePurchases'=>"ga:uniquePurchases", 'itemQuantity'=>"ga:itemQuantity", ]; $VIEW_ID = $this->getViewId($dp);// $dateRange = new \Google_Service_AnalyticsReporting_DateRange(); $dateRange->setStartDate($start_at); $dateRange->setEndDate($end_at); $metrics=[]; $dimensions=[]; foreach($metricArr as $k=>$v){ $Metric = new \Google_Service_AnalyticsReporting_Metric(); $Metric->setExpression($v); $Metric->setAlias($k); array_push($metrics,$Metric); } foreach($dimensionArr as $k=>$v){ $Dimension = new \Google_Service_AnalyticsReporting_Dimension(); $Dimension->setName($v); array_push($dimensions,$Dimension); } $orderBy=new \Google_Service_AnalyticsReporting_OrderBy(); $orderBy->setFieldName('ga:itemQuantity'); $orderBy->setSortOrder("DESCENDING"); $request = new \Google_Service_AnalyticsReporting_ReportRequest(); $request->setViewId($VIEW_ID); $request->setDateRanges($dateRange); $request->setMetrics($metrics); $request->setDimensions($dimensions); $request->setOrderBys($orderBy); $body = new \Google_Service_AnalyticsReporting_GetReportsRequest(); $body->setReportRequests( array( $request) ); $reports= $analytics->reports->batchGet( $body ); $result=$this->getResults($reports); return $result; } /** * Queries the Analytics Reporting API V4. * * @param service An authorized Analytics Reporting API V4 service object. * @return The Analytics Reporting API V4 response. */ function getContentReport($VIEW_ID,$analytics,$metricArr,$dimensionArr) { } function getResults($reports) { $data=[]; for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) { $item=[]; $report = $reports[ $reportIndex ]; $header = $report->getColumnHeader(); $dimensionHeaders = $header->getDimensions(); $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries(); $rows = $report->getData()->getRows(); for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) { $row = $rows[ $rowIndex ]; $dimensions = $row->getDimensions(); $metrics = $row->getMetrics(); if($dimensionHeaders&&$dimensions){ for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) { $header = $dimensionHeaders[$i]; $header=str_replace('ga:','',$header); $item[$header]=$dimensions[$i]; // print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r"); // echo"
"; } // $date=$dimensions[0]; // $date=date('Y-m-d',strtotime($date)); }else{ continue; } if($metricHeaders&&$metrics){ for ($j = 0; $j < count($metrics); $j++) { $values = $metrics[$j]->getValues(); for ($k = 0; $k < count($values); $k++) { $entry = $metricHeaders[$k]; $item[$entry->getName()]=$values[$k]; // print($entry->getName() . ": " . $values[$k] . "\n\r"); // echo"
"; } } } $data[]=$item; } } return $data; } }