Google BigQuery is a fully managed, serverless data warehouse that allows you to analyze massive datasets at impressive speeds using SQL queries.
Google BigQuery is a serverless, cost-effective, and multi-cloud data warehouse. Thanks to its fast deployment cycle and on-demand pricing, Google BigQuery enables scalable and interactive analysis of massive datasets for businesses ranging from mid-size to enterprise.
With Databox, you can visualize your most important business data in a fast and efficient way. You can use queries to pull data directly from BigQuery and present it alongside KPIs from other applications you may be using, like Google Analytics, Salesforce, and Mixpanel. By visualizing multi-source data in relevant dashboards, you can transform your most important KPIs into meaningful insights that you can use to make better data-driven decisions and inform your teams on desktop, mobile, Apple Watch, TV display, or Slack channels.
Facebook Ads
Impressions refer to the number of times an ad was displayed to a user on a social media platform like Facebook. It does not necessarily mean that the user interacted with the ad, but simply that it was shown to them.
Facebook Ads
The Amount Spent metric in Facebook Ads represents the total cost of all clicks, impressions, and other ad interactions that generated charges for your campaign or ad set.
Facebook Ads
The Clicks (All) metric on Facebook Ads shows the total number of clicks on an ad, including link clicks, reactions, comments, shares, and more.
Facebook Ads
Reach refers to the total number of people who view your ad, both organically and through paid promotion. It indicates the potential audience that can be reached through your ad campaign.
Facebook Ads
CPC (All) is the average cost per click across all ad types, placements, and objectives in a Facebook Ads campaign. It shows how much an advertiser pays for each click on their ad.
Facebook Ads
Link Clicks is a metric that shows the number of clicks your ad received that led people to a destination on or off Facebook, such as your website.
Facebook Ads
CTR (All) is a Facebook Ads metric that measures the ratio of clicks to impressions for all ad placements. It helps to evaluate the ad's relevance to users and overall performance. A higher CTR indicates better user engagement and ad performance.
Facebook Ads
Purchases is a metric in Facebook Ads that measures the number of completed transactions on your website, app or Facebook page as a result of your ad. It is a key measure of the advertising ROI and can be used to optimize your ad campaigns for increased sales and revenue.
Facebook Ads
Post Engagement is a metric that measures the number of people who have interacted with your Facebook post and includes likes, comments, shares, and clicks.
Facebook Ads
Amount Spent by Campaign indicates the total cost incurred by a specific Facebook ad campaign over a given time period. It shows the amount of money spent on ads, including ad creation, placement, and delivery costs.
Facebook Ads
CPM (Cost Per Thousand Impressions) is the cost that an advertiser pays per thousand ad impressions on a social media platform such as Facebook. It is an important metric that helps to measure the effectiveness of ad campaigns and their reach.
Facebook Ads
Impressions by Campaign is a metric that measures how many times an ad was shown on Facebook or Instagram to its target audience. It shows the total number of times an ad was displayed, regardless of whether someone clicked on it or not. This metric is useful in evaluating the reach of a specific campaign and can help in optimizing the ad's targeting and creative elements to increase engagement.
Facebook Ads
Leads metric indicates the number of people who have shown interest in your product or service by providing their contact details through a lead form on Facebook or Instagram ad.
Facebook Ads
Purchase ROAS is a metric that helps measure the effectiveness of Facebook Ads campaigns based on the revenue generated compared to the money spent on the ads. It is calculated by dividing the revenue generated by the amount spent on the campaign. A high Purchase ROAS indicates a profitable campaign.
Facebook Ads
CTR (Link Click-Through Rate) is a measure of the ratio between clicks and impressions on a link within a Facebook ad. It shows the effectiveness of the ad in engaging the audience and driving traffic to the intended destination.
Facebook Ads
Purchases Conversion Value is a metric that shows the total value of the purchases made by people who clicked on your Facebook ads. It helps you track the revenue generated by your ads and optimize your campaigns accordingly.
Facebook Ads
Frequency is a Facebook Ads metric that shows the average number of times your ad was shown to each person in your target audience. It can help you understand how often your ad is being viewed by the same people and avoid ad fatigue.
Facebook Ads
Impressions by Ad is the number of times your ad was displayed to users on Facebook or Instagram, regardless of whether they clicked on it or not. It indicates the reach of your ad campaign.
Facebook Ads
Clicks (All) by Campaign is a metric that measures the total number of clicks received by all ads within a specific campaign, including all clicks on links, call-to-action buttons, and other interactions with the ad.
Facebook Ads
The Reach by Campaign metric measures the number of unique people who have seen an ad in a particular campaign during a set time period.
Show more...
Enhance your social media advertising and dive into performance metrics for your Facebook, TikTok, LinkedIn, and X ads—all in one easy-to-use template. Perfect for understanding what’s driving results and optimizing your ad spend.
Use this Facebook Ads report to share insights into important metrics like spend, impressions, engagement, ROI, and more.
Use this Facebook Ads advanced report to share high-level and in-depth metrics of your Facebook Ads performance. Present an overview of key metrics like Impressions, CPC, Cost per Lead, ROAS, and more.
Use this Facebook Pages advanced report to share high-level and in-depth metrics of your Facebook performance. Present key metrics like Post Performance, Audience Demographics, Page Impressions, and more.
High-level insights into Facebook Ads, Google Ads, & LinkedIn Ads
Databox recommends to group data by day in the SQL query in Metric Builder. If you have several entries for the same date, you need to configure your SQL query to group all values for the given day. You can use Aggregation Functions such as SUM, MIN, MAX, AVG, Count in the SQL query and GROUP BY date DESC to take all values for a day into consideration and compute them based on used Aggregated Function to display all data from your SQL database.
You can learn more about Data Types in Databox here.
