Brian Green Consultancy

Salesforce IDs and MS Excel UDF [Video]

Brian Green — Thu, 27 Jan 2011 21:08:26 +0000

Following from my earlier Post, Salesforce IDs and the 15-18 digit problem, here’s some Visual Basic code that can be installed as a User Defined Function (UDF) in Microsoft Excel (or, Microsoft Access) to easily convert Salesforce 15 character IDs to the “unique”, required by Microsoft applications, form of 18 characters … and a YouTube [...]

Why CRMs are not merely for dogs

Brian Green — Sun, 23 Jan 2011 17:42:50 +0000

May you live in interesting times These are certainly challenging economic times for charities, for nonprofits; indeed for-profit as well. Now, more than ever, at the end of each day, you must be questioning whether your internal system are fit for purpose: that those monthly all too critical reports are all too time consuming to [...]

Salesforce IDs and the 15-18 digit problem

Brian Green — Sun, 09 Jan 2011 13:22:54 +0000

Salesforce CRM user? Are you a Salesforce CRM user? Use Microsoft Excel for analysis or reports? Then you’ll have met the Salesforce 15 digit ID problem. Internally Salesforce IDs are 18 digits long. But, Salesforce Reports reduce them to 15 digits. So, for example, an Organisation ID internally might be 0014000000LmabcAAB, but in a report it [...]

Friends without boarders

Brian Green — Thu, 16 Dec 2010 09:58:52 +0000

I’ve just come across the stunning image – give it some time … It’s by Paul, an intern on Facebook’s data infrastructure engineering team. The image represents the social graph of 500 million Facebook users. Paul constructed the image using the the longitude and latitude of each user’s city and the number of friends between each [...]

Why my partner is moving to the clouds …

Brian Green — Wed, 06 Oct 2010 15:21:43 +0000

My partners computer crashed yesterday – it’s irreparable! So I re-moved her hard-drive to my server and, thankfully, she now has full access to all her files. But what if her crash had damaged her hard-drive; wiped all her data? Classic: we have no back-up of her PC files! Losing your business data (i.e. data [...]

How to control the fonts in your email marketing newsletter

Brian Green — Sun, 26 Sep 2010 15:46:11 +0000

One of the unavoidable complications with your email marketing newsletter is that you cannot fully control the font in which it is displayed. The email reader, or the browser, that your customer uses is not guaranteed to use the font you have so diligently selected for your newsletter. This is just as true for your [...]

Media isn’t Social [Video]

Brian Green — Thu, 05 Aug 2010 14:39:21 +0000

Just come across this excellent Youtube video by David Armano (Senior Vice President of Edelman Digital) presented at TEDxPennQuarter. A more appropriate title might be Reinventing Social Media. Enjoy …

Social Media trailblazers [Video]

Brian Green — Fri, 04 Jun 2010 19:18:40 +0000

Just come across this great video on Social Media. It originates from Social Media World Forum 2010 – a SixDegs’s Channel on YouTube. There are some 15 related videos. Enjoy …

Social CRM? Don’t have a Cluetrain?

Brian Green — Thu, 13 May 2010 20:51:46 +0000

Despite being published just over 11 years ago The Cluetrain Manifesto is still provocative, outrageous, and smart – the Cluetrain.com web site went live in April 1999. As Thomas Petzinger, then a columnist for The Wall Street Journal and author of “The New Pioneers: Men and Women Who are Transforming the Workplace”, states in the [...]

Wordle!

Brian Green — Thu, 06 May 2010 18:51:22 +0000

Just come across Wordle … enjoy!