Combine Your Whole Data With This 1 Weird Trick
On Voluum but probably also different trackers there are limits. Sometimes we also lose data because of data retention. Sometimes we can get only 30 days max.
@diplomat advised to use AWS tools to join all data but I don’t really know how it works.
But I know Google Sheets a bit and I can Google 😀
So I created the sheet which does the whole job.
I got so much help and value from STM so probably it’s the time to give some love back. Maybe this sheet will be useful to somebody 🙂
Anyway, how it works? I will show it with Voluum as example.
1. Go to your tracker, select all placements from last 30 days from whatever GEO / offer / vertical you want. Click Export > Download CSV
Select placement (Zone ID), revenue, costs and conversions. That’s all what we need.
2. Repeat step #1 with older period of time or whatever different data. Now you have at least 2 CSV files with various data.
3. Go to the Google Sheet Data Combiner. I shared it to view only. So just click File > Make a copy and use it on your Google Drive.
4. You can see two sheets in the file. It’s “data” and “unique ...