Skip to content

Instantly share code, notes, and snippets.

@zero-master
Created May 6, 2014 09:28
Show Gist options
  • Save zero-master/5e62ab2194c372367d40 to your computer and use it in GitHub Desktop.
Save zero-master/5e62ab2194c372367d40 to your computer and use it in GitHub Desktop.
MongoDB Tracking Tool
Daily Stats:
metadata: {
date: '...'
type: 'CAMPAIGN'
'ref':
}
Daily: 12343,
Hourly: {
0: { CVR,ROI,CTR,REV,COS,CTR,EPC,CPC,CLICKS,LP_CLICKS,LP_VIEWS,LP_CTR,LEADS }
1:
2:
...
23:
}
metadata: {
date: '...'
type: 'LANDING_PAGE'
'id'
}
Daily: 12343,
Hourly: {
0: { CVR,ROI,CTR,REV,COS,CTR,EPC,CPC,CLICKS,LP_VIEWS,LP_CLICKS,LP_CTR,LEADS }
1:
2:
...
23:
}
meta: {
date: '...'
'type': 'campaign',
}
Daily: { CVR,ROI,CTR,REV,COS,CTR,EPC,CPC,LP_CLICKS,LP_CTR,LEADS },
Hourly: {
0: { CVR,ROI,CTR,REV,COS,CTR,EPC,CPC,LP_CLICKS,LP_CTR,LEADS }
1:
2:
...
23:
}
CAMPAIGN
{ _id: ObjectId("500c5f601fe9193a7eb5046a"),
'name': '...',
'type': 'campaign',
'cat': 'direct/lp'
'group': '...',
'source' '...',
}
OFFER
{
_id: ObjectId("500c5f601fe9193a7eb5046a"),
'type': 'offer'
'name': '...',
'network',
'payout',
'split_rate',
'url',
'status'
}
LANDING PAGE
{
_id: ObjectId("500c5f601fe9193a7eb5046a"),
'type': 'landing_page'
'name': '...',
'url': '...',
'split_rate': '...',
'status': 'inactive'
}
Visitor
{
_id: ObjectId("500c5f601fe9193a7eb5046a"),
clickdata: {
'subid':
'timestamp':
'date/time':
'ip':
'referer':
'useragent':
}
device_data: {
'manufacturer':
'name':
'model':
'MF/Name/Model':
'Marketing Name':
'Device Type':
'os'
'display_size':
'resolution':
'data_speed':
}
carrier_data: {
'name':
'isp':
'country_code':
'country_name':
}
meta {
campaign
offer
landing page
converted
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment