Report according to specific pages by device and country

Hello, I need to create a report to track visits by device and country for specific pages. Is there any way to do this without having to create a segment or purchase the custom reports module?

maybe with segmentation.

I had thought about using a segment or a custom report, but I’m not sure if there’s any other way to do it. Keep in mind that there are more than 300 pages, and creating a segment for each one seems like an overwhelming task. Is there perhaps a way to do it directly with SQL from the tables?

For 300 pages is OK. 300 website not.

Use the matomo API:

Or create a Plug-In:

Thank you for the help. However, after reviewing the available APIs in Matomo, I don’t see any way to extract this information without creating the segments beforehand. Because each module has its own API, I can’t extract visits from a page by device and country in a single query by filtering for the page. Do you know if there’s any other way to obtain this information?

This is always possible. I don’t know wich tables.

That is not a problem. By this, you must the results filtered with a for loop.
… I have tested a segment with language and device type. This is the query:
It is possible.
By creating a segment, the Test is only a test. You must save it.

Hi @Sergi
You can use the Custom Report premium plugin: