First: I have Piwik on my site and I’m very happy with it!
I have set up a “goal”. Now: i would like to query the piwik database via PHP to get the total number of conversions (just the total, i dont mind the date rage, etc.). I need to use that numer on another application (witch sum the total conversions from different sources).
It’s easier! I do not have subdomains. The other sources are external websites witch i do not host.
The only thing i need to do is to get from the db the total number of times the goal “XYZ” has been reached (unique users). The goal is the “id=2” in “piwik_goal” table.
I guess i have to query the “piwik_log_conversion” table in some way…
Thanks matt! I tried to look at “api_rest_call.php” and “api_internal_call.php” but i really do not understand where to start ;). Is there an online references or some pratical example somewhere?