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.

[Read more…]Publishing Pivot Table Charts to Your Website With Google Sheets

Using Google Drawings to Create “Live” Marketing CTAs

A 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.

[Read more…]Using Google Drawings to Create “Live” Marketing CTAs

Moving to Gmail for Business: Migration Options

Moving to Gmail for BusinessIf you are thinking about moving from your current email provider to business Gmail for your organization, you’re probably wondering what would be involved with associating existing users’ email addresses, which are in a name@yourcompany.com type format, with a new G Suite account.

Also, what’s the best way to get your users’ often years worth of sent and received email into their Gmail accounts?

A move to business Gmail involves a number of technical tasks. However, this post is designed to provide a mainly non-technical overview of the tasks and options involved.

[Read more…]Moving to Gmail for Business: Migration Options