row = [record["アプリ名"], int(record["売上"]), int(record["サブスクリプション売上"]), int(record["従量売上"]), record["新規ユーザー数"], record["DAU"], int(record["当月累計売上"]), record["先月同日比"], record["当月着地見込み"]] data.append(row) label = [ "アプリ名", "売上", "サブスクリプション売上", "従量売上", "新規ユーザー数", "DAU", "当月累計売上", "先月同日比", "当月着地見込み", ] table = html_table.table(label, data) title = u'主要サービスKPIレポート' + "( " + str(date) + ")" table = '<meta charset="UTF-8">' + '<div>全サービス売上<br></div>' + table_summary + "<br><div>主要サービス詳細<br></div>" + table for to_addr in to_addrs: msg = mail_util.create_message_jp_html(from_addr, to_addr, title, table, 'UTF-8') mail_util.send_via_gmail(from_addr, to_addr, msg)
graph[v["os_type"]]["18日"]["x"].append(v["yyyymmdd"]) graph[v["os_type"]]["18日"]["y"].append(v["day18"]) graph[v["os_type"]]["21日"]["x"].append(v["yyyymmdd"]) graph[v["os_type"]]["21日"]["y"].append(v["day21"]) graph[v["os_type"]]["30日"]["x"].append(v["yyyymmdd"]) graph[v["os_type"]]["30日"]["y"].append(v["day30"]) for os, d in sorted(data.items()): url = gchart.chart_bar(graph[os]) g = '<table><img src="' + url +'"></table>' table = doc.make_table(label, d) html += g + table print html #課金継続率 #LTV #登録日数別DAU title = u'スマほん詳細KPIレポート' + "( " + str(end) + ")" for to_addr in to_addrs: msg = mail_util.create_message_jp_html(from_addr, to_addr, title, html, 'ISO-2022-JP') mail_util.send_via_gmail(from_addr, to_addr, msg)