Subscribe
Sign in
p/coefficientSync Google Sheets with your SaaS systems & DBs in seconds
Start new thread
Hannah Recker

Salesforce Report Template Pack - 10 sales dashboards for spreadsheets (built by ops pros)

by•

Salesforce Report Templates in Sheets are completely free & make data transparency & flexibility possible right within your spreadsheet. Grab a pre-built dashboard, launch it in Sheets instantly, then power it with your live Salesforce data in a few clicks.

Add a comment

Replies

Best
Hannah Recker
Hunter
📌
Hello Salesforce operators! We’ve teamed up with ops pros to build out-of-the-box Salesforce dashboards that are completely customizable and free to download. Grab the template you need and, in just a few clicks, connect your live Salesforce data. The dashboards live in your spreadsheet, are viewable based upon your spreadsheet share settings (no Salesforce user seat required), and can be refreshed with your live data at any point in time. Our pack contains: 1. Accounts Overview Dashboard: Monitor activity, rep performance, and future deals for each account. 2. Pipeline Creation Dashboard: Get a comprehensive view of pipeline creation across reps and teams. 3. Sales Team Leaderboard: Track the performance of your company, teams, and individuals. 4. Salesforce Sales Performance: Compare YOY sales by opportunity type, industry, region and account. 5. Win-Loss Analysis: Track win rates by team, individual, industry, region, and deal size. 6. Sales Opportunity Tracker: Track your opportunity pipeline and monitor sales targets. 7. Sales Operations Dashboards: Access core charts, metrics, & filters you need to grow sales. 8. Pipeline Analysis: Compare MOM results for pipeline creation, win rates, average deal age, and more. 9. Opportunity History Changes: Track opportunity edits and identify changes that affect your forecast. 10. Sales to Target Tracker: Set sales targets and easily track progress by month, quarter, and year. Salesforce limitations can no longer hold you back in building or sharing the reports you need. Report on sales pipeline, opportunity history, rep performance, and more right within your spreadsheets. We’re aware no two sales pipelines look the same, so we’ve made template customization easy. Others are even using the Salesforce Google Sheets connector to DIY their own reports for quota payouts, data cleanup, and forecasting. Enjoy! -Hannah P.S. Have a Salesforce report you desperately need built? Feel free to make a template request and we’ll build based upon overall user needs! https://forms.gle/rdKTNhHBQfiRP5Mk9 P.P.S. Don’t use Salesforce? No problem. We have a library of HubSpot templates as well. Make a copy of any template and customize for your own CRM!
Awesome! Great launch, guys!
Salif Ba
Whoever built these has serious skills in Google Sheets AND some serious sales ops experience. Thank YOU!
Hannah Recker
@salif_ba we feel the exact same! Glad you can see what we see. Hope you can find the templates useful!
Jhoel Padilla
I don’t even use Salesforce and these are HUGELY beneficial for my workflow. Please build for Pipedrive!
Hannah Recker
Hunter
@jhoel_padilla So glad to hear the templates can help! We look forward to building for Pipedrive as we've recently launched a new Pipedrive-Google Sheets connector.
Rafael Miller
Do you have any templates for other systems?
Hannah Recker
Hunter
@rafael_miller we do! we currently have templates for Salesforce, Hubspot, Google Analytics, Shopify, and Zendesk. You can check them all out here: https://coefficient.io/google-sh...
AYUB ALI
I’ve always appreciated a great template. You nailed it!
Manav Sharma
Congrats on the launch Salesforce team!
Hannah Recker
@manav_sharma1 thanks for the congrats, Manav! Coefficient is behind the templates, but they're all based upon and pull in your Salesforce data. We have templates for Hubspot as well - and any of these can be customized to use for your own CRM, even if it's not one of the two. We actually recently added a Pipedrive connector, but don't have any pre-built templates avail yet! Coming soon! :)
Behrens Vicki
Love that these are free and the data can be refreshed with just a click of a button on the sheet. I’ve had so much trouble sharing reports with clients. Can they see and refresh this button as well?
Frank J. Ferris
Maker
@behrens_vicki so glad to hear you loved our templates! Other users can refresh the data imports if they create a free Coefficient account, if they have edit access to the spreadsheet and specific tabs with imported data on them. You can limit this ability by setting Google Sheets edit permissions on your data import tabs (or entire sheet) if you don't want them refreshing. They won't have the ability to edit your data import (ie change filters or add new fields) unless you explicitly give them permission in the Coefficient app. Looking forward to hearing what you build! 😃
Daniel Ryan
Look amazing! Great job! Congrats on the launch!
Siavash G
Heck yeah!
Williamx Alex
How often can I keep these refreshed with my data?
Hannah Recker
Hunter
@williamx_ hi, William! You can set a refresh schedule on your data imports - we have options ranging from hourly to weekly. You'll also have a button on your data import tab that you can click at any time to refresh the data.
Sandra Djajic
This is a game changer! Congratulations on the launch 😀