Data Lakes Daily

Amazon Vendor Central — Selling Partner API Amazon released a new Vendor Central API within the Selling Partner API (SP-API). Sellers have had API access under the MWS umbrella for years. Amazon released a new version of the Amazon Marketplace Web Service (MWS) called the Selling Partner API (SP-API). However, vendors have had a more complex journey for programmatic access to Amazon. Unlike the old MWS system, the new API now supports Amazon Vendors, the same as Sellers!😊 API: Vendor Central vs. Seller Central Vendors and Sellers are two distinct models within the Amazon ecosystem. Seller Central accounts are generally open to all merchants to use the platform to sell directly to customers. Those participating in this market are referred to as 3rd party sellers or “3P”. Unlike Amazon sellers (3P), access to Amazon Vendor Central is an invite only program. Without an invitation from Amazon, you can not participate in Vendor Central. Amazon Vendors have ...

Code-free Amazon Seller Central API for products, competitors, and fees data Amazon Sellers are looking for advanced reporting and analysis for Amazon product research, Amazon sales rank, or competitive advantage. It is not uncommon for sellers wanting to see how sales rankings change over time based on Amazon PPC spend or competitive pressure their listings. Unfortunately, the data and reporting interfaces provided by many 3rd-party tools are not enough. While these tools provide basic, top-level performance metrics, the built-in reporting can be complicated, underwhelming, or missing data. Go faster than basic Amazon Seller Central monthly reports Amazon Sellers attempt to graduate from these 3rd-party tools by downloading daily spreadsheets for use within Excel or Google Sheets. Unfortunately, the daily downloads are a manual task and do not provide comprehensive coverage of critical seller data. Also, data quality suffers due to any manual manipulation and proce...

Remote Fulfillment with FBA creates new sales opportunities to Canada and Mexico for US sellers Are you currently a seller in the US, but have hesitated to expand to Canada and Mexico, given the complexity involved? Amazon has simplified cross-border selling with a new Remote Fulfillment by Amazon (FBA) program. The new Remote Fulfillment with FBA program removes barriers and complexity, allowing you to fulfill orders in Canada and Mexico with your US FBA inventory. The new remote fulfillment solution saves you the extra work and hassle of managing multi-country inventory, cross-border logistics, and import duties. After you create offers in Canada and Mexico, Amazon will also make them Prime-eligible and fulfill orders to customers in those countries. How does the FBA program work? Amazon has made the process straightforward for US sellers; Any offer you create on Amazon.ca, or Amazon.com.mx automatically pulls from your US inventory, unless the item is...

Amazon recently released a collection of updates for its Sponsored Brands Video and Amazon Attribution. The updates will continue to create new opportunities to streamline operations and deliver automation for insights efforts. Sponsored Brands video available in the US, United Kingdom, and Germany Amazon has released Sponsored Brands video to vendors and sellers registered in the Amazon Brand Registry in the United States, United Kingdom, and Germany. Sponsored Brands video allows you to upload video creative, create and manage video campaigns, access reporting, stand out on desktop and mobile shopping pages, and help customers discover your brand and products as they shop on Amazon. Ads are keyword targeted, cost-per-click, and link customers directly to the product detail page where they can learn more and purchase. Spend less time on manual operations, and more time focusing on what matters — reviewing insights, identifying trends, and creating optimization strat...

How to create Azure Data Lake Storage Gen2 destinations Three simple steps show you how to create Azure Data Lake Storage Gen2 data destinations for insights and analytics Configuring an Azure Data Lake destination is quick and easy. In this post, we walk you through the steps to get a data lake configured in your Azure account. This guide assumes you have an Azure account and understand why a data lake is a good fit for your use case. If you ask yourself, “ what is a data lake ?” or struggling with a “ data lake vs. data warehouse ” question, check out those links. Ready to get started? Let’s go… Three Steps To Setting Up Azure Three primary steps align to specific resources within Azure; A Gen 2 storage account, a data lake container, and access credentials within Azure. These three elements are needed by other systems to establish a connection to your Azure Data Lake destination securely: Storage Account Name Container Name Connection strin...

Amazon Attribution beta delivers critical third-party media performance & optimization data The Amazon Advertising API has been updated to deliver direct Amazon Attribution performance data for reporting, insights, and optimization efforts. With the latest changes, Amazon delivers data critical for sellers undertaking cross-channel paid media campaigns across non-Amazon platforms (i.e. Google Ads, Facebook, Microsoft Ads). The new API data feeds include conversion metrics, such as detail page views, add to carts, and sales, available for third-party campaigns that link to Amazon. What is Amazon Attribution? Amazon Attribution provides insight into how brands’ non-Amazon marketing channels impact sales performance on Amazon. For example, how are Google Ads vs Facebook Ads performing? Is Google driving more visits, but Facebook delivers more sales? How to use Amazon Attribution Understanding how non-Amazon media impacts sales on Amazon helps sellers optimize sales ...

5 Tips To Drive Innovation With Google, AWS, Or Azure Data Lake A data lake case study: Start small, go for agile cloud data lakes Getting started with data lakes can be confusing for newcomers. They are met with contradictions, false comparisons of data lake vs. data warehouse , and overwhelming technical jargon. It does not have to be this way. Done well, a modern data lake platform can deliver tremendous value to your team and company. Taking an agile, lightweight approach will reduce technical debt while accelerating an enterprise’s understanding of how a data lake can improve the accessibility for the consumption of data by analysts. In this post, we outline an approach to get started quickly with a pilot or PoC that applies to a Google, AWS, or Azure Data Lake. Data lake trends and best practices Getting your feet wet in a lake can be done in the context of quick, low-risk, disposable data lake pilot or proof-of-concept (POC). Here are a few tips as you...

The new Amazon SP-API automates delivers updated approach for automated operations, analytics, and seller insights Amazon has released the next-generation version of the Amazon Marketplace Web Service (Amazon MWS) called the Selling Partner API (SP-API). The Selling Partner API is a REST-based system to access their data on listings programmatically, orders, payments, reports, etc. Like MWS did, the new API allows sellers the ability to automate access to data for selling efficiency, automate manual processing, discovers insights as to when customers may be more likely to purchase, optimize ad spend, inform inventory management decisions, target special offers, and promotions. Why the change from Amazon MWS to the Selling Partner API? The new SP-API reflects a modernization of MWS APIs. MWS has been offering programmatic access to Amazon for more than ten years, but the technology reflected that age. While MWS has performed well, the update to a modern approach will be a...

Defining data lakes in terms of velocity, agility, and openness, delivers successful business outcomes Data lake definitions can take many shapes, largely because different vendors promote definitions that align with product offerings. Given that there can be many different definitions, there can be confusion when people attempt to ask “ what is a data lake ?” Building a background definition it helps build a common vocabulary around what can be overly technical, abstract, and vendor-driven conversations. Define “Data Lake” Rather than rely on an AWS, Google, or Azure data lake definition, here are a few essentials to set some baselines. Pentaho co-founder and CTO, James Dixon framed it this way; This situation is similar to the way that old school business intelligence and analytic applications were built. End users listed out the questions they want to ask of the data, the attributes necessary to answer those questions were skimmed from the data stream, and bulk l...

Here come the SQL query engines! AWS added query services to Redshift with Spectrum which enabled users to query an S3 data lake. However, with the latest federated query updates, AWS is bringing Amazon Redshift in line with competitive query service offerings from not only Google and Microsoft, but other AWS services too. What are federated queries? Facebook PrestoDB popularized the concept of distributed SQL query engines when it open-sourced the project back in 2013. Over the past couple of years, AWS, Google, Microsoft, and many others in the industry have accelerated the adoption of a distributed query engine model within their products. For example, AWS developed Amazon Athena on top of the Presto code base. Here is how PrestoDB describes what is allows users to do: Presto allows querying data where it lives, including Hive, Cassandra, relational databases or even proprietary data stores. A single Presto query can combine data from multiple sourc...

BigQuery’s distributed query engine extends support for multi-cloud data lakes Google Cloud released BigQuery Omni, a service that provides a federated query engine that can query the contents of data lakes on AWS and Azure. Unlike query engine offerings from AWS or Azure, the BigQuery Omni service fully embraces multi-cloud with a serverless SQL query engine than can execute queries across different cloud data lakes. If you are asking yourself “ What is a data lake ?” we cover the architecture, value, and best practices on our site. The first release focuses on Amazon Web Services while a subsequent release supports Azure. BigQuery Omni, Anthos & Dremel Rather than run the full-stack of BigQuery resources in Google Cloud, Google “localizes” its Dremel engine compute resources to the AWS or Azure cloud it is running on. Doing solves a few technical hurdles, but also some significant cost implications. For example, let’s say that Google said that data...

The use of video by Amazon sellers can have a significant impact on product sales. Kissmetrics reported visitors are 64–85% more likely to buy a product on an online retail site after watching a video. While Amazon Sellers can include video content as part of their listings, they can also use video in paid advertising. Why paid video ads? Extending the reach of your content can amplify the impact video can have on sales growth. If you want to extend the reach of your video content, you can leverage Amazon Video Ads to give your content a boost. What are Amazon Video Ads? Amazon Sponsored Video Ads allow advertisers to reach Amazon customers with targeted videos on Amazon’s sites, apps, and Fire tablets. Amazon offers a number of placement options to boost video views and engagement; Home Page — Desktop — 300 x 250 Home Page — Smartphones (Below the Fold) — 300 x 250 Home Page — Tablet Shopping App — 300 x 250 Detail Page — Smartphones — 414 x...

Code-free, fully-automated data feeds from the Amazon Advertising DSP API to turbocharge advertiser performance insights Amazon Advertising DSP is a demand-side platform that allows advertisers to buy display, video, and audio ads on and off Amazon at scale. Advertisers can programmatically reach audiences across the web on both Amazon sites and apps using Amazon’s demand-side platform (DSP). In addition to Amazon properties, the platform supports a collection of publishing partners and third-party exchanges. If you are unfamiliar with the Amazon service you can learn more about it here: Amazon DSP (Demand Side Platform) So how are high-performing advertisers using Amazon DSP to drive performance insights and optimization? By taking advantage of an essential resource available to them,  data . This data includes information on audiences, campaigns, costs, creatives, placements, and many others critical for helping teams understand what drives performance to optimiz...

Modern data ingestion automation allows organizations innovate and stop wasting investments in outdated technologies & manual processes Businesses use all sorts of systems to communicate, engage, manage, and delight customers. These systems reflect platforms for email, social, loyalty, advertising, mobile, web, and a host of others. Guess what these systems generate a lot of? A critical business asset,  data . The Economist proclaimed that data is now “the world’s most valuable asset” . Harvard Business Review reported that 80% of an analysts’ time is spent just preparing data for reporting . The NY Times also reported that data “Janitor Work” is a crucial hurdle to insights outcomes. When this data is hidden and locked in these systems it clogs operations, block insights, and cripples informed decision making. Smart, effective use of data can be a competitive advantage for a business. Don’t feel like you are alone in this data struggle to use data for competi...