Data Management

The Data section of your Peacock Service Panel provides you with added context regarding the payments data you import into Pagos. It contains the following pages:

Data Import Logs

The Data Import Logs page displays the status of our data pulls from your payment processors, including when the data import occurred and what time period we imported data for.

Filtering Data Import Logs

You can use the following filters at the top of the Data Import Logs page to refine your list of data pulls:

  • Imported on - Set a date range for when the data import occurred
  • Imported period - Set a date range for the data pulled into Peacock by the import
  • Processor- View data imports only for the selected payment service provider (PSPs)
  • Status - View only data imports with the selected status (e.g. Success, Pending, or Failed)

Failed Data Imports

Click Retry on a failed data import to retry the data pull.

Know Your Data

We designed the Know Your Data section of Peacock to help you better understand what's going on behind your payments data. Each page in this section presents statistics on attributes of your data to better inform how you filter your charts and dashboards when searching for insights or checking the health of your payments stack. This section contains pages named for specific data filters, along with a set of pages categorized under distribution summary.

Each page includes a table that breaks down your payments data by the parameters of the named data filter. To select which columns of data appear for each parameter, click the list icon in the top-right corner of the table; options include Total Transaction Count, Approval Rate, Decline Count, and more.

You can take the following actions to organize a Know Your Data table:

  • Drag and drop the columns into the desired order
  • Click a column header to sort the table’s data in ascending or descending order by that column’s values
  • Use the Period or Processor filters to filter the entire data set
  • Click the Download button to download a CSV file of the table’s data; keep in mind, the downloaded file will only include the columns you've selected

At this time, Know Your Data contains the following pages:

BIN List

This table identifies the top BINs associated with payment cards you've processed transactions for. This page includes two unique filters:

  • Use the Count filter to select the number of individual BINs you want to view your payments data broken down by.
  • Use the Transaction Response Code filter to identify the BINs associated with transactions that were declined for a specific reason (e.g. suspected_fraud)

Soft Descriptors

This table identifies the top soft descriptors used in your transaction data, along with aggregated metrics for the transactions tagged with those soft descriptors. Use the Count filter to select the number of soft descriptors (e.g. 100, 200, etc.) you want to view your payments data broken down by.

You can use this information to identify the best soft descriptors to filter your standard and custom dashboards by when exploring trends in your transaction data. Keep in mind, the Soft Descriptor filter requires you to enter the exact soft descriptor you want to filter your data by; copy the exact soft descriptor value from this table to use in the filter.

Metadata

Using the Metadata filter, select a metadata field you want to view payments data for. The table then displays each metadata value associated with that field, along with aggregated metrics for the transactions tagged with those metadata values. Use the Count filter to select the number of metadata values (e.g. 100, 200, etc.) you want to view your payments data broken down by.

You can use this information to identify the best metadata fields to filter your standard and custom dashboards. Learn more about how you might use Metadata in our Labeling Transactions with Soft Descriptors and Metadata guide.

Transaction Retry Attempts

Adyen retries some failed transaction attempts based on their own internal logic. Peacock only counts the final attempt of a retried Adyen transaction in your ingested data, tagging it with a custom flag indicating the total number of times Adyen attempted the transaction (e.g. Initial Attempt, Second Attempt, etc). This chart displays the total number of attempted transactions tagged with each retry flag, along with the approval rates of those retries.

For example, if you have 10 transactions tagged as Second Attempt with an approval rate of 90%, this means Adyen attempted 10 different transactions twice each, and of those, 9 succeeded after the second attempt while 1 continued to fail (but Adyen didn’t retry again).

With this chart, you can compare approval rates for retried vs. initial Adyen transactions, and track how many of those retries are successful and how many are ultimately declined. Keep in mind, if an initial transaction fails and Adyen attempts it again, the initial decline will not count toward your approval rate for transactions labeled as Initial Attempt, since we only log the final attempt of any Adyen transaction. In other words, the count of Initial Attempt transactions doesn't include every Adyen transaction, but instead includes the count of Adyen transactions that were only attempted once. The same is true for Second Attempt, and Third Attempt transaction counts and approval rates.

Distribution Summary

This section of Know Your Data pages provides you with a holistic view of the distribution of certain values across your payments data. At this time, it contains one sub-page for Average Order Value, which displays histograms of your average order value data. Select from the following sub-charts:

  • Order Value Histogram: Transaction Count - View the frequency distribution of the number of transactions processed within a specific range of average order value (AOV). For example, you processed 45 transactions that had an AOV between $5 and $10, and only 12 transactions that had an AOV between $90 and $100.
  • Order Value Histogram: Transaction Value - View the combined value of all transactions processed within each defined range of average order value. For example, you made a total of $360 from transactions that had an AOV between $5 and $10, and $1140 from transactions that had an AOV between $90 and $100.

📘

Note

Both Average Order Value histograms disply your AOV in USD, meaning all transaction values—regardless of the processing currency—are converted into USD for these graphs.

Report Download

🚧

Early Access Feature

At this time, the Report Download feature is in Early Access and not available to all Peacock users. The functionality of this feature matches our upcoming Puffin product. For more information about the Report Download Beta or Puffin, contact your Pagos account manager.

When you connect your payment processors to Pagos, we import all of your payments data from each source and aggregate it together for display in Peacock's charts and dashboards. In this manner, Peacock acts as a single source of truth for your aggregated payment metrics and events across all data types. To assist your teams with integrating such data into your workflows, we can provide you with this data in a CSV downloadable report. You can create and download these forms from the Report Download page.

Generating a New Report

To generate a report:

  1. Click Add New Report.
  2. Click the Report Type drop-down to select the data type you want a report for (e.g. Transactions, Chargebacks, etc.).
    1. If you select BIN List as your Report Type, you must then select a Metric from the dropdown (Transaction Count/Value, Approval Rate/Count with Decline Rate/Count, Chargeback Rate/Count, or Refund Rate/Count).
  3. Click the Date Rate drop-down to select a time period, then click Apply. Keep in mind, all time periods will appear in UTC.
  4. Click the Select Data Source drop-down, then select the data source you want to download data for.
  5. Click Add.

Your new report will appear in the Report Download table with the status of Submitted. When the report is complete, the status changes to Done and a link appears in the Download Links column of the table. Click the link to download the CSV report file.

📘

Note

If your report file exceeds 1.5GB, we'll split it into multiple downloadable files. The default name for each file will indicate which part of the report it is (Part 1, Part 2, etc.).

Supported Data Types

For all data sources we will provide access to specific Core Metrics, provided the data is available in the selected Data Source:

  • Verifications
  • Transactions
  • Transformed Transactions (Deduplicated, Re-mapped)
  • Disbursements
  • Refunds
  • Chargebacks
  • Fees
  • Invoices

What data attributes appear in a report depends on the data type you selected as the Report Type. Examples include payment method type, issuing bank, issuer BIN, currency, transaction flags (e.g. CVV, AVS, 3DS), detailed response codes, status, metadata, and more.

📘

Transaction Lifecycle Changes

If any objects in the Core Metric set change over time (e.g. a chargeback or transaction's status changes), Pagos will send the object again with the new status. As such, if you download reports on a regular basis, you will see the same object in multiple reports with a different status. For example, a report downloaded on Monday may have a chargeback with the status of dispute_open, while the report on Wednesday will include the same chargeback with the status of dispute_accepted.

Schedule a Report

If you’d like to download your data on a regular and repeating basis, you can schedule a report. To do so:

  1. Click Schedule, then click Schedule New.
  2. Select a Frequency for how often you want to download the scheduled report (e.g. daily or monthly).
  3. Select the Report Time when you want the report to be downloaded. Keep in mind, this time will always appear in UTC.
  4. Click the Report Type drop-down to select the data type you want a report for (e.g. Transactions, Chargebacks, etc.).
  5. Click the Date Rate drop-down to select a time period, then click Apply. Keep in mind, all time periods will appear in UTC.
  6. Click the Select Data Source drop-down, then select the data source you want to download data for.
  7. Click Schedule.