Forum Discussion

munish's avatar
munish
New Contributor
6 years ago

Google analytics

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?

pipeline

2 Replies

  • dmiller's avatar
    dmiller
    Former Employee
    6 years ago

    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.