When working with Google Analytics, you might came across the need to combine the data from multiple accounts into single consolidated output. As an example, let’s imagine you want to merge the following data coming from two independent Google Analytics accounts :
Google Analytics data #1:
Google Analytics data #2:
Expected output :
To combine such, people in most cases utilize tools like MS Excel or Google Spreadsheet, but the whole process is rather a pain, especially when performed on regular basis. Fortunatelly, you can use Dataddo to automate the whole process and get the most from your data.
Step 1 : Define data sources
Presuming you have already registered in Dataddo, you can utilize Google Analytics connector to gather the data from Google Analytics. The connector allows you to define multiple dimensions and metrics, set advanced filters or set-up automated data synchronization. You can explore our Wiki to overview the complete functionality of Google Analytics connector. Add a source for every Google Analytics account you want to combine.
Step 2 : Adding a structure
Dataddo has a quite unique feature called structure, allowing you to define a relations between the data from multiple diferrent sources and merge them together. Simply, in structure designer drag & drop the sources you want to combine together and make sure all the sources have the same count of columns (remember, the data from one column will be placed on top of another one). Do not define any connection between the sources. You can explore the full functionality of structures in our Wiki.
Step 3 : Explore the data!
Once the structure is set up, you can explore the data. If you are merging the data that somehow overlap, you might find very useful using data aggregation. For example, if you download data from two separate GA accounts data with dimension “sourceMedium”, you should group the data according to this column and to other columns set aggregation function “sum of values”. This set-up will produce consolidated output from both accounts.