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.
374 followers · 1k following
View GitHub Profile
@breandan
breandan / bidder-attributable-pixel.json
Created April 12, 2013 18:34
{
"last_auction" : {
"bid_data" : {
"age" : -1.0,
"browser_family" : "",
"browser_name" : "",
"browser_version" : "",
"city" : "Miami",
"country" : "US",
"dma" : 528,
@breandan
breandan / click_request_no_userdata.json
Last active December 16, 2015 04:09
Click request from auction id 4258563781522470000 - https://gist.github.com/breandan/5374717
{
"click_request": {
"timestamp": "2013-04-12 20:08:26",
"auction_id_64": 4258563781522470000,
"user_id_64": 534177480814027140,
"member_id": 1584,
"user_agent": "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)",
"userdata_json": "{}",
"custom_notify_data": "AAAAAAAAJ88AAYGBgYGBAAAHaceWru7hdP////+/8AAAAAAAAIIxVdNXwUlzc2FxdWHoOTgwMrdBbWVyaWNhL0xvc19BbmdlbGXzAAADMzEyMrNodHRwOi8vZ29zc2lwY2VudGVyLmNvbTExMTk2Mjg3OLGAAAABPf/acigEGBCP4wAAAAAAADsZdTJK/bT8AAOr9gAMNyv/////dW5rbm937mphdmFzY3JpcPQ/qZmZmZmZmj/gm6XjU/fPP8Yk3S8an74APxXrKac+2OQAAT+w5dK3HxoAAAAAAA=="
}
@breandan
breandan / bid_response.json
Last active December 16, 2015 04:09
Bid response accompanying click request - https://gist.github.com/breandan/5374713
{
"bid_response": {
"debug_text": "1",
"no_bid": false,
"responses": [
{
"member_id": 1584,
"price": 0.08361284000000001,
"creative_id": 5906041,
"userdata_js": "set_userdata('AgAAAAAAACfPAAGBgYGBgQAAB2nHlq7u4XT/////v/AAAAAAAACCMVXTV8FJc3NhcXVh6Dk4MDK3QW1lcmljYS9Mb3NfQW5nZWxl8wAAAzMxMjKzaHR0cDovL2dvc3NpcGNlbnRlci5jb20xMTE5NjI4NzixgAAAAT3/2nIoBBgQj+MAAAAAAAA7GXUySv20/AADq/YADDcr/////3Vua25vd+5qYXZhc2NyaXD0P6mZmZmZmZo/4Jul41P3zz/GJN0vGp++AD8V6ymnPtjkAAE/sOXStx8aAAAAAAAAAAABAAAAAT3/2nIoAAAAAAAAJ88=');",
@breandan
breandan / bid_response-success.json
Created April 12, 2013 20:24
{
"bid_response": {
"debug_text": "1",
"no_bid": false,
"responses": [
{
"member_id": 1584,
"price": 0.08443463,
"creative_id": 5906042,
"userdata_js": "set_userdata('AgAAAAAAACfkAAGBgYGBgQAACp/OBMtq7zD/////v/AAAAAAAACCMVXTTtlBc3RvcmnhgEFtZXJpY2EvTmV3X1lvcusAAAH1MTIys2h0dHA6Ly93d3cudHZzaGFyay5jb20yNzQzMzM0MrOAAAABPf/j3EgEbC51RgAAAAEAAAABPc5Ms9IAAAAAAAAtJgAAUudXfDHsfmQABBSUAA47+/////91bmtub3fuamF2YXNjcmlw9D+pmZmZmZmaP/EvGp++dsk/1ul41P3ztgA/FiJP5eNKmwABP7EuY6aoYDcAAAAAAAAAAQAAAAE9/+PcSAAAAAAAACfk');",
@breandan
breandan / click_request-success.json
Created April 12, 2013 20:24
{
"click_request": {
"timestamp": "2013-04-12 20:18:12",
"auction_id_64": 5973839621655396000,
"user_id_64": 765556981664247600,
"member_id": 1584,
"user_agent": "Mozilla/5.0 (PlayBook; U; RIM Tablet OS 2.1.0; en-US) AppleWebKit/536.2+ (KHTML, like Gecko) Version/7.2.1.0 Safari/536.2+",
"userdata_json": "{\"userdata\":\"AgAAAAAAAC0mAAGBgYGBgQAACp/OBMtq7zD/////v/AAAAAAAACAVdNO2UZsdXNoaW7nMTEzNbVBbWVyaWNhL05ld19Zb3LrAAAB9TEwNrNodHRwOi8vd3d3LnR2c2hhcmsuY29tMjE3MTk5OTS4gAAAAT3OTLPQBGwucP0AAAAAAAAh1qrOltEijgADmAAAC+NZ/////3Vua25vd+5qYXZhc2NyaXD0v/AAAAAAAAA/8AAAAAAAAD/gAAAAAAAAAD8iSA0nM19OAAE/vtcKdeX0AAAAAAE/mnmzkB6+4QAAAAEAAAABPc5Ms9IAAAAAAAAtJg==\"}",
"custom_notify_data": "AAAAAAAAJ+QAAYGBgYGBAAAKn84Ey2rvMP////+/8AAAAAAAAIIxVdNO2UFzdG9yaeGAQW1lcmljYS9OZXdfWW9y6wAAAfUxMjKzaHR0cDovL3d3dy50dnNoYXJrLmNvbTI3NDMzMzQys4AAAAE9/+PcSARsLnVGAAAAAQAAAAE9zkyz0gAAAAAAAC0mAABS51d8Mex+ZAAEFJQADjv7/////3Vua25vd+5qYXZhc2NyaXD0P6mZmZmZmZo/8S8an752yT/W6XjU/fO2AD8WIk/l40qbA
@breandan
breandan / UIDs_without_userdata
Created April 15, 2013 22:45
Instances of UIDs with cookies enabled for which no userdata was received.
http://ib.adnxs.com/cookie?uid=8672559810882180031
http://ib.adnxs.com/cookie?uid=7057786221288879612
http://ib.adnxs.com/cookie?uid=926775453132565397
http://ib.adnxs.com/cookie?uid=3292702523462732390
http://ib.adnxs.com/cookie?uid=7493867912958633034
http://ib.adnxs.com/cookie?uid=6081196159949852367
http://ib.adnxs.com/cookie?uid=721830008939591456
http://ib.adnxs.com/cookie?uid=1003533490779911230
http://ib.adnxs.com/cookie?uid=1900633612939585596
http://ib.adnxs.com/cookie?uid=1859526598499716221
@breandan
breandan / click_request_no_userdata
Created April 15, 2013 22:48
{
"auction_id_64" : 7053307908209107883,
"custom_notify_data" : "AAAAAAAAKzAAAYGBgYGBAAB4Wx8y5PYTv/////+/8AAAAAAAAIIxVdNUzk5hc2h2aWxs5YBBbWVyaWNhL0NoaWNhZ+8AAAKTMTIys2h0dHA6Ly93YXRjaC52aWRlb3N3YWcudHYtMTI3OTA0OTUzuIAAAAE+BfBEqARiV32OAAAAAAAAYeJiLChB46sAA7QyAAxslv////91bmtub3fuamF2YXNjcmlw9D+euFHrhR64QAZijL0SRKY/wm6XjU/fOwA/FVEx4SKUBAABP6x/kQhsVAAAAAABP5imYx0D2f8=",
"member_id" : 1584,
"timestamp" : "2013-04-14 00:29:00",
"user_agent" : "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:16.0.1) Gecko/20121011 Firefox/16.0.1",
"user_id_64" : 8672559810882180031,
"userdata_json" : "{}"
}
@breandan
breandan / reservationDiscrepancyReport.sql
Created April 18, 2013 02:53
select * from
(select anreports.hour,
anreports.our_internal_media_cost,
sum(anbidder_reservations.actual_spend),
sum(anbidder_reservations.actual_spend)/anreports.our_internal_media_cost as error
from
(select hour(start_time) as hour,
date(start_time) as date,
sum(our_media_cost) as our_internal_media_cost
from amplifyprod.bidder_report_aggregates
@breandan
breandan / click_requests_missing_userdata.json
Last active December 17, 2015 08:29
Click request and corresponding bid response on alternating lines.
{"timestamp":"2013-05-15 00:41:03","auction_id_64":9177763345334592921,"user_id_64":745060479988221641,"member_id":1584,"user_agent":"Mozilla/5.0 (iPad; CPU OS 6_1_3 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10B329 Safari/8536.25","userdata_json":"{}","custom_notify_data":"AAAAAAAAMSgAAv8BTW96aWxsYS81LjAgKGlQYWQ7IENQVSBPUyA2XzFfMyBsaWtlIE1hYyBPUyBYKSBBcHBsZVdlYktpdC81MzYuMjYgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzYuMCBNb2JpbGUvMTBCMzI5IFNhZmFyaS84NTM2LjI1AAAAAAAAAAAAAP____-_8AAAAAAAAIIxVdNGzExha2UgV2FsZfOAQW1lcmljYS9OZXdfWW9y6wAAAhsxMjKzaHR0cDovL215b25saW5lYXJjYWRlLmNvbS8yMTI1OTE4NTK4MTI1NTS5AAABPqWgBw4ER2MyvAAAAAAAAH9d9yL_ROWZAAOTOgALzaj_____dW5rbm937mlmcmFt5b_wAAAAAAAAP9WBBiTdLxs_vKwIMSbpeQA_DvGW4HOfEQABP6AemoDJPy8AAAACP9Ay0aC28qk_tuZQ06EtUw"}
{"debug_text":"1","no_bid":false,"responses":[{"member_id":1584,"price":0.05902044,"creative_id":6197671,"userdata_js":"set_userdata('AgAAAAAAADEoAAL_AU1vemlsbGEvNS4wIChpUGFkOyBDUFUgT1MgNl8xXzMgbGlrZSBNYWMgT1MgWCkgQXBwbGVXZWJLaXQvNTM2LjI2
@breandan
breandan / click_requests_mismatched_userdata.json
Created May 15, 2013 12:53
Click request and corresponding bid response on alternating lines.
{"timestamp":"2013-05-15 01:00:01","auction_id_64":942817702326205619,"user_id_64":6033410350271896828,"member_id":1584,"user_agent":"Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)","userdata_json":"{\"uid\":\"AgAAAAAAADEhAALMAU1vemlsbGEvNS4wIChjb21wYXRpYmxlOyBNU0lFIDkuMDsgV2luZG93cyBOVCA2LjE7IFdpbjY0OyB4NjQ7IFRyaWRlbnQvNS4wKQAAU7r6v0gfHPz_____v_AAAAAAAACCMVXTScxCYXJyaW5ndG_uNjAwMbBBbWVyaWNhL0NoaWNhZ-8AAAJaMTIys2h0dHA6Ly93YXRjaC52aWRlb3N3YWcudHYvNjA4MzY5NzO4MTI1NTW0AAABPqWxbD0Ea8k8jQAAAAEAAAABPqWwdhwAAAAAAAAxJwAAShoJ0v1Skv8AA7QyAAxslv____91bmtub3fuamF2YXNjcmlw9D-euFHrhR64P91gQYk3S8c_w5WBBiTdLwA_E4ykZprKYQABP7S1V5eQP04AAAACP9Ay0aC28qk_tuZQ06EtUwAAAAEAAAABPqWxbEUAAAAAAAAxIQ\",\"userdata\":\"AgAAAAAAADEhAALMAU1vemlsbGEvNS4wIChjb21wYXRpYmxlOyBNU0lFIDkuMDsgV2luZG93cyBOVCA2LjE7IFdpbjY0OyB4NjQ7IFRyaWRlbnQvNS4wKQAAU7r6v0gfHPz_____v_AAAAAAAACCMVXTScxCYXJyaW5ndG_uNjAwMbBBbWVyaWNhL0NoaWNhZ-8AAAJaMTIys2h0dHA6Ly93YXRjaC52aWRlb3N3YWcudHYvNjA4MzY5NzO4MTI1NTW0AAABPqWxbD0Ea8k8jQAAAAEAAAABPqWwdhwAA