Hi,
I've connected to Google Ads as a Data Source. Everything comes across accurately, but the format of the cost number is tripping me up. Here's what I'm seeing;
From Google Directly: Google Cost = 9,930.00
From the Tableau Google Ads Import: Google Cost = 9,930,560,300
I think I should convert the Google Cost field into a String, and then create a calculated field to format the cost correctly. But, I'm not getting anywhere....and haven't been able to locate documentation on how to format the number correctly.
Would appreciate any help, even referral to documentation I might've missed.
Edit: I located a Related Question that was answered: https://community.tableau.com/s/question/0D54T00000C6e8gSAB/direct-google-ads-connection-why-are-my-numbers-so-high However, this seems like a not-so-great solution.
I think - Tableau has this documented too - so @kofi okine is right on other post
https://help.tableau.com/current/pro/desktop/en-us/examples_googleads.htm
Use a calculated field to correct money values
The connector returns the data in the same format as the Google Ads API. For Money fields (such as costs, amounts, etc.), the Google Ads API returns them in micro currency units(micros). To have the correct value you need to divide by 1000000 to get the amount in the account's local currency.
