I am trying to create a custom KPI performance report to allow marketing managers to enter a specific campaign code and to have the report displayed for that campaign code.
I have watched the Adobe How-to videos for this and am still running into issues.
In the report, the campaign code is my ‘group by’ with the KPIs attached to it in the report.
My issue is allowing the user to enter the campaign code and only get results attributed to that campaign code.
I can get the over-all report to display as expected, but it is displaying for all campaigns. I run into problems with adding the Input Zone (https://helpx.adobe.com/campaign/classic/how-to/provide-an-input-zone-to-populate-variable-in-acv6.h...)
I have tried this two ways using the number box as the input zone.
I must be missing something obvious. Given that the general report displays as expected, but only has issues once I try to filter the report to a specific campaign I believe the problem is with how I configured the input zone.
I appreciate any help with this.
I was able to resolve this.
The error from using a variable was the needing to correctly identify the carriable itself, based on the data type. So adding ToString() allowed this to work. So it looks like this: ToString($([vars/CRM_Campaign_Code]))