The latest release is always available from the Download page.
Version 1.35.1.0 (2024-11-25)
- Google Ads: fixed problems with invalid accounts so they properly report errors
- Google Analytics: fixed dimension ‘is empty’ filtering to use new API capability
- Formula function errors now properly reported when trying to write to Excel worksheet. Debug sheet properly reports an error with bad formulas.
- Failed renewal license activation will no longer disable existing licenses if the license server does not repond.
- Some wizards now correctly clear previous settings when re-editing the function.
- Google Ads Reports: corected an error when selecting an account that is expired or has no customer accounts.
- Google Search > Url Inspection wizard now cautions if no Url entered [also marked as a required field].
Version 1.34.0.0 (2024-11-11)
- Bing Webmaster: fixed a problem when editing date ranges; added report dimensions and metrics lists for reference
- Google Search: MultiQuery options moved to Fields section (no functional change)
- Repeat Macro: added option ‘Do not clear cell formatting’ when clearing worksheet before run
Version 1.33.0.0 (2024-11-07)
- Bing Webmaster: added pivot by date and metric selection for some reports; supports favorite website per account
- Google Search: correctly handles empty metric columns during pivot operations
- Fixed a problem where previous selections appear twice in some function wizards
- ReadWorksheet, RepeatMacro: adjusts workbook folder reference to current folder if it has been moved
- Now supports license file in located installation folder (with new license file name)
- ‘Formula bar’ now expands to show multi-line values
Version 1.32.0.0 (2024-10-28)
- Bing Webmaster: fixed several reports; added date range capability; added preset date ranges
- Google Search: removed unsupported connection type from Chrome UX report
- Arrange function: fixed insert column by name selection
- File-Google Sheets panel redesigned
Version 1.31.0.0 (2024-10-12)
- Handles large data significantly faster, especially Pivot
- Pivot: added option to limit data processed to reduce likelihood of out-of-memory errors
- Updated algorithms for Combine, Compare, Lookup, Pivot to improve speed and use less memory
- LinkedIn Ads: updated to 202409 API (no functional change)
- License: activate buttons for license keys now appear as ‘activate’ text to avoid confusion
- Cancel button moved above status dropdown on ribbon
- All data processing pushed to background thread to keep product responsive
- Cleaned up some threading problems to make the product more stable
- Implemented security updates in underlying technology
- Ensured that all functions are cancellable
- Updated code to use optimizations available in .NET 8
Version 1.30.0.0 (2024-09-15)
- Combine function: fixed problems with ‘First’ aggregation
- Google Search: properly indicate account problems in wizards
- LinkedIn Ads: update to API 202408
- Bing Ads: updated fields list
- License wizard: added checks for entered but unactivated license keys; About tab improvements
- fixed item deleteion problems in reorderable lists in several wizards
- column name match is now case insensitive
- improvements to connector error reporting
- improvements to debug and exception logging
- privacy improvements: exceptions now logged only to local files when in debug mode
Version 1.29.0 (2024-08-14)
- fixed changes to lists reverting to previous state
- added shadow to dropdown lists
Version 1.28.0 (2024-07-31)
- Google Search: Chrome UX Report fixed cell references for Url/Origin; fixed checkbox for Url selection
- Google Search: Url Inspection fixed cell references for Url
- Google Search: PageSpeed Insights fixed cell references for Url
- Fixed occasional problems with cell display and editing
Version 1.27.0 (2024-07-30)
- Facebook Ads: updated Reports wizard and fixed several bugs with By Action breakdown reports; properly report errors
- fixed problems when deleting entries in several wizards and connectors
- improved error handling
Version 1.26.1 (2024-07-23)
- debug mode enhancements
Version 1.26.0 (2024-07-20)
- fixed a problem with Step Results sheet not displaying properly
- auto-activates connector trials on first use
- debug mode (per Options) now dumps full debug info for API calls
- exception logging (when in debug mode) now keeps timestamped exceptions
- Microsoft Ads: fixed login problems when using multiple accounts
- Microsoft Ads: added error in Reports wizard when selected account requires refresh
- Bing Webmaster: fixed problem when Reports wizard opened without a saved account
- Facebook Ads: properly reports bad account errors
- deletes old temp files monthly
Version 1.25.0.0 (2024-07-15)
- Google Analytics: added the ability to create your own dynamic calculated metrics that do not affect your account limits
- Google Analytics: fixed a problem were comparison date ranges are reversed in reports
- Google Analytics: now properly reports errors when there are account permission problems
- debug mode now captures a stack trace to a local file
- Pivot: now properly handles a datetime column with different time components as a key column
- Google Search: PageSpeed Insights, Chrome UX Report and URL Inspection now accept range names with multiple values for bulk queries
Version 11.24.0.0 (2024-06-30)
- Removed Universal Analytics functions from the Google Analytics connector (goodbye UA!)
- Fixed a problem with GA4 reports involving multiple properties
- ‘Accounts’ on main panel renamed to ‘Options’; added debug mode option
- Added YouTube Analytics connector (early release, only in debug mode, contact support for access)
- Fixed some bugs when working with multiple workbooks
- Added option to turn off usage tracking in License wizard
Version 11.23.0.0 (2024-06-16)
- Read Google Sheet: updated wizard layout; bug fixes
- Write to Google Sheet: updated wizard layout; bug fixes
- improved validation checks in several wizards
Version 1.22.0.0 (2024-06-09)
- Google Ads: updated to v17 API (adds campaign aggregate asset view and channel aggregate asset view)
- fixed note functionality in several wizards (adds comment to macro entry in task pane)
Version 1.21.0.0 (2024-06-07)
- Constant Contact: NEW added connector with V3 API support and new functions (Accounts, Account Information, Campaign Reports, Campaigns, Contacts)
- Fixed some misbehaving cell reference buttons in several connectors (Facebook Insights, Facebook Ads, Google Analytics) and function wizards (Read Google Sheets, Write Google Sheets
Version 1.20.0.0 (2025-05-31)
- Facebook Ads: updated to API v20; fixed a problem when deleting accounts; fixed a problem when using ad account id cell references
- Google Ads: updated to API v16; added autoretry when API return null response;
- Google Analytics: changed filter indenting to make filter priority more obvious; made filter list boxes bigger in wizards; fixed a problem with duplicate filter expressions
- LinkedIn Ads: updated to API v202405; added impression device and placement name dimensions, qualified lead metrics
- Filter, RunMacro, QuickFunctions: changed filter expression indenting to clarify priority
Version 1.19.1.0 (2024-05-13)
- fixed a build problem causing a Syncfusion license warning
Version 1.19.0 (2024-05-10)
- Facebook Ads: fixed Ads Listing when referencing cell for account and ad account
- Facebook Ads: added ability to query per campaign, or query per ad set, to avoid 500 internal error caused by asking for too much in a single query
- Google Analytics: now automatically updates to new fields when editing queries (e.g. conversion -> keyEvents)
- Google Analytics: fixed multi-property queries when referencing a worksheet [range]
Version 1.18.6 (2024-04-27)
- fixed start and end date editing problems with several connector wizards
- Google Business Profile: fixed Last 6 Months selection; fixed search terms editing problems
Version 1.18.5 (2024-04-22)
- Facebook Ads: fixed filtering on campaign/ad set/ad names
- Google Ads: filtering on text filed now auto-wraps expression in single quotes as required
- Google Ads: fixed some error handling problems
- LinkedIn Ads: updated to latest API
- improved Facebook login stability; enabled retry of Code login
- added SMTP back into Save to Workbook/PDF functions
- Convert: fixed date->text with ISO Year and ISO Week conversions
- Filter/Run…If…: fixed And/Or missing on second filter added
Version 1.18.0 (2024-03-28)
- cleaned up help references
- Bing Webmaster: reports wizard updated for consistency with other connectors
- Google Search: fixed date comparison options for difference and % changed
Version 1.17.0 (2024-03-24)
- Google Search: fixed country filtering
- Fixed a variety of user interface quirks in selected fields, filter rules and sort rules list boxes
- Fixed several account wizards not properly closing
- License wizard: fixed licensing problems with Microsoft Ads connector
- Google Analytics – GA4 Report: added Minimize Sampling option
- Google Analytics – Realtime Report: fixed filter and sort options, field names
- fixed a problem where caching prevented downloading of the latest release
- Replace function: fixed a problem for [range name] usage in find or replace text field
- fixed a problem where some text in wizards was obfuscated (made meaningless)
Version 1.15.0 (2024-03-07)
- Microsoft Ads: fixed problem refreshing security tokens
- fixed a problem where wizard Cancel buttons don’t work
- added ability to type-to-filter in many dropdown controls
- fixed a problem where dropdowns may not close when selection clicked
- Google Ads: fixed a problem where opening the wizard crashed
- faster wizard opening
- Google Business Profile: consolidated single/multiple metric functions into single Performance Report function
- fixed a problem selecting macros in the Task Pane
Version 1.14.0 (2024-03-05)
- Added Google Business Profile connector (early release – contact support for access)
- cleaned up login functionality in many connector wizards
- cleaned up multithreading problems in several wizard Fields panels
- Google Ads: fixed a pagination problem; fixed sort panel problems
- Google Analytics: now reports sampling metrics in Status log after each query
- SaveToPdf/Workbook: proeprly offer Microsoft Email and Gmail account options
- Read/Write To Google Sheets: properly offer Google account options
- License/About: migrated to popup window identical to the Add-in
- Accounts: migrated to popup window identical to the Add-in
- License: added Update section to simplify updates
- Fixed stability problem affecting several wizard and connectors
- Microsoft Ads: improved login experience for multi-account users
- Fixed problems with several connectors when modifying selected fields
Version 1.12.1 (2024-02-22)
- fixed problem with Append to Worksheet function
- fixed a problem where debug sheet did not show last row of data
Known Issues:
- On MacOS: pressing Enter in popup dialogs (new macro name, file name, etc) ignores the text entered; WORKAROUND: click the OK button instead
Previously in v1.12.0 and earlier
- updated Microsoft Ads and Microsoft Email logins to permit specifying an alternative email address to log into (other that the default that the browser remembers)
- improved error handling in Read/Write Google Sheets wizard
- added Date Comparison capability to the GA4 Reports query
- fixed problems with Read/Write Google Sheets wizards
- fixed a problem where wizards sometimes open empty
- fixed problems licensing and logging in with the Microsoft Ads connector
- Fixed a problem with scheduling a workbook refresh
- Fixed a problem with updates not picking up new metadata files
- added Facebook Ads connector
- fixed a problem with updates not picking up new metadata files
- Microsoft Ads: fixed Budget report
- Google Ads: fixed cache file location
- LInkedIn Ads: updated to 202402 API; limited to 1000 rows due to bug in API
- removed Google BigQuery connector early access warnings
- Google Ads connector now automatically handles multiple assets in reports (as multiple rows)
- added new Google Big Query connector (early release)
- added filter expression copy button to GA4 Report wizard
- fixed a problem for grandfathered Basic add-in licenses
- fixed the expiry date display for the Add-in in the Licnese wizard
- fixed a problem with the Step Results sheet not properly displaying during Quick Query
- properly handle large Google Analytics account listings
- new function Google Analytics > GA4 Realtime query
- fixed the refresh selected queries dialog
- fixed Google Search > Search Analytics query with cell reference for date end
- fixed problems with multiple connectors when adding new accounts
- fixed multiple connectors not handling cell reference values properly when editing query
- Google Ads connector now rebuilds account in-memory cache if Excel is restarted
- fixed problem editing Google Ads queries
- updated Google Ads to v15 API with latest fields; may affect how assets are reported
- added to Quick Filter > Arrange function the ability to convert MultiColumn (-1,-2) to MultiRow similar to full Arrange function in macros
- 1.6.1 fixes a problem affecting startup for new installations
- cleaned up Google Sheets folder navigation in Read Google Sheets and Write Google Sheets functions
- fixed configuration folder handling for non-typical installations
- added split by semicolon option to Web Request function
- added functions Read Google Sheet and Write Google Sheet
- fixed startup crash
- fixed blank Step Results sheet problem