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.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有