I like to generate a report that summarizes target acquisition and (multiple) campaign activity by week.
WeekEnding CountOfTargets GrowthFromPreviousWeek SentEmails
2014-06-01 32 n/a 14
2014-06-08 62 99% 43
2014-06-15 68 10% 32
How can I generate a report like this in SugarCRM? Even just getting a weekly summary of new targets seems hard, let alone joining against campaign activity. I come from the SQL world so could write the queries directly if I knew what was in all the different tables...