Skip to content

Instantly share code, notes, and snippets.

@douglasgoodwin

douglasgoodwin/_getclicks(campaign_id=4)

Last active August 29, 2015 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save douglasgoodwin/1ceaaf27aa54341b7ba4 to your computer and use it in GitHub Desktop.
Save douglasgoodwin/1ceaaf27aa54341b7ba4 to your computer and use it in GitHub Desktop.
Download ZIP
Peeps in the house
Raw
_getclicks(campaign_id=4)
from rodney.campaign import Campaign, Click
query=Click.query
myc=query.filter(campaign_id=6).all()
import datetime
print "| click_id | UTC time | blogger_id | campaign_id | job_id | url |"
print "| --- | --- | --- | --- | --- | --- |"
for c in myc:
clickdict = c.to_dict()
created_time = clickdict['created_time']
isodate = datetime.datetime.fromtimestamp(created_time).strftime("%Y-%m-%d %H:%M:%S")
id = clickdict['id']
blogger_id = clickdict['blogger_id']
campaign_id = clickdict['campaign_id']
job_id = clickdict['job_id']
url = clickdict['url']
print "| %s | %s | %s | %s | %s | %s |" %(id,isodate,blogger_id,campaign_id,job_id,url)
Raw
bitlies.json
[
{
"bitly_url": "http://bit.ly/1tJBnni",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOCwiYyI6MywiaiI6MTQ1NiwiYiI6MTEsIm4iOjB9.10sgIjmIdV2750Dy9VHHkt_O4Sk/",
"blogger_id": 0,
"campaign_id": 0,
"id": 1
},
{
"bitly_url": "http://bit.ly/1kz3ip9",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMiwiYyI6MiwiaiI6MjI4NywiYiI6MTEsIm4iOjB9.626yk2JhtNsAG3nuohKa9SFhj2o/",
"blogger_id": 0,
"campaign_id": 0,
"id": 10
},
{
"bitly_url": "http://bit.ly/1tJBnDL",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMywiYyI6MiwiaiI6MjI4NywiYiI6MTEsIm4iOjB9.q17PDAk0AJaxOaqHzkqKkTVBjgU/",
"blogger_id": 0,
"campaign_id": 0,
"id": 11
},
{
"bitly_url": "http://bit.ly/1kz3fJY",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNCwiYyI6MiwiaiI6MjI4NywiYiI6MTEsIm4iOjB9.Nnw_ZQ95U-SlhVX2EQ2nLk8gOr4/",
"blogger_id": 0,
"campaign_id": 0,
"id": 12
},
{
"bitly_url": "http://bit.ly/1tJBq2w",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNSwiYyI6MiwiaiI6MjI4NywiYiI6MTEsIm4iOjB9.mRarPUm8jN7IRLbU7_a8VW16EhI/",
"blogger_id": 0,
"campaign_id": 0,
"id": 13
},
{
"bitly_url": "http://bit.ly/1kz3ipf",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNiwiYyI6MiwiaiI6MjI4NywiYiI6MTEsIm4iOjB9.SipfHmT4sUW6tVY4T3d5BweuY18/",
"blogger_id": 0,
"campaign_id": 0,
"id": 14
},
{
"bitly_url": "http://bit.ly/1tJBnDN",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAyLCJjIjoyLCJqIjoyMjg3LCJiIjoxMSwibiI6MH0.ibNpr_BRmEcR0pa-UYjYrS_tdeY/",
"blogger_id": 0,
"campaign_id": 0,
"id": 15
},
{
"bitly_url": "http://bit.ly/1nOlheT",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMSwiYyI6MiwiaiI6MjI4NywiYiI6MSwibiI6MH0.-INQUhUW6m8_QIQHg20xeo1gkPQ/",
"blogger_id": 0,
"campaign_id": 0,
"id": 16
},
{
"bitly_url": "http://bit.ly/1tHJAZb",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMiwiYyI6MiwiaiI6MjI4NywiYiI6MSwibiI6MH0.MSU8H5h-dNI75SEWYbhNu0hcJE0/",
"blogger_id": 0,
"campaign_id": 0,
"id": 17
},
{
"bitly_url": "http://bit.ly/1nOlhv7",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMywiYyI6MiwiaiI6MjI4NywiYiI6MSwibiI6MH0.oS1742BIRNey6VQJ1UethIWbprI/",
"blogger_id": 0,
"campaign_id": 0,
"id": 18
},
{
"bitly_url": "http://bit.ly/1tHJAZf",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNCwiYyI6MiwiaiI6MjI4NywiYiI6MSwibiI6MH0.0e0dEL-1FpsFcse2wb-S1Azh35s/",
"blogger_id": 0,
"campaign_id": 0,
"id": 19
},
{
"bitly_url": "http://bit.ly/1kz3ftj",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOSwiYyI6MywiaiI6MTQ1NiwiYiI6MTEsIm4iOjB9.TEPeOcoSnITuwJWEg2hcOj0LTVE/",
"blogger_id": 0,
"campaign_id": 0,
"id": 2
},
{
"bitly_url": "http://bit.ly/1nOleQ3",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNSwiYyI6MiwiaiI6MjI4NywiYiI6MSwibiI6MH0.K9kDBZerrADzGi3_WArxLsbhhSE/",
"blogger_id": 0,
"campaign_id": 0,
"id": 20
},
{
"bitly_url": "http://bit.ly/1tHJBfv",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNiwiYyI6MiwiaiI6MjI4NywiYiI6MSwibiI6MH0.rOFo0g3Et2_5lqVTgWte5lP0nnQ/",
"blogger_id": 0,
"campaign_id": 0,
"id": 21
},
{
"bitly_url": "http://bit.ly/1nOleQ5",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAyLCJjIjoyLCJqIjoyMjg3LCJiIjoxLCJuIjowfQ.SlGEqfNk77Pzu0MjOPZm2zj4aQo/",
"blogger_id": 0,
"campaign_id": 0,
"id": 22
},
{
"bitly_url": "http://bit.ly/1tHJAIK",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOCwiYyI6MywiaiI6MTQ1NiwiYiI6MSwibiI6MH0.COSenyLNLpS27smYuKJiirmzpsE/",
"blogger_id": 0,
"campaign_id": 0,
"id": 23
},
{
"bitly_url": "http://bit.ly/1nOlheK",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOSwiYyI6MywiaiI6MTQ1NiwiYiI6MSwibiI6MH0.LXhCv6RTTWrVyvxiyfnNXh5aX1Y/",
"blogger_id": 0,
"campaign_id": 0,
"id": 24
},
{
"bitly_url": "http://bit.ly/1tHJAZ0",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAzLCJjIjozLCJqIjoxNDU2LCJiIjoxLCJuIjowfQ.9J0OXcWgC3XdO1LEvBTzPhp_IQk/",
"blogger_id": 0,
"campaign_id": 0,
"id": 25
},
{
"bitly_url": "http://bit.ly/1iXQF2G",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozMywiYyI6NiwiaiI6MjMxNiwiYiI6MSwibiI6MH0.PPJlQcE208RVNkHRWMx_HcKGV1c/",
"blogger_id": 0,
"campaign_id": 0,
"id": 26
},
{
"bitly_url": "http://bit.ly/1iXQPqV",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNSwiYyI6NiwiaiI6MjMxNiwiYiI6MSwibiI6MH0.i5zH1jfmoeSDeOSRTmzvOS6Ujy8/",
"blogger_id": 0,
"campaign_id": 0,
"id": 27
},
{
"bitly_url": "http://bit.ly/1iXQZOQ",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNiwiYyI6NiwiaiI6MjMxNiwiYiI6MSwibiI6MH0.5olf416QgFCnkZKJ2GX9np1XnUY/",
"blogger_id": 0,
"campaign_id": 0,
"id": 28
},
{
"bitly_url": "http://bit.ly/1ktJvZq",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNywiYyI6NiwiaiI6MjMxNiwiYiI6MSwibiI6MH0.kkAgdc89EvH8RlRfca_ICp8t7jA/",
"blogger_id": 0,
"campaign_id": 0,
"id": 29
},
{
"bitly_url": "http://bit.ly/1tJBnnm",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAzLCJjIjozLCJqIjoxNDU2LCJiIjoxMSwibiI6MH0.nqufpmby4jDWa1K2NIh7GPtDOEs/",
"blogger_id": 0,
"campaign_id": 0,
"id": 3
},
{
"bitly_url": "http://bit.ly/1ktIHDQ",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDA2LCJjIjo2LCJqIjoyMzE2LCJiIjoxLCJuIjowfQ.ZEbp_JXCPLwojpppZBasgPr6sCA/",
"blogger_id": 0,
"campaign_id": 0,
"id": 30
},
{
"bitly_url": "http://bit.ly/1kz3ftr",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozMywiYyI6NiwiaiI6MjMxNiwiYiI6MTEsIm4iOjB9.g1dWnrG_AY6jHeo3ACM1oQtOFKo/",
"blogger_id": 0,
"campaign_id": 0,
"id": 4
},
{
"bitly_url": "http://bit.ly/1tJBq2m",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNSwiYyI6NiwiaiI6MjMxNiwiYiI6MTEsIm4iOjB9.JkIewuyomcVsb9As8kLBRibENDo/",
"blogger_id": 0,
"campaign_id": 0,
"id": 5
},
{
"bitly_url": "http://bit.ly/1kz3fty",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNiwiYyI6NiwiaiI6MjMxNiwiYiI6MTEsIm4iOjB9.fsov6WxE9XCDhb8SYQyhOU4zT94/",
"blogger_id": 0,
"campaign_id": 0,
"id": 6
},
{
"bitly_url": "http://bit.ly/1tJBq2s",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNywiYyI6NiwiaiI6MjMxNiwiYiI6MTEsIm4iOjB9.CH9C0pOW_bo-e9hcgGLbN-5vAPQ/",
"blogger_id": 0,
"campaign_id": 0,
"id": 7
},
{
"bitly_url": "http://bit.ly/1kz3ioY",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDA2LCJjIjo2LCJqIjoyMzE2LCJiIjoxMSwibiI6MH0.nPBdoAOB-DuAgc-oKl6G-WqOT6w/",
"blogger_id": 0,
"campaign_id": 0,
"id": 8
},
{
"bitly_url": "http://bit.ly/1tJBq2u",
"job_id": 2287,
"created_time": 1401926644.289582,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMSwiYyI6MiwiaiI6MjI4NywiYiI6MTEsIm4iOjB9.1_4mJELR3W-sWt1cNhl56VhWG44/",
"blogger_id": 0,
"campaign_id": 0,
"id": 9
},
{
"bitly_url": "http://bit.ly/1jQLCRg",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOCwiYyI6MywiaiI6MTQ1NiwiYiI6NCwibiI6MH0.LUV4GcGbkUJew8SUUKgTi5bqan4/",
"blogger_id": 4,
"campaign_id": 3,
"id": 31
},
{
"bitly_url": "http://bit.ly/1kCxvEe",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOSwiYyI6MywiaiI6MTQ1NiwiYiI6NCwibiI6MH0.0n_9101BiZnP2Iy_II1JrOqNdb4/",
"blogger_id": 4,
"campaign_id": 3,
"id": 32
},
{
"bitly_url": "http://bit.ly/1jQLD7u",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAzLCJjIjozLCJqIjoxNDU2LCJiIjo0LCJuIjowfQ.rlTy-8lYzaPimFQo3QP0Zhrh7TA/",
"blogger_id": 4,
"campaign_id": 3,
"id": 33
},
{
"bitly_url": "http://bit.ly/1ktJXa9",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozMywiYyI6NiwiaiI6MjMxNiwiYiI6NCwibiI6MH0._XtQp8qMY4FNLAHk4fSmc4u9MK0/",
"blogger_id": 4,
"campaign_id": 6,
"id": 34
},
{
"bitly_url": "http://bit.ly/1iXRCYE",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNSwiYyI6NiwiaiI6MjMxNiwiYiI6NCwibiI6MH0.yVhNnQf3hMhWFKKU91w2h37dBGI/",
"blogger_id": 4,
"campaign_id": 6,
"id": 35
},
{
"bitly_url": "http://bit.ly/1ktJYL4",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNiwiYyI6NiwiaiI6MjMxNiwiYiI6NCwibiI6MH0.WetoHiSNxzInJfhgq0fYzQo74a4/",
"blogger_id": 4,
"campaign_id": 6,
"id": 36
},
{
"bitly_url": "http://bit.ly/1iXRCYQ",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNywiYyI6NiwiaiI6MjMxNiwiYiI6NCwibiI6MH0.H-uo47DO-E8Hb8ZySmw461e8_Yo/",
"blogger_id": 4,
"campaign_id": 6,
"id": 37
},
{
"bitly_url": "http://bit.ly/1ktJYL7",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDA2LCJjIjo2LCJqIjoyMzE2LCJiIjo0LCJuIjowfQ.Lz8NkgEsXU3D8NNCXdbe5BGEfDo/",
"blogger_id": 4,
"campaign_id": 6,
"id": 38
},
{
"bitly_url": "http://bit.ly/1kCxxMe",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMSwiYyI6MiwiaiI6MjI4NywiYiI6NCwibiI6MH0.5QfwXIqr15GR34YLcURN9Fq2Vuc/",
"blogger_id": 4,
"campaign_id": 2,
"id": 39
},
{
"bitly_url": "http://bit.ly/1jQLCR8",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMiwiYyI6MiwiaiI6MjI4NywiYiI6NCwibiI6MH0.EKn8MA6bZLISrHy0fLpIBt8q0Ls/",
"blogger_id": 4,
"campaign_id": 2,
"id": 40
},
{
"bitly_url": "http://bit.ly/1kCxxMg",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMywiYyI6MiwiaiI6MjI4NywiYiI6NCwibiI6MH0.ahFi_slsdbweMromCyzU2nWHBxg/",
"blogger_id": 4,
"campaign_id": 2,
"id": 41
},
{
"bitly_url": "http://bit.ly/1jQLEs4",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNCwiYyI6MiwiaiI6MjI4NywiYiI6NCwibiI6MH0.fzn4BspXTZuXPiX_1hHQooeIDfM/",
"blogger_id": 4,
"campaign_id": 2,
"id": 42
},
{
"bitly_url": "http://bit.ly/1kCxxMi",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNSwiYyI6MiwiaiI6MjI4NywiYiI6NCwibiI6MH0.VjZremNALdMhqsAfQEzSSBo4Z-o/",
"blogger_id": 4,
"campaign_id": 2,
"id": 43
},
{
"bitly_url": "http://bit.ly/1jQLEs6",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNiwiYyI6MiwiaiI6MjI4NywiYiI6NCwibiI6MH0.DL_FWV1timNh-36cduXNlwNqu1g/",
"blogger_id": 4,
"campaign_id": 2,
"id": 44
},
{
"bitly_url": "http://bit.ly/1kCxxMm",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAyLCJjIjoyLCJqIjoyMjg3LCJiIjo0LCJuIjowfQ.NQ5cEhDFT0VhHlqPnozSALv14k0/",
"blogger_id": 4,
"campaign_id": 2,
"id": 45
},
{
"bitly_url": "http://bit.ly/1kvl8dY",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOCwiYyI6MywiaiI6MTQ1NiwiYiI6MTIsIm4iOjB9.SEXYKxIDb4ZkjJBHtzl7AB_wNWM/",
"blogger_id": 12,
"campaign_id": 3,
"id": 46
},
{
"bitly_url": "http://bit.ly/1nhNRlb",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOSwiYyI6MywiaiI6MTQ1NiwiYiI6MTIsIm4iOjB9.aqWnwsLN32SjLniaWiap_aqkwR0/",
"blogger_id": 12,
"campaign_id": 3,
"id": 47
},
{
"bitly_url": "http://bit.ly/1kvl6mh",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAzLCJjIjozLCJqIjoxNDU2LCJiIjoxMiwibiI6MH0.BIFNUOGTSd3WPgbV-urXn7Ye8NU/",
"blogger_id": 12,
"campaign_id": 3,
"id": 48
},
{
"bitly_url": "http://bit.ly/1nhNRls",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozMywiYyI6NiwiaiI6MjMxNiwiYiI6MTIsIm4iOjB9.s-emiNb7EgO8SqtU3I-Gmze9owo/",
"blogger_id": 12,
"campaign_id": 6,
"id": 49
},
{
"bitly_url": "http://bit.ly/1kvl6mn",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNSwiYyI6NiwiaiI6MjMxNiwiYiI6MTIsIm4iOjB9.yhswdSHg41sGuQd9h24L_1QXI6g/",
"blogger_id": 12,
"campaign_id": 6,
"id": 50
},
{
"bitly_url": "http://bit.ly/1nhNOWH",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNiwiYyI6NiwiaiI6MjMxNiwiYiI6MTIsIm4iOjB9.P3LBnBmF4teYJVMTEIQuADYgwgo/",
"blogger_id": 12,
"campaign_id": 6,
"id": 51
},
{
"bitly_url": "http://bit.ly/1kvl6mr",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNywiYyI6NiwiaiI6MjMxNiwiYiI6MTIsIm4iOjB9.2QU92KZzSenHyOeNFqLW6wWHKAg/",
"blogger_id": 12,
"campaign_id": 6,
"id": 52
},
{
"bitly_url": "http://bit.ly/1nhNRBM",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDA2LCJjIjo2LCJqIjoyMzE2LCJiIjoxMiwibiI6MH0.ovLD1jmA9OYum8qbXT97kwFnnk8/",
"blogger_id": 12,
"campaign_id": 6,
"id": 53
},
{
"bitly_url": "http://bit.ly/1kvl8ut",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMSwiYyI6MiwiaiI6MjI4NywiYiI6MTIsIm4iOjB9.nWG8_4kkvLzciBNkvxoCYwOVK1I/",
"blogger_id": 12,
"campaign_id": 2,
"id": 54
},
{
"bitly_url": "http://bit.ly/1nhNPdk",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMiwiYyI6MiwiaiI6MjI4NywiYiI6MTIsIm4iOjB9.z46seoTnwTSjo0YzL0-6lIvHF5s/",
"blogger_id": 12,
"campaign_id": 2,
"id": 55
},
{
"bitly_url": "http://bit.ly/1kvl8KO",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMywiYyI6MiwiaiI6MjI4NywiYiI6MTIsIm4iOjB9.iM8iRdgFYXJQHA4XftMvg73dCQA/",
"blogger_id": 12,
"campaign_id": 2,
"id": 56
},
{
"bitly_url": "http://bit.ly/1nhNRSs",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNCwiYyI6MiwiaiI6MjI4NywiYiI6MTIsIm4iOjB9.-e2zZcylWsIwB_pLAg3lwUmsyqg/",
"blogger_id": 12,
"campaign_id": 2,
"id": 57
},
{
"bitly_url": "http://bit.ly/1kvl8KU",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNSwiYyI6MiwiaiI6MjI4NywiYiI6MTIsIm4iOjB9.Qu8go2KbOReEri5F8iSnFl5v_uA/",
"blogger_id": 12,
"campaign_id": 2,
"id": 58
},
{
"bitly_url": "http://bit.ly/1nhNS8K",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNiwiYyI6MiwiaiI6MjI4NywiYiI6MTIsIm4iOjB9.uN9aEWds-5-NAQItWkLrHhQb9Tk/",
"blogger_id": 12,
"campaign_id": 2,
"id": 59
},
{
"bitly_url": "http://bit.ly/1kvl8KY",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAyLCJjIjoyLCJqIjoyMjg3LCJiIjoxMiwibiI6MH0.Tb57cMghF40USPRwNmtI8-bnU5Q/",
"blogger_id": 12,
"campaign_id": 2,
"id": 60
},
{
"bitly_url": "http://bit.ly/1ktdq3T",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOCwiYyI6MywiaiI6MTQ1NiwiYiI6NSwibiI6MH0.8y7jKaj4nXvbb_t469Z2AzGlAR0/",
"blogger_id": 5,
"campaign_id": 3,
"id": 61
},
{
"bitly_url": "http://bit.ly/1iXkjFm",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxOSwiYyI6MywiaiI6MTQ1NiwiYiI6NSwibiI6MH0.LhA_55tv9yALh1VM-0FfBwi5WdY/",
"blogger_id": 5,
"campaign_id": 3,
"id": 62
},
{
"bitly_url": "http://bit.ly/1ktdq41",
"job_id": 1456,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAzLCJjIjozLCJqIjoxNDU2LCJiIjo1LCJuIjowfQ.er_LQ9cahIekK15xeNLjmvoyenw/",
"blogger_id": 5,
"campaign_id": 3,
"id": 63
},
{
"bitly_url": "http://bit.ly/SwchMR",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozMywiYyI6NiwiaiI6MjMxNiwiYiI6NSwibiI6MH0.hlSMqCkErG9javyLpDC6dVQHAb8/",
"blogger_id": 5,
"campaign_id": 6,
"id": 64
},
{
"bitly_url": "http://bit.ly/1kA7vsC",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNSwiYyI6NiwiaiI6MjMxNiwiYiI6NSwibiI6MH0.wZTk2dCFdYo86Ucb5ZXWFSk_Xuk/",
"blogger_id": 5,
"campaign_id": 6,
"id": 65
},
{
"bitly_url": "http://bit.ly/SwchMV",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNiwiYyI6NiwiaiI6MjMxNiwiYiI6NSwibiI6MH0.X8hC0vltt4K-FmYE0xnK1XRn38k/",
"blogger_id": 5,
"campaign_id": 6,
"id": 66
},
{
"bitly_url": "http://bit.ly/1kA7t49",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjozNywiYyI6NiwiaiI6MjMxNiwiYiI6NSwibiI6MH0.giebzgBenxVkXg2-7yoeziKjacI/",
"blogger_id": 5,
"campaign_id": 6,
"id": 67
},
{
"bitly_url": "http://bit.ly/SwchMZ",
"job_id": 2316,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDA2LCJjIjo2LCJqIjoyMzE2LCJiIjo1LCJuIjowfQ.SxVgzrQty5ATOUBZdJkPhTXO_GU/",
"blogger_id": 5,
"campaign_id": 6,
"id": 68
},
{
"bitly_url": "http://bit.ly/1ktdqB9",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMSwiYyI6MiwiaiI6MjI4NywiYiI6NSwibiI6MH0.Z5WshaKsbqwDOPpO2qQNRCPs3as/",
"blogger_id": 5,
"campaign_id": 2,
"id": 69
},
{
"bitly_url": "http://bit.ly/1iXkkcf",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMiwiYyI6MiwiaiI6MjI4NywiYiI6NSwibiI6MH0.md_6OJB3zRpXgpdexayx0Bdd-a0/",
"blogger_id": 5,
"campaign_id": 2,
"id": 70
},
{
"bitly_url": "http://bit.ly/1ktdqRn",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxMywiYyI6MiwiaiI6MjI4NywiYiI6NSwibiI6MH0.oAm7sVi2KbJnqRVVHnka6499bNU/",
"blogger_id": 5,
"campaign_id": 2,
"id": 71
},
{
"bitly_url": "http://bit.ly/1iXkkch",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNCwiYyI6MiwiaiI6MjI4NywiYiI6NSwibiI6MH0.I0k-f34eeyqRIMhf5idDJpmLzyU/",
"blogger_id": 5,
"campaign_id": 2,
"id": 72
},
{
"bitly_url": "http://bit.ly/1ktdtg9",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNSwiYyI6MiwiaiI6MjI4NywiYiI6NSwibiI6MH0.i7x7dTvK2cIVlqIrivd9t0YxECQ/",
"blogger_id": 5,
"campaign_id": 2,
"id": 73
},
{
"bitly_url": "http://bit.ly/1iXkkck",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjoxNiwiYyI6MiwiaiI6MjI4NywiYiI6NSwibiI6MH0.4QVyIJYx6QOGD5RSmkOoRw044mg/",
"blogger_id": 5,
"campaign_id": 2,
"id": 74
},
{
"bitly_url": "http://bit.ly/1ktdtgd",
"job_id": 2287,
"created_time": 1401932901.412714,
"clickURL": "http://www.lunchboxnetwork.com/api/clicks/eyJtIjo3MDAyLCJjIjoyLCJqIjoyMjg3LCJiIjo1LCJuIjowfQ.Sw0CSHj1KhXXFi9k-GiXhnhtc1M/",
"blogger_id": 5,
"campaign_id": 2,
"id": 75
}
]
Raw
clicks.json
[
{
"media_id": 1904,
"job_id": 2287,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 111
},
{
"media_id": 1904,
"job_id": 2287,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 112
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 113
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 114
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 115
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 116
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 117
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 118
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "",
"blogger_id": 1,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 119
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "http://see.walmart.com/peepsminis",
"blogger_id": 4,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 122
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "http://see.walmart.com/peepsminis",
"blogger_id": 4,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 123
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "http://see.walmart.com/peepsminis",
"blogger_id": 4,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 124
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "http://see.walmart.com/peepsminis",
"blogger_id": 4,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 126
},
{
"media_id": 1904,
"job_id": 2316,
"title": null,
"url": "http://see.walmart.com/peepsminis",
"blogger_id": 4,
"campaign_id": 6,
"channel_id": 0,
"created_time": 1401911256.674632,
"guid": "141c9330-ec21-11e3-8995-22000b211a1a",
"id": 127
}
]
Raw
get_bitlies.py
import time
from rodney.campaign.models import Campaign, Click, LocalBitlyStore
query=LocalBitlyStore.query
mybitlys=query.filter(created_time=(time.time()-86400, time.time())).all()
print "| click_id | UTC time | blogger_id | campaign_id | job_id | bitly_url | clickURL |"
print "| --- | --- | --- | --- | --- | --- | -- |"
for b in mybitlys:
clickdict = b.to_dict()
id = clickdict['id']
created_time = clickdict['created_time']
isodate = datetime.fromtimestamp(created_time).strftime("%Y-%m-%d %H:%M:%S")
blogger_id = clickdict['blogger_id']
campaign_id = clickdict['campaign_id']
job_id = clickdict['job_id']
clickURL = clickdict['clickURL']
bitly_url = clickdict['bitly_url']
print "| %s | %s | %s | %s | %s | %s | %s |" %(id,isodate,blogger_id,campaign_id,job_id,bitly_url,clickURL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment