RiteChannel

RiteChannel Contact information, map and directions, contact form, opening hours, services, ratings, photos, videos and announcements from RiteChannel, Software Company, Panmure.

We show sales Leaders how to get their "Data Ducks" in a row with the Ritechannel strategy so they can begin untangling, automating and optimizing their DataOps process.

02/03/2022

Are you managing duplicates through name matching? maybe you've stepped up to fuzzy name matching? Why not solve the problem at the root by adding LinkedinID's to your data?

In this video I'll show you why linkedin ID's are useful in your crm, and then how to use them in Salesforce.

31/10/2021

Are you managing duplicates through name matching? maybe you've stepped up to fuzzy name matching? Why not solve the problem at the root by adding LinkedinID's to your data?

In this video I'll show you why linkedin ID's are useful in your crm, and then how to use them in Salesforce.

18/10/2021

99% of LinkedIn Sales Nav's power comes from the advanced search functionality to get far more detailed results.

Follow along to learn how we use Booleans at Ritechannel to get really accurate search results!

14/10/2021

Are you wondering if there's an easier way to import contacts into your CRM? how about the easiest way to do it.

Use this formula to quickly create an import sheet for your CRM

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

12/10/2021

What’s the lowest productivity activity an SDR does every day?

Calling people and not getting through.

Call connect rates are less than 7%. That means 93% of the time your reps are dialling, they’re effectively wasting time.

Why? Nothing has been left behind. There’s not an email to refer to, there’s not a profile to check out on Linkedin in, the call vanishes into the ether.

But calls are still important. Why? Because conversations convert.

When you get someone on the phone, you get a chance to gain context, understand their situation and position yourself accordingly. That’s priceless for go-to-market teams. That’s insight that can’t be gained through static conversations over chat, email or social.

So calls are important, but they’re terribly unproductive.

How do we fix that?

Only call prospects that you know answer their phone.

By doing this you’ll turn 7% connect rates into 25-40% connect rates. Your reps will have 6-7 conversations an hour as opposed to 6-7 per week.

That’s what RiteChannel does, we tell you who picks up and who doesn’t so you can make sure your SDR team is as efficient as possible.

11/10/2021

A lot of the time when scraping data or dealing with data your reps have put into the system you'll come up against very "human" phone formats. This formula will turn all of those messy phone numbers into a consistent format.

="+1"®EXREPLACE(REGEXREPLACE(to_text(A2),"[^0-9]+",""),"^1","")

If you have any questions or issues with the formula, let me know in a message or comment and I'll respond asap!

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

08/10/2021

How to create objects and link them in salesforce with lookup fields

It can be tricky to understand how salesforce stores and links data. In this video I'll give an overview of:

- What are lookup fields in salesforce?
- How to use lookup fields
- What are Master Detail Records
- How to link objects
- Which settings you should use when creating objects and lookup fields
- How to make your new custom objects visible on the salesforce navigation bar

Let me know via comment or PM if you have any questions or difficulties implementing lookup fields

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

06/10/2021

How to remove letter accents in google sheets using a simple formula!

Sometimes when working with fuzzy data you'll come across errors caused by letter accents. Certain CRMS won't accept them, others will change the letters to something completely different, and when you go to use your data tools to find information for these contacts you'll find many of them won't properly format letter accents.

So what formula should you use to quickly remove letter accents from your spreadsheets?

Give the video a watch and then head to the below sheet to copy the formula.

https://lnkd.in/gGkUzBzJ

Feel free to comment with any questions!

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

06/10/2021

Learn how to add formulas to google forms responses in 5 minutes

With google forms it can be really tricky to apply formulas because google forms appends a new row to the response sheet, rather than inputting data on an existing row.

This means any formulas you add to the empty rows of your response sheet will not apply to your form responses. Watch this video for an easy solution!

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

05/10/2021

How to convert a list of company URLS into email domains in 5 Minutes.

TL;DR use this "=regexreplace(COMPANYURL,"https://|http://| |www.|/.*$" , "" )"

There's a bunch of tools out there that help you find data on prospects. Many of them require a clean domain to search with. Use this formula to format any company URL into a usable domain in seconds!

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

04/10/2021

How to get started customizing salesforce in less than 15 minutes!

So you've got your new salesforce org and you have no idea how it works or what to do. What should you do first? Follow along with this video and I'll give an overview of the following:

- What is an object in salesforce?
- What is a field in salesforce?
- What is a record in salesforce?
- What does "ORG" mean in salesforce?
- How do I create a custom field on an object in salesforce?

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

01/10/2021

TL;DR Use the formula "=INDEX( *ReturnRange* ,MATCH(TRUE,EXACT( *SearchKey* , *SearchRange*),0))"

In this video I'll show you how to create a case sensitive vlookup you can use on salesforce Contact and Account ID's in less than 2 minutes.

If you're a nerd feel free to stick around after the 2 minute mark and I'll go into detail about how each piece of the formula works.

Feel free to message or comment if you have any questions!

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Address

Panmure

Alerts

Be the first to know and let us send you an email when RiteChannel posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share