Google analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-08-2020 08:33 PM
I am working with google analytics integration and have some query.
I saw there is only one google analytics read snap provided where I can select only one account id and one table id.
Question 1) Can I configure it dynamically for all accounts and all tables inside that? How?
Question 2) If I try to write write google analytics result in File Write, I want to keep the file name same as ‘Table Id’ field in Google Analytics means dynamically. How can we do it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-13-2020 11:16 AM
There may be other ways, but I would likely try:
- Create the pipeline with the Google Analytics through to File Writer.
- define variables for AccountID and TableID
- set Account ID and Table ID to expressions (clicking the = button) and map them to their respective variables.
- in the File Writer, set File Name to an expression and map it to Table ID.
- Create a second pipeline with CSV Reader and Pipeline Execute
- create a csv file to store all account ID-table ID pairs.
- in Pipeline Execute, call the first first pipeline and map the CSV header labels to the Account Id and Table ID variables.
- run this pipeline.
Diane Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-24-2020 03:29 AM
thanks @dmiller
