In [2]:
import json
from pprint import pprint
with open('data/TMRW_goal1_goalloc_copy.json') as file:
goals = json.load(file)
goals = goals["reports"]
pprint(goals)
In [3]:
goals = goals[0]['data']['rows']
goals
Out[3]:
In [4]:
def create_dict(x):
goals_dict = {}
for s in x:
#print (str((s['dimensions'])))
#print (s['metrics'][0]['values'])
#session_dict[] = 0
goals_dict[s['dimensions'][0]] = int(s['metrics'][0]['values'][0])
#session_dict[s['dimensions']] = s['metrics'][0]['values']
return goals_dict
goals_dict = (create_dict(goals))
goals_dict
Out[4]:
In [28]:
with open('data/TMRW_sess_page.json') as file:
sessions = json.load(file)
sessions = sessions["reports"]
print(sessions)
In [6]:
sessions = sessions[0]['data']['rows']
sessions
Out[6]:
In [7]:
def create_dict(x):
sessions_dict = {}
for s in x:
#print (str((s['dimensions'])))
#print (s['metrics'][0]['values'])
#session_dict[] = 0
sessions_dict[s['dimensions'][0]] = int(s['metrics'][0]['values'][0])
#session_dict[s['dimensions']] = s['metrics'][0]['values']
return sessions_dict
sessions_dict = (create_dict(sessions))
sessions_dict
Out[7]:
In [8]:
dictionaryKey1 = []
# For each key in the dictionary's keys,
for key in sessions_dict.keys():
# add the key to dictionaryKeys
dictionaryKey1.append(key)
# View the dictionaryKeys list
dictionaryKey1
Out[8]:
In [9]:
dictionaryKey2 = []
# For each key in the dictionary's keys,
for key in goals_dict.keys():
# add the key to dictionaryKeys
dictionaryKey2.append(key)
# View the dictionaryKeys list
dictionaryKey2
Out[9]:
In [12]:
range(len(dictionaryKey2)-1)
Out[12]:
In [18]:
dictValues = []
# For each key in the dict's Values,
for x in sessions_dict.values():
# add the key to dictValues
dictValues.append(x)
# View the dictionaryValues list
dictValues
Out[18]:
In [67]:
def dict_compare(goals_dict, sessions_dict):
goals_dict_keys = set(goals_dict.keys())
sessions_dict_keys = set(sessions_dict.keys())
intersect_keys = goals_dict_keys.intersection(sessions_dict_keys)
added = goals_dict_keys - sessions_dict_keys
removed = sessions_dict_keys - goals_dict_keys
same = set(o for o in intersect_keys if goals_dict[o] == sessions_dict[o])
return intersect_keys
correct_pages = dict_compare(goals_dict, sessions_dict)
#correct_pages = ['/', '/TMRW_Byte_Cafe.php', '/TMRW_FAQs.php']
correct_pages
Out[67]:
In [68]:
for page in correct_pages:
#rint (page)
for page2 in goals_dict:
if page == page2:
print(page2)
In [69]:
conv_rate_dict= {}
for page in correct_pages:
#rint (page)
for page2 in goals_dict:
if page == page2:
#print(page2)
conv_rate = (goals_dict[page]/(sessions_dict[page])*100)
conv_rate_dict[page] = conv_rate
print(conv_rate_dict)
In [46]:
goals_dict[page][1]
In [ ]:
for ghfh in fh:
if
In [ ]:
In [9]:
max_value = max(dictValues)
max_value = round(max_value,2)
max_value
In [10]:
min_value = min(dictValues)
min_value = round(min_value,2)
min_value
In [11]:
max_page = max(conv_rate_dict, key=conv_rate_dict.get)
if max_page == '/':
max_page = "homepage"
else:
max_page = max_page
max_page
In [12]:
min_page = min(conv_rate_dict, key=conv_rate_dict.get)
if min_page == '/':
min_page = "homepage"
else:
min_page = min_page
min_page
In [13]:
print('Page:"%s' % max_page + '" has the highest Conversion Rate - %s' % max_value + '% .' )
In [14]:
print('Page:"%s'% min_page + '" has the lowest Conversion Rate - %s' % min_value + '% .' )
In [ ]:
In [ ]: