Example for using a pivoted report with pivotby

Support & Bugs
1

We have trouble to use the pivotby function with the provided example I found online:

YOUR-DOMAIN/index.php?date=yesterday&filter_limit=10&flat=1&format=XML&idSite=YOUR-ID-SITE&method=Events.getCategory&module=API&period=day&pivotBy=Events.EventAction&pivotByColumn=nb_events&pivotByColumnLimit=20&token_auth=YOUR-AUTH-CODE

as it is specific for events but we need a different dimensions as e.g. in follwing reporting structure we used with google analytics and want to use also now with matomo:

Dimensions:

medium
,deviceCategory
,countryIsoCode
,e.g. custom_dimension7

Metrics:

visits
,bounceRate
,sessionDuration
,pageviews
,timeOnPage
array_get(“goal(n)Completions”, 1)AS goal6Completions, -> a defined goal

Can you please provide a link as for the event example?

Thanks

2

Not sure if that’s possible, but maybe you can use Custom Reports for this? (although they’re limited to 3 dimensions): Custom Reports User Guide - Analytics Platform - Matomo