Tag Manager Lookup Table change comma to decimal point
i have a problem with Facebook Donations and Fundraising. The Amount is written with comma but i need it in decimal point to match the data with data from other sources in my German Google Analytics Account. The Data from other sources is written the german way with decimal point.
Is there a way to convert the data from facebook with comma (10,000) into german data with decimal point (10.000) with a Google Tag Manager Lookup Table?
google-analytics google-tag-manager lookup-tables
asked Nov 23 '18 at 12:58
AdriAdri
63
add a comment |
i have a problem with Facebook Donations and Fundraising. The Amount is written with comma but i need it in decimal point to match the data with data from other sources in my German Google Analytics Account. The Data from other sources is written the german way with decimal point.
Is there a way to convert the data from facebook with comma (10,000) into german data with decimal point (10.000) with a Google Tag Manager Lookup Table?
google-analytics google-tag-manager lookup-tables
asked Nov 23 '18 at 12:58
AdriAdri
63
add a comment |
i have a problem with Facebook Donations and Fundraising. The Amount is written with comma but i need it in decimal point to match the data with data from other sources in my German Google Analytics Account. The Data from other sources is written the german way with decimal point.
Is there a way to convert the data from facebook with comma (10,000) into german data with decimal point (10.000) with a Google Tag Manager Lookup Table?
google-analytics google-tag-manager lookup-tables
asked Nov 23 '18 at 12:58
AdriAdri
63
i have a problem with Facebook Donations and Fundraising. The Amount is written with comma but i need it in decimal point to match the data with data from other sources in my German Google Analytics Account. The Data from other sources is written the german way with decimal point.
Is there a way to convert the data from facebook with comma (10,000) into german data with decimal point (10.000) with a Google Tag Manager Lookup Table?
google-analytics google-tag-manager lookup-tables
google-analytics google-tag-manager lookup-tables
asked Nov 23 '18 at 12:58
AdriAdri
63
asked Nov 23 '18 at 12:58
AdriAdri
63
asked Nov 23 '18 at 12:58
AdriAdri
63
asked Nov 23 '18 at 12:58
AdriAdri
63
asked Nov 23 '18 at 12:58
AdriAdri
63
63
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
So I think you can create a variable with Custom Javascript and do a str.replace of "," to "." and THEN send that to GA?
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
That's a much better idea than using a lookup table (as asked by the OP), which would require a line for every possible amount.
– Eike Pierstorff
Nov 25 '18 at 17:34
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53447166%2ftag-manager-lookup-table-change-comma-to-decimal-point%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
So I think you can create a variable with Custom Javascript and do a str.replace of "," to "." and THEN send that to GA?
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
That's a much better idea than using a lookup table (as asked by the OP), which would require a line for every possible amount.
– Eike Pierstorff
Nov 25 '18 at 17:34
add a comment |
So I think you can create a variable with Custom Javascript and do a str.replace of "," to "." and THEN send that to GA?
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
That's a much better idea than using a lookup table (as asked by the OP), which would require a line for every possible amount.
– Eike Pierstorff
Nov 25 '18 at 17:34
add a comment |
So I think you can create a variable with Custom Javascript and do a str.replace of "," to "." and THEN send that to GA?
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
So I think you can create a variable with Custom Javascript and do a str.replace of "," to "." and THEN send that to GA?
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
answered Nov 23 '18 at 18:13
XTOTHELXTOTHEL
2,1911210
2,1911210
That's a much better idea than using a lookup table (as asked by the OP), which would require a line for every possible amount.
– Eike Pierstorff
Nov 25 '18 at 17:34
add a comment |
That's a much better idea than using a lookup table (as asked by the OP), which would require a line for every possible amount.
– Eike Pierstorff
Nov 25 '18 at 17:34
That's a much better idea than using a lookup table (as asked by the OP), which would require a line for every possible amount.
– Eike Pierstorff
Nov 25 '18 at 17:34
That's a much better idea than using a lookup table (as asked by the OP), which would require a line for every possible amount.
– Eike Pierstorff
Nov 25 '18 at 17:34
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53447166%2ftag-manager-lookup-table-change-comma-to-decimal-point%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
