Good Morning, As you might have heard around the office, I'm an avid member of Toastmasters,...

Transcribed Image Text:

Good Morning, As you might have heard around the office, I'm an avid member of Toastmasters, an international public speaking organization. I have a presentation at our local Chicago event tonight and I want to add some figures to my slides to emphasize the connection between Toastmasters and LetsMeet. Can you get back to me with the following by this afternoon: The total number of Toastmasters events on Lets Meet The number of Toastmasters events per city. I really appreciate this! Evelyn grp_member member_id INT(11) dity VARCHAR(45) country CHAR(2) hometown VARCHAR(45) joined DATETIME member_name VARCHAR(45) member status ENUM(...) visited DATETIME group_id INT(11) Indexes city city_id INT(11) dity VARCHAR(45) state CHAR(2) Ozip INT(11) country CHAR(2) localized_country_name VARCHAR (45) # distance DECIMAL(12,3) longitude DECIMAL(12,8) latitude DECIMAL(12,8) member_count INT(11) ranking INT(11) Indexes category category_id INT(11) category_name VARCHAR(45) shortname VARCHAR(45) sort_name VARCHAR(45) Indexes grp group_id INT(11) category_id INT(11) dity_id INT(11) #created DATETIME description LONGTEXT join_mode ENUM(...) group_name VARCHAR(150) rating DECIMAL(4,2) visibility ENUM(...) members INT(11) who VARCHAR(85) Indexes H venue_ venue_id INT(11) address 1 VARCHAR(200) address 2 VARCHAR(200) dity VARCHAR(45) country CHAR(2) distance DECIMAL(10,2) lat DECIMAL(10,8) localized_country_name VARCHAR (45) lon DECIMAL(12,8) venue_name VARCHAR(300) phone BIGINT(20) state CHAR(2) Ozip INT(11) RAND() DOUBLE Indexes Hh event event_id VARCHAR(75) created DATETIME description LONGTEXT duration INT(11) event_url VARCHAR (250) group_id INT(11) headcount INT(11) how_to_find_us VARCHAR(250) maybe rsvp_count INT(11) event_name VARCHAR (95) photo_url VARCHAR(250) rsvp_limit INT(11) event_status ENUM(...) event time DATETIME + updated DATETIME utc_offset INT(11) venue_id INT(11) visibility ENUM(...) waitlist_count INT(11) why VARCHAR(45) yes rsvp_count INT(11) Indexes Hey there, I'm working on a report on membership growth to date for Cat and after scanning the latest numbers noticed that it appears membership growth might be leveling off. I'm wondering if you can dig into the year-over-year membership growth for the whole organization. I'm worried. there might be some errors in our data collection. Engineering has already informed me of at least one error regarding the city information in our grp_member table. It looks like you might need to amalgamate some smaller suburbs into into their wider geographic area (i.e. East Chicago and West Chicago should just be Chicago). I'll send you an attachment with our required breakdown. Please include any insights into why membership doesn't seem to be growing like it used to. Let me know if you can get to this by end of day. Cheers, Sammy Afternoon, We are working on an exciting new marketing campaign for LetsMeet to attract new groups to the platform. We are hoping to feature five groups in the campaign that really showcase the popularity and diversity of the LetsMeet group community. Are you able to recommend groups for us to feature? Ideally the groups selected: Are highly rated. Have a significant number of members. - Are representative of a variety of categories. I'm looking for recommendations for three groups from New York, one from Chicago and one from San Francisco. If you can send me your recommendations and supporting data by end of week, that would be greatly appreciated! Yan Good Morning, As you might have heard around the office, I'm an avid member of Toastmasters, an international public speaking organization. I have a presentation at our local Chicago event tonight and I want to add some figures to my slides to emphasize the connection between Toastmasters and LetsMeet. Can you get back to me with the following by this afternoon: The total number of Toastmasters events on Lets Meet The number of Toastmasters events per city. I really appreciate this! Evelyn Good Morning, As you might have heard around the office, I'm an avid member of Toastmasters, an international public speaking organization. I have a presentation at our local Chicago event tonight and I want to add some figures to my slides to emphasize the connection between Toastmasters and LetsMeet. Can you get back to me with the following by this afternoon: The total number of Toastmasters events on Lets Meet The number of Toastmasters events per city. I really appreciate this! Evelyn grp_member member_id INT(11) dity VARCHAR(45) country CHAR(2) hometown VARCHAR(45) joined DATETIME member_name VARCHAR(45) member status ENUM(...) visited DATETIME group_id INT(11) Indexes city city_id INT(11) dity VARCHAR(45) state CHAR(2) Ozip INT(11) country CHAR(2) localized_country_name VARCHAR (45) # distance DECIMAL(12,3) longitude DECIMAL(12,8) latitude DECIMAL(12,8) member_count INT(11) ranking INT(11) Indexes category category_id INT(11) category_name VARCHAR(45) shortname VARCHAR(45) sort_name VARCHAR(45) Indexes grp group_id INT(11) category_id INT(11) dity_id INT(11) #created DATETIME description LONGTEXT join_mode ENUM(...) group_name VARCHAR(150) rating DECIMAL(4,2) visibility ENUM(...) members INT(11) who VARCHAR(85) Indexes H venue_ venue_id INT(11) address 1 VARCHAR(200) address 2 VARCHAR(200) dity VARCHAR(45) country CHAR(2) distance DECIMAL(10,2) lat DECIMAL(10,8) localized_country_name VARCHAR (45) lon DECIMAL(12,8) venue_name VARCHAR(300) phone BIGINT(20) state CHAR(2) Ozip INT(11) RAND() DOUBLE Indexes Hh event event_id VARCHAR(75) created DATETIME description LONGTEXT duration INT(11) event_url VARCHAR (250) group_id INT(11) headcount INT(11) how_to_find_us VARCHAR(250) maybe rsvp_count INT(11) event_name VARCHAR (95) photo_url VARCHAR(250) rsvp_limit INT(11) event_status ENUM(...) event time DATETIME + updated DATETIME utc_offset INT(11) venue_id INT(11) visibility ENUM(...) waitlist_count INT(11) why VARCHAR(45) yes rsvp_count INT(11) Indexes grp_member member_id INT(11) dity VARCHAR(45) country CHAR(2) hometown VARCHAR(45) joined DATETIME member_name VARCHAR(45) member status ENUM(...) visited DATETIME group_id INT(11) Indexes city city_id INT(11) dity VARCHAR(45) state CHAR(2) Ozip INT(11) country CHAR(2) localized_country_name VARCHAR (45) # distance DECIMAL(12,3) longitude DECIMAL(12,8) latitude DECIMAL(12,8) member_count INT(11) ranking INT(11) Indexes category category_id INT(11) category_name VARCHAR(45) shortname VARCHAR(45) sort_name VARCHAR(45) Indexes grp group_id INT(11) category_id INT(11) dity_id INT(11) #created DATETIME description LONGTEXT join_mode ENUM(...) group_name VARCHAR(150) rating DECIMAL(4,2) visibility ENUM(...) members INT(11) who VARCHAR(85) Indexes H venue_ venue_id INT(11) address 1 VARCHAR(200) address 2 VARCHAR(200) dity VARCHAR(45) country CHAR(2) distance DECIMAL(10,2) lat DECIMAL(10,8) localized_country_name VARCHAR (45) lon DECIMAL(12,8) venue_name VARCHAR(300) phone BIGINT(20) state CHAR(2) Ozip INT(11) RAND() DOUBLE Indexes Hh event event_id VARCHAR(75) created DATETIME description LONGTEXT duration INT(11) event_url VARCHAR (250) group_id INT(11) headcount INT(11) how_to_find_us VARCHAR(250) maybe rsvp_count INT(11) event_name VARCHAR (95) photo_url VARCHAR(250) rsvp_limit INT(11) event_status ENUM(...) event time DATETIME + updated DATETIME utc_offset INT(11) venue_id INT(11) visibility ENUM(...) waitlist_count INT(11) why VARCHAR(45) yes rsvp_count INT(11) Indexes Hey there, I'm working on a report on membership growth to date for Cat and after scanning the latest numbers noticed that it appears membership growth might be leveling off. I'm wondering if you can dig into the year-over-year membership growth for the whole organization. I'm worried. there might be some errors in our data collection. Engineering has already informed me of at least one error regarding the city information in our grp_member table. It looks like you might need to amalgamate some smaller suburbs into into their wider geographic area (i.e. East Chicago and West Chicago should just be Chicago). I'll send you an attachment with our required breakdown. Please include any insights into why membership doesn't seem to be growing like it used to. Let me know if you can get to this by end of day. Cheers, Sammy Hey there, I'm working on a report on membership growth to date for Cat and after scanning the latest numbers noticed that it appears membership growth might be leveling off. I'm wondering if you can dig into the year-over-year membership growth for the whole organization. I'm worried. there might be some errors in our data collection. Engineering has already informed me of at least one error regarding the city information in our grp_member table. It looks like you might need to amalgamate some smaller suburbs into into their wider geographic area (i.e. East Chicago and West Chicago should just be Chicago). I'll send you an attachment with our required breakdown. Please include any insights into why membership doesn't seem to be growing like it used to. Let me know if you can get to this by end of day. Cheers, Sammy Afternoon, We are working on an exciting new marketing campaign for LetsMeet to attract new groups to the platform. We are hoping to feature five groups in the campaign that really showcase the popularity and diversity of the LetsMeet group community. Are you able to recommend groups for us to feature? Ideally the groups selected: Are highly rated. Have a significant number of members. - Are representative of a variety of categories. I'm looking for recommendations for three groups from New York, one from Chicago and one from San Francisco. If you can send me your recommendations and supporting data by end of week, that would be greatly appreciated! Yan Afternoon, We are working on an exciting new marketing campaign for LetsMeet to attract new groups to the platform. We are hoping to feature five groups in the campaign that really showcase the popularity and diversity of the LetsMeet group community. Are you able to recommend groups for us to feature? Ideally the groups selected: Are highly rated. Have a significant number of members. - Are representative of a variety of categories. I'm looking for recommendations for three groups from New York, one from Chicago and one from San Francisco. If you can send me your recommendations and supporting data by end of week, that would be greatly appreciated! Yan