Campbell et al v. Facebook Inc.
Filing
179
Joint Notice of Refiling of Documents Accompanying Class Certification Briefs and Evidentiary Objections. (Attachments: # 1 Exhibit 1 (Redacted), # 2 Exhibit 2 (Redacted), # 3 Exhibit 3 (Redacted), # 4 Exhibit 4 (Redacted), # 5 Exhibit 5 (Redacted), # 6 Exhibit 6 (Redacted), # 7 Exhibit 7 (Redacted), # 8 Exhibit 8 (Unredacted), # 9 Exhibit 9 (Unredacted), # 10 Exhibit 10 (Redacted), # 11 Exhibit 11 (Redacted), # 12 Exhibit 12 (Redacted), # 13 Exhibit 13 (Redacted), # 14 Exhibit 14 (Redacted), # 15 Exhibit 15 (Redacted), # 16 Exhibit 16 (Redacted), # 17 Exhibit 17 (Redacted), # 18 Exhibit 18 (Redacted), # 19 Exhibit 19 (Unredacted), # 20 Exhibit 20 (Redacted), # 21 Exhibit 21 (Redacted), # 22 Exhibit 22 (Unredacted), # 23 Exhibit 23 (Redacted), # 24 Exhibit 24 (Redacted), # 25 Exhibit 25 (Unredacted))(Chorba, Christopher) (Filed on 3/28/2016) Modified on 3/29/2016 (kcS, COURT STAFF).
EXHIBIT 6
From:
Sent:
To:
Cc:
Subject:
fdn-insights-bounces@lists.facebook.com on behalf of Alex Himel
Friday, February 11, 2011 6:54 PM
Kristin Thayer
Aryeh Selekman; fdn-insights@lists.facebook.com
Re: [fdn-insights] URL stats for Demand Media
FYI, new realtime insights supports top 10 right now, and will support top 100 after adding pagination to the UI.
http://www.intern.facebook.com/insights/?sk=lt 10150102618235061
(add yourself to insights_dashboard gatekeeper if you do not see this)
-Alex
On Feb 11, 2011, at 2:41 PM, Kristin Thayer wrote:
>Thanks Jonathan!!
>
>-----Original Message----> From: Jonathan P. Hsu
> Sent: Friday, February 11, 20111:54 PM
>To: Jonathan P. Hsu; Kristin Thayer; fdn-insights@lists.facebook.com
> Cc: Aryeh Selekman
>Subject: RE: URL stats for Demand Media
>
> It came back, but I had forgotten to cast it... Try this ...
>
>from dim_shares
>select ds, url, tracking_info, cast(split(tracking_info,',')[O] as
>int) as shares where ds>'2011-02-03' AND ds<'2011-02-10'
>and url like '%ehow.com%'
>and split(tracking_info,',')[0]<1000000
>order by shares desc limit 1000
>
>it takes about 40 minutes ...
>
>~~~~~~~~~~~~~~~~~~
>From: Jonathan P. Hsu
> Sent: Friday, February 11, 20111:50 PM
>To: Kristin Thayer; fdn-insights@lists.facebook.com
> Cc: Aryeh Selekman
>Subject: RE: URL stats for Demand Media
>
>Currently, the only thing that shows metrics for several urls from a single domain ala link.getStats is in the "most liked
and shared" list in Insights.
>
> http://www.dev.facebook.com/insights/?sk=do 10150102618235061
>
>Other than that, the data is scraped into dim_shares but is not currently collected into mysql in any fashion ...
>
> Unfortunately also, dim_shares has share objects from re-sharing that
>are separate from the initial share event and don't have these
Highly Confidential
FB000008489
>numbers. In any case, what you want is the tracking_info field for
> urls in dim_shares where the tracking_info field isn't holding an
> fbid. The easiest way is something like this
>
>from dim_shares
>select url, tracking_info, split(tracking_info,',')[O] as shares where
> ds='2011-02-05'
>and url like '%ehow.com%'
>and split(tracking_info,',')[0]<1000000
>order by shares desc limit 100
>
>The split() clause is there to ensure that you're only looking at original share objects which have the share tracking
numbers in tracking_info.
>
> For those rows, tracking_info contains these numbers in a comma delimited string ...
>
> share_count, post_count, like_count, comment_count, click_count
>
>This query takes a very long time because the table is too big. I started running it, but it hasn't come back yet ...
>
>
>
>
>
>
>
>~~~~~~~~~~~~~~~~~~
>From: fdn-insights-bounces@lists.facebook.com
> [fdn-insights-bounces@lists.facebook.com] On Behalf Of Kristin Thayer
> [kristin@fb.com]
> Sent: Friday, February 11, 201111:58 AM
>To: fdn-insights@lists.facebook.com
> Cc: Aryeh Selekman
>Subject: [fdn-insights] URL stats for Demand Media
>
>Is it possible to get daily data, for each URL in a domain (cracked.com, ehow.com, and livestrong.com), of the
cumulative stats that are exposed in link.getStats:
>
> https://api.facebook.com/method/links.getStats?
> urls=http%3A%2F%2Fwww.ehow.com%2Fhow_7739881_make-chocolate-valentines
>-day-candy.html&
> access_token= ...
> {
>
>
>
>
>
>
"url": "http://www.ehow.com/how 7739881 make-chocolate-valentines-day-candy.html",
"normalized_url": "http://www.ehow.com/how 7739881 make-chocolate-valentines-day-candy.html",
"share_count": 4,
"like_count": 24,
"comment_count": 17,
"total_count": 45,
> }
>l
>
>
Highly Confidential
FB000008490
> Please let me know if you need more information.
>
>Thanks,
> Kristin
>
>
> kristin thayer
I platform partnerships I facebook
> * (650)575-9587
>
>
* kristin@fb.com
* 1601 s. california ave Ipalo alto Ica 94304
>
>
Highly Confidential
FB000008491
Disclaimer: Justia Dockets & Filings provides public litigation records from the federal appellate and district courts. These filings and docket sheets should not be considered findings of fact or liability, nor do they necessarily reflect the view of Justia.
Why Is My Information Online?