Change Log – Add-in

Version 11.18.4 (2024-04-08)

  • fixed scheduled refresh functionality

Version 11.18.3 (2024-04-04)

  • improved startup stability
  • improved Facebook login stability; enabled retry of Code login

Version 11.18.2 (2024-04-02)

  • added SMTP back into Save to Workbook/PDF functions
  • Accounts (Add-in): fixed SMTP settings not being saved

Version 11.18.1 (2024-03-31)

  • Convert: fixed date->text with ISO Year and ISO Week conversions
  • Filter/Run…If…: fixed And/Or missing on second filter added

Version 11.18.0 (2024-03-27)

  • 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 11.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

Version 11.16.1 (2024-03-20)

  • License wizard: fixed licensing problems with Microsoft Ads connector

Version 11.16.0 (2024-03-14)

  • 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 11.15.1/11.15.2/11.15.3 (2024-03-11)

  • fixed Google Analytics UA Report filters

Version 11.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

Version 11.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: fixed browse button for user configuration folder

Version 11.13.0 (2024-02-29)

  • Ribbon now shows version of update available
  • License: added Update section to simplify updates
  • Fixed stability problem affecting several wizard and connectors
  • Add-in should properly resume from Sleep mode
  • Microsoft Ads: improved login experience for multi-account users
  • Fixed problems with several connectors when modifying selected fields

Version 11.12.1 (2024-02-22)

  • 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)
  • updated Add-in Accounts login wizard to properly report status in the wizard title
  • Add-in should properly resume after computer resuming from sleep/suspend
  • improved error handling in Read/Write Google Sheets wizard

Previously in version 11.12.0 and earlier

  • 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
  • Microsoft Ads: fixed Budget report
  • Facebook Ads: updated wizard UI; breaking changes: metrics always follow dimensions, dropped filter by Placement
  • Google Ads: fixed cache file location
  • LInkedIn Ads: updated to 202402 API; limited to 1000 rows due to bug in API
  • reintroduce Task PAne button on ribbon
  • fix Facebook Ads 250 row limit; update Ads Listing wizard
  • fixed loss of Microsoft Ads connector from License wizard; removed Google BigQuery connector early access warnings
  • Google Ads connector now automatically handles multiple assets in reports (as multiple rows)
  • fixed Facebook login in Facebook Insights and Facebook Ads connectors
  • Facebook Ads connector now displays campaigns properly
  • 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 Facebook Ads connector changing previous selections when editing query
  • 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
  • updated Facebook Insights connector to latest API release
  • updated Facebook Ads connector to latest API release
  • 1.7.1 – fixed Facebook account problems with Facebook Insights and Facebook Ads connectors; may require account refresh
  • 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
  • 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
  • skipped version numbers to synchronize with the Desktop App (Addin v11.5.0 shares code with Desktop App v1.5.0)
  • production release of the Add-in, stability and bug fixes to the Desktop App
  • dropped SMTP email, added Microsoft email to the Save to PDF/Save to Workbook wizards