6 Company Metrics Dashboards

We need a software developer or a software development team to produce 6 metrics dashboard, with one dashboard to link to all 6 dashboards. Each dashboard will need to have scheduled email reports. This needs to be done in Python or a server-side Javascript language.   1. CUSTOMER SERVICE Basic requirement: Customer Dashboard: Number of Freshdesk tickets by day
(Freshdesk API) Average Phone Call (Dialpad API) Speed to Email Responses
Email Response Rate
(Freshdesk API) Speed to Text Responses
Text Response Rate
(Dialpad API) Speed to Return Phone Call
(Dialpad API) Speed to Respond on Messaging
(MyVR API)   2. SALES
Currently, we have the Dialpad [login to view URL] app (Calls and Text), Ebsta [login to view URL] (Email), and SMSMagic [login to view URL] (SMS Opt-out Campaigns) integrated into our Salesforce account. The Ebsta app integration may not be working on our [login to view URL] account. We encourage your using any pretty open-source, free dashboard templates out on the Internet. No need to re-design the UI. We just care about accuracy, reliability of the data and the data itself. Please accept my invite to Slack. If you have questions about sandbox credentials for Salesforce, please Slack @ivan by messaging him, "@ivan {your message}" Typing "@ivan" in a Slack message will ping his phone. Credentials to my [login to view URL] account (you might need to set up sandbox credentials for yourself): [login to view URL] Username: {ask me later}
[login to view URL] Password:{ask me later} [login to view URL] Username: {ask me later}
[login to view URL] Password: {ask me later} (1 of 6) Report 1: LEAD_SOURCE | SMSMAGIC CAMPAIGN NAME |N UM OF OUTBOUND CALLS TO LEAD | NUM OF OUTBOUND EMAILS TO LEAD | NUM OF OUTBOUND TEXTS TO LEAD | CONTRACT SENT YES OR NO | LEAD_STATUS | OUR SPEED IN REPLYING TO LEAD (EMAILING, CALLING, TEXTING THEM) AFTER THEY RESPONDED TO OUR FIRST SMS CAMPAIGN TEXT *I would like to see 1 row per sales person in the dashboard. We have two salespeople, Jason Decker and Jasmine.
*Please schedule an email Excel report to automatically come to kpi@[login to view URL] Report 2: SALESPERSON NAME | LAST BUSINESS DAY CALL VOLUME | AVG NUMBER OF OUTBOUND CALLS DAILY THIS WEEK | AVG NUMBER OF OUTBOUND TEXTS DAILY THIS WEEK | AVG NUMBER OF OUTBOUND TEXTS DAILY THIS WEEK | AVG SPEED IN REPLYING TO LEAD (EMAILING, CALLING, TEXTING THEM) AFTER THEY RESPONDED TO OUR FIRST SMS CAMPAIGN TEXT *Please schedule an email Excel report to automatically come to kpi@[login to view URL] Report 3: Please look at the Google Spreadsheet at the "Daily Analytics", "Weekly Analytics", and "Monthly Analytics"worksheets at the bottom of: [login to view URL]
and Please have the dashboard show Daily, Weekly, Monthly Analytics. *Please schedule an email Excel report to automatically come to kpi@[login to view URL]   3. ACCOUNT MANAGEMENT/ONBOARDING CLIENTS Instructions: [login to view URL] Our developers already built the code for the account management dashboard and it working but the data pulling is broken. It requires VPN access. You will fix the code and add new code to meet instructions above. 4. Business Development   You will be pulling how many users we’ve gotten out of the the available monthly traffic data from this sheet - https://docs.google.com/spreadsheets/d/1OcBp3e_HPFkBwkVej4DWBpMNXTLNw2_vqlW-AjBBSxg/edit#gid=0 5. Finance Dashboard You will be syncing with the Quickbooks API (By Month/Week/Day) Month-to-Month growth or decrease Gross Revenue Gross Profit/Net Revenue Net Profit/Net loss   6. Marketing   You will be pulling data from Google Adwords and Analytics. (1) https://docs.google.com/spreadsheets/d/1cpRUb2P2xCXNAOkARhvRXZ8vC5__CF_Rwy6--GhwkZA/edit#gid=359332817 (2) [login to view URL]