This is a powerful tool that summarizes data.
What is a Pivot Table?
This is the name of the ad campaign you're viewing in reporting.
What is Campaign?
This function returns a custom result when a formula generates an error and a standard result when no error is detected.
What is IFERROR?
These are very useful in measuring the success of an ad or the health of a business.
What are KPIs?
The average cost for 1,000 impressions.
What is CPC?
This is the unique ID of the ad you're viewing in reporting.
What is AD ID?
This function strips extra spaces from text, leaving only a single space between words and no space for characters at the start or end of the text.
What is TRIM?
To report on marketing activities, metrics fall into either of these two categories.
What are simple or calculated?
The percentage of times people saw your ad and performed a click.
What is CTR?
This is a group of people who can potentially see your ads.
What is Audience?
This function runs multiple tests and returns a value corresponding to the first TRUE result.
What is IF?
This is the number of times an ad has been viewed
What are Views?
The average cost for each video view.
What is CPV?
This is the estimated total amount of money you've spent on your campaign, ad set or ad during its schedule.
What is Media Spend?
This is the individual cell of a worksheet in which one piece of information is stored
What is Field?
This function combines the text from multiple ranges and/or strings.
What is CONCAT?
This is the average cost for each click.
What is Cost Per Click?
This is the process of transforming and mapping data from one "raw" data form into another format with the intent of making it more appropriate and valuable.
What is Data Wrangling?
This is the amount of revenue earned per every dollar spent on media.
What is ROAS?
This function’s input arguments are lookup_value, table_array, col_index, [range_lookup].
What is VLOOKUP?
When the amount is low this is good.
What is CPC or CPA?