Analytics Invoices
The Analytics Invoices table can be extremely helpful to summarize and filter information for your invoices. In its default setting, the table actually breaks up each invoice by line item. This allows you to see specific information about the component parts of that invoice, such as ad size, service name, or issue ID. You can always choose to sort or filter this information to group the data by specific invoices, or only see information about specific invoices if that is what you need. There is also a URL link in the table, which can take you to the corresponding company’s invoices page in the system.
Breakdown of Data
Organization or Publisher
Pub Name
Issue Name
Company Name
Is External Invoice - Let you know if the item is set to externally invoiced, which means there is not invoice in your system to collect against.
Service Name
Brand Name
Ad Size
Sales Rep
Line Item Key – Every line item in the system gets a unique identification number, which is created when you add an order. You will either see single line item keys or duplicates depending on how the order was invoiced. For example, you may see duplicates if you created an installment invoice or if you split an invoice.
Pub ID – Every publisher in the system gets a unique identification number. We recommend using the ID if you ever want to import data or join a table to get more information about a publisher. Using IDs is a better way to join than by name.
Invoices URL – The URL link will take you to the selected Company’s Invoices tab.
Invoice Date – This is often the date that the invoice was created, but may be different depending on the specific invoice. For example, the invoice date that is part of an installment may be a month or two away.
Cash Billed – The cash billed displays the total value of that invoice, not the specific line item amount.
Service ID – Every service in the system gets a unique identification number. We recommend using the ID if you ever want to import data to a service or join a table to get more information about a service. Using IDs is a better way to join than by name.
Issue ID – Every issue in the system gets a unique identification number. We recommend using the ID if you ever want to import data to an issue or join a table to get more information about an issue. Using IDs is a better way to join than by name.
Invoice Due Date – Shows when the invoice is due.
Cash Due – The amount that is left unpaid for the total invoice, not the specific line item amount.
Barter Agreed – The amount agreed upon for the invoice that is a form of payment other than actual cash, such as a gift card. This is referring to the total amount of the invoice, not the specific line item.
Invoice ID – Every invoice in the system gets a unique identification number. We recommend using the ID if you ever want to import data to an invoice or join a table to get more information about an invoice. Using IDs is a better way to join than by name.
Ad Size ID – Every ad size in the system gets a unique identification number. We recommend using the ID if you ever want to import data to an ad size or join a table to get more information about an ad size. Using IDs is a better way to join than by name.
Barter Due – What is left unpaid on an agreed barter amount for the invoice, not the specific line item.
Below are reports created in Metabase just using the Analytics Table