Impressions per contact

Show which templates have more or less impressions/contact

1. Export a Daily Inventory report for the month and the publications you're interested in.

2. Create a PivotTable. Put "Template" in the "Row Label" box.

3. Create a calculated field, impressions / contacts; add the calculated field to the "Values" box.

4. Select the data in the pivottable, go to "Conditional formatting" and select a colour scale to highlight the highs and lows.

Category:

Howto & Style

Tags:

• tutorial