代码之家 › 专栏 › 技术社区 › DrXCheng

如何使用FQL获取多天的“page_fan_adds”

facebook-fql facebook-graph-api facebook

0

DrXCheng · 技术社区 · 14 年前

我可以得到的价值 page_fan_adds 具体日期使用FQL。

SELECT metric, value FROM insights WHERE object_id = XXX AND 
metric = "page_fan_adds" AND end_time = end_time_date("2012-07-20") AND 
period = period("day")

我得到:

{"data": [
    {"metric": "page_fan_adds", 
      "value": 1}
]}

然而,使用Graph API,我可以获得一个月的数据: graph.facebook.com/XXX/insights/page_fan_adds/?since= 1340175600&until=1342767600 。我得到:

{"data": [
  {"id": "XXX/insights/page_fan_adds/day", 
   "name": "page_fan_adds", 
   "period": "day", 
   "values": [
     {"value": 4, 
      "end_time": "2012-06-21T07:00:00+0000"}, 
     {"value": 2, 
      "end_time": "2012-07-20T07:00:00+0000"}
  ], 
  "title": "Daily New Likes", 
  "description": "Daily The number of new people who have liked your Page (Total Count)"}], 
"paging": {
  "previous": "https://graph.facebook.com/XXX/insights/page_fan_adds/?since=1337583600&until=%201340175600", 
  "next": "https://graph.facebook.com/XXX/insights/page_fan_adds/?since=1342767600&until=1345359600"
  }
}

period 列只能是 day 对于 页面_页面_ads 。那么如何使用FQL获取一个月的数据呢?

2 回复 | 直到 14 年前

1

cpilko 14 年前

这似乎是实现这一点的唯一方法,即分别查询所有日期,然后聚合它们。

SELECT metric, value FROM insights WHERE object_id=XXX AND 
   metric = "page_fan_adds" AND period = period("day") AND (
      end_time = end_time_date("2012-07-20") OR 
      end_time = end_time_date("2012-07-19") OR
      ...
      end_time = end_time_date("2012-06-21")
   )

正在尝试 end_time IN 引发错误。

2

0

magicgregz 12 年前

SELECT metric, value FROM insights 
WHERE object_id=XXX 
AND metric = "page_fan_adds" 
AND period = period("day") 
AND end_time in ( 
  end_time_date("2012-07-20"), 
  end_time_date("2012-07-19"), 
  end_time_date("2012-06-21")
)