Power Query get and transform data

Mike1093

New Member
Joined
Nov 1, 2019
Messages
1
Hi experts,

for reporting on e-commerce data I am preparing daily, weekly and monthly reports. The data sits in different databases (Oracle, Google Analytics and numerous third partner platforms). The KPIs needed are: order count, revenue, cost, clicks, impressions.

Is there a way to automate queries from Oracle and Google Analytics? With Google Analytics, I have stumbled across Query Explorer and found it really useful. But so far, I was only able to pull KPIs on the total data. How can I use Query Explorer to pull data from different marketing channels into Excel via Power Query?

With third parties, however, the problem seems to be that one would have to log in every time one needs to uptade a (daily) report. Is there a way around?

Looking forward to your insights.

Best,

Mike
 

Forum statistics

Threads
1,077,784
Messages
5,336,327
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top