I am trying to build a data table using all the data in Adobe Analytics data warehouse within my respective reporting suite and bring it into R. At the moment I am using RSiteCatalyst to connect to Adobe's API however I am not sure how to bring both multiple dimensions and metrics into a single table. I work in Television so the table I am trying to bring in would be something like:

  1. report suite (dimension)
  2. date (time)
  3. program/show (dimension)
  4. viewing device (dimension)
  5. page views (metrics)
  6. unique visitors (metrics)
  7. visitors (metrics)

Please let me know. Most functions in RSiteCatalyst allow only one dimension or metric with the exception of QueueDataWarehouse which times out when I run it.

0 Answers