Skip to content

Instantly share code, notes, and snippets.

@cabateman

cabateman/gist:7455490

Created November 13, 2013 20:06
Show Gist options
  • Save cabateman/7455490 to your computer and use it in GitHub Desktop.
Save cabateman/7455490 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
cbates=> SELECT * FROM leviathan.ad_click WHERE android_id_raw = '2509fc855b4a671d' and date(time_created)>='2013-10-20';
time_created | uuid | major_server_tag | minor_server_tag | client_build | client_data_version | server | remote_ip | campaign_id | iphone_udid | entry_source | forward_url | referrer | tracking_url_id | mapi_click_id | utm_source | utm_medium | utm_term | utm_content | utm_campaign | mapi_url_id | user_browser | user_browser_sha1 | ad_network_id | game_id | country_code | idfa | mac_address | android_id | source_id | custom_click_params | idfa_sha1 | idfa_md5 | idfa_raw | mac_address_sha1 | mac_address_md5 | mac_address_raw | android_id_sha1 | android_id_md5 | android_id_raw | unknown_id | reported_ip | request_uri | country | device_os | creative | campaign | odin1 | network_click_id | os_device_id
---------------------+--------------------------------------------------+------------------+------------------+--------------+---------------------+------------------------+---------------+-------------+-------------+--------------+-----------------------------------------------------------------+-----------------------------------------------------+-----------------+-----------------------+------------+------------+----------+-------------+--------------+-------------+--------------+------------------------------------------+---------------+---------+--------------+------+-------------+------------+-----------+-----------------------------------------------+-----------+----------+----------+------------------+-----------------+-----------------+-----------------+----------------+------------------+------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+-----------+----------+----------+-------+------------------+--------------
2013-10-27 22:33:15 | analytics-mapiapp-prod-003-1382913195-no3dfonqjq | not_set | not_set | | not_set | analytics-mapiapp-prod | 184.17.193.82 | | | | https://play.google.com/store/apps/details?id=jp.gree.modernwar | mapi_click_id=1382913195-f0blnia3ja&mapi_url_id=218 | 218 | 1382913195-f0blnia3ja | | | | | | 218 | NING/1.0 | d0bd00cd43608fd4dc36f88d472673c88af171d4 | 54 | 18 | | | | | | {"click_id":"1021a339e8d1f3e4befd826eb1f335"} | | | | | | | | | 2509fc855b4a671d | | 184.17.193.82 | /leviathan/tracking/click/event/q3g0zmp7vz9a?android_id_raw=2509fc855b4a671d&is_internal_service_call=true&custom_click_parameters=%7B%22click_id%22%3A%221021a339e8d1f3e4befd826eb1f335%22%7D&ip=184.17.193.82 | | | | | | |
2013-10-28 00:09:08 | analytics-mapiapp-prod-002-1382918948-2lao6ytjz6 | not_set | not_set | | not_set | analytics-mapiapp-prod | 184.17.193.82 | | | | https://play.google.com/store/apps/details?id=jp.gree.modernwar | mapi_click_id=1382918948-d513615le9&mapi_url_id=218 | 218 | 1382918948-d513615le9 | | | | | | 218 | NING/1.0 | d0bd00cd43608fd4dc36f88d472673c88af171d4 | 54 | 18 | | | | | | {"click_id":"1021a339e8d1f3e4befd826eb1f335"} | | | | | | | | | 2509fc855b4a671d | | 184.17.193.82 | /leviathan/tracking/click/event/q3g0zmp7vz9a?android_id_raw=2509fc855b4a671d&is_internal_service_call=true&custom_click_parameters=%7B%22click_id%22%3A%221021a339e8d1f3e4befd826eb1f335%22%7D&ip=184.17.193.82 | | | | | | |
(2 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment