I could have added these filtering capabilities in the script code, but I felt that brazil phone number list most advertisers are more comfortable changing parameters in spreadsheets than in javascript. So you have all the data, how you filter it is up to you. :) methodology for calculating incrementalitythe script itself is quite simple, but you might be curious how we calculate brazil phone number list the "Incrementality" of rsas. Here's what we do if a query gets impressions with both ad formats. We assume that additional impressions with a particular ad format will perform at the same level as existing impressions with that ad format.
We calculate the difference in conversions per brazil phone number list impression, ctr and cpc between rsa and eta for each line of the sheet.We apply the difference of each of the above 3 stats to the query impressions. Legend: each row in the spreadsheet shows how rsa ads helped or hurt the ads served for each query in the ad group. Based on this, advertisers brazil phone number list can make decisions to restructure accounts to get the right query with the right ad in the right place.
This allows us to see how many clicks, conversions and brazil phone number list costs would have changed if we hadn't had the other ad format.ConclusionAdvertisers should not make decisions with incomplete data. Automation is here to stay so we need to figure out how to get the most out of it and that means we need tools to answer important questions like 'how do we make rash brazil phone number list work for us?' scripts are a great option for automating complex reports that you want to use frequently, so I hope this new software helps. Tweet me with ideas for new scripts or ideas for improving this one.