Custom Data Import (dimension widening) #6613
Labels
Enhancement
For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
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.
Workflow
I prepare a data file in
CSV
format.userId
) and then the file contains up to N custom data columns:userId
.userId
column in CSV file then it must match the User ID values set in Piwik.Here is a file example:
Then as a Piwik Admin user or Super User:
Custom Data
User
as "Type of data to import" (I could also instead importContent
orProduct
orCampaign
custom data)tmp/customdata
)Proposed steps / TBD
DB Schema:
piwik_custom_data
keeps track of the custom data as simple lookup tableidimport, piwik_dimension_value, custom_dimension_value
1, client765, 222
piwik_custom_data_dimensions
idimport, idsite, piwik_dimension_name, custom_dimension_name
1, 5, userId, LifeTimeValue
piwik_custom_data_import
idimport, idsite, ts_imported, name, rows, login, status, deleted, filename
1, 2014-12-01 00:11:22, "Customer LTV & Industry", 9000000, matt, "pending", 0
Notes
Feel free to post your feedback in a comment!
The text was updated successfully, but these errors were encountered: