Hello,
I’m having trouble using this API, because any newly created URL seems to have recurrent visits even when it did not exist.
Here is the request I’m using
http://piwik.mywebsite.com/.fr/index.php?method=Actions.getPageUrl&pageUrl=http://my_url&date=last10&period=day&module=API&idSite=1&token_auth=e9e3bddcfa2455c5111e39a70024deed&format=xml
which returns the following XML
<results>
<result date="2012-07-07"/>
<result date="2012-07-08"/>
<result date="2012-07-09"/>
<result date="2012-07-10"/>
<result date="2012-07-11"/>
<result date="2012-07-12"/>
<result date="2012-07-13">
<row>
<label>/a5c2f0a40a</label>
<nb_visits>4</nb_visits>
<nb_uniq_visitors>4</nb_uniq_visitors>
<nb_hits>4</nb_hits>
<sum_time_spent>1706</sum_time_spent>
<entry_nb_uniq_visitors>2</entry_nb_uniq_visitors>
<entry_nb_visits>2</entry_nb_visits>
<entry_nb_actions>33</entry_nb_actions>
<entry_sum_visit_length>12669</entry_sum_visit_length>
<entry_bounce_count>1</entry_bounce_count>
<exit_nb_uniq_visitors>2</exit_nb_uniq_visitors>
<exit_nb_visits>2</exit_nb_visits>
<avg_time_on_page>427</avg_time_on_page>
<bounce_rate>50%</bounce_rate>
<exit_rate>50%</exit_rate>
<url>http://mywebsite.com/a5c2f0a40a</url>
</row>
</result>
<result date="2012-07-14"/>
<result date="2012-07-15"/>
<result date="2012-07-16"/>
<result date="2012-07-17"/>
<result date="2012-07-18"/>
<result date="2012-07-19"/>
<result date="2012-07-20"/>
<result date="2012-07-21"/>
<result date="2012-07-22"/>
<result date="2012-07-23"/>
<result date="2012-07-24">
<row>
<label>/a5c2f0a40a</label>
<nb_visits>4</nb_visits>
<nb_uniq_visitors>4</nb_uniq_visitors>
<nb_hits>4</nb_hits>
<sum_time_spent>1706</sum_time_spent>
<entry_nb_uniq_visitors>2</entry_nb_uniq_visitors>
<entry_nb_visits>2</entry_nb_visits>
<entry_nb_actions>33</entry_nb_actions>
<entry_sum_visit_length>12669</entry_sum_visit_length>
<entry_bounce_count>1</entry_bounce_count>
<exit_nb_uniq_visitors>2</exit_nb_uniq_visitors>
<exit_nb_visits>2</exit_nb_visits>
<avg_time_on_page>427</avg_time_on_page>
<bounce_rate>50%</bounce_rate>
<exit_rate>50%</exit_rate>
<url>http://mywebsite.com/a5c2f0a40a</url>
</row>
</result>
<result date="2012-07-25"/>
<result date="2012-07-26">
<row>
<label>/a5c2f0a40a</label>
<nb_visits>4</nb_visits>
<nb_uniq_visitors>4</nb_uniq_visitors>
<nb_hits>4</nb_hits>
<sum_time_spent>1706</sum_time_spent>
<entry_nb_uniq_visitors>2</entry_nb_uniq_visitors>
<entry_nb_visits>2</entry_nb_visits>
<entry_nb_actions>33</entry_nb_actions>
<entry_sum_visit_length>12669</entry_sum_visit_length>
<entry_bounce_count>1</entry_bounce_count>
<exit_nb_uniq_visitors>2</exit_nb_uniq_visitors>
<exit_nb_visits>2</exit_nb_visits>
<avg_time_on_page>427</avg_time_on_page>
<bounce_rate>50%</bounce_rate>
<exit_rate>50%</exit_rate>
<url>http://mywebsite.com/a5c2f0a40a</url>
</row>
</result>
</results>
and the URL was opened today (and it might have gotten 5 visits effectively).
Indeed, I noticed days had all the same visits. If I go back to last200 some others day have the same result.
Does anyone have any idea ?
It could help if I could query the MySQL database directly, though I’m not used to querying in MySQL + I don’t know the tables structure. Could anyone tell me what sql request should I make ?
Regards,
Alexis.