Usage Metrics Report poor data integrity

[AntonioAngel]

Hello all,
I am trying to get data from the dataset 'Usage Metrics Report' in order to store the views we have in our reports.

I would expect that if a user visits 3 pages in a report in a given date I would have three records in the table 'Report page views', and one record in the table 'Report views' for that user, report and date.

Nevertheless, I find some records in 'Report Page Views' without record in 'Report views' and vice-versa. Seems there is no data integrity. The unmatching records reach 10% in some reports, which is a lot.

Anyone can help me to understand why this happens?

[aj1973 · Accepted solution]

Hi @AntonioAngel 

Here is the answer

Use REST APIs for better metrics