Connecting/Calculating Google Sheets with Analytics
Comments
-
Step one would be to import the pageviews data from the Google Analytics data connector. Once you have the data imported, I would cross check the identifiers you have for the pages and the sale items to make sure there is something you can join on. (example, if WidgetA is on page id 49584 I would go through and add that page id to my Google Sheet so that I can join the data together).
Step two would be to import your updated Google Sheet and then build an ETL that joined your item sales to the relevant page views.
From there you could modify this to fit whatever final cards you're looking to achieve.
Hope this helps,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Thank you for your fast replay. This isn't really easy. When i try to join the data, it didn't works. In Analytics i have data from every day in one row. In Google Sheets i have one row for each order. In my optinion this must go much easier. I must get the number of pageviews from a selected page and the sales date in one calculation.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive