/

15 minute read

November 25, 2020

Reports in the Dashboard

Reports in the Marqeta Dashboard provides reports that enable you to explore your card program data. Reports includes tools for dynamic filtering, sorting, and interactive visualizations. Default reports use the same data endpoints that you can access through the DiVA API. For a complete list and for more information on the DiVA API endpoints, see the DiVA API Reference.

In Reports, you can:

  • Retrieve data using filters.

  • Download data in CSV format and, for large amounts of data, with Gzip compression.

  • Add visualizations to reports to enhance data presentation.

  • Define periodic reports using relative date filters on saved reports.

  • Generate your user tokens to access the DiVA API.

The basics

To access Reports, go to the Marqeta Dashboard and select Reports from the sidebar. The following figure shows Reports:

Reports

Is this helpful?

To start exploring your data, use the dropdown list at the top of the page to select a report and the controls displayed above the report view area. You can view data in tables, and visualize the data graphically by creating charts and graphs. You can use filters to refine the view and save reports.

Data sync times

Report data, such as clearing and settlement data, is synchronized three times each day—at 8:00 pm, 7:00 am, and 2:00 pm UTC. The 2:00 pm sync time reconciles the previous day’s activities, and is useful for comparing the prior day’s activity with today’s.

Report types

You can view the following report types:

Balance reports

Balance reports give you detailed information on cardholder balances, such as starting and ending balances and chargebacks.

Report Description

Overview

Provides key aggregated program data, such as loads, purchases, and chargebacks.

  • The Acting Cardholder report provides a point-in-time view at the cardholder level.

  • The Business report provides user-level data for business entities within the program.

  • The Account report provides generic user-level data.

Network Detail

Provides key aggregated program data, similar to the Balance Overview report, organized by relevant network.

The Acting Cardholder report provides a point-in-time view at the cardholder level.

Reserve Balances

(Limited Access) Provides a daily aggregated view of reserve requirements and needs for replenishment.

Program Balances

(Limited Access) Provides a daily aggregated view of a program’s funding balance using an authorization funding model.

Balance Counts

Provides a daily or monthly aggregated view of high-level program metrics, including loads, adjustments, and purchases, plus transactional counts.

Card transaction reports

Card transaction reports provide details on card transactions derived from the transaction-related messages sent to and from the Marqeta platform.

Report Description

Authorizations

Provides aggregated and detailed views of authorized transaction messages as part of the overall flow of a particular transaction.

Settlements

Provides aggregated and detailed views of cleared transactions.

Clearing Detail highlights cleared transactions. A single clearing transaction message, identified by the Transaction Token, is represented over several rows, with one row for each accounting layer. There are typically four Transentry Token entries for every Transaction Token, with an entry for purchase, interchange, cross-border fees, and currency conversion fees. The accounting layer for each entry is identified by the Account Group column.

Each record includes an Initiating Transaction Token value, which corresponds to the initial authorization record. The corresponding initial authorization record can be found in the Authorizations Detail report by filtering for a Transaction Token that matches the Initiating Transaction Token value for the clearing record.

Settlements Detail retrieves settlement transaction data at a specified aggregation level. For example, if you choose the detail aggregation level, each row represents a single settlement transaction.

Declines

Provides aggregated and detailed views of declined transactions as part of the overall flow of a particular transaction.

Loads

Provides aggregated and detailed views of cardholder loads to enable transaction processing. Loads provide a view of the cycle for an individual transaction.

Network Reconciliation

Provides final cleared numbers in an aggregated view. This report is different from a Settlements report in its construction and ability to view different components.

Other transaction reports

Other transaction reports give you detailed information about transactions other than card transactions, such as ACH, bill payments, and direct deposit.

Report Description

Bill payments

Provides details on bill payments, such as bill payment status and user information.

Direct deposit

Provides details on direct deposits, such as bank information and processor state.

Program stats reports

Program stats reports give you detailed information about your card programs, such as when a card was created and activated.

Report Description

Cards

Provides detailed information at the card level.

Users

Provides detailed information at the user level. A user corresponds to a profile within the Marqeta platform, but does not necessarily imply a cardholder.

Risk monitoring reports

Risk monitoring reports give you information on risk, such as chargebacks and KYC.

Report Description

Chargebacks

Provides a detailed view of various chargebacks filed for a program, as well as the status and state of any particular chargeback.

ACS3ds

Provides information returned by Marqeta’s ACS and 3DS features.

System reports

System reports give you information on system health and performance.

Report Description

Platform Response

Provides a monthly average duration and gateway duration for transactions.

Utilities reports

Utilities reports provide information on the data dictionary, which describes the data for each of the columns.

Report Description

Core API Transaction Token

Provides a lookup between the Reports Transaction Token and the Core API Transaction Token, which is derived from a webhook associated with the Core API.

Data Dictionary

Provides information on the data dictionary, which describes the data for each of the columns in reports.

Which reports to use

Curious which report to use for a particular process? The table below summarizes some of the main reporting needs that are addressed and the report to use for each.

To Do This…​ Use This Report

Reconcile financial transactions

Use either the Balance > Balance Amounts or the Card Transactions > Settlements reports. The Amount to Send, Deposit, and Partner Funds Loads Net columns are key indicators of program activity. Ask your Marqeta representative if you have questions about which data points are appropriate for your program.

Monitor a funding account

Use the Balance > Balance Amounts report.

Monitor program performance and growth

Several reports are available, including:

  • Balance > Overview > Day

  • Card Transactions > Settlements > Day, Week, or Month

  • Card Transactions > Authorizations > Day, Week, or Month

Use the Visualization Controls to graphically view your data.

Monitor declined transactions

Use the Card Transactions > Declines report. This report is available in a Detail view, or aggregated in Daily, Weekly, or Monthly views.

View chargeback details or status

Use the Risk Monitoring > Chargebacks report. Use the Detail view to see details of the submitted chargebacks, or the Status view to see the status of current chargebacks.

Review user and card demographics

Use the Program Stats > Cards > Detail report and the Program Stats > Users > Detail report.

Accessing reports

Reports are grouped by report type. To access a report:

  1. In the sidebar, under All Reports, select a report type.

    Select a report

    Is this helpful?

  2. Select the report. After you select a report, the data is exposed and the filtering and visualization tools become available.

Exposed and data views

Because the amount of data exposed through the user interface can be unwieldy, two view types are provided to help you work with the data:

  • Exposed view – This is initially set at 10,000 rows with the option to add rows in increments of 100,000.

  • Data view – The complete set of records for the fully specified table build.

Only a subset of data is exposed when working with visualizations. If you want to access the complete data view, you can download up to 1,046,576 rows.

Managing the number of retrieved rows

The default number of rows retrieved when you open a report is 10,000. To retrieve the next 100,000 rows, select Get more data at the bottom of the report view area. Because the dataset may be too large to practically load into your browser, you can download the full dataset:

  • At the upper-right of the report view area, select the Download Current Report button. The complete set of records in the data view is downloaded in Gzip compression format. The dataset may take some time to generate before the download begins.

Filtering data

Use filters and visualizations to uncover whatever data points you want to explore. You can download data to work with it offline or to save your custom reports for future access.

Working with the exposed view

When you open a report, the exposed view shows a subset of the columns for the underlying data view, as well as a subset of the data. You can interact with the data by using quick filters, by sorting and reordering columns, or by adding and removing columns.

Managing columns

To include or exclude columns or to rearrange the column order:

  • Select Modify columns from the gear icon in the upper-right corner to open the Customize Columns dialog box.

  • To define which columns should appear in the report, select or clear the checkbox for the columns to include or exclude.

  • To reorder the columns, drag them up or down to their new positions.

Working with the data view

Filters allow you to work with the entire data view. Filters apply to the entire underlying data view; however, only the exposed view is returned and displayed.

To filter columns:

  • To filter by date, select the calendar and set the date filters.

  • To sort columns, select Filter table. Under Sort, select the sort column and the direction, ASC or DESC.

  • To filter columns using a relational operator, select Filter table. Under Field Filter, select the column and an operator, and enter a value. See Relational operator behavior below.

  • To add more filters, select Add filter and set the filter values.

  • To remove filters or sorting, select the x to the right of the row.

  • Select Apply changes.

To return to the default view, select Reset table to default using the gear icon.

Relational operator behavior

Filter behavior for relational operators depends on the type of information for the selected column:

Field Type Options

String

Use the tilde (~) as a wildcard at the beginning or end of a value. For example, "ba~" matches both "bar" and "basket". You can also apply a filter list using commas to separate the values. For example, "= California, New York, Ohio" returns only those states in the result; "!= California, New York, Ohio" returns all states except those.

Date

Enter dates in yyyy-mm-dd format. For example, to specify November 1, 2018, enter "2018-11-01". Use the <, <+, =, , > operators to filter dates before, after, or equal to the given date. Use two dots (..) to specify a range of dates. For example, "2018-09-01..2018-09-07" filters dates between September 1, 2018 and September 7, 2018. Only the = operator is valid for date ranges.

Number

Use standard mathematical operators to filter numeric values. Use two dots (..) to specify a range of numbers. For example, specifying "100..110" filters values between 100 and 110, inclusive. Only the = operator is valid for number ranges.

Saving reports

To save a report:

  1. Select Save Current Report.

  2. Enter a report name.

  3. Select Save.

Saved reports are available under Saved Reports in Home.

Visualizations

Visualizations help you understand your data. Using visualizations, you can create charts based on the data you have retrieved and include them in a report. The available options depend on the visualization type. Note that visualizations apply to the exposed view of your data.

Visualization types

The following visualizations are available:

Type Description

Line chart

Shows data trends over time as a series of data points connected by straight line segments.

Bar chart

Presents data using rectangular bars that are proportional to the values that they represent.

Scatter plot

Displays values for two variables as a collection of points, showing how much one variable is affected by another.

Line chart

A line chart displays information as a series of data points connected by straight line segments. A line chart is most frequently used to show trends and analyze how data has changed over time. Typically, the y-axis displays a quantitative value, and the x-axis provides a timescale or a sequence of intervals.

Line chart

Is this helpful?

The following are line chart options:

Option Details

X-Axis

The column to display along the x-axis. Only date columns are available as x-axis options.

Y-Axis

The column to display along the y-axis. Only number columns are available as y-axis options. Select one or more.

Cumulative

Allows values to accumulate so that a value shown is the total of the base value and the sum of all previous values. Use a cumulative line chart when you have one grouping that represents an ordered set of data and one value to show, summed over time.

Multi-Line

Displays multiple lines for a selected column, based on the Dimensions and Lines options you specify. Selecting this option displays the Dimensions and Lines options.

Dimension

If Multi-Line is selected, the column to display along the y-axis.

Lines

If Multi-Line is selected, the groups to include within the selected dimension.

To add a line chart:

  1. Retrieve the data you want to include.

  2. Select Visualization Controls and select Line Chart. The most likely columns are displayed in the initial graph.

  3. Select ··· in the upper-right corner of the chart and select the options.

  4. To save the chart, select Save.

Bar chart

A bar chart presents data using rectangular bars that are proportional to the values that they represent. A bar chart can be used to compare changes over a period of time for more than one group.

Bar chart

Is this helpful?

The following are bar chart options:

Option Details

Dimensions

The column data to display on the x-axis.

Bars

The column to display in bars along the y-axis. Select one or more columns.

Sort

The order in which to display the bars along the x-axis.

  • Type – Value or Dimension. Value sorts the display by value; Dimension sorts by group name.

  • Direction – The order in which to display the bars along the x-axis: DESC or ASC.

Max Bars

The maximum number of bars to display. To change, edit the value under Max (number).

Y-Axis Functions

Applies functions to alter the information displayed to make the trends more easily identifiable in visualizations:

  • y – Returns to the original display, removing any functions.

  • -1*y – Flips the y values on the chart so that negative values are displayed as positive values above the x-axis. Useful for the display of negative values in a more readable format.

  • log(y) – Reduces the y values logarithmically to make the trend easier to see in the chart.

  • e^y – Increases the y values logarithmically to make the trend easier to see in the chart.

  • abs(y) – Displays the absolute value along the y-axis.

Stacked Bars

Overlays the selected y-axis columns into a single bar. Select to display the Stacked Bar Options:

  • Dimensions – The columns to report on.

  • Sub Bars – The columns to stack together into a bar.

To add a bar chart:

  1. Retrieve the data you want to include.

  2. Select Visualization Controls and select Bar Chart.

  3. In the upper-right corner of the visualization, select ··· and then select the options.

  4. Select Save.

Scatter plot

A scatter plot displays values as a collection of points, where the value of one variable determines the position on the x-axis and the value of the other variable determines the position on the y-axis. A scatter plot shows how much one variable is affected by another. The relationship between the two variables is called their correlation.

A scatter plot is useful when:

  • You have paired numerical data.

  • Your dependent variable has multiple values for each value of your independent variable.

  • You want to determine whether two variables are related.

Scatter plot

Is this helpful?

A scatter plot can be useful for gaining insight into certain kinds of problems, especially to determine whether a particular cause and effect are related or whether two effects that appear to be related both have the same cause.

Adding a scatter plot

To add a scatter plot:

  1. Retrieve the data you want to explore.

  2. Select Visualization Controls and select Scatter Plot. Only number columns are available for both the x-axis and y-axis. The default columns to display in the graph are the first two active numerical columns.

  3. To change the columns to display in the graph, select ··· in the upper-right corner of the chart and select the columns for each axis. You can choose only one column for each axis.

Downsampling

Downsampling reduces the amount of noise from the display by combining points that are similar into a single point.

After you display the scatter plot, draw a box around the area to downsample. When you are finished downsampling, select Filtered to remove the Downsample filter.

Creating your DiVA API access tokens

Reports in the Marqeta Dashboard accesses the same data endpoints as the DiVA API. Using the Dashboard, you can generate your DiVA API access tokens to use when making API calls. You will have the same permission level as you have in the Dashboard.

To generate your access tokens:

  1. In the upper-right corner, select your username and choose DiVA API access.

  2. On the API Access page, select Generate Token in the upper-right corner.

  3. In the Add a Note popup window, enter a note you want to associate with your access tokens, and select Generate. After DiVA generates your access tokens, the API Tokens popup window appears and displays your tokens.

  4. Select Download to save your tokens.

You can view and copy your user tokens at any time from the API Access page.

Get user token

Is this helpful?

Have any feedback on this page?

If you feel we can do anything better, please let our team know.

We strive for the best possible developer experience.