💡Measuring the Performance Amount Spent will allow you to see the daily amount spent on your ads.
Dimensions & Metrics:
No Dimensions will be selected in the Dimensions tab. When you set your Granularity the date will become a Dimension.
Select Spend in the Metrics tab.
Now select your Granularity. Set your Granularity to Daily.By selecting Daily, the date will be used as a dimension and show the data for each day in the selected date range.
Set your Preset date range. We used a Preset of This Month in this report.
Set your Row and Top limit. We used a Row Limit of 25 and a Top Limit of 5.
You can change these values to your liking.
Preview & Submit:
Use the Preview button to generate a table to show your report. Preview runs fairly quickly because the processing is done by Cognetik’s distributed API engine and does not require waiting for Tableau to create a local database for the extract.
If the report looks correct you can hit the Submit button to extract the data into Tableau.