Automate Google BigQuery data import with Google Cloud Functions

 3r33333. 3r3-31. We are constantly working with Google BigQuery - importing data about users, their orders and advertising costs from various sources in order to be able to combine them with each other. What does this give us? For example, if you have an online store and a customer places an order by phone, and then logs into the site, then using Google BigQuery, you can link all of his actions backdating. You can track the client’s entire journey through the marketing funnel - from the first hit on the site to buying at the brick and mortar store, and evaluate advertising campaigns taking into ...
+ 0 -

Briefing as an investment. We introduce the intranet correctly

Briefing as an investment. We introduce the intranet correctly Last month, we talked about the relationship between the customer and the contractor. We continue by reasoning about the briefing, its components, and the responsibilities of partners.
 
The implementation of the portal is an individual process, there is no questionnaire for all cases of life. Based on N answers to specific questions, it is impossible to understand the pain, needs and needs of the customer. There is only experience, the accumulation of knowledge and the ability to plunge into the client's business. Below Maxim Schennikov, commercial director of the interactive agency AREALIDEA...
+ 0 -

We make a 3D configurator without programming and layout. Part Two

In our previous article " We make the 3D configurator without programming and layout "We discussed the creation of a 3D jewelry store using the Blender and 3ds Max simulation packages.
 
 
Today we will update this project and make from it a really working store. For this we need to provide it with the following functions:
 
 
Price calculation based on user configuration.
 
Sending orders for further processing by the manager.
 
Buttons of social networks (where without them).
 
 
In the end, we will have something like this:
 
 
We make a 3D configurator without programming and layout. Part Two
 
 
Press [...
+ 0 -

Where do the websites go after death? Personal experience

Where do the websites go after death? Personal experienceHello habr.
 
 
Long ago, more than 10 years ago, I started a website. More precisely, even two. The first was a typical home page in the style of narod.ru (if anyone remembers), honestly mapped using Notepad in HTML. There were no contacts or LiveJournal yet, so having your own site with a photo gallery, a news feed, a guest book and a visitor counter at the bottom of the page was cool. The second site in the domain com, was intended to accommodate several shareware programs. For him was even bought a corporate design template, so that looked like a site for those times, quite well.
 
 
Genius ...
+ 0 -

How to defeat the gluing in J. Direct and AdWords for 600 thousand rubles per month

Over the past six months, we have succeeded in defeating the "clinking" of our contextual advertising with a budget of 1 million rubles a month.
 
 
The key to victory over Frode was the minute monitoring of traffic with notifications of abnormal changes and disabling of bad API ads, and a number of reports that reflect the situation in real time.
 
 
How to defeat the gluing in J. Direct and AdWords for 600 thousand rubles per month
 
Figure 1. Diagram of the number of visitors for keywords on dekynutam
 
 


How do you know if you are being attacked?


 
One of the first signs of "gluing" advertising will be an increase in the percentage of return funds for fraud in Direct and AdWords...[/h]
+ 0 -

The fight against Yandex: how I spent more than a year to bring the site to the top

Hey. My name is Andrei Greznev. I'm an SEO analyst at Finitech Group ID Finance (brands MoneyMan, Solva, AmmoPay, Plazo). In this post I will tell you how, from the 72nd place in Yandex for the most frequency and competitive request in the subject of microfinance, I managed to promote the site in the top 10. I took more than a year to go this way, taking into account mistakes and false hypotheses. The story turned out: to raise the site, I needed to figure out what was wrong with him and try several solutions to the problem.
 
 
The fight against Yandex: how I spent more than a year to bring the site to the top
 
...
+ 0 -

RFM analysis with one button or how we made it easier for customers to live

 
RFM analysis with one button or how we made it easier for customers to live
 
Since the company Mindbox first pronounced
Machine Learning
, the overall goal was
The Big Green Button
. This is such a button in the full screen, when you click on that all works itself and brings profit.
 
In the analytical project "RFM" the goal is less ambitious -
Small green button
. You click, and the database is automatically divided into segments, by which the sending of letters is started (for example).
 
 
 
To achieve the goal, we wrote an automatic RFM segmenter and developed a special report to visualize the results.
 
We tell how this happened and why now it's possible
Do without analysts
give ...
+ 0 -

Apple refuses the affiliate program to promote applications from the App Store

Apple refuses the affiliate program to promote applications from the App Store
 
One of the most discussed news of the last week was Apple's decision revise the terms of partnership with third-party sources that attract traffic to the market. On August ? thousands of developers and reviewers received a laconic letter-notification from the administration:
 
Thank you for participating in the affiliate program for apps. With the launch of the new App Store on both iOS and macOS and their increased methods of app discovery, we will be removing apps from the affiliate program. Starting on October 1st, 201? commissions for iOS and Mac apps and in-app content will be removed from ...
+ 0 -

We do ASO to ourselves: how we received ?000 installations for the first week in Google Play Open Beta

We do ASO to ourselves: how we received ?000 installations for the first week in Google Play Open Betafor free. Introduction  On August ? we launched an open beta of the mobile online game Cats vs Pigs: Battle Arena. Despite the fact that we did not advertise the start of testing anywhere, did not send out press releases and did not buy traffic - within a week after the release, according to GameAnalytics, the game was installed by about 2000 users.Knowing that many developers are very interested in the growth of organic and viral traffic for their games, we decided to share the experience of independent work in the field of ASO and in preparation for the open beta of Google Play, which allowed to get ...
+ 0 -

How traffic exchanges resell autosurfing and where from the network millions of bots

The case was two years ago, I, as a hobby, engaged in arbitration and tested various exchanges of traffic pirender (and not only him). After talking with colleagues, he decided to pour the traffic on gambling and casino. To try, of course, decided on the road, because the language is familiar, accordingly, the landings make it easier and the audience is easier to understand.
 
 
How traffic exchanges resell autosurfing and where from the network millions of bots  
...
+ 0 -