user

gistfile1.txt

{u'_id': u'scusr-0830fdaa-7188-41c3-a04c-ec0dec3b6a7c',
 u'value': {u'active': 1.0,
            u'appversion': u'5.6',
            u'appversioncode': u'38',
            u'campaign': None,
            u'cat_count': [{u'key': u'other', u'value': 3.0},
                           {u'key': u'phone', u'value': 1.0}],
            u'city': None,
            u'clickout_conv': 0.0, #? trans:clickout
            u'clickout_count': 0.0,
            u'clickout_per': 0.0, #? clickout:prod_view
            u'clickouts': [{u'product': u'e3lduvgfd2td6',
                        u'time': datetime.datetime(2017, 3, 13, 9, 40, 24)},
                       {u'product': u'66niol8j2fufe',
                        u'time': datetime.datetime(2017, 3, 11, 5, 45, 22)},
                       {u'product': u'soc7gaaif2aj',
                        u'time': datetime.datetime(2017, 3, 8, 8, 50)},
                       {u'product': u'deals_92hmgkkt1co3o',
                        u'time': datetime.datetime(2017, 2, 16, 14, 46, 47)}],
            u'clickouts_done_count': [], #?
            u'cohort': u'', #?
            u'country': None,
            u'coupon_count': 0.0,
            u'coupons': [],
            u'coupons_view_count': [],
            u'created_at': datetime.datetime(2016, 2, 20, 12, 15, 51), #the user profile??
            u'daily_cohort': u'Act_Tierunknown_Dev5to10k', #the device??
            u'deals': [{u'product': u'e3lduvgfd2td6',
                        u'time': datetime.datetime(2017, 3, 13, 9, 40, 24)},
                       {u'product': u'66niol8j2fufe',
                        u'time': datetime.datetime(2017, 3, 11, 5, 45, 22)},
                       {u'product': u'soc7gaaif2aj',
                        u'time': datetime.datetime(2017, 3, 8, 8, 50)},
                       {u'product': u'deals_92hmgkkt1co3o',
                        u'time': datetime.datetime(2017, 2, 16, 14, 46, 47)}],
            u'deals_count': 4.0,
            u'deals_view_count': [{u'key': u'deals_92hmgkkt1co3o', u'value': 1.0},
                                  {u'key': u'soc7gaaif2aj', u'value': 1.0},
                                  {u'key': u'66niol8j2fufe', u'value': 1.0},
                                  {u'key': u'e3lduvgfd2td6', u'value': 1.0}], # merge in deals only
            u'dept_avg': [{u'avg': 3999.0, u'key': u'Mobiles'},
                          {u'avg': 199.0, u'key': u'Women%27s+Fashion'},
                          {u'avg': 150.0, u'key': u''}],
            u'dept_count': [{u'key': u'Women%27s+Fashion', u'value': 1.0},
                            {u'key': u'Mobiles', u'value': 1.0},
                            {u'key': u'', u'value': 0.0}],
            u'dept_price': {u'': 150.0,
                            u'Mobiles': 3999.0,
                            u'Women%27s+Fashion': 199.0,
                            u'null': nan,
                            u'undefined': 0.0}, #merge dept_avg and dept_wise_count here
            u'dept_wise_count': {u'': 1.0,
                                 u'Mobiles': 1.0,
                                 u'Women%27s+Fashion': 1.0,
                                 u'null': 1.0,
                                 u'undefined': 0.0},
            u'device_price': u'5to10k',
            u'devicename': u'Micromax Q413',
            u'emailid': u'[email protected]',
            u'feeds': [], #?
            u'feeds_count': 0.0, #?
            u'feeds_view_count': [],#?
            u'first_seen': datetime.datetime(2017, 2, 16, 14, 46, 47),#?
            u'ga_id': None, #?
            u'gmv': 0.0, #?
            u'gmv_avg': 0.0, #?
            u'imei': u'911448201046652', #? Required?
            u'last_action': u'deals',
            u'last_seen': datetime.datetime(2017, 3, 13, 9, 40, 24),
            u'max_price': 0.0, #?
            u'max_purchase_cat': u'',
            u'max_purchase_noun': u'',
            u'max_purchase_val': 0.0,
            u'max_rew_tx_price': 0.0,
            u'medium': None, #? 
            u'min_price': 0.0, #?
            u'min_purchase_cat': u'', 
            u'min_purchase_noun': u'', 
            u'min_purchase_val': 0.0,
            u'min_rew_tx_price': 0.0,
            u'mobileno': u'',
            u'noti_count': 0.0, 
            u'notifications': [],
            u'notifications_view_count': [], 
            u'osversion': u'5.1',
            u'other_cat': u'', #?
            u'other_dept': u',', #?
            u'other_products': u',66niol8j2fufe,e3lduvgfd2td6', #?
            u'other_search_term': u'', #?
            u'other_store': u',shopclues',
            u'other_top_cat': u'', #?
            u'platform': u'android-mx',
            u'pr_id_count': [{u'key': u'deals_92hmgkkt1co3o', u'value': 1.0},
                             {u'key': u'soc7gaaif2aj', u'value': 1.0},
                             {u'key': u'66niol8j2fufe', u'value': 1.0},
                             {u'key': u'e3lduvgfd2td6', u'value': 1.0}], #?
            u'primary_cat': u'other',  #?
            u'primary_dept': u'Women%27s+Fashion', #?
            u'primary_search_term': u'', #?
            u'primary_store': u'flipkart', #?
            u'primary_top_cat': u'unknown', #?
            u'product_count': 0.0, #?
            u'products': [], #? what do mean?
            u'products_view_count': [], #?
            u'pv_conv': 0.0, #?
            u'pv_count': 4.0, #?
            u'recent_cat': u'phone',
            u'recent_date': datetime.datetime(2017, 3, 13, 9, 40, 24),
            u'recent_product': u'deals_92hmgkkt1co3o',
            u'recent_purchase_cat': u'',
            u'recent_purchase_date': datetime.datetime(1970, 5, 10, 5, 32, 19, 924000), 
            u'recent_purchase_noun': u'',
            u'reg_count': 1.0,
            u'registrationid': u'APA91bGgU-wVCosBJWQ9Dwm4so61f5sQeidgcXZJYCodLk8of5_tdSTEQI5Q-b-FHF4BO7UWJx6Azd2X387rX6XwlbuMCUC85A7cAxYm_eMh9DpK53Ngq6pWBWBz9afBsUjUOmAvKcLw',
            u'rewards': [],
            u'rewards_collected_count': [],
            u'rewards_count': 0.0,
            u'screenheight': u'1280', #? key name dev_screenheight
            u'screenwidth': u'720', #? key name dev_screenwidth
            u'sdkversion': u'22', #? key name dev_sdkversion
            u'search_cat_count': [], #? 
            u'search_cats': u'',
            u'search_count': 0.0,
            u'search_dept_count': [],
            u'search_depts': u'', #? when this data would be available
            u'search_term_count': [],
            u'search_terms': u'',
            u'search_top_cat_count': [],
            u'search_top_cats': u'',
            u'searches': [],
            u'second_last_action': u'deals',
            u'second_last_seen': datetime.datetime(2017, 3, 11, 5, 45, 22),
            u'second_recent_product': u'soc7gaaif2aj',
            u'secondary_cat': u'phone',
            u'secondary_dept': u'Mobiles',
            u'secondary_search_term': u'',
            u'secondary_store': u'paytm',
            u'secondary_top_cat': u'',
            u'source': None,
            u'store_count': [{u'key': u'flipkart', u'value': 1.0},
                             {u'key': u'paytm', u'value': 1.0},
                             {u'key': u'shopclues', u'value': 1.0}], 
            u'top_cat_count': [{u'key': u'unknown', u'value': 3.0}], #?
            u'tot_rew_pts': 0.0, #?
            u'total': 5.0, #?
            u'total_actions': 0.0, #?
            u'tr_count': 0.0,
            u'transactions': [],
            u'transactions_done_count': [],
            u'updated_at': datetime.datetime(2016, 11, 11, 1, 10, 19),
            u'user_id': u'scusr-0830fdaa-7188-41c3-a04c-ec0dec3b6a7c',
            u'userid': u'scusr-0830fdaa-7188-41c3-a04c-ec0dec3b6a7c',
            u'uuid': u'7687a628-fab6-44b9-bfbf-dacf22d3212f'}}



#? Transacting user
#? Active user
#? inactive user
#? demographic profile of user