{"id":6772,"date":"2020-12-15T14:56:01","date_gmt":"2020-12-15T07:56:01","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/bluecore-cung-google-cloud-sql-da-thuc-day-mua-sam-truc-tuyen-nhu-the-nao-2\/"},"modified":"2023-04-12T11:49:44","modified_gmt":"2023-04-12T04:49:44","slug":"bluecore-cung-google-cloud-sql-da-thuc-day-mua-sam-truc-tuyen-nhu-the-nao","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/bluecore-cung-google-cloud-sql-da-thuc-day-mua-sam-truc-tuyen-nhu-the-nao\/","title":{"rendered":"How Bluecore and Google Cloud SQL Drive Online Shopping?"},"content":{"rendered":"

Note<\/i><\/b>: The world situation in 2020 has boosted online shopping habits, martech provider Bluecore has been at the forefront. One of Google's Cloud Technology Partners of the Year in Retail, Bluecore powers a marketing platform for more than 400 retail brands, combining data and predictive intelligence for targeted campaigns. Here, we look at how Google Cloud SQL managed services free up Bluecore's valuable time and energy so they can continue to innovate. Let's see how Bluecore and Google Cloud promote online shopping?<\/span><\/i><\/p>\n

At <\/span>Bluecore<\/span>, ch\u00fang t\u00f4i gi\u00fap c\u00e1c th\u01b0\u01a1ng hi\u1ec7u b\u00e1n l\u1ebb quy m\u00f4 l\u1edbn chuy\u1ec3n \u0111\u1ed5i ng\u01b0\u1eddi mua s\u1eafm c\u1ee7a h\u1ecd th\u00e0nh kh\u00e1ch h\u00e0ng l\u00e2u d\u00e0i. Ch\u00fang t\u00f4i \u0111\u00e3 ph\u00e1t tri\u1ec3n m\u1ed9t n\u1ec1n t\u1ea3ng ti\u1ebfp th\u1ecb \u0111\u01b0\u1ee3c c\u00e1 nh\u00e2n h\u00f3a \u0111a k\u00eanh ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng, s\u1eed d\u1ee5ng c\u00f4ng ngh\u1ec7 m\u00e1y h\u1ecdc v\u00e0 tr\u00ed tu\u1ec7 nh\u00e2n t\u1ea1o \u0111\u1ec3 cung c\u1ea5p c\u00e1c chi\u1ebfn d\u1ecbch th\u00f4ng qua c\u00e1c m\u00f4 h\u00ecnh d\u1eef li\u1ec7u d\u1ef1 \u0111o\u00e1n. B\u1ed9 s\u1ea3n ph\u1ea9m c\u1ee7a ch\u00fang t\u00f4i bao g\u1ed3m c\u00e1c gi\u1ea3i ph\u00e1p email, trang web, k\u00eanh qu\u1ea3ng c\u00e1o v\u00e0 d\u1eef li\u1ec7u l\u00e0 tr\u1ecdng t\u00e2m c\u1ee7a m\u1ecdi th\u1ee9 ch\u00fang t\u00f4i l\u00e0m, gi\u00fap c\u00e1c nh\u00e0 b\u00e1n l\u1ebb c\u1ee7a ch\u00fang t\u00f4i cung c\u1ea5p tr\u1ea3i nghi\u1ec7m \u0111\u01b0\u1ee3c c\u00e1 nh\u00e2n h\u00f3a cho kh\u00e1ch h\u00e0ng c\u1ee7a h\u1ecd.<\/span><\/p>\n

Because our market of retail customers needed real-time data access and processing in their user interfaces \u2014 without downtime or performance degradation \u2014 we needed a solution new database. Our engineering team has spent time upgrading our own relational database management, which means we'll need less time building marketing products. We realized we needed a fully managed service, which fit within our existing architecture so we could focus on what we do best. <\/span>Google Cloud SQL<\/span><\/a> can do that.<\/span><\/p>\n

\"How<\/p>\n

Bluecore and Google Cloud personalize the online shopping experience
\n<\/strong><\/h2>\n

Our retail partners can create highly accurate campaigns within the Bluecore app by tailoring their marketing messages and campaigns to their target customers based on factors such as traffic source, time, and location. space on page, scroll bar depth, browsed products, and cart status. Based on those rules, our product intelligently decides which information should be shown to which customers. Highly personalized campaigns can be created easily with drag-and-drop features and widgets like campaign-specific images or emails.<\/span><\/p>\n

Our request for the database was full campaign creation functionality using metadata, including campaign type (pop-up, full-page, etc.), time-based campaigns (Christmas, Black Friday, etc.) and targeted customer segments. This Metadata campaign needs to be connected and available in real-time within the user interface itself without slowing down the retail partner's site. For example, a partner's customers who are highly engaged with discounts may be shown highly discounted products while browsing products.<\/span><\/p>\n

Once the campaign is live, we can measure who participated in the campaign, what products they browsed, and whether they made a purchase. Those analytics are available to e-commerce houses and our own data science team, so we can measure which campaigns are most effective. We can then use that information to optimize our features and the future campaigns of retail brands.<\/span><\/p>\n

Using the same underlying data set and feed, we can tie email functionality to the website. For example, if a customer hasn't opened an email in a certain amount of time and they visit a website, we can show them a campaign. Or if they've read a brand's email, we can show them another offer. Email and website channels can be used independently or together, depending on the marketer.<\/span><\/p>\n

Need a real-time solution
\n<\/strong><\/h2>\n

The first use case with Cloud SQL is about storing campaign information. We have a multi-tenant architecture. Our raw data like user activity (clicks, views) is stored in raw tables in <\/span>BigQuery<\/span><\/a>. At first, our campaign information was stored in a Data Warehouse, which can scale easily, but we discovered very quickly that our data was better suited to a relational model much and we started using Cloud SQL..<\/span><\/p>\n

If a marketing partner makes a change to one campaign, it can affect many other campaigns, so we needed a solution that could pull and apply that data immediately without breaking the bank. reduced performance or downtime. This is an important feature for Bluecore.<\/span><\/p>\n

\"How<\/p>\n

Choose Google Cloud SQL with Bluecore to optimize online shopping
\n<\/strong><\/h2>\n

When evaluating a relational database, we looked at a number of options and even initially tried setting up our own MySQL using Google Kubernetes Engine<\/a> (GKE). But we quickly realized that switching to our existing partner, Google, could deliver the results we needed while freeing up time for our engineers. Google Cloud SQL provides a fully managed database service for high availability while handling common time-consuming tasks like backups, maintenance, and replication. With Google ensuring a reliable, secure, and scalable database, our engineers can focus on what we do best, enhancing the performance and features of the platform our marketing.<\/span><\/p>\n

Specifically, one feature we have developed is to allow our retail brand customers the ability to deliver custom messaging in real time. For example, we might send a personalized message offering a coupon code in exchange for a customer's email subscription to a customer who has viewed five web pages but hasn't added anything to their cart. .<\/span><\/p>\n

<\/span>Cloud SQL pairs well with the Google Cloud suite of products<\/strong><\/span><\/h2>\n

In addition to BigQuery and Cloud SQL services, we rely on many Google managed services across our infrastructure. Events are being sent from websites to Google <\/span>App Engine<\/span>, from there they are queued into Pub\/Sub and processed by Kubernetes\/GKE. Our user interface is also hosted on App Engine<\/a>. Interfacing with Cloud SQL from both App Engine and GKE is extremely easy. Google continues to work with us to realize the full capabilities of the services we use and determine which services can best advance our growth plans.<\/span><\/p>\n

To learn more about their marketing technology platform, visit <\/span>Bluecore<\/span>. Are you ready to get started with a fully managed relational database solution? Explore Cloud SQL now.<\/span><\/p>\n

Contact Gimasys for advice on a transformation strategy that is suitable for your actual business situation and free service experience Google Cloud Platform<\/a><\/i><\/p>\n