Need a leg up on international campaigns? Use this giant interactive Excel to compare cultures, create ads that connect and avoid pissing money away.
Inspired by Finch’s hilarious “How not to crack an international market” post, I decided to share this juicy spreadsheet. I got it during my MBA, probably from one of the professors – I had never seen it before, and have never seen it posted since. The spreadsheet form comes from Neil Sandford who got permission from the original researcher, Professor Geert Hofstede.

What’s in it an how it was made
(Original simple article in Chinese)
These ideas were first based on a large research project into national culture differences across subsidiaries of a multinational corporation (IBM) in 64 countries. Subsequent studies by others covered students in 23 countries, elites in 19 countries, commercial airline pilots in 23 countries, up-market consumers in 15 countries, and civil service managers in 14 countries. These studies together identified and validated five independent dimensions of national culture differences:
Power distance, that is the extent to which the less powerful members of organizations and institutions (like the family) accept and expect that power is distributed unequally. This represents inequality (more versus less), but defined from below, not from above. It suggests that a society’s level of inequality is endorsed by the followers as much as by the leaders. Power and inequality, of course, are extremely fundamental facts of any society and anybody with some international experience will be aware that ‘all societies are unequal, but some are more unequal than others’.
Individualism on the one side versus its opposite, collectivism, that is the degree to which individuals are inte-grated into groups. On the individualist side we find societies in which the ties between individuals are loose: everyone is expected to look after him/herself and his/her immediate family. On the collectivist side, we find societies in which people from birth onwards are integrated into strong, cohesive in-groups, often extended families (with uncles, aunts and grandparents) which continue protecting them in exchange for unquestioning loyalty. The word ‘collectivism’ in this sense has no political meaning: it refers to the group, not to the state. Again, the issue addressed by this dimension is an extremely fundamental one, regarding all societies in the world.
Masculinity versus its opposite, femininity, refers to the distribution of roles between the genders which is another fundamental issue for any society to which a range of solutions are found. The IBM studies revealed that (a) women’s values differ less among societies than men’s values; (b) men’s values from one country to another contain a dimension from very assertive and competitive and maximally different from women’s values on the one side, to modest and caring and similar to women’s values on the other. The assertive pole has been called ‘masculine’ and the modest, caring pole ‘feminine’. The women in feminine countries have the same modest, caring values as the men; in the masculine countries they are somewhat assertive and competitive, but not as much as the men, so that these countries show a gap between men’s values and women’s values.
Uncertainty avoidance deals with a society’s tolerance for uncertainty and ambiguity; it ultimately refers to man’s search for Truth. It indicates to what extent a culture programs its members to feel either uncomfortable or comfortable in unstructured situations. Unstructured situations are novel, unknown, surprising, different from usual. Uncertainty avoiding cultures try to minimize the possibility of such situations by strict laws and rules, safety and security measures, and on the philosophical and religious level by a belief in absolute Truth; ‘there can only be one Truth and we have it’. People in uncertainty avoiding countries are also more emotional, and motivated by inner nervous energy. The opposite type, uncertainty accepting cultures, are more tolerant of opinions different from what they are used to; they try to have as few rules as possible, and on the philosophical and religious level they are relativist and allow many currents to flow side by side. People within these cultures are more phlegmatic and contemplative, and not expected by their environment to express emotions.
Long-term versus short-term orientation: this fifth dimension was found in a study among students in 23 countries around the world, using a questionnaire designed by Chinese scholars It can be said to deal with Virtue regardless of Truth. Values associated with Long Term Orientation are thrift and perseverance; values associated with Short Term Orientation are respect for tradition, fulfilling social obligations, and protecting one’s ‘face’. Both the positively and the negatively rated values of this dimension are found in the teachings of Confucius, the most influential Chinese philosopher who lived around 500 B.C.; however, the dimension also applies to countries without a Confucian heritage.
Scores on the first four dimensions were obtained for 50 countries and 3 regions on the basis of the IBM study, and on the fifth dimension for 23 countries on the basis of student data collected by Bond. Power distance scores are high for Latin, Asian and African countries and smaller for Germanic countries. Individualism prevails in developed and Western countries, while Collectivism prevails in less developed and Eastern countries; Japan takes a middle position on this dimension. Masculinity is high in Japan, in some European countries like Germany, Austria and Switzerland, and moderately high in Anglo countries; it is low in Nordic countries and in the Netherlands and moderately low in some Latin and Asian countries like France, Spain and Thailand. Uncertainty avoidance scores are higher in Latin countries, in Japan, and in German speaking countries, lower in Anglo, Nordic, and Chinese culture countries. A Long Term Orientation is mostly found in East Asian countries, in particular in China, Hong Kong, Taiwan, Japan, and South Korea.
The grouping of country scores points to some of the roots of cultural differences. These should be sought in the common history of similarly scoring countries. All Latin countries, for example, score relatively high on both power distance and uncertainty avoidance. Latin countries (those today speaking a Romance language i.e. Spanish, Portuguese, French or Italian) have inherited at least part of their civilization from the Roman empire. The Roman empire in its days was characterized by the existence of a central authority in Rome, and a system of law applicable to citizens anywhere. This established in its citizens’ minds the value complex which we still recognize today: centralization fostered large power distance and a stress on laws fostered strong uncertainty avoidance. The Chinese empire also knew centralization, but it lacked a fixed system of laws: it was governed by men rather than by laws. In the present-day countries once under Chinese rule, the mindset fostered by the empire is reflected in large power distance but medium to weak uncertainty avoidance. The Germanic part of Europe, including Great Britain, never succeeded in establishing an enduring common central authority and countries which inherited its civilizations show smaller power distance. Assumptions about historical roots of cultural differences always remain speculative but in the given examples they are quite plausible. In other cases they remain hidden in the course of history.
The country scores on the five dimensions are statistically correlated with a multitude of other data about the countries. For example, power distance is correlated with the use of violence in domestic politics and with income inequality in a country. Individualism is correlated with national wealth (Per Capita Gross National Product) and with mobility between social classes from one generation to the next. Masculinity is correlated negatively with the share of their Gross National Product that governments of the wealthy countries spend on development assistance to the Third World. Uncertainty avoidance is associated with Roman Catholicism and with the legal obligation in developed countries for citizens to carry identity cards. Long Term Orientation is correlated with national economic growth during the past 25 years, showing that what led to the economic success of the East Asian economies in this period is their populations’ cultural stress on the future-oriented values of thrift and perseverance.
Enjoy. If you are using Excel 2010 or higher, you’ll have to allow editing to be able to interact with the charts. Here’s the spreadsheet:
Prof. Geert Hofstede conducted perhaps the most comprehensive study of how values in the workplace are influenced by culture.
Geert Hofstede analyzed a large data base of employee values scores collected by IBM between 1967 and 1973 covering more than 70 countries, from which he first used the 40 largest only and afterwards extended the analysis to 50 countries and 3 regions. In the editions of GH’s work since 2001, scores are listed for 74 countries and regions, partly based on replications and extensions of the IBM study on different international populations.
Subsequent studies validating the earlier results have included commercial airline pilots and students in 23 countries, civil service managers in 14 counties, ‘up-market’ consumers in 15 countries and ‘elites’ in 19 countries.
From the initial results, and later additions, Hofstede developed a model that identifies four primary Dimensions to assist in differentiating cultures: Power Distance – PDI, Individualism – IDV, Masculinity – MAS, and Uncertainty Avoidance – UAI.
Geert Hofstede added a fifth Dimension after conducting an additional international study with a survey instrument developed with Chinese employees and managers.
That Dimension, based on Confucian dynamism, is Long-Term Orientation – LTO and was applied to 23 countries.
These five Hofstede Dimensions can also be found to correlate with other country, cultural, and religious paradigms
Luke 12:47 am on June 22, 2011 Permalink |
I just found your post while searching online. The same thing happened to me, but the ads they banned me for were 7 years old.
I wrote up the whole ordeal here: http://www.everstatus.com/03/29/google-bans-11-year-old-adwords-account-over-deleted-ads/
I would suggest possibly filing a complaint with your state Attorney General. They have been instrumental in banding together to lobby the FTC to take action.
Google has an amazing amount of hubris at the moment and it will probably take regulatory action to bring any sort of change.
NegBox 6:11 pm on June 22, 2011 Permalink |
@Luke, great post on your blog – Thank you. I’ve just finished filing a complaint with my state’s Attorney General. I think I have a contact into his office too – Yummy! I knew I was forgetting something.
Google is controlling a monopolistic-level share of something extremely valuable to citizens: The index to the internet. You either self-regulate and keep complaints low, or get doggy-banged by the government. It isn’t rocket science, the same deal has played out dozens of times before, yet it seems it takes more than a thousand PhDs to figure out.
Bil Smith 8:21 pm on June 22, 2011 Permalink |
I’ve lost a handful of Adwords accounts over the years but it never really bothered me to be honest, but what they’re doing now is ridiculous. I lost accounts because I was doing things I shouldn’t have been doing – knowingly, no less – not because of something that I promoted half a decade ago that changed without any input from me. Google is the 600 pound gorilla in the room and they’ve relied on that to pull this kind of crap. Hopefully if enough people complain to the right people, something will finally be done.
NegBox 8:47 pm on June 22, 2011 Permalink |
Bil, that’s exactly the issue. You get banned for being sly… Fine. Move on or try again. You can’t complain. You get banned for nothing, and suddenly you’re on a crusade to avenge the wrong, embodied in the monstrous Googlezilla. Human nature at its best. What makes it most fun to watch is Google’s uncompromising out-of-this-planet idea of customer service and public opinion, which goes along the lines of “What customers?” – Behaving as if the world were static and timeless, or that an impenetrable shell can be created is, in one word: Solipsistic.
Matt 12:59 pm on August 11, 2011 Permalink |
any update on this post? curious if the gov-types made any mention of receiving your info.
NegBox 11:06 pm on August 11, 2011 Permalink |
@matt, they did – I got two letters from my state’s Attorney General. I really don’t expect much. If anything the whole experience is quite liberating. Now instead of trying my best to be a good AdWords advertiser, I try my best to be the sneakiest AdWords outlaw as possible – Way less stressful.
Hay 3:30 pm on October 24, 2011 Permalink |
I too just found out that I am permanently suspended from my adwords account because of two failed campaigns I ran for about a month two years ago. I simply took two campaigns from an affiliate network that I am part of and tried some adwords ads. Guess who lost money? So, I stopped the campaigns and never gave it any more thought. Lo and behold, a few weeks ago i visited my adwords account and found myself PERMANENTLY SUSPENDED!! I emailed the great Internet god and found that I may as well talk to a brick. Certainly I could easily find more common sense talking to a brick. Couldn’t reason at all with them.
Google insisted that the only way to be re-established was to make changes to the websites (which I NEVER DID OWN, NOR DID I EVER HAVE ACCESS TO THEM). Google is completely, totally, unreasonable and uncaring. They own the internet and set all the rules to suit their own profitability.
Have you ever noticed that google’s attitude toward anyone trying to make money on the Internet is like you are pond scum (while they scoop in billions after obscene billions). Interesting, eh?
Google is an INTERNET BULLY of the highest magnitude and the sooner someone legislates them the better. How can the governments of the world stand by and let this monster become even more monstrous?
NegBox 3:00 pm on October 27, 2011 Permalink |
Hey Hay – A giant chunk of the responsibility for the way Google is today falls on us. And by ‘us’ I mean people directly related to technology – I can’t take all the credit, otherwise I’d say “me”.
We used Google instead of Altavista, Dogpile, or Yahoo – MSN was out of the question since they were the Evil Galactic Empire ruled by Darth Gates. We switched everyone’s default engine from Yahoo to Google. We told everyone about Google. We made Google grow into what it is today. Why? First, they gave us the same shitty results as everyone else, except they had a very clean homepage – while everyone else had shit out the wazoo on their search page – Who wants to load a 1 Megabyte page on a 56K modem? Let alone set it as a default page…. Then Google started giving really good results – Took them YEARS to put out more relevant results than the other engines – Nobody gives a shit about the quality o the results if it takes forever to get them, though – so we all used Google then for its speed and un-cluttered-ness and gave them the chance to get better. Then they added ads to their listings and over time literally fucked us all in the ass and will continue to do so for quite some time… So better go get some K-Y.
Gyuri 8:36 am on December 12, 2011 Permalink |
Hey,
How is your case coming with the FTC? Would love to have some updates.
Gyuri 7:43 am on December 13, 2011 Permalink |
Just raised my FTC complaint. I focused on the fact that Google Adwords is a monopoly for online advertisement, and them banning you for life seriously impairs your prospects to enter the online market which is a necessity for survival. 🙂
If there would be 4-5 players with 20% market share their ban would not matter, but this way it does. For an FTC complaint you need to focus on monopolistic nature of Google, and why they should not be allowed to ban an advertiser for life.
NegBox 10:41 pm on December 20, 2011 Permalink |
Really “my case” is lob the grenade and run. Not gonna chase the FTC. Now does anyone really believe that because Google doesn’t want me to use their systems, I won’t if I need to? If I had a choice, then I would respect that – When I don’t have a choice, well then I just don’t have a choice.
Gyuri 11:43 am on December 16, 2011 Permalink |
One more thing I wanted to mention that the Adwords team could simply block questionable URLs in campaigns instead of banning people. This treatment is totally rude. In the US Justice system not even murderers get a permanent ban for life.
Gyuri 7:34 am on December 25, 2011 Permalink |
One more addition: If you are living in the EU the new data protection scheme will allow individuals the “right to be forgotten” , meaning someone can request the deletion of all personal data, such as IP email etc. This way they wont be able to ban you for life. Screw you Google, http://www.telegraph.co.uk/technology/internet/8388033/Online-right-to-be-forgotten-confirmed-by-EU.html.
I will be one of hte first person to request this for my Adwords account.