Showing posts with label online-to-offline. Show all posts
Showing posts with label online-to-offline. Show all posts

Sunday, June 30, 2019

Can't Blame Amazon Completely for Barnes & Noble's Downfall

As 2 suitors, Elliott Management and Readerlink, possibly fight over Barnes & Noble, the beleaguered bookseller, I can see why the chain is dying and the hard work cut out for its new owner.

The media always blames Amazon.com for B&N's misfortunes. But I found out first-hand that it's also B&N's own doing. In fact, smaller independent bookstores have seen a resurgence, despite B&N's demise.

Recently, I was looking for a Funko Pop gift online and found it at BN.com. Better yet, it was 25% off according to its website. I didn't have time to have it shipped so I went to a nearby store and didn't see the need to buy online and pickup in store because I wanted to see it live first.

At the store, there were 100s of Funko Pops across 4 large display shelves, stacked at least 2 boxes deep! Of all the stores, this B&N had the most Funko Pops I've ever seen. Normally, such a large selection is great. But not today. I tried to ask a worker to help me find the one I wanted, but I had no luck in tracking someone down nearby. I eventually found it myself.

Now all I had to do was pay for it. Easy, right? Sadly, no. B&N makes it really hard to checkout when a customer is ready to actually buy!

First, I couldn't find anyone at either of the 2 Cashier stations. So I walked over to the Customer Service counter and a worker there tries to explain to me that it is "normal" for no one to be at one of the counters because the workers are on the floor. Then why is there a Cashier sign to direct customers to go there and pay if you don't expect a worker to man that station? As for the second counter, she pointed back towards the Cashier counter and said a guy was walking over there now. No apologies at all during this whole exchange and she made me feel like it was my fault for even asking her where is a cashier so I can pay.

So I walk over to the Cashier area, and they had an "Enter Here" sign pointing customers to the far right. But there was no one in line so I thought I'd walk right up to the cashier who saw us coming. He looks at me and nods his head to his left (my right), as if signaling me to follow the sign and queue the long way around to the other end of the cashier counter, only to work my way back down to him...as if B&N ever has long lines or a stampede of customers these days.

When I finally reached the cashier, I told him that the $39.99 price on the box was higher (48% to be exact) than what I saw on their website. I showed him on my mobile phone the price on BN.com (see below).

BN.com product page


BN.com shopping cart - sales price ($26.99)
B&N in-store price on box ($39.99)
He said no problem. He can price match. Great! But wait, there's more! He said he could only match the $29.99 price. But online, as shown above, BN.com had another 10% off with promo code SUNSHINE. So the price before taxes was $26.99.

He said he "had no way of price matching AND applying a discount." Why is that even 2 different things in his mind? If he's going to ring up any price into the register to price match, why not entire the $26.99 amount instead of $29.99?

Frustrated by the whole experience so far, I just accepted the $29.99 price to get out of there. I can't believe how complicated their price match policy was. And it's not like I was asking him to match a COMPETITOR'S offer. This was their own website for crying out loud!

I guess it's not entirely the workers' fault for the horrible in-store experience. When business is dying, I guess B&N is not used to customers actually buying something in their stores!

TIP: If you ever see something on sale on BN.com that you must get that day, you should always buy online and pick up in store, instead of assuming you can easily walk in to buy it!

Ultimately, successful retailers today have to offer consumers a compelling reason to go into a physical store and when consumers show up, retailers have to offer helpful customer service and a consistent omni-channel experience, especially when it comes to price. Is that too much to ask?

#FAIL for Barnes & Noble.

##

Tuesday, May 14, 2019

Google Marketing Live Day 1 Takeaways

Ok, it's late. I just finished watching the Golden State Warriors destroy the Portland Trail Blazers in Game 1 of the NBA Western Conference playoffs. My mind is still racing from attending today's Google Marketing Live 2019 event. And while my fellow GML attendees enjoy a free concert tonight with Katy Perry, here I am writing about my takeaways from today's product announcements for you, my readers. =)


Google's main themes were focused on:

  • Be responsible - Gee, I wonder why they led with this? Perhaps because of the consumer backlash around online privacy and the threat from regulators to breakup the online duopoly?
  • Be there - Google plans to reach you across its vast ecosystem 
  • Be useful - Google spoke a lot about personalization, understanding user intent, and predictive analytics 

To that end, a lot of the new ad products further exploit machine learning and AI to automate things from bidding to optimizing placements to even creative development. Google is also expanding ads across more of its properties, even Google Images. I suspect Pinterest's success has inspired Google to try to monetize its Google Images site. And there was lots of talk about using all it knows about users and users intent to anticipate their needs...while protecting user privacy.

If you're an e-commerce retailer, there were some exciting announcements from Google. Here's a few that caught my eye.

DISCOVERY ADS

As a long time Android and Google user, I never noticed the Discover button on the home page of the Google app or Google.com. But apparently lots of people do as Google claims 800 million people use it monthly! So, naturally, Google is going to try to monetize those eye balls and Discovery Ads aim to do that. Discovery Ads are essentially mobile-first native ads that appear in multiple Google properties with feeds: Google home page feed, Youtube home page feed, and Gmail. (Not sure how Discovery Ads in Gmail will conflict with regular Gmail Ad buys though. And I suspect Discovery Ads reporting won't be too transparent with reporting by placement like with Google Smart Shopping. We're just asked to trust the black box algorithm to automate things for us.)

SHOWCASE SHOPPING ADS EXPANSION

These large, visual ads have been around for a few years and drive user engagement on mobile. I've seen success with these with my retail clients. So when Google announced Showcase Shopping Ads will expand to Google Images, Discover feed, and YouTube feed, lots of people got excited naturally.

MOBILE APP DEEPLINKING FROM ADS

It's frustrating when my mobile ads drive users to my mobile web site, even when my customers have our app downloaded on their phones. So it was huge news when Google announced Search, Shopping and Display campaigns will now link users directly into the mobile app. In its tests, Google saw 2X conversion rate lift. No surprise! Google also announced improved mobile app reporting if you also use Google Analytics for Firebase.

GOOGLE SHOPPING FACELIFT

Google has redesigned the Google Shopping site experience to be more personalized and centered around the customer journey. And it will prominently focus on driving sales for advertisers by encouraging users to either (1) buy directly on an advertiser's e-commerce site, (2) go to a local store, or (3) buy directly on Google leveraging Google Express.

Also, as part of their Shopping Actions Program, this shopping experience will also extend to Google.com, Google Assistant, YouTube, and Google Imagesto  allow users to buy directly from these Google properties!

Alright time to call it a night. Unlike Katy Perry, I am no longer "Wide Awake." If you want to learn more, check out the Google Ads blog.

##


Sunday, November 11, 2018

FIRST PEEK: Amazon 4-Star Store

This week Amazon opened a new 4-Star store (its third one ever) in Berkeley, CA, and I just had to check it out! Readers of my blog know I'm a big Amazon fan =)

The 4-Star store is located on 4th Street, a cute little commercial strip in west Berkeley that includes big retailers, such as Apple Store, Sur la Table, Z Gallerie, as well as local merchants and eateries. The 4-Star store actually replaced a Crate & Barrel Outlet I liked that closed earlier this year.

Amazon 4-Star Store, Berkeley
If you haven't heard of 4-Star stores, it's different than Amazon Go cashierless stores. 4-Star stores are manned by real people and you can check out at a normal register counter. They appear targeted towards consumers who don't want to wait for delivery, have security concerns with packages left at their doorsteps, or just want to physically see and touch a product, so they prefer to buy from a physical store.

Also, as the name implies, all the items are rated 4 stars or higher, as well as items that are new or trending based on what Amazon's website knows about shopping patterns in the surrounding area. A store employee told me inventory will constantly change based on local preferences and sales data. Yay, BIG data!!!

The store stocks hundreds, maybe 1000s, of products, ranging from books, toys & games, kitchen appliances and gadgets, home goods, consumer electronics, and of course, Amazon-branded Echo, Kindle, and Fire TV devices.

Inside Amazon 4-Star Store, Berkeley
I liked a section called Amazon Launchpad that featured products from start-ups. I actually saw the Rocketbook I bought for a friend's gift last year here.

Amazon Launchpad section
I have mixed feelings about the store layout. While it was semi-organized by department with big signage, such as "Devices and Electronics" and "Home and Kitchen," there was also lots of random stuff on tables in the middle of the store. While this created a sense of discovery, much like what has made discount stores like TJ Maxx or Ross popular, at times it felt cluttered and overwhelming.

I was really impressed by the dynamic price tags or "shelf talkers". It makes sense these are dynamic because an item's price and ratings are update regularly and I presume Amazon has to reuse these tags from the revolving inventory of items stocked in the store. The price tags are very easy to read and appear to be based on the same e-ink technology from their Kindle reader.

Dynamic Price Tag (a.k.a. "Shelf Talker")

The price tag often has 2 prices: a "regular" price and a lower price for Amazon Prime members. I was told non-Prime customers can sign up for a free 30-day trial and instantly receive the Prime price in-store.

I thought the bar codes on the left side of the price tags would allow me to scan the bar code with my Amazon mobile app to learn more about the product online, such as product details and actual reviews. But it didn't work when I tried it on a few items. So I don't think that is the intent of these bar codes, but IT SHOULD BE!

As you might expect, you can drop off Amazon returns here for free. But just know that you still have to initiate the return process online first and pick this location as a drop-off location. You can't just walk in like a traditional retail store with your receipt and expect them to process it for you in-store.

It would be cool if the Amazon site or app could check the 4-Star store's inventory and allow for store pickup if it knew I was near this store.  This would be similar to how traditional brick-and-mortar stores, such as Best Buy, Target, and Barnes & Noble, let you order online and pickup at a local store. But when I tried to do this from my Amazon app, it did not even show the new 4-Star store as a location for pickup (see below). Even if it was listed, it's not actually the same customer experience as these traditional retailers who are actually picking the product off the shelf in a specific store by searching its inventory management system. Amazon still says it will be available for pickup at your chosen pickup location in a few days, which makes me think it's still being shipped from its nearby warehouse. So much for instant gratification.

Where is the Amazon 4-Star Store on 4th Street in its App?

Overall, I liked the 4-Star store and can see myself coming back during the holidays for gift ideas because I like how it's curated. Or if I need to pop in for some cable or Amazon Essentials product. And I do like touching and feeling some products before buying. It's convenient especially for playing with the consumer electronics, which aren't just on display, but are actually connected so you can really test them out.

Happy Shopping!!!

##

Thursday, May 24, 2018

[REVIEW] Is Square Marketing's Simple Email CRM Program Right for your Small Business?

Square Marketing launched about 3 years ago as a simple, turnkey email marketing system for small businesses. I've used it and other email marketing applications and wanted to provide a hands-on review about what I like and don't like about Square Marketing.

First of all, keep in mind Square Marketing is an intentionally simple CRM email marketing program for small businesses who don't have the time or knowledge to deal with relationship marketing. But they know it's important. It's not really for prospecting, but more for customer retention, because it is based on email addresses tied to your customer's credit card that Square may already have in its system, even if a customer has never bought from you. That's one of the beauties of this solution. You've got a lot of customer emails without having to spend time asking for it from each customer and slowing things down at the register.

What I Like About Square Marketing

Square Marketing is easy to setup! I love how they have created the most common templates already for welcoming a new customer, lapsed customer, product promotion, newsletter, and events, to name a few.

The biggest advantage of using Square Marketing is its integration with the Square POS register that seamlessly ties customer profile, campaign, and sales transaction data!

First, you get basic email performance overview metrics, like emails sent (a.k.a. Recipients in Square's language), email opens, and unsubscribes. You don't get bounce rates though.

Square Campaign Overview Report

One metric to be careful about with Square reporting is the notion of an "Attributed" sale or purchase. Square defines "Attributable Sales" as the total sales generated from customers who made an in-store purchase within 14 days of viewing this campaign, or any customers who redeemed a coupon. This is different than the offer redemption rate because it doesn't mean everyone included in this metric actually redeemed an offer. It's meant in some ways to imply that by simply reaching out to customers via email, you reminded them about your business and that might have influenced their decision to repurchase.

The usefulness of attributed sales depends on how frequent customers shop with you and if you use coupons a lot. For a cafe or coffee shop, where customers may routinely come in several times a month, I think Attributable sales is less relevant. But if you are a shoe retailer where a customer may shop less than a handful of times per year, this may mean your emails kept your business top of mind for customers, even if they didn't redeem an offer.

Now let's look at actual Coupon Performance reporting. I love how Square effortlessly tracks actual redemptions in store by just entering a unique promo code from the email a customer got or you can actually look up the customer's name from the Square POS and select the offer available to that customer. The latter is pretty darn convenient if a customer loses or can't find that email at the time of checkout.

Square Coupon Performance Report
As the above shows, you get daily-level coupon redemption by "source", where source refers to email received (blue line above) or receipt (yellow line above). In my experience, I rarely get customer redemptions from receipts. But it's a nice touch from Square, I guess.

In this report, you also get the true offer redemptions and net sales, not attributable sales like above.

One thing I like to look at is redemptions-to-open rates (RTOR). I normally look at click-to-open rates (CTOR) from email marketing campaigns, but these simple Square emails don't really have a ton of links so Square doesn't even provide any click reporting. So that's why I created my RTOR metric as a way to benchmark across my campaigns.

Areas for Improvement

There are several things I'd like to see in Square Marketing.

Promotion times: I wish you could run promotions for certain days of the week or time of day. For example, you can't run happy hour promos. Or to run weekend promos, you have to send emails out Friday night and have the campaign expire Sun night. Similarly, for weekday promotions, the workaround is to run campaigns Sunday night until Friday.

Customer drill down from redemption report: I wish I could drill down and see who actually opened an email and/or redeemed the offer from a campaign. In the example above, I'd love to click on the 18 redemptions and see a list of the names of the 18 customers. As an owner of the business or the marketer, you may not always be the one who rang up the person, but you'd like to get to know who is actually using your coupons. I don't know why Square doesn't offer this capability since it has this data and does show you such granularity when you pull up a customer record from the Customer menu. Here is a customer profile record:
Buyer Summary from Customer Profile
The top shows any current coupons this user has. Then it has some very useful RFM (Recency, Frequency, Monetary) stats in the Buyer Summary. More on RFM below.

Below that is the historical timeline of activities of the customer. This is where you can see not only when they purchased and the amount spent, but also when the customer received an email, got a coupon, and actually redeemed it. So, if Square can show this from the Customers menu, why does it not let me go directly to this view from the Square Marketing's Campaign reporting section? I also wish they added Email Open to this timeline.
Customer's historical activity

Limited segmentation within Square: In the Customers interface, you can filter your customer directory and create your own custom segments, which is cool! Here is what you can segment by:
Customer Filters for Segmentation in Square
A big Filter miss I think is including the Monetary value or cumulative amount a customer has spent with your business. I could run campaigns for the big spenders or promos to get little spenders to spend more. Square obviously has this data at the customer level because it's in the Buyer Summary above. Why can't we segment on it?!? This prevents you from employing the most common, yet powerful, segmentation out there - RFM (Recency, Frequency, Monetary).

To create a workaround for this RFM shortcoming, you can export your entire customer directory as a .CSV file and pull it into Excel. In addition to some personal contact info, you also get these useful transaction data that serve as the basis for creating RFM segments:

RFM metrics exported from Square
In Excel, I calculated Avg Spend and defined some Low, Mid, and High breakpoints for Recency, Frequency, and Monetary. And proceeded to assign my customer list to 1 of these 27 cells (e.g., High Recency, High Frequency, Low Monetary). BTW, to simplify this, you can also use 8 cells (=2x2x2), using Low and High segments.

Then I hit another snag with Square. There is no easy way to import my segmentation back into Square through the front-end interface. I had to manually sort by name and individually locate each user to assign them to the custom group I created in Square. This makes it very difficult to maintain the RFM segmentation on an ongoing basis so I have to "re-score" the customer database myself manually periodically.

Exporting item category purchased: Since I'm on the subject of the .CSV export, I wish I could export what categories or items customers bought as columns in the export file. Then I could run targeted cross-sell campaigns. For example, if you're a shoe retailer and you know a customer always bought athletic shoes from you, you can cross promote casual walking shoes or dress shoes. Because Square Marketing lets you offer discounts by item category, this is a natural desire for cross-sell campaigns.

User-defined Campaign Names: Square automatically assigns a Campaign Name to each campaign based on your subject line. While that may sound convenient, it's actually quite limiting, especially if you use the same subject line again because it will lead to duplicate Campaign Names. Below is how Square lists all your campaigns chronologically. To better organize my campaigns, I wish it allowed me to edit the Campaign Name. For example, instead of "We miss you! Come back and save 15%", I would call that "Lapsed Test 15% offer." Then my other "We miss you! Come back for a special offer" campaign would be called "Lapsed Test Special offer."

List of all campaigns in Square Marketing

Slow email preview: Before you activate and launch an email campaign, Square lets you preview the email by sending you a test email of how it will actually look. Nice feature! But I have noticed a wide variance in how long it takes to receive the test email. Sometimes over 5 minutes. This is annoying because you'd like to get the preview email instantly so you can then activate the campaign while in their campaign editor tool. Instead, I often have to save what I've done and come back later.

Losing offer details while editing coupon:
Another annoying bug I've found is often I would go in to edit a previously saved offer in a saved draft campaign, and Square loses my existing content and I have to start over. So I take a screenshot of it now before I click the "Click To Activate" button to edit the coupon, just in case.

Editing coupon offer

Better image editing features: For my custom uploaded photos, it would be nice to have some common photo editing features, like crop, brightness, contrast, etc.

No A/B testing: Ok, this request may be for advanced users and not who Square Marketing is targeting with this solution. But it would be nice if Square could randomly split an audience and send 2 slightly different emails to 2 subgroups for A/B testing. Instead, I have to manually test different offers, copy, or images serially by pausing one campaign, duplicating it, editing it slightly, and relaunching it.

Brief Word about List Sizes

List size matters and is actually how Square and other email marketing solutions like Constant Contact price their offerings! Your potential email marketing list depends on your business and the percentage of customers who pay with cash vs. credit card. That's because Square (and any solution) can't capture any customer data from cash transactions without some kind of loyalty program link. So if you have a primarily cash-driven business, your list will be smaller and the potential impact of email marketing campaigns will be likely be lower. For example, a hair salon can have over 80% cash customers, while a restaurant could have 20% cash customers. In this case, there is more opportunities for the restaurant.

Summary

Overall, Square Marketing did a solid job with a K.I.S.S. email marketing solution for small businesses. And despite all the items on my wish list above, if you're not a hard core marketer like me, but wish you could do something with customer emails, this may be right for you, depending on how large your reachable target list is!

##

Monday, March 19, 2018

6 Offline-to-Online Marketing Integration Best Practices

Despite all the doom and gloom in the retail sector, such as the planned liquidation of Toys R Us, some retailers are doing some great things in terms of marketing. While Bed Bath and Beyond (BBBY)'s stock price has fallen by over 33% the past year, its latest in-home mailer offers some great examples of O2O integration across its digital and offline marketing programs.

When I first received their Spring 2018 mailer, it is clear they are migrating to more of a lifestyle brand catalog, like Pottery Barn. It's thicker (84 pages!) and on higher quality paper stock. In the past, it was a few pages and the paper was junk mail-like paper quality.

Spring 2018 in-home catalog


1. MOBILE APP PROMOTION

Open up the first page and BBBY immediately and prominently promotes its mobile app, telling you how you can easily shop the catalog via mobile by just scanning the catalog's front cover with the app's AR scanner.
Mobile app promotion


2. SOCIAL MEDIA PROFILE PROMOTION

Also on the same page, since they're talking mobile, BBBY promotes its Instagram profile. But I'm surprised they did not also promote its Pinterest page, because home decor is so popular!

Cross promotion of BBBY Instragram acount


3. KEYWORD SEARCH CALLS TO ACTION

One of my favorite tactics is their suggestion to enter specific keywords into its website's search bar to see all the same products laid out in its catalog:

Shop the room: Search keyword cues in catalog

Close-up example of keyword: airy living room

If you type "airy living room" on its site, you see the below landing page, which is a great hand-off from the catalog. This is so much easier for consumers than trying to recall a long website URL path to manually enter in a web browser.

My only suggestion for improvement is to make the room photo interactive so if I click on an item I like, it has an anchor link on a hotspot to take me directly to the specific product description rather than scroll through the extremely long landing page with all the products listed below the main photo.

Landing page if you search for "airy living room" on bedbathandbeyond.com
From an analytics perspective, the keyword CTA is great because from your web analytics tools, such as Adobe Analytics that BBBY uses, you can see the exact search volume for each keyword entered to truly gauge how popular this tactic is! Because let's face it, no one in his/her right mind will think of entering "airy living room" without some kind of prompt =)

4. VANITY URLS & TRACKING

Throughout the catalog, BBBY has CTAs to go online using vanity URLs. Near the end, it even has one page that promotes many of its offerings online.

Vanity URLs galore from catalog page!
All these URLs resolve and redirect to longer URLs. For example, bedbathandbeyond.com/yourmove redirects to https://www.bedbathandbeyond.com/store/static/movers.

bedbathandbeyond.com/creditcard-catalog redirects to BBBY's credit card partner Comenity's website: https://c.comenity.net/bedbathandbeyond/pub/apply/Apply.xhtml?cmp=460_print_apply_catalog_201701_001

What is noteworthy here is that Comenity has assigned a unique campaign tracking code to this URL. This gets passed to its Adobe Analytics as a campaign parameter to easily and surgically track the session of a user that came from this ad placement in BBBY's catalog. Perfect! Unfortunately, BBBY does not have these detailed campaign tracking codes in the vanity URLs that drive to its own website for some reason, so that's a big analytics miss.

5. COUPONS TO TRACK IN-STORE PURCHASE

Typical 20% off coupon
As many of you know, BBBY is extremely generous with its distribution of 20% off coupons. This direct mail catalog was no exception. While the retailer thought about weaning itself off of such promotions a few years ago, it hasn't. But I'm glad to see that if you're going to offer a coupon, track the heck out of it! Here's what they are doing that more retailers need to do. BBBY's direct mail coupons have unique bar codes on them for tracking purposes. These are unique based on customers in its CRM system. When a user redeems the coupon in a physical store (or online), this tracking code is captured and BBBY knows you actually bought something in store.

But many retailers stop short of doing something useful with this insight. BBBY sends a personalized email (see below) a few days later to (1) thank you for your recent in-store purchase and (2) ask you to rate the purchase to help populate its user reviews on its website. This is a great example of tying your print, web, email, and CRM marketing campaigns together with a bow!!! All this is done without me ever realizing they matched, on the back-end, my email address from an online order I made once a long time ago to my CRM profile. I didn't have to give my name or email to the cashier in the store. It was all tied to the physical coupon seamlessly!

Thank you email tied to recent purchase
(BTW, if you didn't know, these BBBY coupons never really expire despite the expiration date printed on them.)

6. ACQUISITION INTEGRATION

Last year, BBBY bought Decorist.com, an online interior decorating service that matches a consumer with a designer to design a room together in one's style and budget. The catalog is sprinkled with new Pro Tips throughout from designers on Decorist.com and encourages readers to go to bedbathandbeyond.com/decorist to learn more.

Decorist promotion


In summary, most of this #O2O goodness can be done by any retailer with nominal investment. Marketers just need to be willing to invest in strategic planning and coordinating efforts across departments to do what's best for their brand and customers!

###

Monday, October 23, 2017

How I Became a Data Plumber

The other day I realized that big data, business intelligence, and dashboards may sound sexy in my strategy and analytics world. But all that and the insights they promise is not really possible without the less glamorous work of what I call "data plumbing." Yes, mom, all my years of schooling and work experience has led me to a career as a plumber =) Having a modern plumbing system in place is not only critical for your home, it's also essential for marketing.


Let me share a real life example of one of the many things I do as a Data Plumber. In this example, the role of the Data Plumber is to make sure all the pipes are connected end-to-end for more precise data to flow to improve tracking and optimization.

Here's a common use case: To optimize paid search campaigns, we need keyword level data for offline conversions. This happens a lot for lead gen campaigns where sales are closed offline, especially for B2B clients and B2C clients whose products or services require more hand holding than ordering a book from Amazon to close the deal.

First, I work with the media team to generate and pass a unique click ID to the landing page when a user clicks on an ad. The click ID will provide granular keyword level tracking. That's the first upstream plumbing connection from the search engine to the client's site. This is like getting water from the main line in the street to your house.

Then we need a way to pass the click ID to the client's lead management or CRM system. This is where years of experience talking "tech" with developers and "data fields" with database administrators pays off as I make the business case on why the Marketing Department needs these changes.

I visit the client's CRM team to see if they can create a field for me to house my new incoming click ID from the client's site. In plumbing speak, I need to make sure there is a faucet in the house that can receive the water from the street once I hook up the pipes under the house.

Once that is taken care of, I am off to work with the web development team to pass my click ID at the point of lead generation, usually when a user submits a lead gen or order form on the site. Normally this involves altering the API to the lead management/CRM system to capture the click ID upon form submission. Now we got pipes to allow water to go from the street to the kitchen sink!

But we're not done yet. We need a way to drain the used water back out of the house. I'm back with the DBAs and the CRM team to create a way to send us the data we need via an ETL or dropping a file regularly to a FTP server. We are creating a conversion file that passes every lead and sale with our associated click ID back to the media team's search campaign management system...ideally in real-time (or near real-time) for bid optimization, as well as reporting.

Almost there...so I go back to where I started with the search team. We create a process where they can consume the client's conversion file and match the data back to click ID. What's powerful about all this is you don't just tell the campaign management tool that a keyword led to a sale or not (which is binary), but you can also pass the amount of the sale, product type, and even the customer segment for even more insightful reporting!

Without such plumbing in place, you can optimize at the keyword level on web leads, but not sales. Now, you may find you've been spending a lot of media budget on a keyword that generates a lot of leads, but has either a low sales conversion rate or a higher CPA (cost per acquisition) than you thought because you've been optimizing to CPL (cost per lead). Or perhaps you weren't getting the quality of sales or the right customer or product sold than you thought for some keywords. That's like having hot water enter your house, but only warm, foul-tasting water may be coming out at the tap unbeknownst to you because you just saw water coming out of the tap (assuming everything was working fine), but you never felt the temperature or tasted the water to realize something was wrong.

So, there you have it. Just a day in the life of a Data Plumber. =) Actually, in this case, the above would have taken me weeks, not a day, to setup in partnership with my client, media teams, web dev teams, and CRM/database administrators. But when it's all done, it feels great!

##



Friday, September 22, 2017

Taylor Swift's UPS partnership to promote new Reputation album - WHY!?!?

Spotted a huge picture of Taylor Swift yesterday in the street. Thought it was one of those moving billboard trucks until I realized it was a UPS truck!


First of all, I think it's interesting that UPS is pimping out ad space on its trucks, like a public transit bus. I didn't even realize they had an interest in building out an ad business. Perhaps the fight with FedEx has them looking to expand to other revenue streams. It's not a bad idea for UPS to monetize that huge boring brown space across their fleet of trucks.

Some might say the UPS partnership is a good offline marketing vehicle. It's 100% share of voice. And people don't go to record stores (R.I.P. Tower Records!) anymore and even the Best Buys and Targets of the world aren't really selling many physical albums these days to warrant in-store promotions as users are digitally streaming or downloading music.

But if you're TAYLOR SWIFT, why do you even need to spend money to advertise your new album? She's world famous with reporters, radio DJs, bloggers, and her fans hanging on her every word and ready to buy her latest music!

She's recently released 2 singles, Look What You Made Me Do and Ready For It, from the new Reputation album weeks apart and both are getting lots of air play!

Not only that, but social media was supposed to be the great equalizer for artists to build direct connections to fans. And it certainly has been for Taylor. She has a huge social media fan base:

YouTube (Taylor Swift) - 1.7 MM subscribers
YouTube (Taylor Swift VEVO) - 24 MM subscribers
Twitter - 86 MM followers
Instagram - 103 MM followers

All she has to do is post on her own social media channels and call it a day.


In fact, Tay Tay is already doing it. Her YouTube channel is totally promoting her new album's drop date of Nov 10th:



It's also on the comments of her Look What You Made Me Do video on TaylorSwiftVEVO:


Her other profiles are all promoting it too. In fact, it's a great example of integrated marketing as all the channels have the same Reputation album cover photo and call to action to get her album on Nov 10th. You may recall she caused an Internet frenzy when all her social accounts went dark last month to prep and coordinate all this stuff.

Taylor has always been a very respectable, smart business woman. But I just don't get why she did this UPS deal...

###

Saturday, May 7, 2016

Multi-Channel Retailers Still #FAIL to Manage Channel Conflicts

In today's world of shopping, savvy mobile shoppers and price transparency are the norm. 

There is a lot of talk these days from Target to Best Buy to Wal-Mart to better leverage their physical stores as a competitive advantage against Amazon. They are trying to combat showrooming, which was a big concern about 2 years ago. More and more retailers are putting in place pick-up in-store capabilities, which is a great option for consumers.

However, I have found that some major retailers are still charging different prices (usually higher prices in store) between the online and offline channels, indicating there are still silos in these companies and channel conflicts have not been resolved. 

Exhibit A: Petco. It is not uncommon to find prices online that are lower than their in-store price. In the example below, the aquarium appears to be on sale for $8.99. I lobbed in a mystery shopper call to my local Petco and found out they would charge me $14.99 if I walked in to the store. I asked why is it cheaper online and the store clerk really had no idea and just said that online prices are different than the store. No apologies and no offer to match their own online price! Not even if you are in their loyalty program and shop there all the time! In this case here, if I bought it online, there was a $5.99 shipping charge, which made online 1 cents cheaper than in-store, but that doesn't account for the delayed gratification and gas savings from online shopping.



Exhibit B: Verizon Wireless. Despite being the #1 wireless carrier, Verizon's online, call center, and local retailer channels are often not aligned. Online and the call center tends to offer the same prices and deals. But local retailers sometimes have different offers and can't match their online prices.

There are back-end data issues as well as in-store reps often say they can't see certain customer info that the call center can. No idea why as that seems to be more of a problem a decade ago!

Exhibit C: Best Buy. Best Buy has had a rough few years and is a poster child of how mobile shopping and showrooming really disrupted their business. But they have made bold moves by redesigning their in-store experience and putting in place an aggressive price match policy. I was first shocked to learn they even price match again Amazon! Yes, I said Amazon. On a few occasions, I found a lower price on m.BestBuy.com when I was looking for product reviews while shopping in-store. When I asked a sales associate about the lower price, I was happy to learn they matched their own online sale prices!!! What a novel idea! You hear that, Verizon and Petco? It's a pretty wild concept to match your own prices.

I suspect many retailers have lower prices online (even if they are doing pickup in store) because of the price transparency from online shopping that creates cutthroat pricing strategies (a.k.a. the Amazon effect). Google Shopping and its Product Listing Ads that often show on top of the SERP further exacerbates the pricing transparency problem for retailers.

Despite retailers trying to create a seamless multi-channel experience leveraging their stores better, I am shocked how many still #FAIL.

##

Monday, August 24, 2015

How to Tie Online Search to Offline Sales

Here's a problem that has challenged me for years. You have a lead generation client with a robust paid search campaign. But sales conversion is offline and may have a long purchase consideration cycle. How do you track the impact of your SEM campaign? 

Sure you can use dynamic phone numbers on your landing page that tie to the SEM campaign. Or a lead gen form with a conversion pixel. But what if the prospect walks into a physical location to close the deal? Or returns from another campaign not tied to SEM and you may attribute to last click?

Wouldn't it be great if a lead walked in to your office, branch, or store and said, "Hi. I was searching last Tuesday at 9:54pm on Google and clicked on a paid search ad that took me to your site. Oh and by the way, I used this keyword and after learning about your company and product offering, I'm here today to buy."...Not going to happen! 

Well, I got close to this with a recent test I did for a large financial services client. Since actual sales conversion happens offline with a sales representative, we wanted to know if the prospect might have actually searched beforehand. 

The key was tying an offline record to an online cookie. We worked with a third-party "data onboarder" that specializes in matching offline customer data, say from a brand's CRM database or prospect list, to online cookies. This is typically done by matching name, physical address, and email address. Such online data can be captured when users make an online purchase on sites since this is always entered as a shipping address. Data onboarders will partner with many sites to build a large audience. 

Usually this technique is used to target banner ads to a brand's customer segments once users are onboarded and matched, as the matched cookies are pushed to an ad serving partner. 

But here is where I got a little creative with their technology. I developed a way to sync the cookies between our SEM campaign and the data onboarder's when a user clicked on our paid search ad. 

We were able to match a sample to our CRM database who indeed searched during our campaign. 

Here is some of the cool things we learned: 

  • % of users who searched and clicked to our site that ended up in an offline sale. While you can guesstimate this by taking total sales divided by total SEM clicks in a period, you can't really attribute all those sales to SEM. Also, while you can use dedicated SEM phone numbers or a lead gen form as mentioned above, those are tracking leads. This allows you to track and give credit to SEM higher up in the purchase funnel. 
  • Average and frequency distribution of the time from online search to offline sale. This is based on the timestamp of the SEM click and the date of sale in the CRM tool. From a histogram, we found that X% convert in Y days. While we previously knew the time from lead to sale, this again gave us a peek further upstream from search to sale.
  • What keywords drove sales, as it may not be the same as the clicks or lead converting keywords that you see in search engine reports that don't track offline sales well or at all. 
  • What client segments search and bought. Search is always an anonymous pull tactic. You can't really target search ads at someone like a banner ad. But we were able to learn a little bit more about them. While it is easy to see what segment a lead is after you acquire them, we were able to see what percent of each segment came to the site via SEM. Furthermore, we could see for each segment, what was the likelihood of SEM visitors becoming a sale. 
In the end, while it took a lot of work and ingenuity to set up, this campaign allowed us to see what kind of users SEM drove relative to our segments and what keywords drove more desirable segments to be acquired. 

##

Wednesday, May 14, 2014

Yelp Has a Hard Attribution Problem to Solve

Yesterday, Yelp sent OpenTable's stock dropping when it announced plans to roll out its own free reservation service for restaurants. There are many good business reasons for Yelp to do this to encourage more businesses to work with them. I'm most interested in how this can Yelp tackle its online-to-offline conversion or sales attribution challenge.

Lots of people use Yelp's website or app to find a restaurant. I know, as a consumer, I do and find it indispensable when I travel. But if I was a restaurant owner (and a Yelp target customer), how would I know how effective Yelp is in driving foot traffic or calls to my restaurant, which are my primary KPIs? Back to me as a consumer...I often find something I like and look at the map and go. And when I get to the restaurant, I usually don't mention anything about how Yelp led me to them.

This leaves Yelp dealing with how to measure online-to-offline conversions -- one of the hardest things to do in marketing!

Let's look at Yelp's tracking options.


Page Views: One of first generation online KPIs, page viewings of a business listing is easy to measure by Yelp, but it is really table stakes and insufficient to track conversions, especially if you're trying to convince a business to pay for advertising.

Referrals to business's website: While it's easy for Yelp to track clicks to the business's website, this is only marginally better than tracking page views of the business's profile page. Many don't have a website and if a lot of them have horrible ones that quite frankly are better off with their Yelp page. Also, if your goal isn't e-commerce, then you're not getting any closer to the end goal KPIs.

Phone Calls: Tracking phone calls from a user viewing the business listing would be great and a step closer to conversion. With mobile click-to-call tracking, it's easy to prove to a business the number of calls made from the Yelp listing. However, this is harder to do on a desktop/tablet experience as most people don't click-to-call from these devices. And the typical way to track these phone calls would be to get vanity phone numbers that redirect to the business's actual phone number. But Yelp can't really show a vanity phone number for businesses because that would confuse consumers who use Yelp like the Yellow Pages and expect them to display the actual phone number of the business. Lucky for Yelp, many of its users are using their mobile app instead of the desktop site so phone conversion tracking is likely getting better.

Get Directions or Map Clicks: This is a common KPI used by retailers and is a proxy or leading indicator of user's intent to visit a store. But just because someone wanted to see how far away you are doesn't necessarily mean s/he actually visited your business. So, it's not great.

Check-ins: This is one step better than Directions/Map Clicks because users self-report actually being at your business. Don't know what percent of Yelp users actually check-in to places. I don't. But businesses and Yelp could also incentivize users to check-in more by rewarding users if they do so. I've seen these offers on Yelp in the past. It's a good way to track foot traffic. In the future, iBeacon technology could improve this or the business can recognize you (or your mobile device) when you walk in, but it may also get creepy for consumers if they're not aware of such tracking.

Exclusive Online Offers: This is an old stand by. Create an exclusive offer that is only available from Yelp (it doesn't have to be tied to the check-in idea above) and prospects must physically redeem it at the point of sale. Then you track redemptions and could build a model to estimate the online-offline conversion rate for extrapolation. The cost of the offers would be in the name of research and analytics.

Tell Them You Saw It on Yelp: When all else fails, there's the old school way of tracking offline conversions from TV and radio, tell them you saw it on Yelp! =)

Reservations: So, getting back to yesterday's news, online reservations aligns perfectly to a restaurant's primary KPI. If you make it free, then more businesses will claim their business and use it. That then helps Yelp with their attribution problem. That then helps Yelp convince businesses to spend more on advertising on them.

So, I can totally appreciate their tracking issues and applaud their move to offer free online reservations to improve conversion tracking.

##

Sunday, July 7, 2013

Twitter Jumps on Behavioral Targeting Bandwagon

On Wednesday, Twitter had a blog post about "Experimenting with new ways to tailor ads." They provided the following example:

Let’s say a local florist wants to advertise a Valentine’s Day special on Twitter. They’d prefer to show their ad to flower enthusiasts who frequent their website or subscribe to their newsletter. To get the special offer to those people who are also on Twitter, the shop may share with us a scrambled, unreadable email address (a hash) or browser-related information (a browser cookie ID). We can then match that information to accounts in order to show them a Promoted Tweet with the Valentine’s Day deal.

It is an interesting move by Twitter to engage in behavioral targeting, which is a proven tactic in online advertising. What we're seeing more of in the industry is what data is brought to bear to inform and improve re-targeting.

For example, site re-targeting was huge when it first came out. The idea of being able to serve a "hey, you, come on back and finish that order we know you were looking at on our site the other day" online ad to a cookied  user who had come to your site was fantastic! It still is.

As re-targeting grew, people got more creative with data, especially ways to tie various online data sets via cookies or other means. In Twitter's case, an email address or cookie would be tied to an advertiser's first-party data. I've also worked with brands that hand over their first-party CRM data (email addresses -- which are needed as the primary key to match to another data set -- and key segmentation variables) to a DMP/DSP that attempts to match user's cookies to re-target them across ad networks. In some cases, an intermediary like LiveRamp helps marry the data sets to facilitate this process.

The other targeting trend I am seeing that I think could show promise is 3rd-party data append of offline data to online behavioral data. For a long time, classic direct marketers have appended data from the likes of Experian or Acxiom with their CRM data to learn more about their customers' interests, financial profile, or shopping behavior. The challenge for a long time is with anonymous cookies, how do you tie that to a real person offline. Email was and still is a great primary key as consumers often use a specific legitimate email address for online shopping, signing up for newsletters or contests, etc. and usually keep that email address updated. That led to companies like Rapleaf whose main business is matching users via email addresses.

Then Facebook took it to a new level earlier this year when they announced a partnership with major 3rd-party marketing data companies, such as Epsilon, Acxiom, and Datalogix. Those names sound familiar? With their new self-serve Partner Categories ads, Facebook claimed it was a new way to target ads to more categories of people. For example, a local car dealership can now show ads to people who are likely in the market for a new car who live near their dealership. To date, advertisers have been able to show ads to people based on their expressed interests on Facebook. Now with Partner Categories, they can also show ads to people on Facebook based on the products and brands they buy online or offline. This has the potential to marry tried and true techniques of direct marketers with the power of the social graph!

And then there's FBX -- Facebook Exchange, which allows real-time bidding and behavioral targeting with data from third-party Web sites.

It's too early to tell if all this is working at Facebook. But in one early report of Partner Categories tests run by Facebook partner Social Code using a wonky KPI called "engagement per Like (EPL)" showed promise.

For a data-driven strategist like me, it's fun to get my hands dirty with first-party CRM data, 3rd-party data appends, and these social networks. What an exciting time in the industry!

##

Tuesday, February 28, 2012

United Airlines' Online/Offline Disconnect #FAIL

Yesterday, I received an email from United Airlines with an update on its Mileage Plus program post-merger.


What caught my eye was actually the bottom of the email:


Talk about a broken user experience. The brand emails me, but then the call to action if I wish to respond to the sender is to SNAIL MAIL them in Illinois? Are you kidding me?

I get that email blasts often don't accept email responses. But for pete's sake, they should list a separate contact email like contactus@united.com or inquiries@united.com. Or, a link to a contact us form or their customer service page.

#FAIL

##

Saturday, July 24, 2010

Click-and-mortar shopping -- the way it should be. Kudos, Barnes & Noble!

Today, I wanted to buy a book after dinner as a last minute gift. From my dinner table, I whipped out my Droid and searched on barnesandnoble.com for some ideas. I am usually a very loyal Amazon.com shopper, but in this instance, I couldn't wait for mail delivery.

Within minutes I found a book I wanted. And I noticed an in-store inventory check and pickup option.



Punched in my zip code, got presented a few nearby stores with my book available now, and filled out the "Pick Me Up" pop-up form.



I noticed the checkbox for a text message when the reservation is complete. So, I figured I'd give it a shot and hit Submit.

I paid my dinner bill and drove 5 minutes to the bookstore. I got a message from Barnes & Noble that my book was set aside while I was in the parking lot. I walked in to a special express pickup area inside the store. I gave the salesperson my last name and she pulled out my book that had my Pick Me Up information attached to it. I was in and out in 2 minutes. Awesome!

This may not seem surprising. And one could argue this is expected in this age of e-commerce. But it's not. This actually worked as expected!

This made me realize that there is hope for brick-and-mortars that master this online-to-offline integrated shopping experience. Or in this case, mobile-to-offline.

This will be the only way to compete against the Amazons of the world.

##