如何分组google sourceMedium并统计相同的推介(How to group google sourceMedium and count same referral)

我使用Gapi.class.php从谷歌分析中获取数据。

这是我的PHP代码

$ga->requestReportData(xxxxx,array('sourceMedium','month','year'),array('sessions'), $sort_metric=array('month'), $filter=null, $start_date=$fromDate, $end_date=$toDate, $start_index=1, $max_results=10000);

我是这样的

[dimensions:gapiReportEntry:private] => Array
                (
                    [sourceMedium] => l.facebook.com / referral
                    [month] => 06
                    [year] => 2016
                )
   [dimensions:gapiReportEntry:private] => Array
                (
                    [sourceMedium] => mail.google.com / referral
                    [month] => 06
                    [year] => 2016
                )
     [dimensions:gapiReportEntry:private] => Array
                (
                    [sourceMedium] => mbasic.facebook.com / referral
                    [month] => 06
                    [year] => 2016
                ) 
  
 
 
 我想知道如何将它们分组并计数， 
 
Example 
        source   Count
         fb    =  100
        google =  50
 
 请。 
 
 更新 
 
  
I used Gapi.class.php to get data from google analytic.
 
Here is my php code 
 
 $ga->requestReportData(xxxxx,array('sourceMedium','month','year'),array('sessions'), $sort_metric=array('month'), $filter=null, $start_date=$fromDate, $end_date=$toDate, $start_index=1, $max_results=10000);
 
I got like this
 
 
 
  
  
[dimensions:gapiReportEntry:private] => Array
                (
                    [sourceMedium] => l.facebook.com / referral
                    [month] => 06
                    [year] => 2016
                )
   [dimensions:gapiReportEntry:private] => Array
                (
                    [sourceMedium] => mail.google.com / referral
                    [month] => 06
                    [year] => 2016
                )
     [dimensions:gapiReportEntry:private] => Array
                (
                    [sourceMedium] => mbasic.facebook.com / referral
                    [month] => 06
                    [year] => 2016
                ) 
  
 
 
I want to know how can I group them and count,
 
Example 
        source   Count
         fb    =  100
        google =  50
 
Please.
 
Updated
 

                
最满意答案
                
                    
                        
 只需从查询中删除与日期相关的维度，即month和year ，即可获得汇总数字。 
 
 所以你的查询应该看起来像这样得到预期的输出。 
 
$ga->requestReportData(xxxxx,array('sourceMedium','pagePath'), array('pageviews'), $sort_metric=array('pageviews'), $filter=null, $start_date=$fromDate, $end_date=$toDate, $start_index=1, $max_results=10000);
 
 请查看以下链接以供参考。 
 
 Google Analytics维度和指标 
 
 创建报告 
 
 创建报告的高级用例 
Just remove date related dimensions i.e. month and year from your query to get aggregated numbers.
 
So your query should look something like this to get expected output.
 
$ga->requestReportData(xxxxx,array('sourceMedium','pagePath'), array('pageviews'), $sort_metric=array('pageviews'), $filter=null, $start_date=$fromDate, $end_date=$toDate, $start_index=1, $max_results=10000);
 
Have a look at following links for your references.
 
Google Analytics Dimension and Metrics
 
Creating Reports
 
Advanced Use Cases of Creating Reports