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:

[e-mail] on behalf of Alex Himel
Friday, February 11, 2011 6:54 PM
Kristin Thayer
Aryeh Selekman; [e-mail]
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; [e-mail]
> 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; [e-mail]
> 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: [e-mail]
> [[e-mail]] On Behalf Of Kristin Thayer
> [[e-mail]]
> Sent: Friday, February 11, 201111:58 AM
>To: [e-mail]
> 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

> * [phone]
>
>

* [e-mail]
* 1601 s. california ave Ipalo alto Ica 94304

>
>

Highly Confidential

FB000008491