Setup Organization Default Currency Metric Margins
When you want to display cost numbers in your report with your agency operating costs included, setting up margins in NinjaCat will allow this. Margins in NinjaCat allow you to increase the displayed cost (or spend) based metrics in your reports and dashboards. This article explains the steps of setting up margins at the Agency Level. After reading you will know how to add a margin by percentage to a particular data source and input the start date for the margin.
Access Agency Margins
1. Go to the Setup Settings
2. Click on "Agency Settings" in the "Settings" sub-navigation
3. Click on the "Margins" tab under Agency Settings
Create and Edit Margins
1. Click on the desired Data Source to configure a margin
2. Click on "Add Margins"
3. Click the field under "Start Date"
4. Select the month and year for the margin start
5. Click the field under "Margin"
6. Type numbers to input the percentage of the total spend which constitutes the margin.
If the Data Source spend is $750 and your markup is $250, your margin is 25% ($250 is 25% of the total = $1000) and would be input as .25.
7. Click the "Save Margins" button near the bottom right
To edit an already created margin:
Click on the data source network for which you want to edit an existing margin
On this screen, you can change the start date, and the margin percentage or delete the margin altogether
Margins FAQ
Where can I set margins, and which one wins?
You can set margins at three levels. Each margin is set per data source.
| Level | Where |
|---|---|
| Organization | Organization Settings → Margins tab. Hover over a data source and click Set Margin. |
| Account | In the account's settings, open the Margins tab. Hover over a data source and click Set Margin. |
| Connection | Open an existing connection, then choose Margins from its more actions menu. This option isn't available on a new connection, and not every connection has it. |
The most specific margin wins: a connection margin overrides the account margin, and an account margin overrides the organization margin.
At the account and connection levels, click Override Agency or Override Advertiser to copy the inherited margins into this level so you can edit them. The inherited margins are then shown as "(Overridden)". To go back to the inherited margins, click Remove Overrides. This deletes this level's margins right away, with no confirmation.
For Google Ads, you can set separate margins for Display, Search and Video.
How do I set a margin?
- Click Add Margins.
- Choose a Start Date (a month).
- Enter the margin in the Margins column (for Google Ads, the Display, Search or Video column), as a number from 0 to 0.99 (for example, 0.10 for 10%).
- Click Save Margins.
To remove a row, click its Delete (trash) icon, then click Save Margins.
There's no end date. Each margin starts on the first day of its Start Date month and applies until the next Start Date. The latest margin applies from its Start Date onward. To change a margin from a certain month, add a new row with that month as the Start Date. Changing the value of an existing row changes past data for that period too.
Each row needs a Start Date and a value, and two rows can't have the same Start Date. Otherwise you'll see "Start date cannot be empty.", "Please make sure there are no empty values." or "There are duplicate start dates."
The margin is applied day by day, based on the date of the data. If the margin changes during your date range and the widget's data isn't broken out by date, the widget can show Error Getting Data. Add the Date dimension to the widget, or choose a date range that falls within a single margin period.
How is the margin calculated?
To find your margin, divide your gross profit by revenue. NinjaCat then divides the cost by (1 − margin):
Cost with margin = Cost ÷ (1 − margin)
Example: with a margin of 0.10 and a cost of $100:
$100 ÷ (1 − 0.10) = $100 ÷ 0.90 = $111.11
This isn't the same as adding 10%, which would give $110.
Which metrics get the margin?
Margins apply to each data source's cost metrics, not to every currency metric. Cost metrics include the data source's standard Cost metric and other cost metrics that the data source defines. For example, Google Ads cost metrics include Cost and cost per conversion.
Some metrics are calculated from Cost. For example, in Google Ads, average CPC is Cost ÷ Clicks, and average CPM is 1,000 × Cost ÷ Impressions. These calculated metrics include the margin, because they're calculated from the cost with margin. A rate metric that comes directly from the data source includes the margin only if it's one of that data source's cost metrics (for example, Google Ads first page CPC is one, so it includes the margin).
Can I exclude a single metric, such as CPC?
No. You can't exclude a single metric (such as CPC) from the margin, for an account or anywhere else.
Alternative: turn margins off for a whole dashboard. In the dashboard's settings, under Dashboard Filters, turn on Use Dashboard Margin Toggle. Dashboard viewers can then open the Margins filter, select or clear Show Margins, and apply.
When margins are off, they're off for every widget on the dashboard.
Why isn't my data source in the Margins list?
Some data sources don't support margins, so they don't appear in the Margins list and their connections don't have a Margins option. If you need margins for a data source that isn't listed, contact your CSM or NinjaCat support through the Nina chat in the app.
Updated 5 days ago