/tagmanager/community?hl=en
/tagmanager/community?hl=en
11/12/13
Original Poster
Google user

GTM eCommerce not reporting correct currency.

Hi Folks,
 
I have a site that has three TLDs and as a result three currencies (GBP/EUR/USD). After some help from a wonderful member of this group I was able to get my eCommerce javascript using the dataLayer working. So I am now seeing transactions in Google Analytics. Yipppeeee
 
Except it seems to be making a dogs dinner of the currencies. On the site the user can choose which currency they want to pay with/be billed with so as part of the javascript that adds transaction information I have added the currency (see below for code).
 
If I report a sale on a UK website lets say in USD doesn't GA automatically convert that to the appropriate local currency automatically?
 
Dave
 
 
<!-- BEGIN GOOGLE ANALYTICS ECOMMERCE dataLayer SCRIPT -->
<script>
 
dataLayer=[{
'transactionId':'IE00000047',
'transactionAffiliation':'',
'transactionTotal':20.00,
'transactionTax':0.0000,
'transactionShipping':8.0000,
'transactionProducts':[{
'name':'product description',
'sku':'L2005_S',
'category':'',
'price':20.0000,
'quantity':1.0000
}]
}]

dataLayer.push({
'event': 'trackTrans',
'transactionId':'IE00000047',
'transactionAffiliation':'',
'transactionTotal':20.00,
'transactionTax':0.0000,
'transactionShipping':8.0000,
'transactionPaymentType': 'Credit Card',
'transactionCurrency': 'USD',
'transactionPromoCode': '',
'transactionProducts': transactionProducts
});
 
</script>
<!-- END GOOGLE ANALYTICS ECOMMERCE dataLayer SCRIPT-->
Community content may not be verified or up-to-date. Learn more.
All Replies (10)
DuracellTomi
11/12/13
DuracellTomi
Hi,

If you pass for example an USD price into an Analytics account that has GBP as primary currency set, GA converts this money to GBP.
There are "local" metrics in GA which can be used to create reports using the currency that was included in the transaction:

Does this answer your question?

Cheers,
Thomas Geiger
DuracellTomi
11/12/13
DuracellTomi
One more thing: there is a currency setting in your GA tag if you select "Transaction" for type.
You should create a macro that reads your transactionCurrency dataLayer variable and set this macro to the currency field in your tag settings:


11/12/13
Original Poster
Google user
Hi Tomi,
 
Many thanks for your reply however I am still a bit confused.com. I have included the code I am using for testing below. As you can see I am passing the transaction in as GBP and it all goes through fine etc but when I view it in Google Analytics with EUR set as the local currency that test order shows up as 40€ not 40GBP converted to EUR (approx 47.47 EUR) so its not converting it it is simply displaying the value as EUR and not the Euro equivalent of GBP.
 
I have looked at adding the macro as you suggested (I made the assumption that Google detected it as the auto event handling) but I cannot see any mention of currency when creating the rules (bar the macro I created) but I am unsure how you can create a rule or macro to do the conversion. I have the standard eCommerce transaction setup and the only rule I have is:
 
UA Event is trackTrans {{event}} equals trackTrans
 
Any assistance in clarifying this would be very much appreciated.
 
Dave
 
<!-- BEGIN GOOGLE ANALYTICS ECOMMERCE dataLayer SCRIPT -->
dataLayer=[];
cartItems=[];
 
cartItems.push({
'sku':'TestIE-GBPTest1',
'name':'TestIE_GBPTest',
'category':'',
'price':20,
'quantity':1
}); //repeat for additional products
 
cartItems.push({
'sku':'TestIE-GBPTest2',
'name':'TestIE_GBPTest2',
'category':'',
'price':20,
'quantity':1
}); //repeat for additional products

dataLayer.push({
'event':'trackTrans',
'transactionId':'IE00-GBPTest',
'transactionAffiliation':'',
'transactionTotal':40,
'transactionTax':0,
'transactionShipping':8,
'transactionPaymentType':'',
'transactionCurrency':'GBP',
'transactionPromoCode':'',
'transactionProducts':cartItems
});
<!-- BEGIN GOOGLE ANALYTICS ECOMMERCE dataLayer SCRIPT -->
 
claudia_k
11/12/13
claudia_k
Hi Dave,

You do not need a new rule, just a macro to get the currency out of your website into GTM. For all the other values GTM does it automatically, but unfortunately not (yet) for the currency.
So if you have not done so already create a macro with the following settings:
macro name:
transactionCurrencyCode
macro type:
Data layer variable
Variable name:
transactionCurrency


Then go to the e-commerce tag that you have set up in GTM  and use this macro for the currency code in your tag - seen screenshots:

Classic Analytics:


Universal analytics:


Good luck

Claudia



11/12/13
Original Poster
Google user
Hi Claudia,
 
Saving my bacon once again :-) I have added that macro and run the tests, now waiting to see what shows up in GA. I was using universal analytics which is why I was getting confused. I don't think this nugget is mentioned so explicitly anywhere I can find, alot of what Google returns is either related to standard analytics or just does the usual of Oh your a developer surely you should know. I think an eCommerce setup guide would be a great idea for a next article for you coz I can tell you now the documentation and guides that are out there are pretty poor.
 
Should I bet using standard Google Analytics instead of Universal Analytics? I chose Universal Analytics as I wanted to future proof where I can and not have to redo work from standard analytics.
 
Dave
11/12/13
Original Poster
Google user
Hi Tom,
 
I was using universal anlytics rather than standard google analytics which is where the confusion came from. Thanks agian for all your help, if I had of been using google analytics that would have solved the problem for sure.
 
Dave
DuracellTomi
11/12/13
DuracellTomi
Hi Dave,

Universal Analyitcs does not support currently
  - remarketing
  - age/gender/interest reports

It will be in the (hopefully) near future.

If you do not need those reports for now I would suggest you to keep using UA.
If you need remarketing and the other reports I would suggest to use both GA and UA in two different web properties and let the GA profile go if UA has everything included.

Cheers,
Thomas Geiger

Graeme McLaughlin
8/27/15
Graeme McLaughlin
@cluadia_k - Could you help update this process for the new UI in Tag Manager please? It would be very much appreciated. 
Graeme McLaughlin
8/27/15
Graeme McLaughlin
Hi, sorry for the double post but it would be great if you could update the process within the new GTM  user interface. Thanks
Steve Esson
6/20/17
Steve Esson
Graeme, you just need to check the "Enable overriding of settings in this tag" and you will see the More settings section.
Thanks
Were these replies helpful?
How can we improve them?
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Expert - Google Employee — Googler guides and community managers
 
Expert - Community Specialist — Google partners who share their expertise
 
Expert - Gold — Trusted members who are knowledgeable and active contributors
 
Expert - Platinum — Seasoned members who contribute beyond providing help through mentoring, creating content, and more
 
Expert - Alumni — Past members who are no longer active, but were previously recognized for their helpfulness
 
Expert - Silver — New members who are developing their product knowledge
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.