Skip to main content

Set up a creative export

Export your ad images and videos with a manifest file to Amazon S3, Google Cloud Storage, Azure Blob Storage or SFTP, and match them to your performance data.

A creative export saves the images and videos from your ads as files in your own storage, with a manifest file that lists each file and the IDs you need to match it to your performance data.

​

Creative exports are a private beta feature. To get access, contact your Funnel representative.

​

Creative exports support more connectors than creatives in dashboards.

​

Before you begin

  • Your data source has the configuration for creative data. See the list below.

  • You can create exports.

  • You have access to Amazon S3, Google Cloud Storage, Microsoft Azure Blob Storage or an SFTP server.

  • Your workspace is on the Business plan or the Enterprise plan.

​

Configure the data source

Funnel can only export creatives from data sources that collect creative data. The configuration is the same as for creative reporting. Use the guide for your connector:

​

  • Facebook Ads: Report type Regular, Level Ad and the additional field group Ad creative data.

  • Google Ads: Report type Standard and Report level Campaign, Ad Group, Ad or Campaign, Ad Group, Asset.

  • TikTok Ads: Metrics Basic and Level Campaign, Ad group, Ad.

  • LinkedIn Ads: Metrics Regular and Report Standard.

  • Pinterest Ads: Level Pin Promotion and Include Pin Metadata.

  • Microsoft Advertising: Metrics Regular and Report level Ad.

  • Reddit Ads: Report type Standard and Report level Ad.

  • Snapchat: Metrics Regular, Level Ad and the additional dimensions Include creative dimensions and Include media dimensions.

  • The Trade Desk: Metric type Standard and Report type Ad Group Performance.

  • X Ads: Report Promoted Post.

​

When you change the configuration of a data source, Funnel reloads its historical data. Wait until it finishes before you run the export.

​

Create a creative export

  1. Go to Export > Destinations, find your destination and click Create Export.

    ​

  2. Connect to your destination and enter where Funnel saves the files, for example a bucket and a bucket path.

    ​

  3. Under Data type, select Creatives.

    ​

  4. Under Data, add filters to choose which creatives to export, for example only some data sources, or only images or videos with Creative type.

    ​

  5. (Optional) In File name template, change how Funnel names and organizes the files. You can use variables such as {connectorId}, {remoteId}, {assetId} and {creativeType}.

    ​

  6. Click Show advanced settings, and set up the manifest file:

    ​

    • Manifest file: Select JSON manifest or CSV manifest. To load the manifest into a data warehouse such as BigQuery, select CSV manifest.

    • Manifest file name template: Keep manifest, or enter another name. Funnel adds the file extension.

    • Manifest fields: Select the columns to include. The Manifest fields section below describes each one.

    ​

  7. Under Schedule, choose when the export runs, and click Save.

    ​

  8. Click Start to turn on the export. To run it right away, open the actions menu (⋮) and select Run now.

​

The export guide for your destination, such as the Amazon S3 export guide, describes the destination settings.

​

What to expect

Funnel saves each image and video as a file in your destination, and saves the manifest file in the same location. Later runs export only new or changed creatives. To check a run, see Run history on the export page.

​

Manifest fields

The manifest has one row for each exported file. These are the fields you can include. Funnel includes the default fields unless you change the selection.

Field

Default

Description

Connector ID

Yes

The connector that the creative comes from.

Remote ID

Yes

The ID of the ad account that the creative comes from.

Mapping ID

Yes

The ID of the item that uses the creative, such as the ad. Use it to match the creative to your performance data.

Asset ID

Yes

The advertising platform's ID for the image or video.

Image ID

No

The advertising platform's ID for the image. Empty for videos.

Video ID

No

The advertising platform's ID for the video. Empty for images.

Platform image field

Yes

The field on the advertising platform that the image comes from.

Platform video field

No

The field on the advertising platform that the video comes from.

Mapping field

Yes

The Funnel field that the creative comes from, such as an image or thumbnail field.

Downloaded at

Yes

When Funnel downloaded the file.

File name

Yes

The path and name of the file in your destination.

Content type

Yes

The file format, such as image/jpeg.

Creative type

No

Whether the file is an image or a video.

If you export videos, add Video ID, Platform video field and Creative type.

​

Match creatives to your performance data

To see your creatives next to their metrics in your own tools, export your performance data too, for example to BigQuery, and join it to the manifest.

​

  1. In your performance data export, include Data Origin Identifier and the ID of the item that uses the creative, such as Ad ID.

    ​

  2. Load the manifest into the same tool as your performance data.

    ​

  3. Join the two on these fields:

    • Data Origin Identifier matches Connector ID and Remote ID in the manifest, combined as connectorId:remoteId. For Facebook Ads, Data Origin Identifier starts with facebook: instead of the connector ID.

    • The ad ID, or other item ID, matches Mapping ID.

    • If you export more than one image field, such as a thumbnail and a full-size image, also filter on Mapping field.

    ​

​

Use a left join, so that rows without a matching creative stay in your results. To show the images in a BI tool, the files in your storage must be public, or your storage must create signed URLs.

​

You can analyze ad creatives and performance in BigQuery with Google Cloud Storage, step by step and with the SQL.

​

If the export does not contain creative data

  • Check that the data source has the configuration for your connector.

  • If you changed the configuration recently, wait until Funnel has reloaded the historical data, and run the export again.

  • If some creatives are missing, check the filters under Data.

  • Check the export guide for your destination for authentication and bucket requirements.

Did this answer your question?