Merge Delivery Hub Report Data with Other Sources

You can export report data from Delivery Hub and combine it with other data sources in your organization to reach broader insights. You can export a report manually (learn more) or schedule to automatically refresh the data at regular intervals, and then create a custom API which your data warehouse system calls to extract the refreshed data for analysis.

Before You Begin

• Decide on the insight you want to check, and define the Delivery Hub data which you need to extract, and build a report which shows that data in a table (learn more).

• Ask your IT integrator to set up an integration with your data warehouse. A typical integration includes a script that calls the custom API endpoint and pulls the contained data into your data warehouse at regular intervals.

Merge Report Data

Step 1 Open Delivery Hub and navigate to Analytics > Reports, then select a report from My Reports or a preconfigured template.

Step 2 To populate the report with updated data at regular intervals, select Schedule Report then enter the cadence of the data update.

Update the data either Monthly, Weekly, or Daily by selecting the frequency under Recurrence, then choose a specific time for the automatic update.

Choose the frequency of the data update

Step 3 Ensure data compatibility with the receiving data systems by selecting Timezone.

The timezone you choose determines the timezone of all timestamps in your data table and determines the exact time for refreshing the data inside the report.

Ensure data compatibility by selecting the time zone of the receiving system

Since you're setting up a script to pull the updated data from Delivery Hub, the timing of the refreshed data must be accurate.

Step 4 Select URL under Select Export Method to create a custom endpoint that returns your report data. The report includes updated data after every scheduled interval.

Generate an API endpoint that leads to your report

Step 5 Select an output format accepted by the data warehouse (or other receiving tool), by selecting CSV or JSON next to Select your format type.

Step 6 Select Send to activate the recurring data update.

Step 7 Select the copy icon next to the URL to copy the text, and send it to your IT integrator to use for the integration with your data warehouse.

You can also test the link by entering it in the address bar of your browser to download the report locally.