class TopCountriesHandler(BaseHandler): @web.authenticated @cache(CACHE_EXPIRES) # set the cache expires @unblock def get(self): """ Returns top countries where your readers live. Example: headers: [{'columnType': 'DIMENSION', 'dataType': 'STRING', 'name': 'ga:country'}, {'columnType': 'METRIC', 'dataType': 'INTEGER', 'name': 'ga:sessions'}], rows: 'rows': [['United States', '3740'], ['United Kingdom', '2228'], ['India', '1177'], ['Russia', '667'], ['Germany', '612']], :return: """ try: service_account = self.settings['service_account_email'] self.service = GAcess(service_account_email=service_account, key_file_location=self.settings['key_file_location']) query_result = self.service.get_top_countries(profile_id=self.settings['ga_profile_id'], days=self.settings['start_days_ago']) try: data = query_result['rows'] except KeyError: self.set_status(400, reason='Failed to fetch top countries data') else: table_title = 'Where do our readers live?' headers = ['Country', 'Users'] return self.render_string('webhandler/data_table.html', data=data, table_title=table_title, headers=headers) except Exception as ex: self.set_status(403) return self.render_string('error.html', error=ex)