Adobe Analytics connector - Data imported not correct

[rossella_]

Hi all, my customer is connecting to Adobe Analytics but data doesn't match.

Data imported into Power BI  are partial with regard to the numbers found in Adobe Analytics.

Suppose it can be given by the fact that there is a limit of imported rows in the table derived from the cube. From the documentation it seems that the limit is 50k, in this test 31k rows have been imported, but the correct data has not been returned. Adobe Analytics does a sampling? Is it possible to import data in the same form as analytics?
Is it possible to fill the sampling gap with a string in the query "#"samplingLevel" = HIGHER_PRECISION"?

Moreover, segment data created in Adobe Analytics can be imported with queries on individual segments but cannot be used as filters on the global query. Is it possible to import segments as dimensions, so we don't have to repeat queries for each segment?

Thank you!

[v-janeyg-msft]

Hi, @rossella_ 

Please follow these guidelines when using Analytics APIs:

• Make multiple, smaller requests instead of a large, single request.
• Request data once and cache it.
• Do not poll for new data faster than a 30 minute interval.
• Pull historical data and increment it regularly instead of requesting the entire data set.

Discouraged Practices:

• Requesting as much data as possible in a single request
• Requesting one year of data at day granularity everyday - just request the new day and merge it
• Driving a web page with a site performance widget by making an API request every time the web page is loaded
• Requesting a full year of day-level data every day to get a rolling 12-month window

You can also limit the amount of data by selecting a set of optional input parameters.

There are similar case1 and case2 you can refer to, If you still have the problem, maybe you could ask in Adobe analytics forum: Adobe Analytics

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.