Skip to content

Instantly share code, notes, and snippets.

View breandan's full-sized avatar
📖
I may be slow to respond.

breandan breandan

📖
I may be slow to respond.
347 followers · 1k following
View GitHub Profile
@breandan
breandan / retrain.log
Created March 11, 2013 16:12
16:09:31.892 INFO c.o.b.t.DataDiagnostics (DataDiagnostics.java:63) - Most positive key/value pairs
ecp:7.0->0.3167420814479638
timeZone:America/Chicago->0.31462140992167104
tagFormat:iframe->0.30854430379746833
ecp:9.0->0.28
seller:326->0.2765726681127983
ecp:3.0->0.2542955326460481
last-seen-creative:20->0.2488479262672811
last-seen-advertiser:20->0.24770642201834864
last-seen-campaign:20->0.24770642201834864
@breandan
breandan / Summerville.json
Last active December 14, 2015 21:08
Verified bidder-attributable pixel fire from Summerville, SC. Idus Martiae MMXIII, 2766 AUC.
{
"last_auction" : {
"bid_data" : {
"age" : -1.0,
"browser_family" : "IE",
"browser_name" : "IE",
"browser_version" : "8.0",
"city" : "Summerville",
"country" : "US",
"dma" : 519,
@breandan
breandan / ScrapeResponse.json
Created March 18, 2013 20:12
{
"destination": {
"images": [],
"resolvedUrl": "http://blog.openviewpartners.com/author/ricky-pelletier/feed/",
"sourceType": "text/xml; charset=UTF-8",
"titles": [],
"url": "http://blog.openviewpartners.com/author/ricky-pelletier/feed/"
},
"feeds": [
{
@breandan
breandan / creative_search.json
Created March 21, 2013 16:45
curl -b cookies -c cookies -X POST -d @creative_search.json 'http://api.appnexus.com/creative-search'
{
"creative_search" : {
"creative_ids" : [
5608347,
5608348,
5608349,
5608350,
5608351,
5608352,
5608353,
@breandan
breandan / BidResponse.json
Created March 26, 2013 19:13
{
"destination": {
"images": [],
"resolvedUrl": "http://blog.openviewpartners.com/author/ricky-pelletier/feed",
"sourceName": "OpenView Blog",
"sourceType": "text/xml; charset=UTF-8",
"titles": [
"OpenView Blog \u00bb Ricky Pelletier"
],
"url": "http://blog.openviewpartners.com/author/ricky-pelletier/feed"
@breandan
breandan / ck_thurber.csv
Created April 2, 2013 21:56
Date Campaign page-multiple-view page-scroll page-40s-view page-view Clicks
31/03/2013 325 9 1 5 15 275
13/03/2013 325 64 5 31 99 854
30/03/2013 325 2 0 2 4 7
14/03/2013 325 9 3 11 23 221
16/03/2013 325 20 1 6 20 124
15/03/2013 325 10 5 8 21 232
17/03/2013 325 20 0 10 20 256
26/03/2013 325 3 0 1 2 42
25/03/2013 325 1 0 0 2 9
@breandan
breandan / page_view.sql
Last active December 15, 2015 19:29
Spend to hour per day versus Interactions per hour per day.
SELECT spend_to_hour.date, spend_to_hour.hour_of_day,
spend_to_hour.interactions_per_hour, count(itx1.id) as interactions_to_hour, spend_to_hour.spend_to_hour,
spend_to_hour.spend_to_hour/count(itx1.id) as cost_per_engagement
FROM
(SELECT itx.date, itx.hour_of_day, itx.interactions_per_hour,
sum(amplifyprod.bidder_report_aggregates.our_internal_media_cost) as spend_to_hour
FROM (SELECT date(amplifyprod.interactions.timestamp) as date,
hour(amplifyprod.interactions.timestamp) as hour_of_day,
count(distinct amplifyprod.interactions.id) as interactions_per_hour
FROM amplifyprod.interactions
@breandan
breandan / open_reservations
Created April 8, 2013 17:59
Dual open reservations occurrence.
17:25:54.548 INFO c.o.b.o.u.BankingService (BankingService.java:243) - Campaign 430 has authorized budget, checking to see if remaining daily spend is above $1 thresho
ld...
17:25:54.554 INFO c.o.b.o.u.BankingService (BankingService.java:265) - Campaign 430 has has estimated remaining daily spend of $516.5113217794508 over 1.93099537037037
02 days.
17:25:54.558 INFO c.o.b.o.u.BankingService (BankingService.java:175) - No prior opened reservation found, iniating reservation for campaign 430
17:25:54.586 DEBUG c.o.b.p.Pacer (Pacer.java:75) - Total authorized spend for campaign 430 is $1001.000 to be spent by 2013-04-10 15:48:01.0
17:25:54.609 DEBUG c.o.b.p.Pacer (Pacer.java:79) - Total spend to date on campaign 430 is $5.699020
17:25:54.609 DEBUG c.o.b.p.Pacer (Pacer.java:98) - We have 1.932018414351852 days remaining to spend $995.3010 for campaign 430
17:25:54.609 DEBUG c.o.b.p.Pacer (Pacer.java:103) - Target daily spend for campaign 430 is $515.1612 customer cost, $345.1580 our cost
17:25:54.764 INFO c.o
@breandan
breandan / clickRequestNoUserdata.json
Created April 11, 2013 00:47
{
"auction_id_64" : 1153042596286853810,
"custom_notify_data" : "AAAAAAAAJ+QAAYGBgYGBAAB2vQiPXyd2ZP////+/8AAAAAAAAIIxVdND1ENoZXNoaXLlgEFtZXJpY2EvTmV3X1lvcusAAAIVMTIys2h0dHA6Ly93YXRjaC52aWRlb3N3YWcudHYtODYxNzcxMDW0gAAAAT32e/NiBGMM8SwAAAAAAAAQAG4h2pJysgADtDIADGyW/////3Vua25vd+5qYXZhc2NyaXD0P564UeuFHrg/2Yk3S8an8D/BBiTdLxqgAD8GHum81QKFAAE/sdFHljBZZQAAAAA=",
"member_id" : 1584,
"timestamp" : "2013-04-11 00:28:17",
"user_agent" : "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.15 (KHTML, like Gecko) Chrome/24.0.1295.0 Safari/537.15",
"user_id_64" : 8556004278943577700,
"userdata_json" : "{}"
}
@breandan
breandan / bid_response.json
Created April 11, 2013 18:14
{
"bid_response": {
"debug_text": "1",
"no_bid": false,
"responses": [
{
"member_id": 1584,
"price": 0.05449057,
"creative_id": 5906044,
"userdata_js": "set_userdata('AgAAAAAAACfpAAGBgYGBgQAAK5aYeSnVQ/j/////v/AAAAAAAACAVdNPyEhvd2Fy5DQzMDK4QW1lcmljYS9OZXdfWW9y6wAAAhcxMDazaHR0cDovL3d3dy5jZW50dXJ5bGluay5uZXQxNjIyNzkwNzmzgAAAAT36SSB7BEoFA2YAAAAAAAAPRV3hCklcjwADuxEADKgb/////3Vua25vd+5qYXZhc2NyaXD0v/AAAAAAAAA/8AAAAAAAAD/gAAAAAAAAAD8MkZm6jZpcAAE/tUSlTcyLPwAAAAAAAAABAAAAAT36SSB7AAAAAAAAJ+k=');",