# Optakit Platform Changelog Website: https://www.optakit.app Total Posts: 107 --- ## Faster, More Reliable Calculated Columns **Category:** Improvement **Published:** Oct 03, 2026 at 07:57 PM Calculated columns are now flattened into a single, optimized expression when queries run, so dashboards built on layered calculations return results faster and more consistently. If you've built calculations on top of other calculations, you'll notice quicker load times and fewer edge-case errors β€” complex metrics now behave the same way simple ones always have. - Nested and chained calculated columns are resolved into one streamlined query expression - More consistent results across widgets that reference the same calculation - Added safeguards that validate generated SQL, catching invalid expressions before they reach a dashboard --- ## Connect Switchboard Data in a Few Clicks **Category:** New Feature **Published:** Oct 03, 2026 at 07:57 PM Switchboard is now available as a native source type, so you can bring Switchboard data into Optakit without custom pipelines or manual exports. Setting up a connection is now a guided, in-app flow instead of an engineering project β€” which means new data lands in your dashboards in minutes, not sprints. - New Switchboard source type available directly in the source editor - Guided configuration with validation, so misconfigured credentials are caught before you save - Clearer activity logging for every Switchboard sync, making it easy to confirm what ran and when - Cleaner confirmation messaging during setup (no more duplicate notifications πŸŽ‰) --- ## Stability Fixes Across Admin and Contact Management **Category:** Fix **Published:** Oct 02, 2026 at 09:01 PM A round of fixes addressing issues reported in admin tools and contact management, including record index refreshes that could leave data looking out of date and inconsistencies in owner-level admin routes. - Corrected contact management record and projection refresh behavior - Fixed edge cases in owner admin routes - Cleaned up legacy publishing logic that could produce inaccurate tool states --- ## Group Membership Limits Keep Access Manageable **Category:** Improvement **Published:** Oct 02, 2026 at 09:01 PM Non-owner users are now capped at 35 group memberships, with clear feedback when the limit is reached. Owners are unaffected and retain full flexibility. **Why it matters:** sprawling group membership is the most common cause of slow permission checks and confusing access audits β€” this keeps sign-in fast and your access model easy to reason about. --- ## Save Your Filters and Reuse Them Anywhere **Category:** New Feature **Published:** Oct 02, 2026 at 09:01 PM Stop rebuilding the same filter combination every time you open a dashboard. You can now save a set of filters, reapply it in one click, and copy it to other dashboards. **Why it matters:** recurring reviews and weekly reports go from a minute of clicking to a single selection, and everyone on the team looks at the same slice of data. - Save and reapply filter sets on dashboards - Copy a saved filter to another dashboard with the new copy dialog - Noticeably faster filter dropdowns, even on columns with lots of distinct values --- ## Query Your Sources Directly from Any SQL Tool **Category:** New Feature **Published:** Oct 02, 2026 at 09:01 PM Sources can now be reached through a standard external SQL connection, so your data lives where your team already works. Point your BI tool, notebook, or reporting script at the mirror and query live Source data with the SQL you already know. **Why it matters:** no more exporting CSVs to get data into downstream tools β€” analysts can connect once and keep their dashboards current automatically. - External SQL access available for Sources - Access governed by plan entitlements, so admins stay in control of who can connect --- ## New Tables Upgrade: Edit Width, Order, and Formatting **Category:** New Feature **Published:** Oct 02, 2026 at 09:01 PM Tables got a significant upgrade aimed at making day-to-day requests easier to answer without leaving the page. Column controls, per-column actions, and text sizing let you shape a view to the question you're actually asking. **Why it matters:** fewer ad-hoc requests to your data team β€” people can reshape and export what they need themselves. * New column controls and per-column actions menu for reordering, formatting, and quick operations * Adjustable text size so dense tables stay readable on any screen * Improved export handling for query results * More consistent handling of created-on and other system fields --- ## New Fonts Across Your Workspace **Category:** New Feature **Published:** Oct 02, 2026 at 09:01 PM You can now choose the font used across your workspace, so dashboards and shared views match your organization's visual identity. **Why it matters:** reports you share with clients and executives feel like they came from you, not from a generic tool β€” with no design work required. --- ## More Reliable Saves While Editing Dashboards **Category:** Improvement **Published:** Oct 02, 2026 at 09:01 PM Dashboard revision saving has been reworked to behave more predictably when multiple edits happen in quick succession, with clearer warnings before you risk overwriting a change. **Why it matters:** less chance of losing work or silently clobbering a teammate's edit during a busy editing session. --- ## More Reliable Meta and Google Ads Reporting **Category:** Improvement **Published:** Sep 16, 2026 at 08:21 PM We've refreshed how Meta and Google Ads data is collected, validated, and published so daily campaign numbers line up with what you see in the ad platforms. Fewer surprises in your performance dashboards means less time spent reconciling discrepancies and more confidence when you share results with clients and stakeholders. πŸ“Š * Updated Google Ads daily campaign performance modeling for more accurate spend and delivery metrics * Added validation checks that catch out-of-range percentage values before they reach your reports * Standardized Meta timestamp handling so activity is attributed to the correct day * Improved output publication so refreshed data flows through to downstream reports consistently --- ## New Source: DSPolitical Deployment Data Into Your Reports **Category:** New Feature **Published:** Sep 16, 2026 at 08:21 PM DSPolitical is now available as a connected source, so deployment reports land in your workspace automatically instead of arriving as one-off files. If you run programmatic or digital persuasion programs through DSPolitical, this removes a manual hand-off from your reporting cycle and keeps deployment results alongside the rest of your paid media data. * New DSPolitical deployment source with guided setup in the source editor * Emailed deployment reports are received, parsed, and loaded for you * Appears with its own icon in the source list, so it's easy to spot and manage --- ## Spot Outliers at a Glance with Conditional Formatting **Category:** New Feature **Published:** Sep 12, 2026 at 03:33 PM Numeric columns in dashboard tables can now be color-coded based on their values, so the numbers that matter jump off the page. Instead of scanning rows to find the underperformer or the breakout result, your table does the work for you β€” turning a wall of figures into an instant read on performance. * Apply conditional formatting rules to any numeric table column * Rules carry through validation so your widgets stay consistent * Improved decimal handling for cleaner, more accurate displays --- ## Hash and Compare Lists Without Sharing Raw Data **Category:** New Feature **Published:** Sep 12, 2026 at 03:33 PM A new Hashing Tool lets you securely hash contact lists and compare them against a partner's file β€” right in the browser, without exposing raw personal data. Secure list matching used to mean spreadsheets, scripts, and a nervous email to your data team. Now it's a self-serve flow that takes a minute and keeps sensitive records protected end to end. πŸ” * Upload a file and preview exactly which columns will be hashed before you commit * Compare two hashed files to find overlap and unique records * Share results through a dedicated share dialog with clear labeling on the compare flow * Full documentation included to walk your team through the process --- ## Safer Calculated Columns **Category:** Improvement **Published:** Sep 12, 2026 at 03:33 PM Calculated columns are now validated before they run, catching invalid or unsafe expressions up front rather than at query time. You get a clear signal when a formula won't work instead of a broken dashboard later β€” and stronger SQL safeguards keep custom expressions from doing anything they shouldn't. --- ## Faster, More Reliable Groups and Resources **Category:** Improvement **Published:** Sep 12, 2026 at 03:33 PM Groups and Resources now run through backend services instead of loading in the browser, making these screens noticeably quicker and more consistent. Large accounts with lots of groups and shared resources will feel this most β€” fewer spinners, fewer stale views, and behavior that stays the same no matter how much data you have. --- ## Bring Switchboard Contributions Into Your Reporting **Category:** New Feature **Published:** Sep 12, 2026 at 03:33 PM Switchboard contribution data is now a supported source type, with a dedicated editor and built-in mapping into standardized sources and donation performance reporting. Contribution data lands in the same models as the rest of your fundraising sources, so you can measure donation performance across channels without stitching exports together by hand. * New Switchboard contribution source editor * Provider mappings and validation handled automatically * Flows directly into standardized source and donation performance recipes --- ## View Map Data by County **Category:** New Feature **Published:** Sep 12, 2026 at 03:33 PM Map visualizations now include a Zipcodes to Counties option, letting you aggregate zip-level data into county boundaries with a single toggle. County-level views are how most partners, boards, and public agencies think about geography β€” this removes the manual crosswalk work that used to stand between your zip data and a presentable map. πŸ—ΊοΈ * Automatic zip-to-county crosswalk, no external lookup files required * County labels now include the state, so similarly named counties are never ambiguous --- ## More Reliable List Publishing **Category:** Fix **Published:** Aug 25, 2026 at 09:41 PM We've resolved issues with list publishing to ensure your published lists are consistently accurate and reflect the latest data. Why it matters: You can now trust that when you publish a list, the results downstream will match exactly what you intendedβ€”no more troubleshooting mismatches between draft and published versions. --- ## Stronger Data Integrity with the New Audit System **Category:** New Feature **Published:** Aug 25, 2026 at 09:41 PM A new behind-the-scenes audit system now continuously validates the platform's data schemas and deployment readiness before changes go live. Why it matters: This catches configuration and data issues earlier, meaning fewer surprises, more reliable deployments, and a more stable experience for you and your team. * Automated schema auditing to detect drift and inconsistencies * Deployment readiness checks integrated into our release pipeline * Clearer distinction between published and working list tables for easier tracking --- ## Export Widget Data to CSV in One Click **Category:** New Feature **Published:** Aug 21, 2026 at 02:56 PM You can now download the results of any widget directly as a CSV file from the dashboard. No more copy-pasting or manual exports β€” pull widget data straight into Excel, Sheets, or your analysis tool of choice in seconds. --- ## Sources Filtered by Group for Cleaner Navigation **Category:** Improvement **Published:** Aug 21, 2026 at 02:56 PM Sources are now filtered by your active group, so you only see what's relevant to the context you're working in. Less clutter, faster selection, and fewer chances of picking the wrong source when building queries or dashboards. --- ## Embed Videos Directly in Your Dashboards **Category:** New Feature **Published:** Aug 18, 2026 at 01:53 PM Bring your dashboards to life with the new Video Widget. Embed videos directly alongside your data to add context, walkthroughs, or announcements without sending users elsewhere. Keep training clips, campaign explainers, and stakeholder updates right where your team is already working β€” no more juggling tabs or hunting for links. --- ## Look Back at 90 Days of a Daily Report **Category:** New Feature **Published:** Aug 18, 2026 at 01:53 PM The new Daily Report History Viewer lets you browse past daily reports directly from the dashboard, giving you instant access to historical snapshots up to 90 days ago without digging through email or archives. Spot trends, revisit past performance, and answer "what did that number look like last week?" in seconds. --- ## Pull From-Line Data from ActionKit **Category:** New Feature **Published:** Aug 18, 2026 at 01:53 PM The ActionKit source integration now includes from-line data, giving you deeper visibility into email sender details when configuring pipelines. Better sender-level reporting means clearer attribution and more accurate performance analysis across your ActionKit campaigns. --- ## New Source: Bring Social Media Data Into Your Dashboards! **Category:** New Feature **Published:** Aug 13, 2026 at 01:03 PM You can now connect social media platforms, such as Instagram, X, YouTube, and TikTok as a data source and pull performance metrics directly into your Optakit dashboards alongside the rest of your marketing data. This removes the need to jump between platforms to piece together campaign results β€” your social performance lives next to everything else you measure, so cross-channel reporting takes minutes instead of hours. - New Social Media source type with X (Twitter), Meta (Instagram, FB), YouTube, and TikTok support - Streamlined pipeline for pulling and refreshing social data - Transparent usage tracking and pricing for social sources --- ## Faster Dashboard Loads and Smarter Refreshes **Category:** Improvement **Published:** Aug 13, 2026 at 01:03 PM Dashboards now load faster and refresh more reliably thanks to bundle optimizations, improved caching, pre-fetching, and a new fallback loader that keeps the app responsive even on slow connections. Less waiting, fewer stalled screens, and more time actually looking at your data. These improvements compound across every session β€” especially for teams checking dashboards throughout the day. - Reduced bundle size for quicker initial page loads - Improved caching and pre-fetching strategy - New fallback loader for a smoother startup experience - Scheduled widget refresh reliability improvements --- ## Track Audiences with First Name, Last Name & ZIP **Category:** New Feature **Published:** Aug 13, 2026 at 01:03 PM List Tracking now supports matching contacts using First Name, Last Name, and ZIP code β€” giving you a reliable way to track audiences when email or phone identifiers aren't available. This means more of your uploaded lists will match successfully, so you get a fuller picture of audience overlap and campaign performance without losing records to missing identifiers. - New First/Last/ZIP matching logic for uploaded lists - Added an Uploaded Timestamp column with initial sort in the visualization - Improved audit script for cleaner tracking data --- ## Fresher Data from Switchboard Sources **Category:** Improvement **Published:** Aug 10, 2026 at 03:34 PM Switchboard sources now refresh on a configurable cache cadence, ensuring the data feeding your workflows and dashboards stays up to date automatically. Fewer stale reports and manual refreshes mean your team can trust the numbers they're seeing and act on them faster. --- ## Track AI Usage Against Your Plan **Category:** New Feature **Published:** Aug 10, 2026 at 03:34 PM AI-powered features are now folded into your Analysis Limits, giving you full visibility into how your team is using Albie and other AI tools across the platform. This means no more surprises at renewal time β€” you can plan capacity, monitor consumption, and make informed decisions about scaling your AI usage with confidence. --- ## Filter Dashboard Widgets on the Fly **Category:** New Feature **Published:** Aug 10, 2026 at 03:34 PM You can now apply filters directly within the widget viewer to drill into the exact data you need without leaving your dashboard. Spend less time hunting through reports and more time answering questions β€” filter, compare, and explore metrics in seconds. --- ## Widget Groups Now Load Reliably **Category:** Fix **Published:** Aug 05, 2026 at 06:15 PM We've resolved an issue that was affecting widget groups in the dashboard and service account setup screens, ensuring they now load and behave consistently every time. This means fewer interruptions when adding templates or configuring service accounts, so your team can move through setup workflows without hitting unexpected snags. --- ## Saved Filters Can Now Auto-Populate from Any Column **Category:** New Feature **Published:** Aug 04, 2026 at 10:05 PM Saved filters now let you pick any column to filter on β€” like Donor State or Refcode or Fundraising Team β€” and leave the values blank. The filter will automatically pull every distinct value from that column into a ready-made dropdown, so you don't have to type out each option by hand. Why it matters: setting up a new filter used to mean knowing every value in advance. Now you just point the filter at a column, and it builds the option list for you β€” accurate to your actual data, and instantly ready to use on the dashboard. - Change filter values without leaving the dashboard - Cached results for faster response times - Shared state across dashboard widgets --- ## See Team Activity at a Glance **Category:** New Feature **Published:** Aug 04, 2026 at 10:05 PM The new Settings Activity Dashboard gives admins a visual breakdown of who's doing what across the platform, with a doughnut chart summary and an "Other" grouping for less frequent actions. Why it matters: quickly spot adoption gaps, identify power users, and understand how your team is actually using Optakit β€” no more guessing where to focus training or license investments. --- ## New in Sources: Write Custom SQL on Any Source, with Albie AI Assistance **Category:** New Feature **Published:** Aug 04, 2026 at 10:05 PM You can now write custom SQL directly against any of your sources β€” no more exporting data or bouncing between external tools to prototype a query. Preview results instantly, and when you're not sure how to write the SQL yourself, ask Albie to draft it or adjust your existing query in plain English. Why it matters: this puts ad hoc analysis and one-off data pulls in reach for anyone, not just SQL-fluent analysts. Albie handles the syntax, so your team spends less time debugging queries and more time getting answers. --- ## Introducing the Data Kitchen: Combine and Standardize Data Sources with 'Recipes' **Category:** New Feature **Published:** Aug 04, 2026 at 10:05 PM Data Kitchen is a new data transformation layer that turns raw provider data into analytics-ready datasets using reusable "recipes". Combine tables, standardize schemas across providers, or blend two systems into one β€” like unifying Meta, Google, and GA4 into a single ad performance source, or joining ActBlue with your CRM to see donation data alongside supporter stats. Why it matters: instead of writing custom SQL for data source, your team can now standardize how data is combined, joined, and mapped β€” cutting hours of prep work and reducing the risk of inconsistent metrics across dashboards. --- ## Health Checks and Uptime Monitoring **Category:** New Feature **Published:** Aug 04, 2026 at 10:05 PM We've added dedicated health check endpoints and uptime monitoring across the platform so issues are detected the moment they occur. Why it matters: faster detection means faster resolution. Your team gets a more reliable experience and clearer visibility into system status when things do go wrong. --- ## Faster, More Reliable Platform with Nuxt 4 **Category:** Improvement **Published:** Aug 04, 2026 at 10:05 PM Optakit has been upgraded to Nuxt 4, bringing improved performance, better stability, and a stronger foundation for upcoming features. Why it matters: pages load faster and behave more predictably, which means less waiting and fewer surprises when you're deep in analysis. --- ## Introducing the Custom SQL Editor **Category:** New Feature **Published:** Jul 27, 2026 at 01:08 AM Advanced technical users can now query and fully customize data sources by writing their own SQL directly in Optakit. Shape data exactly the way your team needs it β€” no workarounds, no waiting on engineering. Available within Query Data and as a Source Type, Custom SQL unlocks flexibility for advanced use cases while keeping everything secure and auditable. - Write and save custom SQL queries as reusable sources - AI-assisted query drafting to help you get started faster - Built-in processing limits and additional security safeguards - Full activity logging so every change is tracked --- ## A Faster, More Reliable Dashboard **Category:** Improvement **Published:** Jul 27, 2026 at 01:08 AM We've migrated the Dashboard to run on backend calls, which means quicker load times, more consistent data, and a smoother experience across the board. You shouldn't notice anything different day-to-day β€” except that everything just feels a little snappier. --- ## Build Your Own Database (Available for Tier 3 and Enterprise Clients) **Category:** New Feature **Published:** Jul 27, 2026 at 01:08 AM Tier 3 and Enterprise clients can now create their own custom database across all their sources. Start pulling data and insights directly from all your sources combined, or only select the tables that are relevant to you. With improved validation and flexible configuration, creating a custom database is faster and more powerful than ever. --- ## Connect Multiple Scale to Win Accounts **Category:** New Feature **Published:** Jul 27, 2026 at 01:08 AM Teams running programs across multiple Scale to Win accounts can now connect all of them to Optakit at the same time. Pull data from every account into one place without juggling logins or losing context between programs. --- ## Switchboard Source Improvements **Category:** Improvement **Published:** Jul 22, 2026 at 12:07 AM Switchboard sources β€” including email messages, SMS messages, and webhooks β€” have been updated with clearer labeling, including a new 'processing intensive' indicator for heavier sources. Why it matters: knowing which sources take longer to process helps you plan syncs and set expectations, so nothing feels stuck or unexpected. --- ## See Groups Directly Inside Albie Analysis **Category:** New Feature **Published:** Jul 22, 2026 at 12:07 AM Albie Analysis now includes a dedicated Show Groups component, so you can view group breakdowns without leaving the analysis view. Why it matters: keeping group context alongside your analysis eliminates extra clicks and helps you spot patterns across segments faster. --- ## More Reliable Data Transfers and Source Setups **Category:** Improvement **Published:** Jul 16, 2026 at 05:08 PM We've tightened up several data source and pipeline integrations so your connections behave more predictably from setup through ingestion. - Data Transfer Service (DTS) backfills and pipeline processing controls now run more consistently across tenants. - Scale to Win source setup requests have been polished for a smoother onboarding experience. - Yahoo report ingestion is more resilient, with fixes to legacy product key handling and the generic webhook receiver. - Updated documentation for pipelines and the backend API to reflect these changes. Why it matters: Fewer failed setups and retries means your data lands where it should the first time, saving your team hours of debugging. --- ## Safer, More Accurate Albie Analysis Queries **Category:** Improvement **Published:** Jul 09, 2026 at 11:01 PM Albie's analysis engine now applies stricter validation on filters and SQL inputs, including tighter handling of boolean values. Why it matters: Fewer ambiguous or malformed queries slip through, which means fewer surprising results and more trustworthy answers when your team asks Albie for insights. --- ## Safer Concurrent Widget Updates **Category:** Improvement **Published:** Jul 08, 2026 at 10:58 PM Widget updates now use document-level locking to prevent conflicting overwrites when multiple users attempt to update the same widget at once. That translates to fewer corrupted states and lost updates, so dashboards stay consistent even under heavy refresh activity. --- ## Published Tool Schemas for Easier Integration **Category:** New Feature **Published:** Jul 08, 2026 at 10:58 PM Published tools now expose clear schemas for projections, query data, and list tracking, making it easier for developers and downstream consumers to understand exactly what data shape to expect. This means faster integrations, fewer guessing games in the API, and more confidence when building on top of Optakit tools. --- ## Connect Google Analytics 4 as a Data Source **Category:** New Feature **Published:** Jul 08, 2026 at 10:58 PM Bring your Google Analytics 4 data directly into Optakit and blend it with the rest of your marketing and business data β€” no more juggling exports or building custom pipelines. Unlock a unified view of audiences, demographics, e-commerce activity, and traffic behavior alongside your other sources, so reporting and analysis happen in one place. - Pre-built models for audiences, demographic details, and e-commerce purchases - Automatic ingestion into your existing warehouse - Ready to use across dashboards, queries, and published tools --- ## Safer Tenant Data Isolation **Category:** Improvement **Published:** Jul 08, 2026 at 10:58 PM We've hardened how tenant service accounts are provisioned in BigQuery, adding stricter roles and additional safeguards around dataset creation and list tracking temp tables. The result is stronger separation between tenant data and less risk of cross-environment leakage β€” security improvements that happen quietly in the background. --- ## More Reliable Campaign Deputy Backfills **Category:** Improvement **Published:** Jul 08, 2026 at 10:58 PM Campaign Deputy backfills now handle edge cases more gracefully, reducing failed runs and manual retries when pulling historical data. You get more complete campaign history with fewer interruptions, so downstream reports stay accurate without operator intervention. --- Page 1 of 3 Next page: /en/23729224-2af5-11f1-bde7-369ca3aa310f?markdown=true&page=2