Currently, I manually download csv reports from multiple marketing channels. Some of them have Supermetrics connectors but they’re expensive so I choose to get weekly reports scheduled to my email.,I then convert dates into weeks in excel so I can provide WoW reports like this:
I basically do all the calculation (nothing much, just CTR, CPC etc) in an excel sheet where I copy/paste all the records together (that are split by dates), run pivot and put it all together.
Before coming to Parabola, I attempted to find a way to put all these CSVs into BQ and not knowing SQL, it became a problem with the ultimate goal of showing this in GDS. So I stopped trying it out.
now I find you guys where things indeed look simple. I was curious though… given what I explained above… is it simple if I use you guys?