Information

Answer

Tango users with permissions to Manage Reports are able to generate and download reports at any platform level they have access to (Organization, Group, or Account). Users with View Reports permissions can download reports that have already been generated, but can't generate new reports for download. Learn how to Set user permissions and access level. See Data contained in Tango Order history reports.

Types of reports in Tango

The following reports are available in Tango:

Type	Description
Orders Report	Shows all completed orders by the date the order was fulfilled. This report helps track how many orders were completed on a particular day of the month.
Order with Email Events Report	Shows all completed order by the date the order was fulfilled besides the email data such as: timestamp for first_delivered, first_opened and the number of times the email has been re-sent. This report helps analyzing customer engagement with order emails such as how many times the email was resent and so on.
Resend History Report	Shows details about the resend activity including the original orders email, resend email, when it was sent and who it was initiated by. This report helps track and audit email resend behavior.
Transaction Report	Full ledger of account activity over a given time period. This report is ideal for financial reconciliation, auditing, or reviewing account-level transactions.

Additional reports in Tango

Tango portal users with reporting permissions can also request certain other reports to be run outside of the Tango portal, such as Balance report or the Stored Value Status reports that show Reward Link® redemption status.

See a list of reports available to request here: Customer Reports . Reach out to your Customer Success Manager (CSM) or success@tangocard.com to request one of the reports not available through Tango portal. See Download line items data to learn more about filtering and downloading a report of Line Items in the Tango portal.

Generate a new report

You can generate the history of your orders for a specific platform level and date and time. Here’s how:

To generate a new report:

Sign in to the Tango portal.
Click on Reports from the left panel.
Select New Report in the top right of the page.
Customize the platform level, date range, and a name for your report:
- Select a Report Type, such as Orders Report, for your specific need. See the full list and their descriptions above.
- Use the Scope to determine at which Tango platform level the report is generated:
  - Organization: The report will include rewards sent from all Groups and Accounts on your Tango platform.
  - Group: The report will only include rewards sent from all Tango Accounts belonging to the Group selected from the drop-down menu.
  - Account: The report will only include rewards sent from the Tango Account selected from the drop-down menu.
- Use the From and To fields to select the start and end dates for the date range of the report.
- Enter a unique Report Name for easier locating later.
Click Create Report.
A notice appears stating "You'll be notified via email once your report is available to download"; the email is sent to the email address you're logged into Tango with, from noreply@tangocard.com.

Download reports

Once you generate a report, you can view it on the screen or download and save or print it. Here’s how:

To download a report:

Sign in to the Tango portal.
Click on Reports from the left panel.
Click Download Report at the top of the details panel.
The information panel displays the report ID, the date the report was generated, and the platform level to which the report is available.
Click Download Report to see an Excel sheet including more reporting details.

Data contained in Tango reports

Tango reports are available to download as an Excel spreadsheet. Below, you'll find the list of columns and their descriptions in alphabetical order:

Column Name	Description
ACCOUNT_NUMBER	Unique identifier for the account.
ACCOUNT_NAME	Name of the account holder or organization.
ACCOUNT_TRANSACTION_ID	Unique ID for the transaction.
AMOUNT_CHARGED	Final amount charged after fees and adjustments.
BALANCE	Account balance after the transaction.
BRAND_NAME	Brand associated with the reward (e.g., Amazon, Starbucks).
CAMPAIGN	Name or ID of the campaign associated with the transaction (e.g., promotional or incentive campaign).
CREDIT_DEBIT	Indicates whether the transaction was a credit or debit.
CURRENCY_CODE	Currency used (e.g., USD, EUR).
CUSTOMER_ID	A unique ID assigned to a specific customer (often a business unit or client within the platform).
CUSTOMER_NAME	Name of the customer associated with the transaction.
DELIVERY_STATUS	Status of the reward delivery (e.g., Delivered, Failed).
DENOMINATION	Value of each reward.
ETID	Email Transaction ID, used to track email delivery and engagement. Learn What is an ETID?
EXCHANGE_RATE	Currency exchange rate used if applicable.
EXTERNAL_REF_ID	Reference ID from an external system (e.g., CRM, ERP).
FIRST_DELIVERED	Timestamp when the reward email was first delivered.
FIRST_OPEN_EVENT_AT	Timestamp when the email was first opened.
FEE	Any fee applied to the transaction.
INITIATED_BY	The user or system that initiated the resend action.
LINE_ITEM_CREATED	Timestamp when the line item was created.
LINE_ITEM_FINALIZED	Indicates if the line item is finalized.
LINE_ITEM_NOTES	Specific notes related to a line item in the order.
LINE_ITEM_STATUS	Status of the specific line item.
LINE_NUMBER	Line item number within the order.
NOTES	General notes or comments about the transaction.
NUMBER_OF_RESEND	Number of times the reward email was re-sent.
ORDER_SOURCE	Origin of the order (e.g., API, Dashboard).
ORDER_STATUS	Status of the order (e.g., Fulfilled, Cancelled).
ORIGINAL_EMAIL	The email address to which the original reward was sent.
PLATFORM_CLIENT_ID	A unique identifier for the entire Tango platform instance used by your organization.
PLATFORM_NAME	The system or platform where the transaction occurred.
PURCAHSE_ORDER	Purchase order number associated with the transaction.
QUANTITY	Number of reward items issued.
REFERENCE_ID	External or internal reference for tracking.
REFERENCE_LINE_ITEM_ID	A unique identifier for a specific line item in an order, used for tracking and auditing.
REFERENCE_ORDER_ID	ID of the order that this line item is associated with
RESEND_EMAIL	The email address used if the reward was resent (can be the same or different from the original).
REWARD_AMOUNT	The monetary value of the reward sent in the line item (e.g., $25, $50).
REWARD_NAME	Name of the reward (e.g., Gift Card).
REWARD_MESSAGE	Custom message included with the reward email.
SENDER_EMAIL_ADDRESS	Email address of the sender.
SENDER_FIRST_NAME	First name of the person or entity sending the reward.
SENDER_LAST_NAME	Last name of the sender.
SENT_AT	Timestamp indicating when the reward email was sent.
TRANSACTION_AMOUNT	Amount involved in the transaction.
TRANSACTION_CREATED	Timestamp when the transaction was initiated.
TRANSACTION_STATUS	Status of the transaction (e.g., Completed, Pending, Failed).
TRANSACTION_TYPE	Type of transaction (e.g., Order, Refund, Adjustment).
TOTAL_FEES	Sum of all fees applied to the transaction.
UTID	Unique Tango Identifier for the reward. Learn What is a UTID?
REWARD_QUANTITY	Number of rewards issued.

More resources

Title	Generate and download reports