Use Google Data Studio's Extract Data connector to store a subset of your Funnel export and select a custom date field for your report. Extracted data can also make reports load faster than a live data source.

Before you begin

You can edit the Google Data Studio report and its data sources.
Your Funnel export contains the custom date field that you want to use.
The extract will contain less than 100 MB of data.

Understand extracted data

The Extract Data connector stores selected fields from an existing data source in Google Data Studio. You can limit the extract with fields, filters and a date range.

Extracted data has these limitations:

An extract can contain up to 100 MB of data. Use a data warehouse if you need more data or more granular data.
An extract is not live. You can refresh it daily, weekly or monthly.
An extract contains only the fields and date range that you select. Edit the extract when you need to add fields or extend the date range.

You can use live Funnel data sources and extracted data sources in the same report. For example, use Extract Data when your CRM data contains several date fields or when you want to report on a social post's creation date instead of its activity date.

Convert the custom field to a date

Create and connect a Funnel export by following Export Funnel data to Google Data Studio.
Open the Funnel data source in Google Data Studio.
Click Add a field.
Enter a name for the field.
Enter PARSE_DATE('%Y-%m-%d', custom_date) in the formula field. Replace custom_date with your field name.
If your field uses a different date format, select the matching format element.
Save the field.
Close the editor.