Collecting data from Magento Advanced Reporting

This guide explains how to collect data from Magento Advanced Reporting. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

  • Magento Advanced Reporting can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

Creating a datastream to collect data from Magento Advanced Reporting

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Magento Advanced Reporting.

Authorization: Allow Adverity to access Magento Advanced Reporting

Before creating an authorization to give Adverity access to Magento Advanced Reporting, perform the following actions:

  1. Ensure that the account you want to use to give Adverity access to Magento Advanced Reporting has admin rights.

  2. Enable Advanced Reporting on the same Magento Advanced Reporting account. For more information, see the Magento Advanced Reporting documentation.

  3. Retrieve an access token from Magento Advanced Reporting. For more information, see the Magento Advanced Reporting documentation.

  4. Retrieve an Analytics access token from Magento Advanced Reporting by following these steps:

    1. Log in to the server that hosts Magento Advanced Reporting. An example of a server URL is as follows:

      https://devdocs.magento.com/cloud/env/environments-ssh.html#magento-cli

    2. Enter the following into the command line, and run the command to display the Analytics access token:

      web@mymagento.0:~$ ./bin/magento config:show | grep analytics/general/token

    3. Copy the Analytics access token from the command line.

To set up a new authorization to fetch data from Magento Advanced Reporting, follow these steps:

  1. In the Authorization step of the datastream wizard, click Access Magento Advanced Reporting using your credentials.

  2. Click Next.

  1. In Website URL, enter the URL for the Magento Advanced Reporting API.

  2. In Access token, enter the access token retrieved from your Magento Advanced Reporting admin account (see step 3 above).

  3. In Analytics access token, enter the Analytics access token retrieved from the command line (see step 4 above).

  1. Click Authorize.

Configuration: Choose the data you want to collect from Magento Advanced Reporting

To choose what data to collect and customize the Magento Advanced Reporting datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Report type, select the type of data to collect from Magento Advanced Reporting.

What's next?