Often when people are starting off writing queries with SQL or via tools like Tableau or Power BI, they are often not very well optimized. Writing well-structured, narrow queries accomplish a few goals.

The first is allowing you to ask questions and get results as quickly as possible. Overly broad queries can take a LONG time to complete.

The second goal is reducing costs. Systems like BigQuery, Snowflake, Amazon Redshift Spectrum and Amazon Athena charge you for the compute resources required to execute your queries. Overly broad queries are much more expensive to run.

For example, let us assume you…


Different partitioning strategies within BigQuery have various pros and cons. A typical strategy for partitioning is by DAY and partitioned on the field _PARTITIONTIME. For context, _PARTITIONTIME is a pseudo column that contains the UTC day that the partitioned data was loaded. In many cases, this is a good default. However, there may be cases where you want to optimize a table beyond Google defaults.

What Tables Should You Optimize?

Like most things, it depends. For example, if you have a high volume of loads for a common data source, using a different strategy can lower query costs. …


Timezones are a confusing topic when it comes to a global marketplace like Amazon. For example, a customer in New York places an order on March 11, 2021, at 1 AM (EST), but it is March 10, 2021, at 10 PM (PST) in Seattle. What when did the order occur? March 11th or March 10th?

Another wrinkle is that Amazon defaults to using a Coordinated Universal Time (UTC) standard in its systems. In our example above, the timestamp of the order would be March 11th, 2021, at 8 AM!

Seller Central User Interface

So, where does a chunk of the confusion arise? Amazon Seller…


How to script a consistent and automated “create warehouse snowflake” environment

Prior to undertaking data loading, Snowflake should be configured with some baselines. In this post, we undertake some “lite” Snowflake data warehouse training using theWORKSHEETfeature. This is an easy-to-understand starting point in anyone’s journey to better learn Snowflake data warehouse setup and operations.

If you are wondering why use Snowflake data warehouse, check out that link for the benefits of the platform. For now, we are assuming you are sold and are ready to give it a try.

Let's get started!

Step 1: Create a Snowflake account

If you do not already have an account, Snowflake offers a free trial. Sign up for an account.

If…


Move e-commerce operations and paid media investments into overdrive with insights-driven strategies fueled by data

A holistic advertising strategy should align with a given platform, competitive landscape, market, search and display ad type. The Amazon Advertising platform offers Sponsored Products, Sponsored Brands, and Sponsored Display for both Seller Central and Vendor Central. These three complementary products allow you to get video ads, search ads, in front of potential customers in a very competitive market.

According to eMarketer, almost 50% of product searches start on Amazon:


Building your eCommerce empire by unlocking Amazon Sponsored Ads performance data

How does a seller or vendor connect with shoppers on Amazon searching for products and brands they offer? Amazon Sponsored Ads in the global Amazon Marketplace.

Amazon Sponsored Advertising is the fast, cost-effective way to reach shoppers online. Amazon offers a wide selection of products in many categories and departments and now gives you an even easier way to reach shoppers based on their expressed interests.

Through advertising, you’ll show your message directly to potential customers in their search results. The Amazon Sponsored Ads audience targeting tools to help you reach the right customers at the right time.

Sponsored Ads…


Unlocking Amazon Seller & Vendor Central advertising automation for efficiency, scale, and growth

Are you stuck with a web-based Ads UI, tired of manually downloading and managing 100s of spreadsheets across your clients? Is this making campaign reporting time-consuming, expensive, and error-prone? If you answered “yes!”, then tapping into the Amazon Advertising API is a must.

The drive for Amazon Advertising optimization

Manual advertising data wrangling of report downloads has a consequence of increasing costs and risky errors. As the number of Advertiser accounts expand, those manual processes become expensive and fragile. A day missed downloading, a file improperly handled, or a folder of spreadsheet exports deleted can toss even the most detail oriented team into chaos.

Enter automation…


Why FBM and FBA seller understanding of financial performance is critical to driving Amazon seller growth and profitability

The Finances API enables Amazon third-party sellers to obtain financial information for their seller central accounts. Sellers can get financial events for a given order or financial data without waiting until a statement closes.

Third-party sellers typically use the data to;

  • gain insights into inventory forecasting
  • create context on how your sales history aligns with profit goals
  • optimization inventory management
  • improving customer service
  • shortening lead times

This is an improvement over waiting for bi-weekly Settlement Reports. As a result, the Finance API gives sellers increased access, velocity, and transparency for mission-critical financial data.

What is finance data available to Third-Party Sellers, Agencies, or FBA acquirers?

So you want data from the Finances…


Image by Thomas Spicer

Why “data lakes are dead” talk contributes little modern data architecture conversations

Last year in a post about data lakes, we covered various “FUD” around lake architecture, strategy, and analytics. Fast forward a year; it seems that data lakes are now definitively considered a “legacy” data architecture.

During the Modern Data Stack Conference 2020 they stated data lakes have no place in a modern data architecture:

“In my opinion, data lakes are not part of the modern data stack. Data lakes are legacy,” Fraser said. “There are organizational [and] quasi-political reasons why people adopt data lakes. But there are no longer technical reasons for adopting data lakes.”

Indeed this is controversial, likely…


Sailthru delivers personalized customers’ experiences across email, web, and mobile. Data resident in your Sailthru account contains rich insights into interactions users are having with these customized experiences.

Your Sailthru data is part of a puzzle that allows you the ability to understand the customer journey. The better you can understand this journey, the greater your opportunities to unlock insights to deepen customer engagement.

What is Sailthru Connect?

The Sailthru Connect service provides the data needed to fuel the insights backbone to the customer journey. If you are a Sailthru customer looking for data insights automation, Sailthru Connect is key to accomplishing that goal.

Thomas Spicer

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store