Tag Archives: Search

“Parasite” searches ride an Oscars wave

It’s been over a week since “Parasite” made history, becoming the first non-English language film to win Best Picture. And people are still talking about (and searching for) it.


Surge in search interest

There was already global interest in “Parasite” before the Oscars (turns out a lot of people could find something to relate to in a dark, funny story about two very different Korean families). Parasite was the third-most-searched Best Picture nominee in the week before the awards ceremony, behind “1917” and “Jojo Rabbit.” 


Parasite map 1

But on the day of the Oscars, there was an 857 percent jump in the number of people searching for “Parasite” around the world, and that interest has continued since. In the week after the awards, it became the most-searched searched film worldwide—117 percent more searched than “1917” and 132 percent more searched than "Jojo Rabbit".

Parasite map 2

Focus on Bong Joon Ho (and his translator)

After being awarded Best Director, Bong Joon Ho won fans around the world with his gracious acceptance speech and promise to “drink until next morning.” Search interest for Bong increased by more than 2,000 percent on the day of the awards, while Korean-language searches for Martin Scorcese surged, too, after Bong quoted one of his lines (“the most personal is the most creative”).


Most queries were about Bong himself, but the fifth-most asked question was “who is Bong Joon Ho’s translator?” (The answer is Sharon Choi, a Korean-American and fellow filmmaker who gained her own following during awards season.)


A boost for Korean cinema

Interest in Korean cinema has been growing steadily over thepast decade—but the success of “Parasite” has sent people scrambling to find out more. Related searches for “Korea” and “film”  have increased by more than 47 percent in the past month and reached their highest peak for 12 months in the week after the Oscars.  


Ram-don fandom

We’ve also seen growing appetite for the Korean noodle dish ram-don (aka Jjapa Guri) which features in “Parasite”. Since the Oscars, searches for “ram-don recipe” have soared by more than 400 percent globally and searches for “Asian supermarket” are up more than 350 percent. Denmark, the United States, Canada, Singapore and Australia are the countries searching the most—suggesting there could be opportunities for enterprising Korean restaurateurs in places from Copenhagen to Canberra.

Source: Search


Importing SA360 WebQuery reports to BigQuery

Context

Search Ads 360 (SA36) is an enterprise-class search campaign management platform used by marketers to manage global ad campaigns across multiple engines. It offers powerful reporting capability through WebQuery reports, API, BiqQuery and Datastudio connectors.

Effective Ad campaign management requires multi-dimensional analysis of campaign data along with customers’ first-party data by building custom reports with dimensions combined from paid-search reports and business data.

Customers’ business data resides in a data-warehouse, which is designed for analysis, insights and reporting. To integrate ads data into the data-warehouse, the usual approach is to bring/ load the campaign data into the warehouse; to achieve this, SA360 offers various options to retrieve paid-search data, each of these methods provide a unique capabilities.

Comparison AreaWebQueryBQ ConnectorDatastudio ConnectorAPI
Technical complexityLow
Medium
Medium
High
Ease of report customizationHigh
Medium
Low
High
Reporting DetailsCompleteLimited
Reports not supported on API are not available
E.g.
Location targets
Remarketing targets
Audience reports
Possible Data WarehouseAny
The report is generic and needs to be loaded into the data-warehouse using DWs custom loading methods.
BigQuery ONLYNoneAny
Comparing these approaches, in terms of technical knowledge required, as well as, supporters data warehousing solution, the easiest one is WebQuery report for which a marketer can build a report by choosing the dimensions/metrics they want on the SA360 User Interface.

BigQuery data-transfer service is limited to importing data in BigQuery and Datastudio connector does not allow retrieving data.

WebQuery offers a simpler and customizable method than other alternatives and also offers more options for the kind of data (vs. BQ transfer service which does not bring Business Data from SA360 to BigQuery). It was originally designed for Microsoft Excel to provide an updatable view of a report. In the era of cloud computing, a need was felt for a tool which would help consume the report and make it available on an analytical platform or a cloud data warehouse like BigQuery.

Solution Approach



This tool showcases how to bridge this gap of bringing SA360 data to a data warehouse, in generic fashion, where the report from SA360 is fetched in XML format and converted it into a CSV file using SAX parsers. This CSV file is then transferred to staging storage to be finally ETLed into the Data Warehouse.

As a concrete example, we chose to showcase a solution with BigQuery as the destination (cloud) data warehouse, though the solution architecture is flexible for any other system.

Conclusion

The tool helps marketers bring advertising data closer to their analytical systems helping them derive better insights. In case you use BigQuery as your Data Warehouse, you can use this tool as-is. You can also adopt by adding components for analytical/data-warehousing systems you use and improve it for the larger community.

To get started, follow our step-by-step guide.
Notable Features of the tool are as following:
  • Modular Authorization module
  • Handle arbitrarily large web-query reports
  • Batch mode to process multiple reports in a single call
  • Can be used as part of ETL workflow (Airflow compatible)
By Anant Damle, Solutions Architect and Meera Youn, Technical Partnership Lead

Searching for love this Valentine’s Day

Love is in the air this week as searches for “love” peak (as they do every year around this time!). Ahead of the most romantic day of the year, we looked at fun Valentine’s Day trends, from romantic comedies and love songs to gift ideas, that will get everyone in the spirit. 

People across the country are searching for love, but these states are feeling extra romantic. They’ve had the most searches for the word “love” since 2004.

  1. Virginia 

  2. Oregon

  3. Mississippi 

  4. Texas

  5. California 

"As if" you needed a reason to post up on the couch, this map will give you 10 things to love about Valentine's Day, with the most-searched rom coms per state. To us, this is perfect.

Most searched romantic comedies

Love songs are a festive way to set the mood for your Valentine’s day sweetheart. We looked at the most-searched love songs since 2004 in the U.S. Trust us, they’ll keep replaying in your head.


  1. “Love Story,” Taylor Swift

  2. “Endless Love,” Diana Ross & Lionel Richie

  3. “Unchained Melody,” The Righteous Brothers

  4. “Amazed,” Lonestar

  5. “My Girl,” The Temptations

If rom-coms and love songs don’t get you in the Valentine’s Day mood, celebrity couples definitely will. Here are the most-searched celebrity couples in the U.S. this year. 


  1. Brad and Jen

  2. William and Kate

  3. Ellen and Portia

  4. Harry and Meghan

  5. Madonna and boyfriend

And if you need some last-minute gift  ideas to say “I love you,” these ones won’t fail—they’re the most-searched gifts this week in the U.S. 


  1. Flowers

  2. Ecards

  3. Teddy bears

  4. Rose bears

  5. Chocolate covered strawberries

This Valentine’s day, celebrate with your favorite rom com, love song, and maybe some chocolate covered strawberries!

Helpful shortcuts for Google apps on iOS

If you have an iPhone or iPad, you might use apps like Gmail, YouTube and the Google app. These apps are specially built to work on iOS phones and tablets, and we’ve recently added Siri Shortcuts so that you can easily access your favorite features on those apps.  With Siri Shortcuts you can simply tap on a suggestion or ask Siri to shortcut the steps to common tasks. Now, to make it easier to find what you’re looking for on the web with the Google app, you can add a Siri Shortcut to “Search with Google.”

How to use "Search with Google" Siri Shortcut

“Search with Google” is the newest of many Shortcuts we’ve recently added to Google iOS apps. If you’re interested in exploring more, check out Drive where we’ve added a Shortcut to “Search in Drive” or YouTube where you can ask Siri to “Search YouTube.” If you regularly write a lot of emails (like we do), you can even add a Siri Shortcut to “Send email” in Gmail

You’ll find all our Shortcuts in the Shortcuts app on your iOS device. Give them a try today.

Source: Search


Lights, camera, red carpet-ready with Search and the Assistant

The silver screen’s big night is right around the corner. Ahead of this year’s Academy Awards, we’re sharing six ways Search and the Assistant can help you stay red carpet ready.

1. Find helpful Oscars info with Search:To keep you updated on the award show, we’re launching a dedicated experience in Search. Starting today, when you search “Oscars 2020” on your phone you can explore the Oscars’ history, including past category winners, and see a full list of this year’s nominees. You can also refresh your memory on the award show careers of your favorite actress or actor. Search their name plus “Oscars” to find out.

If you’re looking for a photo of your favorite star from the red carpet, funny moments or acceptance speeches, you’ll be able to find live images from Getty and video highlights from ABC right on Search. Throughout the show, the list of winners in each category will be updated in Search as well.

Oscars Search Experience.gif

2. Hear from nominees with Cameos: Watch short-form videos from nominees, from film editors to costume designers, when you search “Oscars 2020.” They discuss their craft and answer questions about what it’s like to be up for an Oscar.

3. Find Oscar-nominated films (and where to watch them!):If you need to brush up on the Oscar-nominated films before Sunday’s award show, just search “what to watch.” You’ll see a dedicated category with 2020 Oscar nominees and the platforms you can watch them on. Get ready to binge watch some great movies.

Oscars in What to Watch.png

4. Keep up with the Trends:Leading up to, during, and after the Oscars, you can check out our Google Trends page for the latest questions and trends on your favorite movies, actors, actresses, directors, and more. Here's how the Best Picture nominees are being searched.

Oscars Trends GIF.gif
5. Ask the Google Assistant:Have a question about the Oscars? The Assistant can help you keep you in-the-know as the red carpet rolls out on Sunday. Simply ask: 
  • “Hey Google, when are the Oscars?” 
  • “Hey Google, who’s nominated for Best Actress in a leading role?" 
  • “Hey Google, who’s nominated for Best Picture at the Oscars?” to hear the nominees. You can also follow up with, “Who’s going to win Best Picture?” to learn the Assistant’s prediction.
  • Itching to win an award yourself? 🏆Simply say, “Hey Google, give me an award” and the Assistant will hand out its own custom awards--like Best Actor in a Dialogue with the Google Assistant.

6. See and share the Oscars’ GIF-able moments:Tenor, Google’s visual expression search engine, will be live at the Oscars to capture the event in GIF form. To find and share your favorite red carpet sashay or award speech moment, just search #oscars on Tenor in theGIF Keyboard app or visit theofficial Oscars page on Tenor.

Sunday night will surely be filled with Hollywood glamor. Search and the Assistant are here to keep you up-to-date on all things glitz and gold (trophies).

Source: Search


Gear up for the Big Game with Search and the Assistant

Huddle up, football fans! It’s almost game time. This Sunday, people around the country will gather to watch Kansas City and San Francisco face off in the biggest football game of the year. We took a look at Google Trends data to see the top questions, recipes and topics people are searching for. Fun fact: Search interest in Roman numerals spikes every year at this time (and this year roman numeral LIV is no exception) .


While the teams get ready to go head to head, Search and the Google Assistant can provide  information about Sunday’s showdown, help you prep your game day appetizers, give you fun ideas for your watch party, and keep you updated with the latest plays during the game. Score!

Football fan face-off

Our two conference champions are causing chatter across the U.S. Search interest in both San Francisco 49ers and Kansas City Chiefs have reached an all-time high. What team will you cheer for this Sunday?
Most Searched Teams.png

And football isn’t the only thing we’re excited for. This year’s halftime artists are ready to “Get Right” and put on an amazing show—here are their most-searched songs in the U.S. over the past five years.

Most searched Jennifer Lopez songs

  • I’m Real

  • Get Right

  • Dinero

  • Waiting for Tonight

  • Ain’t Your Mama’

Most searched Shakira songs

  • Waka Waka

  • Try Everything

  • Chantaje

  • Whenever, Wherever

  • She Wolf

For some nostalgia, we took a look at the most-searched halftime performances in the U.S. since 2004. Talk about a top-notch lineup. 

  • Bruno Mars

  • Janet Jackson

  • Maroon 5

  • Lady Gaga

  • Beyonce

Game Day goodies

From white chicken chili to football cookies, this year’s most uniquely-searched game day recipes in each state will have your mouth watering. And with the Google Assistant, you can get step-by-step help cooking on Smart Displays, like Nest Hub Max. Get started by saying, “Hey Google, show me recipes for seven layer dip.”

Food Map.png

Uniquely-searched recipes per state as compared to the U.S.

No matter what team you’re cheering for, yummy food is something we can all agree on. Here are the top five most-searched game day foods since 2004 (buffalo chicken dip is the G.O.A.T. of snacks!).

  • Buffalo chicken dip

  • 7 layer dip

  • Chili

  • Spinach artichoke dip

  • Taco dip

Get in the game with the Assistant

The Assistant can keep you updated on the event or bring more fun to your watch party. Start by asking, “Hey Google …”: 

  • "Watch FOX on YouTube TV” to have your Assistant play the big game on Smart Displays, like Nest Hub Max.

  • “Who do you think will win the big game?” to hear the Assistant’s prediction.

  • “Help me talk like a football fan” for tips to sound like a pro—even if you don’t usually watch football. 

  • “Tell me a football joke” for a few laughs.

  • “Touchdown!” to add to the celebration when your team scores.

No matter what you’re searching for, Search and the Google Assistant can be your game day champion. For the latest on what people are searching for this weekend, see our Google Trends page

Source: Search


Google and the Super Bowl: Here to help

Ten years ago Google aired its first-ever commercial, during the 2010 Super Bowl. We’ve run several more Super Bowl ads in the years since. And on Sunday, viewers of this year’s game will see “Loretta,” which tells the story of a man who uses the Google Assistant to keep the memory of his love alive. 

The ad reflects our goal to build products that help people in their daily lives, in both big and small ways. Sometimes that’s finding a location, sometimes it’s playing a favorite movie, and sometimes it’s using the Google Assistant to remember meaningful details. 

“Loretta” has a few other things in common with our “Parisian Love” commercial from 10 years ago. Both are simple love stories told through the lens of our products. Both were inspired by real people—in fact, the voice you hear throughout “Loretta” is the grandfather of a Googler, whose story we drew from to create the ad. At 85, to an audience of millions, he’ll be making his film debut. We couldn’t be happier for him.

As we look forward to this weekend's game, we’re also releasing “A little help before the Super Bowl,” which celebrates the questions people ask about the game every year, based on Google Trends data. The teams, cities and performers of the Super Bowl change from year to year, but searches about the game remain consistent. Here’s a look at what people are turning to Search to find out about the big day:

A little help before the Super Bowl

From the biggest moments to the everyday questions, and the little things in between—Google always aims to help. Enjoy the game!

The Most Searched: A celebration of Black history makers

Search trends can help us understand what people are interested in and what has endured—the people and events that have captivated our attention over time. 

Last year, as Dr. Martin Luther King, Jr. Day approached, our team had a hunch that his monumental “I Have A Dream Speech” might be the most searched speech in the United States in Google Trends history. It prompted us to analyze 15 years’ worth of U.S. search trends data to find out.

Sure enough, it was.

This revelation was an electrifying moment for our team. It pushed us to explore more aggregate Search trends data to identify other Black icons, events and movements that were the most searched within a specific category or field in the U.S. 

Here’s what we found: Dozens of Black Americans and the historical movements they led were searched more than any other person or event in a category. These range from historical milestones like the Montgomery bus boycott to iconic figures like Maya Angelou to the most searched Pulitzer Prize winner—Kendrick Lamar, for his album DAMN.

That’s why, in celebration of Black History Month, we’re releasing a film tribute to these iconic moments, online and as an ad during the 2020 Grammy Awards. 

“Most Searched” tells a powerful story about how the Black community has helped shape and influence American culture. It also shows the tremendous collective interest in our history.

We're proud to celebrate the people and events in this film, and also hope that it inspires future history makers. In an effort to help build the next generation of Black leaders, scholars, artists and technologists, we’re awarding a $3 million Google.org grant to support the NAACP's Afro-Academic, Cultural, Technological and Scientific Olympics (ACT-SO) program. As part of this, we're connecting Googlers to ACT-SO volunteering opportunities. ACT-SO provides a platform for Black high school students—more than 300,000 to date—to bring their ideas to life and kickstart their journeys to becoming leaders in science, technology, engineering and math (STEM), humanities, business, and the arts. This initiative joins previous commitments to support organizations and programs that help Black and Latino students develop the technical skills they need to succeed in career and life.

To learn more about these individuals and our celebration of Black History Month, visit g.co/blackhistorymonth.

20 years of fashion on Google

At the Grammy Awards twenty years ago, Jennifer Lopez wore a Versace dress on the red carpet which had a ripple effect on fashion -- not to mention, Google -- for years to come. Jennifer’s dress was so popular on Search that it helped inspire the creation of Google Images (then known as Image Search). In honor of this anniversary, we looked at U.S. fashion trends on Search since Google Trends began in 2004 to see how people have used Google over the years for inspiration and style advice.


Jennifer Lopez’s 2000 Grammy Awards appearance may have been the biggest red carpet moment in the show’s history (according to Google Trends), but she wasn’t the only one to make a splash at the event because of what she wore. 


In the Fashion & Style category, these icons saw spikes when they stepped onto the Grammy Awards red carpet over the years:


  1. Jennifer Lopez

  2. Joy Villa

  3. Whoopi Goldberg

  4. Teri Hatcher

  5. Gwyneth Paltrow

  6. Fergie

  7. Beyonce

  8. Queen Latifah

  9. Kate Winslet

  10. Giuliana Rancic


Beyond the red carpet, people have turned to Google to learn more about fashionable celebrities since it was possible to do so. Reality and TV stars dominate the list of the top 10 most-searched stylish celebrities. These are the celebrities whose personal styles topped searches:


  1. Kim Kardashian

  2. Vanessa Hudgens

  3. Jennifer Aniston

  4. Selena Gomez

  5. Rachel Bilson

  6. Jessica Alba

  7. Lauren Conrad

  8. Kourtney Kardashian

  9. Jessica Simpson

  10. Nicole Richie


Celebrities bring fashion to life, but to really learn more about the looks, people turn to designers. In the Fashion Designer & Collection category, these are the designers people searched for most over the years:


  1. Tom Ford

  2. Alexander McQueen

  3. Marc Jacobs

  4. Betsey Johnson

  5. Gianni Versace

  6. Coco Chanel

  7. Diane von Furstenberg

  8. Karl Lagerfeld

  9. Donatella Versace

  10. Vera Wang

blur-close-up-hangers-indoors-1148962.jpg

Since most of us don't have personal designers, people come to Google for practical advice on how to put a look together or make certain outfits work. According to search trends, these are the clothing items in the Apparel category people wanted the most style help with:


  1. how to style boyfriend jeans

  2. how to style overalls

  3. how to style doc martens

  4. how to style a scarf

  5. how to style combat boots

  6. how to style a jean jacket

  7. how to style sweatpants

  8. how to style chelsea boots

  9. how to style a maxi skirt

  10. how to style black jeans


So what styles caught our attention the most? With “vintage,” “retro,” and “classic” atop the list, what’s old is new. These are the most-searched clothing styles overall:


  1. Vintage

  2. Casual

  3. Retro

  4. Classic

  5. Street

  6. Western

  7. Military

  8. Athletic

  9. Business casual

  10. Hipster


If you tune into the show this weekend, who knows? Maybe you’ll discover your next celebrity style icon.


20 years of fashion on Google

At the Grammy Awards twenty years ago, Jennifer Lopez wore a Versace dress on the red carpet which had a ripple effect on fashion -- not to mention, Google -- for years to come. Jennifer’s dress was so popular on Search that it helped inspire the creation of Google Images (then known as Image Search). In honor of this anniversary, we looked at U.S. fashion trends on Search since Google Trends began in 2004 to see how people have used Google over the years for inspiration and style advice.


Jennifer Lopez’s 2000 Grammy Awards appearance may have been the biggest red carpet moment in the show’s history (according to Google Trends), but she wasn’t the only one to make a splash at the event because of what she wore. 


In the Fashion & Style category, these icons saw spikes when they stepped onto the Grammy Awards red carpet over the years:


  1. Jennifer Lopez

  2. Joy Villa

  3. Whoopi Goldberg

  4. Teri Hatcher

  5. Gwyneth Paltrow

  6. Fergie

  7. Beyonce

  8. Queen Latifah

  9. Kate Winslet

  10. Giuliana Rancic


Beyond the red carpet, people have turned to Google to learn more about fashionable celebrities since it was possible to do so. Reality and TV stars dominate the list of the top 10 most-searched stylish celebrities. These are the celebrities whose personal styles topped searches:


  1. Kim Kardashian

  2. Vanessa Hudgens

  3. Jennifer Aniston

  4. Selena Gomez

  5. Rachel Bilson

  6. Jessica Alba

  7. Lauren Conrad

  8. Kourtney Kardashian

  9. Jessica Simpson

  10. Nicole Richie


Celebrities bring fashion to life, but to really learn more about the looks, people turn to designers. In the Fashion Designer & Collection category, these are the designers people searched for most over the years:


  1. Tom Ford

  2. Alexander McQueen

  3. Marc Jacobs

  4. Betsey Johnson

  5. Gianni Versace

  6. Coco Chanel

  7. Diane von Furstenberg

  8. Karl Lagerfeld

  9. Donatella Versace

  10. Vera Wang

blur-close-up-hangers-indoors-1148962.jpg

Since most of us don't have personal designers, people come to Google for practical advice on how to put a look together or make certain outfits work. According to search trends, these are the clothing items in the Apparel category people wanted the most style help with:


  1. how to style boyfriend jeans

  2. how to style overalls

  3. how to style doc martens

  4. how to style a scarf

  5. how to style combat boots

  6. how to style a jean jacket

  7. how to style sweatpants

  8. how to style chelsea boots

  9. how to style a maxi skirt

  10. how to style black jeans


So what styles caught our attention the most? With “vintage,” “retro,” and “classic” atop the list, what’s old is new. These are the most-searched clothing styles overall:


  1. Vintage

  2. Casual

  3. Retro

  4. Classic

  5. Street

  6. Western

  7. Military

  8. Athletic

  9. Business casual

  10. Hipster


If you tune into the show this weekend, who knows? Maybe you’ll discover your next celebrity style icon.