Joinr is built to meet the standards of its ad data framework. This framework provides clean, accurate, and unified advertising data, ready to be put to use.
Learn more about our framework at joinr.com/framework.
Do you think we should add more metrics and/or dimensions to our framework? Let us know at joinr.com/feedback.
Metrics
| Name & Description | Field Name | Calculation |
|---|---|---|
| Average Order Value - The average amount of revenue (value) for each conversion (order) | AOV |
Revenue / Conversions
|
| Conversions - The total amount of conversions | Conversions |
N/A
|
| Cost Per Action - The cost per conversion (action) | CPA |
Spend / Conversions
|
| Revenue - The total amount of revenue attributed to all conversions (Facebook: "Conversion Value"; Google Ads: "Conversion Value") |
Revenue |
N/A
|
| Return on Ad Spend - The ratio of revenue to spend | ROAS |
Revenue / Spend
|
| Clicks - The total number of link clicks (Facebook: "Link Clicks"; Google Ads: "Clicks") |
Clicks |
N/A
|
| Click-through Rate - The percentage of impressions that result in users clicking a link | CTR |
Clicks / Impressions
|
| Cost Per Click - The cost per click | CPC |
Spend / Clicks
|
| Spend - The total amount of ad spend (Facebook: "Amount Spent"; Google Ads: "Cost") |
Spend |
N/A
|
| Cost Per Thousand Impressions - The cost per one thousand impressions | CPM |
Spend / (Impressions / 1000)
|
| Impressions - The total amount of impressions (Facebook: "Impressions"; Google Ads: "Impressions") |
Impressions |
N/A
|
| Video Views @ 100% - The number times a video clip played to completion. (Facebook: "Video Plays @ 100%"; Google Ads: "Video played to 100%") |
Video Views (100%) |
N/A
|
| Video Views @ 75% - The number of times a video clip played to the end of the third quarter (75%) of the video's total length (Facebook: "Video Plays @ 75%"; Google Ads: "Video played to 75%") |
Video Views (75%) |
N/A
|
| Video Views @ 50% - The number of times a video clip played to the midpoint (50%) of the video's total length (Facebook: "Video Plays @ 50%"; Google Ads: "Video played to 50%") |
Video Views (50%) |
N/A
|
| Video Views @ 25% - The number of times a video clip played to the end of the first quarter (25%) of the video's total length (Facebook: "Video Plays @ 25%"; Google Ads: "Video played to 25%") |
Video Views (25%) |
N/A
|
| Cost Per Video View @ 100% - The cost per complete (100%) video views | CPVV (100%) |
Spend / Video Views (100%)
|
| Cost Per Video View @ 75% - The cost per third quartile (75%) video views | CPVV (75%) |
Spend / Video Views (75%)
|
| Cost Per Video View @ 50% - The cost per midpoint (50%) video views | CPVV (50%) |
Spend / Video Views (50%)
|
| Cost Per Video View @ 25% - The cost per first quartile (25%) video views | CPVV (25%) |
Spend / Video Views (25%)
|
| Video Completion Rate @ 100% - The percentage of impressions that result in a complete (100%) video view | VCR (100%) |
Video Views (100%) / Impressions
|
| Video Completion Rate @ 75% - The percentage of impressions that result in a third quartile (75%) video view | VCR (75%) |
Video Views (75%) / Impressions
|
| Video Completion Rate @ 50% - The percentage of impressions that result in a midpoint (50%) video view | VCR (50%) |
Video Views (50%) / Impressions
|
| Video Completion Rate @ 25% - The percentage of impressions that result in a first quartile (25%) video view | VCR (25%) |
Video Views (25%) / Impressions
|
Do you think we should add more metrics and/or dimensions to our framework? Let us know at joinr.com/feedback.
Dimensions
| Name & Description | Field Name |
|---|---|
|
Account - The account name as listed in the provider data source. |
Account |
|
Account ID - The account ID as listed in the provider data source. |
Account ID |
| Provider - The name of the highest-level data source for a specific integration, usually the reporting API used to collect data. (e.g. Facebook Ads; Google Ads) |
Provider |
| Platform - The name of the platform on which your ad was shown. (e.g. Facebook, Instagram, YouTube, Google Display) |
Platform |
| Channel - The type of advertising channel or medium (e.g. Paid Social, Paid Search, Video, Display) |
Channel |
| Campaign Name - The campaign name as listed in the provider data source. (Facebook: "Campaign"; Google Ads: "Campaign") |
Campaign |
| Campaign ID - The campaign ID as listed in the provider data source. (Facebook: "Campaign ID"; Google Ads: "Campaign ID") |
Campaign ID |
| Ad Group Name - The ad group name as listed in the provider data source. (Facebook: "Ad Set Name"; Google Ads: "Ad Group") |
Ad Group |
| Ad Group ID - The ad group ID as listed in the provider data source. (Facebook: "Ad Set ID"; Google Ads: "Ad Group ID") |
Ad Group ID |
| Ad Name - The name of the individual ad creative as listed in the provider data source. (Facebook: "Ad Name"; Google Ads: "Ad" for non-search campaigns; "H1 | H2 |H3" for expanded text ads; "Responsive Search Ad | Ad ID" for responsive search ads) |
Ad |
| Ad ID - The ad group ID as listed in the provider data source. (Facebook: "Ad ID"; Google Ads: "Ad ID") |
Ad ID |
| Conversion Name - The name of the conversion action or event, available as a dimension. (Facebook: "Conversion"; Google Ads: "Conversion action") |
Conversion Name |
| Day - The specific day an impression, event, or action took place (e.g. 2/10/2022) |
Day |
Do you think we should add more metrics and/or dimensions to our framework? Let us know at joinr.com/feedback.
Comments
0 comments
Please sign in to leave a comment.