GA connector: update dimensions/metrics mid way
We are trying to streamline our GA connectors at the minute. This could entail adding some new dimensions to existing datasets or swapping dimensions.
I have done a test on a GA dataset to swap device category for date, and it did not work. The connector allowed me to do the change, but the new run did not change anything. The device category column became null, but the date column did not appear. This does not bode well for the streamlining we are trying to do.
Any idea guys? @jaeW_at_Onyx ?
Thank you very much for your help.
I would take a very careful read of all the settings.
To support customers with highly segmented GA datasets and retain multi-year history while minimizing throttling / Google enforced API rate limits, Domo implemented partitioning.
In a nutshell Partitioning means "just update new data as it comes along." It is possible that your settings are using Partitioning, and therefore, when you reran your connector with new settings it did not replace your full history and instead added the new column to the dataset (with NULL for historical data) and just checked for new data.
For experiments sake, try setting up a new GA connector in with the settings you want to confirm you can get the desired results.
If the experiment works, use the new connector in your ETLs OR revisit the existing connector to see if there's a way to force a reset of the data.
If you're confident there's a bug in the product, [email protected] can help!Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Hi @jaeW ,
Thank you for your reply!
I'll check the settings you mentioned and will test things out.
What you said around the partitioning could also explain why i cannot get historical data on brand new connectors. I can only get the day before, it cannot do historical data pulls... It shows the option for 30, 60 or 90 days but it never works.
I'll try this out and will come back to you.
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 478 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 43 Visualize
- 199 Beast Mode
- 2K Charting
- 8 Variables
- 20 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 29 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部