Bernhard Prange Webmasterei

Webmasterei / search-queries-in-google-docs

Created September 20, 2017 19:18 — forked from derekmartinla/search-queries-in-google-docs

Perform Search Query Analysis In One Google Doc

	/**********************************************************************************************
	* AdWords Account Management -- Review Search Queries & Post Adjustments via Google Docs.
	* Version 1.0
	* Created By: Derek Martin
	* DerekMartinLA.com & MixedMarketingArtist.com
	*********************************************************************************************/

	var GOOGLE_DOC_URL = "put your url here";
	var START_DATE = '20150401';
	var END_DATE = '20150415';

Webmasterei / google-shopping-bid-optimizer-part-1.js

Created August 31, 2016 07:17

	var DESIRED_ROAS = 3.0; // this is the Return on Ad Spend that you are seeking (i.e. 3x1), different from ROI

	var PROFIT_MARGIN = 0.25; // this is the standard profit margin that will be used for bid calculations

	var MERCHANT_ID ='12345'; // this is the id found at the top right of your Merchant Center account

	var DEFAULT_CONVERSION_RATE = 0.02; // set a minimum conversion rate expectation. More on this later

	var START_PERIOD = '20160101'; // beginning of the optimization window
	var END_PERIOD = '20160131'; // end of optimization window