End Result – Pulse Dashboard

Topic Progress:

End Result

Here is one version of your final Dashboard before any other data has been piped in.

You don’t need to have all your fields on the left exactly correct at this time. You can add them as you build out each module.

All of the data on this page is either pulled from another sheet or calculated on page.

Example

For example, Adwords Cost is pulled from the Adwords sheet.

Adwords Orders is pulled from the Revenue sheet (or the Adwords or Google sheets if you have E-Commerce tracking working properly).

The next 2 items (Adwords Return On Ad Spend, Adwords Cost Per Dollar) are calculations done on this sheet. See more in Layouts and Formulas.

Tip

The most important tip for this sheet is to use the same date ranges for all of your sheets.

end-result

Note

Above you’ll see Ad Cost and Orders for both Adwords and Facebook. You don’t need to keep this data on your Dashboard. You can leave it on the respective sheet and just bring in the ratio and/or the trend. I’ll show you how in the modules for those sheets.

>