Google Analytics Ecommerce conversion code decimal issue

Gwendolyn Chambers · March 2019

Reviving an older issue that does not appear to have a been resolved. After following a very helpful webinar on setting up e-commerce conversions, it appears that any gifts over 999.00 get reported to GA at $1.00. So a $1,000 gift is reported as $1.00 or a $10,000 gift is reported as $10, etc. Does anyone know how to fix this?



[[?[[S8]]::donation=completed::

<script type="text/javascript">// <![CDATA[

var rev = "[[S120:dc:giftAmount]]";

var recu = "[[S120:dc:recurringCurrentStatusString]]";

var mon = "Donation_OneTime";

if(recu=="Active"){

mon = "Donation_Recurring";

}

window.dataLayer = window.dataLayer || []

dataLayer.push({

'transactionId' : "[[S120:dc:trackingCode]]",

'sustainerActive': "[[S120:dc:recurringCurrentStatusString]]",

'transactionAffiliation': "[[S120:dc:donFormId]]",

'transactionTotal':rev,

'transactionProducts': [{

'sku': "[[S120:dc:donFormId]]",

'name': "[[S120:dc:donationFormName]]",

'category': mon,

'price': rev,

'quantity': 1

}]

});

// ]]></script>::



]]

Bri MacBain · March 2019

Offhand I'd say this sounds like something to do with GA values only accepting integers. Maybe try sending your values in cents instead of dollars to get rid of decimals and see if that helps.
https://www.en.advertisercommunity.com/t5/Google-Analytics-Tracking-Goals/Event-Tracking-Value-Why-Integer-Values-Only/td-p/482813 for more info.

Gwendolyn Chambers · March 2019

Thanks for your suggestions Bri. Unfortunately, I wouldn't know how to do that and the link doesn't seem to give any specific instruction. Would I be changing something in the data layer or somewhere else? I'm not a coder and fairly new to Tag Manager so I struggle to solve problems like this.

-Gwendolyn

Gwendolyn Chambers · March 2019

I almost don't believe it but I got this problem solved through Google support. After two hours on the phone, I was supplied with a bit of code to insert on the TransactionTotal and price lines of the datalayer. Google Analytics was reading the comma as a dot and this piece of code fixes that issue. Hopefully, it will stay fixed+>



[[?[[S8]]::donation=completed::

<script type="text/javascript">// <![CDATA[

var rev = "[[S120:dc:giftAmount]]";

var recu = "[[S120:dc:recurringCurrentStatusString]]";

var mon = "Donation_OneTime";

if(recu=="Active"){

mon = "Donation_Recurring";

}

window.dataLayer = window.dataLayer || []

dataLayer.push({

'transactionId' : "[[S120:dc:trackingCode]]",

'sustainerActive': "[[S120:dc:recurringCurrentStatusString]]",

'transactionAffiliation': "[[S120:dc:donFormId]]",

'transactionTotal':rev.replace(/[^0-9.]/g,''),

'transactionProducts': [{

'sku': "[[S120:dc:donFormId]]",

'name': "[[S120:dc:donationFormName]]",

'category': mon,

'price': rev.replace(/[^0-9.]/g,''),

'quantity': 1

}]

});

// ]]></script>::



]]

Yohan Aton 2 · May 2019

Hi, I realize this may be a step backwards, but can you please share where / how you're adding Google conversion code?

- Trying to set up via gtm conversions based on form fills and seems the form will not allow for redirect to thank you page nor is the submit button working as an event seemingly as the form is a js embed.

Any help or insight would be greatly appreciated.

Thank you!!!

Gwendolyn Chambers · May 2019

Hi Yohan,

I set up tracking conversions with directions from this webinar by DataHabits: https://datahabits.us3.list-manage.com/track/click?u=993895032867af2b1e375cb4a&id=f55088bf2b&e=8334bdac21 There is a required password: bbaudluminate

If you have trouble getting to it, I would try contacting Datahabits and maybe getting on their email list: https://datahabits.com/

-Gwendolyn

Yohan Aton 2 · May 2019

Hi Gwendolyn,

Thanks so much for your message.

Watching it now... although I don't believe it's going to work
for my use case as I need to set up a tag and trigger based on a
form completion - either redirect or submit button on School
website...

- Hoping to hear back from support but they told me to check
the forum.

Thank you!!!!

Yohan

Reid Dossinger · June 2019

Hi, Gwendolyn. Is this solution still working for you? I was looking to implement it. And have you found it to be accurate? Thanks!

Gwendolyn Chambers:

I almost don't believe it but I got this problem solved through Google support. After two hours on the phone, I was supplied with a bit of code to insert on the TransactionTotal and price lines of the datalayer. Google Analytics was reading the comma as a dot and this piece of code fixes that issue. Hopefully, it will stay fixed+>

Gwendolyn Chambers · July 2019

Yes, this appears to still be working and recording accurately.

Elizabeth Makayed 2 · July 2019

Gwendolyn Chambers‍ ,

You can also convert the value into an integer in Luminate before forwarding the data into the analytics system & parsing it there. With GTM the JavaScript is allowed but it gets trickier when the data goes straight into Google Analytics.

The code for converstion to the integer would be [[E130:[[S120:dc:giftAmount]] number]] .

Hope this is helpful as well, although a bit late.

Gwendolyn Chambers · July 2019

Thanks, I'll keep that in mind!

Google Analytics Ecommerce conversion code decimal issue

Comments

Categories