G Suite: Editing Microsoft Office Files

Edit Microsoft Office Files in Google AppsOne of the things that has prevented some organizations from making the switch to G Suite is the fact that they still would need to maintain and/or purchase Microsoft Office licenses for most of their users.

However, Office licenses may only be needed for a few power users within an organization, as there are two ways that any user can open and edit Microsoft Word, Excel or PowerPoint files using Google Drive. “Power users” can include those who work with very large Excel spreadsheets or who rely on macros within certain Excel spreadsheets. It can also include those who need to exchange redlined Word documents with third parties.

There are two ways that G Suite users can edit Office files without the need for Office software. Continue reading G Suite: Editing Microsoft Office Files

Google Analytics Event Tracking Examples

Google Analytics Event TrackingGoogle Analytics Event tracking allows you to incorporate visitor activity from many different sources within Google Analytics.

Once the information is in Google Analytics, as we covered in the previous post, comparative visualizations can be created in Google Sheets.

Here are five Google Analytics event tracking examples. You can use these to measure the effectiveness of your marketing efforts. This is all predicated on the fact that you are using the Universal Analytics tracking code. Continue reading Google Analytics Event Tracking Examples

Google Analytics Reports in Google Sheets – Using Filters

Google Analytics ReportsOne of many benefits to using G Suite is that G Suite users with access to their organization’s Google Analytics account can easily share specific slices of Google Analytics data with their co-workers.

The Google Analytics Add-on for Google Sheets lets a Sheets user who has a Google Analytics login create a variety of comparative visualizations within Google Sheets. Continue reading Google Analytics Reports in Google Sheets – Using Filters

G Suite vs. Office 365: Which is Best for Your Business?

G Suite vs. Office 365G Suite and Microsoft Office 365 are the two most popular cloud-based suites of business productivity applications on the market. Among the best known applications within these suites are email, calendar, documents, spreadsheets, presentations and online storage.

Google and Microsoft continue to add their own flavors of additional components to their respective suites. For example, G Suite includes Forms, Drawings and My Maps and new Google Sites. A paid extra, Google Jamboard, has been announced. An included extra is Hangouts Meet.

Microsoft Office 365 plans variously include Sway, Yammer, Skype for Business, Office 365 Video and Microsoft Teams. Continue reading G Suite vs. Office 365: Which is Best for Your Business?

Present Data in Google Slides – In Real Time

G Suite users can now present data in Google Slides. And, this data can be presented in real time.

Until Google introduced this functionality, charts had to either be pasted as images into Google Slides or they had to be created using shapes. When the underlying data changed, a more up-to-date chart image had to be pasted into the slide or the shapes had to be modified. This could be very time consuming.

Google has provided two ways to embed data-driven charts right within individual slides. Continue reading Present Data in Google Slides – In Real Time

12 Reasons to Move Your Business From Free Gmail to G Suite

Free Gmail vs. G SuiteLet’s say you’ve been using free Gmail accounts for your business communications. Your email addresses may resemble one or more of these:

abbottsolar@gmail.com
solar-lisa94@gmail.com
abbottsupport@gmail.com

Your employees may even be using assorted Yahoo Mail and cable company email addresses for business purposes.

However, your business is growing and/or you want to start to use more professional looking email addresses such as:

jabbott@abbottsolar.com
lisa@abbottsolar.com
support@abbottsolar.com

Steven Aldrich of GoDaddy has stated that potential customers are far more likely to do business with a company that uses a business email address than those that don’t. Continue reading 12 Reasons to Move Your Business From Free Gmail to G Suite

4 Ways to Add Animation to Your Website With Google Slides

Google Slides can easily be embedded in any website by using the code provided in the File > Publish to the web… menu.

By default, there’s a set of controls at the bottom of an embedded Slides presentation that diminishes the website animation effect. The controls provide multiple options including downloading the Slides as a PDF or PPTX file. Continue reading 4 Ways to Add Animation to Your Website With Google Slides

Create a Poll With Google Forms

With Google Forms, it’s easy to embed surveys, polls and other types of questionnaires into your website.

We created a poll in Google Forms and embedded it below. If you answer the question, you’ll be able to see how others answered the same question simply by clicking the See previous responses link after you submit your response. Continue reading Create a Poll With Google Forms

Google Apps and Salesforce Integration – Dreamforce 2015 Podcast

At Dreamforce 2015, I had the opportunity to interview Brandon Bruce, co-founder of CirrusPath, on the podcast stage in the Admin Lodge.

CirrusPath has done an excellent job of not only integrating Salesforce and Google Apps, but of also developing productivity tools for salespeople that can help to improve win rates. Continue reading Google Apps and Salesforce Integration – Dreamforce 2015 Podcast

9 Reasons Companies Switch to G Suite

Google is a household name for internet search. Most people are aware of consumer Gmail. However, many businesspeople are not aware of Google’s suite of applications for business, G Suite.

“Gone Google” is a term Google coined for companies that have adopted G Suite. At the time of publication of this post, Google states that over 5 million companies have gone Google. With over 125 million businesses in the world, there’s clearly some upside for Google. Continue reading 9 Reasons Companies Switch to G Suite

Google Apps for Work Under The Alphabet Structure

With Google’s recently announced restructuring, where does Google Apps for Work fit in?

Google Apps will live along side a set of related technologies, including Android (which has apps for Google Apps for Work), Search (used in Gmail, Google Drive and Google Sites), YouTube (Google Drive uses the YouTube engine) and Maps (Google My Maps is now part of Google Apps for Work). Continue reading Google Apps for Work Under The Alphabet Structure

Five Google Sites Use Cases

Google Sites is not necessarily the first application that enters the mind of most people as a platform for building out a corporate website, but there are a number of Google Sites use cases that organizations can take advantage of.

One of the great aspects of Google Sites is the fact that it has the built-in sharing options that are common to all Google Apps components. These granular permission levels make Google Sites easy to adapt to a variety of “non standard” use cases.

Here are five ways to use Google Sites other than as a corporate website platform. Continue reading Five Google Sites Use Cases

DIY B2B Marketing Landing Pages for Salesforce

DIY Salesforce Landing PagesYou’re a marketer whose company is subscribing Salesforce Professional Edition or Enterprise Edition.

You want to add on a marketing automation system such as Pardot or HubSpot to Salesforce, but you’re having trouble getting management to commit to a five figure minimum contract.

You’ve got some great blog content and you have a whitepaper or ebook already prepared. You simply want to set up something along the lines of the following flow (click image for full tab view) so that you can capture website leads and assign them to salespeople. You want to avoid involving IT, if at all possible. Continue reading DIY B2B Marketing Landing Pages for Salesforce

What Users Can Do to Strengthen G Suite Security

Google Apps User SecurityIf you’re using G Suite or considering G Suite, some questions about security of your information may have entered your mind, since all your company email and your business documents (if you are leveraging Google Drive for cloud backup of local files) are stored in Google’s data centers.

G Suite, as you’d expect, has multiple levels of built-in security. Continue reading What Users Can Do to Strengthen G Suite Security

Publishing Pivot Table Charts to Your Website With Google Sheets

In the spring of 2013, we used SurveyMonkey Audience to collect data about what CRM systems were deployed at organizations across the U.S. The main question we asked in the survey was “What is your organization’s primary CRM system?”

After the survey finished its run, SurveyMonkey provided us with a CSV file of the survey results from approximately 750 respondents. The first thing we did was to upload the CSV file to Google Drive and then open the file with Google Sheets. Once we had the data in Google Sheets, we were able to easily create pivot tables and associated charts. Continue reading Publishing Pivot Table Charts to Your Website With Google Sheets

Three Great Apps For Scheduling and Tracking Gmail

Schedule and Track GmailThrough the use of simple-to-install browser apps and extensions, several vendors now offer Gmail users instant access to business productivity and sales enablement tools.

Users of business Gmail, part of Google Apps for Work, have several options for scheduling emails, tracking whether emails were opened and finding out whether links were within opened emails were clicked by recipients. And this is only a subset of the empowering functionality that’s available to Gmail users. Continue reading Three Great Apps For Scheduling and Tracking Gmail

Using Google Drawings to Create “Live” Marketing CTAs

Live Marketing CTAs in Google DrawingsA best practice for B2B marketers is to include a call to action (CTA) image at the bottom of every blog post.

When a visitor clicks on the CTA image, they can be directed to a landing page that provides a free offer.

A common process for creating a marketing call to action graphic is to:

  1. Create an image in an image editor (or PowerPoint)
  2. Save the image to a local drive
  3. Upload the image to WordPress or to a marketing automation system’s files area
  4. Incorporate the image into one or more blog posts

If, for any reason you want to modify the CTA image, you need to repeat the entire process. Continue reading Using Google Drawings to Create “Live” Marketing CTAs