I'm using Tableau 10.5 to create a report for an online advertising campaign my company runs on a monthly basis for various products. We've got 4 campaigns, plus a category for items (Unsponsored Items) that are not being actively advertised but are still available for purchase. We're tracking basic advertising metrics (Cost per Click; Cost per Purchase, Click through Rate, etc.).
Here's where I'm getting stuck... we want to include the number of items in each campaign that had advertising dollars spent on them - but we also want to include the purchase count for items that did NOT have advertising dollars spent on them, but still had purchases through our campaign - basically, a user clicked on our ad, went to our website, but actually purchased another item that wasn't being advertised - but we'd like that purchase to be reflected in the report since the user came in through the advertising campaign.
I've got a calculation to filter to only those items that had advertising dollars, but when I add it to the worksheet, all the purchases on the unadvertised items are also filtered out. I'm guessing the solution is either an LOD calc or a parameter, but I just can't get either one to work out right.
I put together a packaged workbook with two worksheets - I attached it in version 10.5 and also 10.2. Sheet 1 is how the report should look (except the item count is wrong); Sheet 2 has the right item count, but the Number of Purchases/Cost Per Purchase is wrong. Could anyone help me figure out a solution? Thanks!