The latest release is always available from the Download page.
Version 11.30.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 11.29.2 (2024-08-26)
- should stop 0x800AC472 errors when interacting with Excel during a refresh
Version 11.29.0 (2024-08-14)
- Facebook Insights: removed deprecated metrics
- fixed changes to lists reverting to previous state
- added shadow to dropdown lists
Version 11.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
Version 11.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
- updated installer to check for latest .Net Desktop Runtime version (8.0.7)
Version 11.26.1 (2024-07-22)
- debug mode enhancements
Version 11.26.0 (2024-07-20)
- 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 11.25.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.14.0 (2024-06-29)
- Removed Universal Analytics functions from the Google Analytics connector (goodbye UA!)
- Fixed a problem with GA4 reports involving multiple properties
- ‘Accounts’ button on ribbon renamed to ‘Options’; added debug mode option
- Added YouTube Analytics connector (early release, only in debug mode, contact support for access)
- Fixed a problem with running multiple Analytics Edge queries or macros from VBA
- Added option for VBA RunMacro commands to run without popup messages
- Fixed some bugs when working with multiple workbooks
- Removed old MailChimp connector
- Added option to turn off usage tracking in License wizard
Version 11.23.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 11.22.1 (2024-06-11)
- Google Ads: fixed a problem with some combinations of fields in the new views in v17 API
- Google Search: fixed the Search Analytcis wizard to clarify that date comparison cannot be used with multi-query options
- Write to Text File: fixed a problem when writing an empty table where the add-in did not create any file; now it creates an empty file
Version 11.22.0 (2024-06-09)
- Google Ads: updated to v17 API (adds campaign aggregate asset view and channel aggregate asset view)
- fixed a problem when working with multiple workbooks open
- fixed note functionality in several wizards (adds comment to macro entry in task pane)
Version 11.21.0 (2024-06-07)
- Constant Contact: added V3 API support with new functions (Accounts, Account Information, Campaign Reports, Campaigns, Contacts); fixed cell references for dates
- 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 11.20.0 (2024-05-31)
- Constant Contact: implemented workaround to retry intermittent API problems
- Facebook Insights: updated to API v20; removed permission request causing error during login
- 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
- Updated ExcelDna to v1.8 (technology enabling Excel add-in)
Version 11.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 11.18.7 (2024-04-29)
- fixed a problem with scheduled refreshes that may have caused double refreshes or errors
Version 11.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 11.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
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