The default affiliate report under admin/affiliates simply shows the number of clicks for today, the week, the month, and the year. It doesn't break it down by campaign or by affiliate. I couldn't find that report in Views. It's probably buried in code somewhere.

Idea... Create a new view with the desired information.

Problem... Affiliate_UID field is in the Affiliate_Click (actually called affiliate_ng_click but shows as Affiliate_Click in Views) table of the database but Views doesn't list it as an available field.

Comments

perignon’s picture

perignon commented
Category: Bug report » Feature request
Issue summary: View changes
Status: Active » Needs work

Some of this will require relations to be build. The main focus of the work on this module right now is to get something you can use to build your own reports, offering only example views of reports. At the moment, it is hard because there has to be a views relationship built in order to run some joins on tables to get good reports. The good thing is that all the data needed to create any foreseeable report is being recorded by the module and put into the database. This is a good thing because your site has been recording the data if you have already been using the module. Just need an easy way to build reports. In a short fix, you can build custom SQL queries to generate the reports.

Labeling this as more of a feature request. Not necessarily a bug because the module is recording the data, just no good way of displaying it at the moment. And the module is working as currently designed.

mikejw’s picture

mikejw commented
Status: Needs work » Closed (outdated)

I think this is no longer a problem as affiliate_uid is now visible on Affiliate clicks.