Function Wizards (filter at right)

Unpivot

This Analytics Edge wizard is used to perform a reverse pivot operation, converting multiple columns of data into two; one with the original column name and the other with the value. More →

Update

This Analytics Edge wizard lets you update the current table from entries with matching rows in another table or worksheet. More →

URL Shares

urlsharesThis Analytics Edge wizard is used to get the Facebook share metrics for any URL or list of URLs. More →

V2 (old) API – Accounts – Constant Contact

This wizard is used to authorize Constant Contact login accounts to be used by the old version 2 API queries. It is strongly recommended to move to the newer version 3 API accounts and queries as soon as possible. More →

Web Request

This function allows you to make a raw web request and parsing the response. Note that this is  a very technical function that could be used in a wide variety of ways, so limited help is available here. Contact support for clarification if needed.

More →

Write To Google Sheet

This Analytics Edge wizard is used to write the results of an analysis to a Google Sheets worksheet. It always overwrites the entire sheet. It can can be added as a separate macro function, or as an option from the Write to Worksheet wizard. More →

Write to Text File

This Analytics Edge wizard lets you write the current table to a delimited text file, specifying the format to be used for dates. More →