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
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