Adobe Analytics and Power BI data limit workaround?

seanb62104197 30-10-2018

Hello Adobe Community! I am working on an analysis that requires time data (total seconds spent by a mobile device) I am connecting to Power BI to extract the data. but for some reason, it won't let me extract more than 750 rows of a specific dimension.

When I run a query let say my limit is top 750 whatever dimension can I start back at 751-1500 with the same date range? The reason I am asking is that I'm extracting total seconds spent on device type and it gives me the top seconds for the date range from 750 rows and that won't give me accurate analysis when it comes to time as a whole.

Screen Shot 2018-10-30 at 2.21.03 PM.png

Mark Solution

Are these answers useful?
Help other community members by marking useful answers as accepted.

Accepted Solutions (0)

Answers (3)

Answers (3)

seanb62104197 31-10-2018

Hey thanks I will give that a try...

My workflow and target for this analysis

I am creating a model in Power BI to help me uncover cross device users.

For example distinguishing from users that only use

Mobile + Tablet

Mobile + Desktop

Mobile + Tablet + Desktop

Desktop + Tablet

And the user's that only use single devices

Mobile

Desktop

Tablet

This part has already been achevied but now I want to get deeper into it and discover

"closed sales conduct x% of their activity on a mobile phone and y% on a desktop and timestamp when the user started using the device and avg time on each device so I know the usage of each device and what was used more in the process "

pabloc82923542 30-10-2018

Not sure what the source data is but could you not get usable data in Adobe Analytics by create Avg Time Spent per visit?

You could then segment users by groups 0-30 sec 31-60 61+ etc...

If you ran device type report then you could get site wide averages etc...

Can you explain in more detail the workflow you have and what desired reporting is being targeted?

regards