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
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive