Facebook Insights API 和 FQL：使用状态检索 page_active_users_city 指标

发布于 2024-12-03 11:07:12 字数 522 浏览 1 评论 0原文

我们使用以下 FQL 查询为我们的页面拉取前 20 个活跃用户城市的列表：

SELECT metric, value FROM insights WHERE object_id=MY_PAGE_ID AND metric='page_fans_city' AND end_time=end_time_date('2011-09-07') AND period=period('lifetime')

问题是返回的数据仅返回城市名称和粉丝数。返回的数据中没有定义状态；因此，当查询返回计数为 12345 的 Louisville 时；我无法判断它是否是肯塔基州路易斯维尔；科罗拉多州路易斯维尔；或其他某个恰好名为路易斯维尔的城市。

除了城市之外，是否还可以检索州和/或邮政编码并从上面的查询中进行计数？或者是否有其他方法可以获取我的页面的用户数量和活跃用户数量，其中包括具有州和用户数量的顶级城市？

非常感谢任何建设性的意见。

谢谢，坦率

原文

We're pulling down the list of top 20 active user cities for our Page using the following FQL query:

SELECT metric, value FROM insights WHERE object_id=MY_PAGE_ID AND metric='page_fans_city' AND end_time=end_time_date('2011-09-07') AND period=period('lifetime')

The problem is the data returned only returns the city name and the fan count. There's no state defined in the data returned; so when the query returns Louisville with a count of 12345; there's no way for me to tell if it's Louisville,KY; Louisville, CO; or some other city that happens to be named Louisville.

Is there anyway to retrieve the state and/or zip in addition to the city and count from the query above? Or is there maybe an alternative way I can get the number of users and active users for my page that will include both the top cities with states and user counts?

Any constructive input is greatly appreciated.

Thanks,
Frank

分享到QQ

分享到微博