How to Create a Scheduled Export in Ads Reporting

Updated 

​Export Options in Ads Reporting

Ads Reporting Export offers a way to download the information from your Paid Reporting dashboards or widgets in a variety of formats. You may download the reporting data in PDF, Excel spreadsheet, or PNG formats. You may also opt to schedule exports to automate the download of data and to schedule an email containing the exported report to other Sprinklr users or to recipients who are not Sprinklr users. For example, you can send a report of the previous week's activity to an analyst's inbox each Monday morning at 9 am.

To Export Ads Reporting Dashboards

1. Click the New Tab icon. Under the Sprinklr Marketing - Advertising tab, select Ads Reporting under Analyze.

2. On the Ads Reporting Home, select the desired custom dashboard you want to export. You can also access your dashboards from the Dashboard Switcher icon alongside the dashboard name.

3. Click the Options icon in the top right corner of the Reporting Dashboard, and select Export.
Clicking Export to Export an Ads Reporting Dashboard4. On the Export Dashboard pop-up, you can either use Sectional Export or Advanced Export option to export your dashboard. Click one of the below options for detailed information:

  • ​Sectional /One Time Export​

  • ​Schedule Export​

To Perform Sectional / One Time Export

1. On the Export pop-up window, Select the Dashboard Sections to Export from the given options.
Section Wise Exporting Dashboard

2. Under Export Type, select the file format you want to export. Note that the PDF format is preselected. You can select from the following options:

  • PDF - For this file format, you can select the PDF Layout (Portrait or Landscape) and Number of PDFs (One PDF per tab or Single PDF for all tabs).

  • EXCEL - For this file format, you can select the Excel Structure (Every widget in a separate sheet or All widgets in a single sheet).

  • PNG

  • PPT

  • CSV

Note
You can export your reports in an Excel format with a limit of 100,000 rows.

Selecting Export File Format Type

3. Click Export in the bottom-right corner.

To Schedule Export

1. On the Export pop-up window, click View Advance & Scheduled Export Settings.
Selecting Advanced Export Option

2. On the Export Dashboard window, you can customize your export by selecting the export typelayout, and scheduling details. For more information, see the Advanced Export Dashboard — Field Descriptions.
Advanced Export Window

3. Click Export in the bottom right corn

Setup Scheduled Exports to receive automated email Exports:-

Scheduled Exports in Social Advertising enables you to receive automated reports in the form of email and as a downloadable report.

By setting up a Scheduled Exports, you can get emails that show Ads Insights based on the criteria you select. Besides email, you also have an option to embed insights data as a downloadable report. This is really useful when you want to view Insights on your device without visiting Sprinklr. When setting up your exports, you can add your preferred time intervals like Minutes, Hourly, Daily, Weekly, and Monthly.

This is how the export looks in email – 


How to setup Automatted Email Exports:-

1. In the Scheduled Exports window, select the Dashboard (standard/custom) for which you want the automated email exports.

2.Go to "When to Export(schedule)" section of Scheduled Exports and Add the details of fields like Frequency, Recipients Email, Subject etc.

3. Click Export in the bottom right corner.

er.

Scheduling Export Dashboard — Field Descriptions

Term
Description
Dashboard Details
Dashboard

Name of the dashboard you are exporting.

Date Range

Select the date range of the data you want to export.

Exclude today's data

Enable to adjust the time frame to exclude today’s data. By default, this option will be disabled.

Note

If you change the date after enabling this option, then we will reset to default, i.e. it will be disabled.

Currency

Select the currency you want your monetary data to be exported in.

Filters

  • Apply dashboard filters - Select to export dashboard with already applied filters.

  • Apply new set of filters - Select to apply the desired filters to the dashboard you are exporting.

Select the Dashboard Sections to Export

Select the Dashboard Section(s) you wish to export.

How to Export

Add Image

Add an image for the cover page of your exported file. You can preview the changes on the right.

Export Cover: Toggle to enable/disable the export of your dashboard cover.

Export Type

Select export as Excel, PDF, PNG, and/or CSV format.

  • When you select Excel, you will have an option to export Every Widget in separate Excel Sheets or export All widgets in a single Excel Sheet. You can select HTML or None as Email Embed Format.

  • When you select PDF, you will have an option to select the orientation (Portrait or Landscape).

  • When you select PNG, you will have an option to select HTML or PNG as Email Embed Format.

  • When you select PPT, you will be able to export your dashboard in PPT format.

  • When you select CSV, you will be able to export your dashboard in the CSV format.

Note

You can export your reports in an Excel format with a limit of 100,000 rows.

Export Name

Choose title on the cover of Exported File and of the Scheduled report.

Format Your Export

Select the format of your export file as desired.

Widget View in Export

Set the widget view for your export file. It ensures that all the data points fit in the exported file and provides an uninterrupted view of the available data. You can select from:

  • Default View - Default Data Points on Y/X axis

  • Expanded View - All Data Points on Y/X axis

Widget View only applies to widgets with a Range Slider on either the Y or X-axis for PDF, PPT, or PNG file formats.

Storage options

Select a storage option for your export file:

  • Default

  • External Storage

    • FTP/SFTP

    • S3

For information on setup, see Store Sprinklr Exports in Non-Sprinklr Environment.

What to Export
Amount of Data

Define the volume of data in the widget and customize data labels. This is pre-selected.

Data Labels

Select from the following:

  • As on Dashboard - Show data labels that are visible on the dashboard.

  • Hide for All Widgets - Exclude data labels on the dashboard that are shown in the tooltip.

  • Show for All Widgets - Include data labels that are not visible on the dashboard but are shown on the tooltip.

When to Export (schedule)

Tags

Enter your export tag(s).

Schedule
Select the schedule for your export. You can select from the following options:
  • Download Immediately

  • Minutes

  • Hourly

  • Daily (Include Weekend)

  • Daily (Exclude Weekend)

  • Weekly

  • Monthly

Add End Date

Provide an end date.

Recipients

Select from:

  • Select Users/User Groups within Sprinklr.

  • Add Email address for external users.

Note

You can schedule the exports of your reporting widgets and/or dashboards via Email containing PDF files.

Send me a copy of export

Toggle to send yourself a copy of the exported file.

Subject

Enter your email subject.

Sender

Enter the sender of the email.

Reply to

Enter the email address the replies should be sent to.

Email Footer Note

Enter a note. This will be included as an email footer in the export.

Contextual Data

Toggle to only send user's respective Locations data in exports from the dashboard (personalized rendering).

Scheduling Status

Toggle to enable or disable the scheduled export.

To Schedule an Export in Settings

1. Click the New Tab icon. Under the Sprinklr Marketing - Advertising tab, select Ads Reporting within Analyze.

2. On the Ads Reporting Home, click the Options icon in the top-right corner and select Scheduled Exports.
Select Scheduled Export from Ads Reporting Home
If you are on a Reporting Dashboard, click the Options icon in the top-right corner and scroll down to Settings. Hover over Settings and select Scheduled Exports.
Select Scheduled Export from Ads Reporting Dashboard Settings

3. On the Scheduled Exports window, click Add Scheduled Export in the top right corner.

4. On the Export Dashboard window, scroll down to select When to Export (schedule) section and fill in the given details.
Filling in Details for Scheduling Exports

5. Click Export in the bottom right corner.

Note:

Once you create a scheduled export of your Advertising dashboard, you must make it active by sliding the Status toggle button to the right.

Disabling the Scheduled Export cover page