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...
pipeline
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.