{"id":1345,"date":"2025-04-17T13:13:45","date_gmt":"2025-04-17T13:13:45","guid":{"rendered":"http:\/\/practicalecommerce.xyz\/index.php\/2021\/06\/17\/using-data-studio-to-convert-multi-currency-reports\/"},"modified":"2025-09-26T02:39:43","modified_gmt":"2025-09-26T02:39:43","slug":"utilizing-information-studio-to-convert-multi-currency-stories","status":"publish","type":"post","link":"https:\/\/practicalecommerce.xyz\/?p=1345","title":{"rendered":"Utilizing Information Studio to Convert Multi-currency Stories"},"content":{"rendered":"<p>Increasing into worldwide markets presents alternatives and challenges for ecommerce firms. One problem is to report the return on promoting and income in every nation and total. Including a number of currencies to the combo complicates the hassle.<\/p>\n<p>Google Analytics can mix a number of currencies into one. Google explains in an Analytics Assist publish the best way to embrace the forex area within the ecommerce monitoring code to transform currencies into the default forex setting.<\/p>\n<p>Google Analytics\u2019 conversion of currencies is easy. Nevertheless, setting the conversion date to equal the date of the transaction will not be an choice, forcing retailers to transform currencies manually. Google Information Studio\u2019s capacity to mix information sources can resolve this guide conversion hurdle.<\/p>\n<blockquote>\n<p>Including a number of currencies to the combo complicates the hassle.<\/p>\n<\/blockquote>\n<h3>Information Studio<\/h3>\n<p>In a publish final yr, I launched mixing information sources in Information Studio. That instance blended SKU prices on a Google Sheet with SKU gross sales in Google Analytics.<\/p>\n<p>For this forex conversion instance, I&#8217;ve created one other Google Sheet that lists the U.S. greenback conversion quantities for distinguished world currencies. We are able to then use that conversion information in Information Studio to transform from U.S. {dollars} to different currencies and vice versa. I\u2019ll assume we\u2019ve marketed on Fb, and we\u2019re changing that advert spend from {dollars} to euros.<\/p>\n<p>Step one is so as to add the info sources in Information Studio. For this instance, the sources are the currency-conversion Google Sheet and information from Facebooks Advertisements.<\/p>\n<p>Within the screenshot beneath, I&#8217;m mixing information from Fb Advertisements and my Google Sheet, to transform from {dollars} into euros. I&#8217;ve used the \u201cDate\u201d as a \u201cBe part of key\u201d for each information sources. The metric I\u2019ve chosen from the Fb information is advert \u201cSpend.\u201d The metric from the Google Sheet is \u201cEuro\u201d as our purpose is to transform Fb {dollars} into euros.<\/p>\n<p id=\"caption-attachment-190257\" class=\"wp-caption-text\">In Google Information Studio, mix information from Fb Advertisements and the Google Sheet, to transform from {dollars} into euros. <em>Click on picture to enlarge.<\/em><\/p>\n<p>\u2014<\/p>\n<p>After saving this mix, I\u2019ve included the date of the advert spend and renamed three different metrics.<\/p>\n<p id=\"caption-attachment-190258\" class=\"wp-caption-text\">Embrace the date of the advert spend (at left) and rename three metrics: \u201cSpend in {Dollars},\u201d \u201cEuros\/Greenback,\u201d and \u201cSpend in Euros.\u201d <em>Click on picture to enlarge.<\/em><\/p>\n<p>The three identify clarifications are:<\/p>\n<ul>\n<li>\u201cSpend in {Dollars}.\u201d I renamed the \u201cSpend\u201d metric to \u201cSpend in {Dollars}\u201d to make clear the forex, which additionally injects the greenback signal. We are able to rename metrics in Information Studio by clicking to the left of the identify.<\/li>\n<\/ul>\n<p id=\"caption-attachment-190259\" class=\"wp-caption-text\">Rename metrics by clicking to the left.<\/p>\n<p>\u2014<\/p>\n<p id=\"caption-attachment-190260\" class=\"wp-caption-text\">Deciding on the forex additionally injects the greenback signal.<\/p>\n<ul>\n<li>\u201cEuros\/Greenback.\u201d I renamed the \u201cEuro\u201d area to \u201cEuros\/Greenback\u201d to be extra descriptive. This area is the conversion issue between {dollars} and euros. It may be omitted from the report, however I included it for extra element.<\/li>\n<\/ul>\n<ul>\n<li>\u201cSpend in Euros.\u201d I created this new calculated area utilizing the next components:<\/li>\n<\/ul>\n<p style=\"padding-left: 80px\"><em>Spend in Euros = sum(Spend)*avg(Euro)<\/em><\/p>\n<p style=\"padding-left: 40px\">The components multiplies Spend occasions the euro conversion issue. I wrap Spend in \u201csum\u201d as Information Studio requires it. I wrap euro in \u201cavg\u201d in case I embrace a abstract row from the underside of my desk. You may additionally wrap in \u201csum\u201d to provide this components:<\/p>\n<p style=\"padding-left: 80px\"><em>Spend in Euros = sum(Spend)*sum(Euro)<\/em><\/p>\n<p style=\"padding-left: 40px\">Bear in mind, nonetheless, that in case you are utilizing a desk and embrace a abstract row, the abstract worth can be off for this column.<\/p>\n<p id=\"caption-attachment-190261\" class=\"wp-caption-text\">Correct abstract row reporting when utilizing \u201cavg(Euro).\u201d<\/p>\n<p>\u2014<\/p>\n<p>If I had used \u201csum(Euro),\u201d the person rows would calculate accurately, however the abstract row can be off.<\/p>\n<p id=\"caption-attachment-190262\" class=\"wp-caption-text\">Correct abstract row reporting when utilizing \u201csum(Euro).\u201d<\/p>\n<p>\u2013<\/p>\n<p>Additionally, modify the sphere from a quantity to forex \u2014 euros on this case.<\/p>\n<p id=\"caption-attachment-190263\" class=\"wp-caption-text\">Modify the sphere from a quantity to forex \u2014 euros on this case.<\/p>\n<h3>One Forex<\/h3>\n<p>With the brand new forex conversion course of, we are able to assemble all gross sales and promoting spend information into one native forex for efficiency evaluation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Increasing into worldwide markets presents alternatives and challenges for ecommerce firms. One problem is to report the return on promoting and income in every nation and total. Including a number of currencies to the combo complicates the hassle. Google Analytics can mix a number of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1349,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[133],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=\/wp\/v2\/posts\/1345"}],"collection":[{"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1345"}],"version-history":[{"count":1,"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=\/wp\/v2\/posts\/1345\/revisions"}],"predecessor-version":[{"id":1348,"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=\/wp\/v2\/posts\/1345\/revisions\/1348"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=\/wp\/v2\/media\/1349"}],"wp:attachment":[{"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/practicalecommerce.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}