O'Reilly logo

Facebook Cookbook by Jay Goldman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Metrics Table

Problem

What’s the schema for the metrics table?

Solution

The metrics table holds all of the metrics recorded for your application. Its fields are listed in Table 8-4. You can view the same metrics from inside the Facebook Insights app (http://www.facebook.com/business/insights/app.php?id=12345). Metrics are calculated at midnight Pacific time everyday, so you should convert your date values into epoch seconds based on midnight PST (see Formatting Relative Time for more about epoch seconds). More information about this table, including an up-to-date listing of fields, can be found at http://wiki.developers.facebook.com/index.php/Metrics_(FQL).

Table 8-4. metrics table fields

Name

Type

Index

Description

end_time

int

The ending date for which these metrics were recorded, in epoch seconds. See Formatting Relative Time for an explanation of epoch seconds.

period

int

Length of time for which you want results, in seconds. Supported lengths are one day (86400 seconds), seven days (604800 seconds), and 30 days (2592000 seconds).

active_users

int

 

Number of active users in your app on this day.

unique_adds

int

 

Number of unique new users for your app on this day (if the same user added, removed, and then added it again, it only counts for one).

unique_removes

int

 

Number of unique removes for your app on this day (if the same user added, removed, added, and removed, it only counts for one).

unique_blocks

int

 

Number of unique blocks for your app on this day (if the same user blocked, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required