Skip to main content

GA Bulk URL Builder - Google Sheets add-on

Tired of tagging urls with UTMs one at a time? With this Add-on you can build 100s of URLs in one click!

GA Bulk URL Builder

The best sizes for sharing images on social media

More useful advice from the folks at Buffer:

In general, here are the best sizes for sharing images on social media. 

Facebook – 1,200 x 628

Twitter – 1,024 x 576

Instagram – 1,080 x 1,080

LinkedIn – 552 x 368

Pinterest – 600 x 900

Google+ – 800 x 320

And here is "the Essential Social Media Design & Sizing Cheat Sheet" from omnicore:

Tracking Internal Marketing Campaigns With Google Analytics

Christian Ebernickel discusses why UTM parameters are are not suitable for tracking internal campaigns and proposes using ITMs instead.

ITM Parameters At A Glance Link

Drawing on the UTM parameters, we’ll use the following ITM parameters to track internal marketing campaigns:

  • itm_source
    This identifies the source of the traffic. In the case of internal ads, this is usually your own domain. However, if you employ cross-domain tracking or different ad servers, different traffic sources can appear in this field.
  • itm_medium
    This is the medium of the internal ad; for example, a banner or product recommendation.
    itm_campaign
    This is the name of the internal marketing campaign.
  • itm_content
    This is a parameter to differentiate between similar content, or links in the same ad; for example, text_link or banner_468x60.
    itm_term
  • This is the search keyword that triggered the internal ad. Alternatively, it could be a keyword to categorize the ad by content.

Marketing Campaign Attribution by Krista Seiden

I still recommend the below hierarchy for manual tagging of campaigns, using the (up to) 5 UTM parameter slots available to you in the URL:

  • Campaign -name of your overarching campaign – e.g. spring-2013-collection or summer-2013-announcements. Be sure to follow a consistent campaign naming structure.
  • Medium – the medium used to send your campaign. Include “email” for an email campaign, “cpc” for ads, “social” for a social network or “landing-page” if you’re tracking button clicks from a landing page.
  • Source – used to differentiate the type of medium. If medium = cpc, then source may be google, bing, or yahoo. If utm medium = email, source can be used to call out the action (try, buy, coupon, awareness, etc).
  • Content – this is essentially a bonus field – it can be used to track many differentiating factors for

The feed should have an option to save articles for later or share to an app like pocket.

8 Google Sheets Tips to Grow & Automate Your Business

Lots of great info in this article by David Krevitt. The facebook ad integration is one I'm going to look into straightaway.

In startups, EVERYONE uses Google Sheets:

  • Marketers track goals and results for campaigns
  • SEO experts perform keyword and backlink research
  • Content producers manage an editorial calendar
  • And tons more...

Use these tricks to dominate your Sheets game. Plus, you’ll see real-life examples on how other successful companies (like Zapier) use Google Sheets for massive success.

Make better use of Google scripts

 

Google Scripts is a powerful tool you can use to automate Google productivity tools like Sheets and Docs. The ability to automatically send emails makes it an extra powerful tool.

Google Search can provide you with HEX Colour Codes

1 min read

If you are ever stuck trying to to find a hex colour code value, just turn to google! Simply search for 'hex color' and google will provide a handy hex colour tool as the top result.

hex color tool

As well as the HEX value you will also get the RGN, HSV, HSL and the CMYK values.

Why not give it a try yourself: https://www.google.co.uk/search?q=hex+color

AnswerThePublic.com: that free visual keyword research & content ideas tool

But the task of capturing all the answers became a challenge. We needed to automate the gathering of questions and create something that could be easily shared. This is search insight that should and could be used by any marketing team. Creative, PR, Content, SEO.

So we built simple visualisations of the data. A one-pager that could be shared to prompt a conversation on how you could start answering your public better. By creating content that’s useful, funny or inspiring.

Gary Preston has written this useful article on how to use google suggest to read the minds of your customers.

On the hero, hub, hygiene content strategy - Dig Content

Hero, hub and hygiene content – a strategy that Google has been touting for some time with special emphasis on Youtube – doesn’t need to start and end with video. As I explored in my last post on content strategy, there’s a very valuable place for it right there behind your blog or your brand’s website, and it can be a great structure on which to hang your overall story. For those at the back, let’s begin with a recap of what the strategy is. Google present it using the example of Volvo trucks and their success with Jean Claude Van Damme, so we’ll look at that first, before exploring an area where it has been applied successfully in the past.

  • Hero content is designed to inspire, entertain and attract both new and loyal customers.
  • Hub content takes the form of regular pieces that loyal customers expect, such as weekly or monthly updates.
  • Hygiene content aims to answer questions from customers.