Produce report showing number of views of campaign email

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hi

I’m trying to produce a report showing who has viewed a campaign email and how many times they have? I’m not getting very far!

Any help grateful received

#2

Is the Campaign Status screen not enough for your needs?

#3

Yes the information on the screen is great, but im not able to do anything with it apart from add the contacts to a target list. I would be very handy to be able to export and download

#4

Ok, I see.

Have you looked into Reports based on the campaign_log table? I haven’t, but if you see that table there, it probably has the information you need (in some ugly format that you will need to work over)

#5

Thanks will take a look

#6

Here’s an example of a campaign contacts activity report for the last 7 days. It’s not perfect but it should get you started.

image
image1312×1163 64.5 KB

1 Like
#7

Thank you! This works a treat!