How Data is Returned from Google Analytics

When running a report, there are several ways you can request Zapier return the data to be used in later steps in a Zap.

Individual Data Points

This option provides each data point returned by Google as a field available to map into another step in a Zap. For instance, if you run a report to get page view counts for last week using the dimension of "Day of the Week," Zapier would provide seven fields to map into later steps in your Zap, one for each day, like this:

screenshot of mapping individual data points

This output is intended for reports that generate only a few data points. For example, a report with zero or one dimension, or a report that sorts and limits to a small subset of results.

Rows

This option provides the data points returned by Google as a list. This can be handy when combined with a later Action that supports line items.

Formatted Text

This option condenses the data into a text report and provides a single field to map into another step in a Zap, like this:

screenshot of mapping text report

This output is intended for reports that generate a lot of data points that would be tedious to map into a Zap one-by-one. For example, a report on page views that uses the dimension "Country", or combines the dimensions "Day of Week" and "Browser", generate over 100 data points.

Formatted JSON

This is an advanced option. It is similar to Formatted Text in that it condenses the data into a single field. However, instead of a human-friendly text report, the data is encoded as JSON. This JSON data can be sent to other systems in HTTP requests using the Webhook by Zapier App, or fed into a Code by Zapier App to be manipulated further.

Was this article helpful?
0 out of 0 found this helpful