如何分组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 = 50Please.
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
更多推荐
发布评论