Google Analytics Custom Dimension falsely interpreted as number
Hi everyone,
I have created a custom report in the GA Connector but correctly importing the most important column doesn't work properly.
The GA Client ID is a string of the following format: "1234567890.1234567890". When this is imported, Domo sees it as a number and cuts off some digits in the end.
This is what I tried to fix it (nothing worked):
- Export the data to Excel -> more digits are reveiled but not all the whole string
- Use Magic ETL to convert the column into a number with more decimals -> still missing digits (and the original form isn't kept, so blending with other data sources doesn't work)
- Contacted Live Chat -> "Please leave as feedback."
- Left as feedback to the product team -> silence until now.
Does anyone have another idea how to tackle this?
Thanks,
Rob
Comments
-
Is anyone able to help out with this request?
0 -
Hey there,
As far as digits are concerned, we only support numbers up to 18 digits.
Currently, there is only 3 ways to force a column type.
1. Through Domo Workbench,2. Through the Domo API.
3. You can add some sort of character to each row in your data before it comes into Domo.
Regarding the feedback you gave, to have it escalated, please contact your Customer Success Manager and Account Executive.Thank you!
Brandon Wardell
Associate Technical Advisor0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive