Set goals in ETL



I'd like to take a dataset (for instance sessions per day in Google Analytics or followers on LinkedIn per day) and and daily targets to it.

So lets say these are the dates and number of sessions for March until now:

1: 25

2: 35


4: 30

5: 56

6: 66

7: 10

Then I'd like to put in the goals for each day that I have in a Google Spreadsheet.

How do I join them properly? When joining in ETL I get some very strange numbers - especially because the session numbers can be divided into what device they were on (mobile, tablet, desktop).

Anyone has a solution for this?



Best Answer