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).

Download PDF
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?