The goal of this issue is to implement a new feature in Piwik that will let you import a custom data file (eg.
CSV format) that contains extra information about either your users, your content and your products. When importing this data you tell Piwik how to match it to your people and content and then Piwik will automatically let you use the Custom Data for Segments, or display it in the UI (eg. Visitor Log), and more!
This feature is similar to Google Analytics Custom Data Import feature: https://support.google.com/analytics/answer/3191417 (which used to be called Dimension Widening)
Types of data you can import
log_visit) — import user metadata, such as a loyalty rating or lifetime customer value, and use these values with segmentation.
log_action) — group content by importing content metadata, such as author, date published, and article category.
log_conversion_item) — gain better merchandising insights by importing product metadata, such as size, color, style, or other product-related dimensions.
Inspired from GA because their way just makes sense.
I prepare a data file in
userId) and then the file contains up to N custom data columns:
Here is a file example:
userId, LifeTimeValue, Industry clientid1, 500, IT clientid2, 5, NGO clientid5, 100, Farming client765, 222, IT
Then as a Piwik Admin user or Super User:
Useras "Type of data to import" (I could also instead import
Proposed steps / TBD
piwik_custom_datakeeps track of the custom data as simple lookup table
idimport, piwik_dimension_value, custom_dimension_value
1, client765, 222
idimport, idsite, piwik_dimension_name, custom_dimension_name
1, 5, userId, LifeTimeValue
idimport, idsite, ts_imported, name, rows, login, status, deleted, filename
1, 2014-12-01 00:11:22, "Customer LTV & Industry", 9000000, matt, "pending", 0
Feel free to post your feedback in a comment!
I was looking into this feature to be able to have a lookup for data that comes in from my websites. If I know that code XYX is really, "Bob's Burgers", and I want to create reports with Bob's Burgers instead of XYX. Would this feature be something that I could use or is there any other functionality that could solve this problem?
Yes, sounds like you need this feature. But it's not developed yet unfortunately. it would be great to have. In the meantime you can set as "Custom Dimension" the real value you need and then use Custom Dimensions reports to see the reports: https://piwik.org/docs/custom-dimensions/
You may also find custom reports interesting: https://piwik.org/docs/custom-reports/