Combining data from multiple Google Analytics accounts

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:

Source Visits Pageviews
Google 100 232
Facebook 50 183

Google Analytics data #2:

Source Visits Pageviews
Google 121 288
Facebook 34 99
Quora 77 201

Expected output :

Source Visits Pageviews
Google 100 232
Facebook 50 183
Google 121 288
Facebook 34 99
Quora 77 201

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.

add_sourceconnector

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.

structure_designer

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.

New Data explorer