Dessert DataConnected Apps
⚙️ Report Format
The date associated with each metric.
Show formulasegments.date
Bing
date_start
TimePeriod
The month associated with each metric.
Show formulasegments.month
Bing
TimePeriod
date_start
The campaign id associated with each metric.
Show formulacampaign.id
Bing
CampaignId
campaign_id
The name of your campaign.
Show formulacampaign.name
Bing
CampaignName
campaign_name
The number of times your ad was shown.
Show formulaimpressions
Bing
Impressions
impressions
The number of times your ad was clicked.
Show formulaclicks
Bing
Clicks
action => action_type = link_click
Click Through Rate (CTR) is the ratio of clicks to impressions.
Show formulactr
Bing
Ctr
ctr
Average Cost Per Click (CPC) is the average amount you pay for each click.
Show formulaaverageCpc / 1000000
Bing
AverageCpc
cpc
The amount you spent on advertising.
Show formulacostmicros / 1000000
Bing
Spend
cost
The number of conversions.
Show formulaallConversions
Bing
Conversions
action_values => action_type = purchase
Conversion Rate is the ratio of conversions to clicks.
Show formulaallConversionsFromInteractionsRate
Bing
Conversions / Clicks
actions => (action_values => action_type === 'purchase') / (actions => action_type === 'link_click')
Cost Per Conversion is the average amount you pay for each conversion.
Show formulacostPerConversion / 1000000
Bing
CostPerConversion
spend / ( action_values => action_type === purchase )
The amount of revenue generated.
Show formulaallConversionsValue
Bing
Revenue
action_values => action_type === 'purchase'
Return on Ad Spend (ROAS) is a measures the revenue generated for every dollar spent on advertising.
Show formulaallconversionsvalue / (costmicros / 1000)
Bing
revenue / spend
revenue / cost
🔌 Data Sources
Google Ads
Your Google Ads Customer ID is a 10-digit number that uniquely identifies your Google Ads account. You can find your Customer ID at the top right corner of your Google Ads account.
Google Ads requires an MCC for an external connection. This will connect all of the associated accounts under the MCC. If you don't have an MCC, you can create one in your Google Ads account.
Name and save the Customer Account IDs you want synced. Records from this source will have a "source" parameter equal to the name.
Facebook Ads (new)
2. Connect to Facebook
Bing
Mongo DB (experimental)
contact [email protected] to enable
🌐 Data Destinations
BigQuery
Your Google Cloud Project ID, and BigQuery Dataset ID can be found in your Google Cloud Console.
GoogleSheets
After the initial sync, you can open the spreadsheet to view and edit the data.
(Not yet connected)