Be sure the Google Analytics account you are using has "Analyst" permissions

Be sure the Google Analytics account you are using has "Analyst" permissions

How Zapier will format the raw data from Google. Read more in the help docs.

Can select up to ten metrics to include in the report.

Can select up to seven dimensions.

Maximum of four. Using segments reduces the total number of dimensions allowed to six.

Must be a metric included in the report.

When sorting by a metric, which direction to sort.

Be sure the Google Analytics account you are using has "Analyst" permissions

Be sure the Google Analytics account you are using has "Analyst" permissions.

We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.

Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].

We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.

Be sure the Google Analytics account you are using has "Analyst" permissions

Be sure the Google Analytics account you are using has "Analyst" permissions

A positive whole number.

Assign a monetary value to the conversion.

Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.

Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows

Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].

Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.

Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.