Expanded data sets in Google Analytics 360 enable you to trigger the expansion of the (other) row in a report or exploration to up to 2 million rows of data. Expanded data sets are available for both default and custom reports for Google Analytics 360 properties. Expanded data sets can also be queried using the Google Analytics API or Looker Studio.
In this article:Limits and caveats
- Expanded data sets are only available for Google Analytics 360 properties.
- You can create a maximum of 100 expanded data sets per Google Analytics 4 360 property. If you're nearing this limit, you can delete any existing expanded data sets that you're no longer using.
You should only use expanded data sets when you need detailed data in a report on an on-going basis.
For one-off reporting needs, you can use unsampled explorations. - The Advertising reports aren't currently eligible for expanded data.
- Your report can't include more than 6 dimensions or 12 metrics. This includes dimensions that are used in filters and comparisons.
- If the expanded data you request still exceeds 2 million rows, your report can still include an (other) row. As a best practice, only include necessary dimensions in reports. Note: Additional metrics do not affect the (other) row.
- If you archive a custom dimension, you have the option to delete any expanded data sets that include that dimension. Learn more about archiving
- From the time you request expanded data in a report, it will take 48 hours for data to move out of the (other) row. After 48 hours, that report will have expanded data going forward.
Request an expanded data set
To request an expanded data set, you need the Editor or Administrator role on the property. Contact your Google Analytics administrator if you have questions about your permission level.
- In your Analytics account, go to an eligible report that includes an (other) row.
- Select your desired primary and/or secondary dimensions and apply any filters or comparisons.
- Click the data quality icon at the top of the report.
- Click Expand this data.
- In the Expanded data details page, enter a name and description.
- Click Create.
Wait for 48 hours and return to the report, which will have expanded data. Google Analytics expands the data for 52 days before the date when the request was made as well as new data going forward.
See expanded data set configurations
To see a list of the expanded data sets for your property, you need the Editor or Administrator role on the property.
- In Admin, make sure that you have the desired account and property selected.
- In the Property column, select Expanded data sets.
On the Expanded data sets page, you'll see a table with rows for each of your requested expanded data sets. The table shows the name, date of creation, first time available, and description of each data set.
If you want to see how close you are to the limit of 100 expanded data sets, click Quota information at the top of the table.
Click a row to open up the Expanded data details page for each data set. You can see which dimensions, metrics, and filters the data set includes.
Delete an expanded data set
To delete an expanded data set, you need the Editor or Administrator role on the property.
- In Admin, make sure that you have the desired account and property selected.
- In the Property column, select Expanded data sets.
- Click the row that contains the expanded data set you want to delete.
- On the Expanded data details page, click the Delete button at the top of the page.
- In the confirmation pop-up, click Delete.
Unsupported dimensions and reports
Not all dimensions or reports are supported. If any of the following is true about the report, then Analytics 360 won't be able to create an expanded data set, and you'll still see the (other) row:
- contains channel grouping dimensions
- is an overview card
- has more than 6 dimensions or 12 metrics, including dimensions used in comparisons and filters
- includes a filter that uses an OR clause