Change Log – Desktop App

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