Export data (admins)
Daria Mamchenkova avatar
Written by Daria Mamchenkova
Updated over a week ago

The export option allows you to export specific information to the file of the .CSV format for your personal needs. You can export different data on Affise.

Read more about permissions to this feature here.

Amazon and Google Cloud

If you need to process reports on large amounts of data or create a specific data grouping, we recommend you to use Data Fusion: Amazon and Google Cloud. These are technical solutions. The volume and speed of their servers help process a huge amount of data. By using them, you can pull all the needed data to the cloud and do with data whatever you want. Read more information about Amazon S3 and Google Cloud.

πŸ’° Google Cloud and Amazon are available by request. Contact your Affise account manager to get the feature.

Export

You can export the following types of data on Affise:

  • Statistics

  • Offers

  • Advertisers

  • Affiliates

  • CR/Click automation data

  • Billing data

Export in Statistics

The export process is similar in all Statistics slices. Look at the example of exporting conversions:

  1. Go to Statistics > Conversions.

  2. Click Export.
    ​
    ​

  3. Select the fields you want to export to the file.

  4. Click Export.

⚠️ There are some peculiarities according to a certain slice:

  • Custom

    • In the Custom slice, the system exports all the data you depict.

    • You cannot choose the certain columns to export.
      ​

  • Conversions, Referrals, Goals, Affiliate postbacks, Server postbacks, Retention rate, Trafficback, Time to action slices:

    • The system exports all the data you have during the time you selected.

    • You cannot export page by page.

    • You can export conversions for 62 days or less at once.

    • You can export postbacks in the Server postbacks and Affiliates postbacks slices of Statistics only for the last 90 days.
      ​

  • Daily, Advertisers, Account/Affiliate managers, Offers, Affiliates, Countries, Cities, Devices, OS, Smartlinks, Mobile ISP, Connection type, Landing slices:

    • The system exports all the data you have during the time you selected.

    • You cannot export page by page.

    • Sorting option doesn't influence the order of data inside the export file.

    • You cannot export data in custom columns, and in the drilldown report (the Group by button).

    • You can export the detailed click statistics for 7 days or less.
      ​

  • KPI, Comparison report slices:

    • You cannot export information from these slices.

πŸ”Ž Export feature downloads records of all the pages.

Export in Offers, Advertisers, Affiliates sections

The export process is similar in these three sections. Look at the example of exporting offers:

  1. In the Offers section, click Export.
    ​
    ​

  2. Select the fields you want to export to the file.

  3. Click Export.

πŸ”Ž Export feature downloads records of all the pages.

Export Affiliates auth log

Besides export of the list of affiliates, you can export Affiliates auth log:

  1. In the Affiliates section, click the Affiliates auth log division.

  2. Click Export to XLS.
    ​
    ​

  3. Select the fields you want to export to the file.

  4. Click Exports.

πŸ”Ž Export feature downloads records of all the pages.

Export CR/Clicks automation data

The export process is similar in these two cases. Look at the example of exporting CR automation data:

  1. Go to Automation > CR automation > Block log.

  2. Click Export to XLS.
    ​
    ​

  3. Select the fields you want to export to the file.

  4. Click Exports.

πŸ”Ž Export feature downloads records of all the pages.

Export in Billing for Advertisers section

You can export the billing for the advertiser.

  1. Go to Billing > Advertisers.

  2. Select the billing from the list and click the eye icon.

  3. Click PDF.

Export in Billing for Affiliates section

You can export one billing, the list of billings, and the list of conversions included in the billing.

  • Export one billing:
    ​

    1. Go to Billing > Affiliates.

    2. Select the billing from the list and click the Download PDF button.


      ​

  • Export the list of billings:
    ​

    1. Go to Billing > Affiliates.

    2. Click the Export tab.

    3. Choose one, several or all billings by selecting the needed checkboxes.

    4. Select the delimiter, format, columns you want to export.

    5. Optional. In the bottom field, type additional note or comment.

    6. Click Exports.

  • Export the list of conversions included in the billing:
    ​

    1. Go to Billing > Affiliates.

    2. Select the billing from the list and click the View button.

    3. Click Conversions.

    4. Click Download PDF.

πŸ”Ž Export feature downloads the record(-s) that you select.

Export section

After exporting in the Statistics, Offers, Affiliates, Advertisers, Automation sections, you can see the file in the Export section:
​
​

πŸ”Ž You can see only the export you did, not other users.

You can also create presets, read more about it here.


Please contact the Affise Customer Support team regarding all raised questions via the e-mail: [email protected].

Did this answer your question?