Project Name

Excel to BigQuery

 

Categories

Google Sheet, Google Apps Script, MySQL, BigQuery

Excel to BigQuery

Excel to Big Query is a mechanism created to import data to BigQuery and generate the calculations in the form of a table through BigQuery. BigQuery is a depository for managed data for business endeavors. It is a serverless space so it utilizes SQL to resolve issues that your organization might face. It also has built-in functions i.e., machine learning, geospatial analysis, and business intelligence.

The mechanism involves two major tools which are, DSI and Bid Optimization tools. DSI tool generates the report of the sponsored advertisements, the number of clicks those sponsors got, and what unit of sales have been conducted through those clicks. This data is generated and then imported to BigQuery to create a manageable table of this imported raw data.

The bid Optimization tool also creates the raw data of all the sponsored products and brands then examines the number of clicks and clicks to output other significant calculations i.e., Decrease, Increase, and Bleeders Cut.

When the filter clicks are equal to or more than 5 and the sales are 0 then the bid will be set to $0.3. If current max bids are already $0.3 or below, no alterations will take place.

image
image
image
image
image