@anonymous-matomo-user opened this Issue on November 22nd 2011

Hello there!

We have done some work with the 'Referrers' plugin and added a new tab "Referrers"->"Social Networks", where you can see entry counts and referrer link from many social networks.

And it works this way:

It requests to the website list (like it does for the "Referrers"->"Websites" tab) and after that it uses the 'pattern' filter.

The list of social networks is here: /piwik/plugins/Referers/data/socials.csv (55 snw)

Each social network gets related icon (like it does for the "Referrers"->"Search Engines & Keywords" tab) from the piwik/plugins/Referers/images/socials folder.

Also we created a new widget: 'Referrers/list of social networks' and we find it very useful. You can add this on you dashboard now.

So that's it.

We would like to make it able to view this social networks info also in the "Referrers"->"Overview" tab. But unfortunately it can't be done using a filtering. So we just put it aside for a while.

If you have some ideas about all this social networks features -- that could help to make it more useful -- we would love to hear from you and try to make it real.

See the attachments for the core patch.

''Best regards.
Codax team''

@anonymous-matomo-user commented on November 22nd 2011


@anonymous-matomo-user commented on June 21st 2012

Attachment: Social networks png list

@anonymous-matomo-user commented on August 31st 2012

Attachment: Fixed

@anonymous-matomo-user commented on November 22nd 2011

referrers.patch - main patch file for the referrers plugin.

csv_img.zip - new files (.ico of socials and .csv) that should be unzipped to the related folders.

@mattab commented on November 22nd 2011 Member

Thanks codax for the patch!! Excellent idea :-)

Are you interested to include this in core? It would be great to have this in Piwik core.

Here is the code review as per our development process

  • Could you change the CSV file and instead put the list of Social networks in a simple php similarly to the search engines file (see other data files in same folder).
    It will make the code simpler.
  • also, please put the images in png format, in the folder plugins/Referers/images/social (for consistency with other images).
  • Also, the output could be part of the Metadata API (so that the new report can be added to PDF/HTML reports and will appear in Piwik Mobile app), see code in https://github.com/piwik/piwik/blob/master/plugins/Referers/Referers.php#L54


@anonymous-matomo-user commented on November 23rd 2011

Thank you Matt!

Yes, we are very interested in including this in core ;)

We'll do all the changes you recommended a little bit later. We're kinda busy for a few days and we're really sorry about that.

Thanks for the feedback!

@gka commented on November 24th 2011 Contributor

big +1 for this feature!

@anonymous-matomo-user commented on June 21st 2012

Hello guys!

And we are sorry for not responding on this ticket. Now it seems like we are stable again and getting back to contribution in Piwik developing.

So now we have fixed things with Social networks feature due to all Matt's recommendations. We re-upload the patch for the Piwik core in this ticket.

And it works this way:

1. When a referrer URL writes down in Piwik (log_visits mysql table) Referrers plugin defines it as a social network referrer (if there is a match with the list of the most popular 50 social networks Socials.php).

2. Now the social networks list is in php format and also changed its folder to /core/DataFiles/ so as Piwik standards want. Socials.php will be created while applying the patch.

3. Social networks icons have all been changed to png.

4. The social network output is now part of the Metadata API and can be imported.

5. Now all graphs related to the social networks are shown well.


@anonymous-matomo-user commented on July 5th 2012

A little thing has been fixed
So get the new .patch file


@mattab commented on July 20th 2012 Member

Thank you for the new patch!

  • It looks good
  • I think now that it is important not to add any archiving code for this new data
    • instead I propose that the API referer.getSocials() calls the API getWebsites() to get the data, then applies a DataTable_Filter to only get the Social websites, and dynamically builds the datatable and returns it.

The data therefore is more a filter on the getWebsites and not a new data blog. There will be no performance impact of this new feature.
Also I think it's beest not to exclude Sites and Social between each other. Because facebook.com is still a website. So it would be confusing that Facebook does not count as a website. I think it's best to count "Social" as a subset of websites. Therefore the data in log_visit is still the same :-)

  • Finally, it would be nice if the Social report was displayed on the right of the Websites report under REferers > Websites & Social

IT's a great feature :-)
Looking forward to seeing it in core :)

@mattab commented on August 26th 2012 Member

It is a great feature, and many users have expressed very strong interesting in Social Tracking! :)

@anonymous-matomo-user commented on August 31st 2012

Hello again!

We make the recommended changes and now the Social Networks report is:

- not excluded from Website referrers
- displayed on the right of the Websites report under the tab "Referers > Websites & Social"

Get the re-attached .patch file for core.

@mattab commented on September 6th 2012 Member

Very cool, thank you codax! :)

Benaka, please commit the change after doing your own review of the feature (looks good to me) - Thank you!

@halfdan commented on October 24th 2012 Member

I see a problem here with Twitter - you usually don't get "twitter.com" as referrer as all URLs are automatically shorted by Twitters own http://t.co/ service.

Instead of checking for twitter.com you should check for "t.co".

I think the same applies for links from Facebook that are shortened to "fb.me".

Have a look at this Tweet: https://twitter.com/piwik/status/258798351611469824. The URL shown is fb.me, but if you hover it you see that it is actually shortened to t.co.

If you look at the Piwik Demo (http://demo.piwik.org/index.php?module=CoreHome&action=index&idSite=7&period=month&date=2012-10-13#module=Dashboard&action=embeddedIndex&idSite=7&period=month&date=2012-10-13&idDashboard=1) you can even see t.co show up in the list of Referrer Websites.

@diosmosis commented on November 14th 2012 Member

(In [7466]) Fixes #2791, committed codax's patch after modification. Two new reports added, getSocials & getUrlsForSocial. New utility function for DataTable called mergeSubtables added. Modified ColumnCallbackDeleteColumn filter so the function callback used can take extra parameters.

This Issue was closed on November 14th 2012
Powered by GitHub Issue Mirror