Framebridge

Framebridge makes Looker the “engine of everything”

Google Cloud results
  • Data refresh speed reduced from 4–5 hours to less than 15 minutes

  • Data-driven decisions for 45 stores nationwide

  • 100% of metric changes tracked using GitHub

  • BI team bandwidth shifted from reactive tasks to strategic projects

Framebridge transformed its data stack by implementing Looker, solving legacy challenges, enabling speed and data governance, and empowering self-service.

Picturing a better data platform

Framebridge has a simple yet ambitious mission: to democratize custom framing. Customers can easily upload photos online to their website or bring objects into retail stores for framing, where they can choose from over 100 curated moldings. Partnerships with design brands like Farrow & Ball have expanded Framebridge’s offerings, creating color-drenched collections that blend art and design. What began as an online-first company quickly expanded into retail, with 45 stores across the United States.

As the company scaled, so did its data needs, and the limitations of its legacy infrastructure became impossible to ignore. Framebridge relied on outdated ETLs in Redshift and a BI tool that couldn’t handle the company’s growing data volume. Engineering capacity was limited, leaving broken pipelines and inconsistent reporting. “We were having to wait upwards of four or five hours to get fresh data. Our old BI platform was black-boxy — three different ‘order files’ all had conflicting information. It was unsustainable,” says Libby Ellison, Director of Business Intelligence at Framebridge.

Looker’s governed LookML layer, GitHub integration, and specific access controls were a huge step up that competitors didn’t have.

Libby Ellison

Director of Business Intelligence, Framebridge

Frambridge struggled with slow data refreshes, which sometimes took 4–5 hours for sales and manufacturing updates. Additionally, Shopify data tables were too large for the old system, and a lack of data governance resulted in conflicting metrics.

Streamlining data operations with Looker

Looker is the engine of everything for Framebridge.

Libby Ellison

Director of Business Intelligence, Framebridge

Framebridge ran a full RFP across six BI platforms and ultimately selected Looker. “My biggest things were speed, accessibility, and reliability. Looker’s governed LookML layer, GitHub integration, and specific access controls were a huge step up that competitors didn’t have,” Ellison says.

Framebridge worked on the migration with Bytecode, a Google Cloud partner, to ensure best practices and sustainable implementation.

“Bytecode was invaluable. They helped us with tricky join questions, schedule timing, and maximizing refresh speeds. Their documentation meant we could fix changes in under an hour,” Ellison says.

Framebridge now uses Looker for all internal business functions across its operations, feeding data from multiple sources such as marketing platforms for attribution, custom platforms, third-party data, and Shopify data into Looker. “Looker is the engine of everything for Framebridge,” Ellison says. The tool integrates with the company’s existing stack, which includes BigQuery.

Employees got up to speed on Looker quickly thanks to training facilitated by Bytecode, which involved developer sessions led by a Bytecode expert to teach LookML best practices.

Transforming BI with speed, visibility, and governance

The migration to Looker brought immediate operational benefits to Framebridge. Data latency was reduced from 4–5 hours to under 15 minutes, and plant managers and executives now rely on real-time dashboards across 45 stores to make daily decisions. “Our head of operations sent me a picture of his data room — TV monitors with Looker dashboards auto-refreshing. That’s something we could never have before,” says Ellison.

Data governance and accuracy have improved because Looker’s semantic layer ensures consistent definitions across complex product categories and eliminates conflicting definitions across teams. “We sell custom frames, preset frames, tabletops, ornaments. It’s very different to make each of those products,” says Ellison. Accuracy in reporting is super important. Looker’s governance prevents 8,000 table calculations from proliferating unchecked.” The solution’s GitHub integration enables transparent pull requests for metric changes, and controlled access provides specific permissions to prevent uncontrolled sandboxing.

Framebridge also has self-service analytics with Looker in place, allowing teams to pivot data, set up charts, and create alerts independently while freeing the BI team from repetitive requests and focus more on forward-looking initiatives. Says Ellison, “It’s really nice to say, ‘I’m going to look at Q1 projects.’ It’s not how many dashboards I can build — it’s how I integrate new data sources or automate processes. We’re thinking strategically about retail expansion and customer data.”

With these capabilities, Framebridge built a holiday dashboard in less than a day, enabling real-time monitoring during peak season. In addition, the solution’s Shopify integration unlocked sales insights, and the company improved customer service by creating automatic alerts for missed orders.

Looker has also made an impact at the store level. The tool’s intuitive design and mobile app transformed accessibility for store teams, and store associates use Looker every day for customer interactions. A zero-outage launch was achieved through a dedicated testing platform set up by Bytecode, including testing with a store team member using both the old and new tools on separate iPads. “The app on the iPad is one of the most viewed pieces of content. Store associates can type in a customer name and see everything about the order. That’s huge,” says Ellison.

Framing the future

Framebridge sees Looker as critical for sustaining the company’s exponential growth. “Without Looker, it would feel unsustainable. We’re expanding rapidly, and we needed a heavy tool to support our growth,” says Ellison. Future priorities include tabbed dashboards to reduce redundancy and improve usability, on-demand web tests with detailed click-level data, and conversational analytics to enable trusted natural language queries for executives. “Framebridge is such a data-driven company. We can’t afford to get it wrong,” says Ellison. “Looker has enabled us to get it right.”

Framebridge, founded in 2014, is a direct-to-consumer custom framing startup. The company allows customers to upload photos, mail in items, or visit one of the brand's 45 retail locations to frame art, mementos, and photos.

Industry: Retail

Location: North America

Products: Google Cloud, BigQuery, Looker


About Google Cloud partner — Bytecode IO

Bytecode IO is a consulting company focused on helping businesses make the best use of the valuable data they collect. With over a decade of experience helping customers deploy scalable, reliable and cost effective data analysis and business intelligence solutions in the cloud, Bytecode IO has helped hundreds of clients unlock value from their data to deliver business insights.

Google Cloud Partners
  • Bytecode IO
Google Cloud