Connect Amazon Ads
In the client’s workspace, open Sources, add Amazon Ads and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.
Advertising integration
Turn sponsored Products, Brands, and Display campaign performance into 411 governed metrics for dashboards, agent answers, and cross-channel reporting.
What you can do with Amazon Ads in Maven
Maven models Amazon Ads into 411 governed metrics from the semantic layer. Track Ad-Level Add-to-Cart Value, Ad-Level Add to Carts, Ad-Level All Conversion Value, Ad-Level All Conversions and Ad-Level Clicks, break results down by Entity Level, Campaign, Ad group and Ad, and report Amazon Ads alongside Google Analytics 4, Shopify and Google Ads without rebuilding exports or metric logic for every report.
What you can measure
Maven keeps Amazon Ads numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.
Compatibility name for add_to_cart_value; returns the same value. No entity_level filter was ever applied.
Compatibility name for add_to_carts; returns the same value. No entity_level filter was ever applied.
Compatibility name for all_conversion_value; returns the same value. No entity_level filter was ever applied.
Compatibility name for all_conversions; returns the same value. No entity_level filter was ever applied.
Compatibility name for clicks; returns the same value. No entity_level filter was ever applied.
Compatibility name for paid_comments; returns the same value. No entity_level filter was ever applied.
Compatibility name for complete_registrations; returns the same value. No entity_level filter was ever applied.
Compatibility name for provider_summary_conversions; returns the same value. No entity_level filter was ever applied.
Compatibility name for provider_summary_cpa; returns the same value. No entity_level filter was ever applied.
Compatibility name for cpc; returns the same value. No entity_level filter was ever applied.
Compatibility name for cpm; returns the same value. No entity_level filter was ever applied.
Compatibility name for ctr; returns the same value. No entity_level filter was ever applied.
Compatibility name for paid_engagements; returns the same value. No entity_level filter was ever applied.
Compatibility name for impressions; returns the same value. No entity_level filter was ever applied.
Compatibility name for initiate_checkouts; returns the same value. No entity_level filter was ever applied.
Compatibility name for landing_page_views; returns the same value. No entity_level filter was ever applied.
Compatibility name for lead_value; returns the same value. No entity_level filter was ever applied.
Compatibility name for leads; returns the same value. No entity_level filter was ever applied.
Compatibility name for paid_likes; returns the same value. No entity_level filter was ever applied.
Compatibility name for link_clicks; returns the same value. No entity_level filter was ever applied.
Compatibility name for one_click_leads; returns the same value. No entity_level filter was ever applied.
Compatibility name for page_engagements; returns the same value. No entity_level filter was ever applied.
Compatibility name for post_engagements; returns the same value. No entity_level filter was ever applied.
Compatibility name for post_reactions; returns the same value. No entity_level filter was ever applied.
Compatibility name for reach; returns the same value. No entity_level filter was ever applied.
Compatibility name for revenue; returns the same value. No entity_level filter was ever applied.
Compatibility name for roas; returns the same value. No entity_level filter was ever applied.
Compatibility name for paid_shares; returns the same value. No entity_level filter was ever applied.
Compatibility name for total_ad_spend; returns the same value. No entity_level filter was ever applied.
Compatibility name for ad_spend_with_commission; returns the same value. No entity_level filter was ever applied.
Compatibility name for units_ordered; returns the same value. No entity_level filter was ever applied.
Compatibility name for video_views; returns the same value. No entity_level filter was ever applied.
Paid media spend with the workspace commission rate applied
Platform-reported value for add-to-cart events where available
Platform-reported add-to-cart events where available
Platform-reported value for all conversions where available
Platform-reported all-conversions count where available
Privacy-thresholded clicks from Amazon Marketing Cloud
Privacy-thresholded conversions from Amazon Marketing Cloud
Privacy-thresholded impressions from Amazon Marketing Cloud
Privacy-thresholded purchases from Amazon Marketing Cloud
Privacy-thresholded attributed sales from Amazon Marketing Cloud
Privacy-thresholded spend from Amazon Marketing Cloud
Privacy-thresholded unique users from Amazon Marketing Cloud
Attributed units reported by Walmart Connect
Paid ad clicks reported by connected ad platforms
Platform-reported completed registration events where available
Paid media cost per click calculated from raw spend divided by clicks
Paid media cost per thousand impressions calculated from raw spend divided by impressions
Paid ad click-through rate calculated as clicks divided by impressions
Ad impressions served by connected paid media platforms
Platform-reported initiated checkout events where available
Platform-reported landing page views or page-view conversion proxy where available
Platform-reported lead value where available
Platform-reported lead events where available. For LinkedIn this is Lead Gen Form (one-click) leads, which LinkedIn does not count in conversions.
Platform-reported link clicks where available
LinkedIn chargeable clicks
Comments on sponsored content
Advertiser-defined conversion value in account currency
Total attributed external website conversions
Account-currency spend per one-click lead
Account-currency spend per chargeable click
Account-currency spend per thousand impressions
Chargeable clicks divided by impressions
Document ads reaching 100 percent
Total interactions with LinkedIn ad units
Follows attributed to sponsored content or follower ads
LinkedIn sponsored-creative impressions
Completed job applications attributed to ads
Clicks to start a job application
Clicks to the creative landing page
One-click leads divided by Lead Gen Form opens
One-click Lead Gen Form opens
One-click leads generated
Likes on sponsored content
Sponsored Messaging contact-info shares
Sponsored Messaging interested clicks
Sponsored Messaging opens
Sponsored Messaging sends
Conversions attributed after a click
Registrations attributed after a click
Conversions attributed after an impression (view-through); included in LinkedIn conversions
Registrations attributed after an impression
Leads marked qualified by the advertiser
Positive reactions on sponsored content
Event or seminar registrations attributed to ads
Shares of sponsored content
Spend in the LinkedIn ad account currency
LinkedIn provider-converted USD spend
Video completions divided by video starts
Video plays reaching 97–100 percent
Video plays reaching the first quartile
Video plays reaching the midpoint
Sponsored video starts
Video plays reaching the third quartile
Qualified sponsored video views
LinkedIn one-click lead events where available
Paid social page engagements where available
Paid social comments where available
Platform-reported paid engagement actions where available
Paid social likes where available
Paid social shares where available
Pinterest-attributed checkout value in the provider ad-account currency.
Checkout conversions attributed to Pinterest ads.
Total Pinterest Pin clickthroughs including earned activity.
Total Pinterest-attributed conversions using the retained attribution windows.
Account-currency Pinterest spend per attributed conversion.
Account-currency Pinterest spend per total clickthrough.
Account-currency Pinterest spend per thousand impressions.
Pinterest total clickthroughs divided by total impressions.
Pinterest engagements divided by total impressions.
Total engagements with Pinterest ads.
Total paid and earned Pinterest ad impressions.
Lead conversions attributed to Pinterest ads.
Pinterest native lead-form submissions.
First-order clicks from Pinterest ads to an advertiser destination.
Pinterest outbound clicks divided by total impressions.
Page-visit conversions attributed to Pinterest ads.
First-order paid Pinterest ad impressions.
Provider-reported unique users reached; non-additive across dates and entities.
Pinterest-attributed checkout value divided by spend.
First-order saves of Pinterest ads.
Signup conversions attributed to Pinterest ads.
Pinterest spend in the provider ad-account currency.
Unique Pinterest video viewers reaching fifteen seconds.
Pinterest video plays reaching 25 percent.
Pinterest video views lasting at least three seconds.
Pinterest video plays reaching 50 percent.
Pinterest video plays reaching 75 percent.
Pinterest video plays reaching 95 percent.
Pinterest video completions divided by video starts represented by 3-second views.
Pinterest video plays reaching 100 percent.
Pinterest video views meeting MRC viewability criteria.
Web sessions attributed to Pinterest ads.
Paid social post engagements where available
Paid social post reactions where available
Compatibility conversion value from the provider ad-performance summary. For Facebook this is the primary named-conversion set's conversion value (conversions source at 7-day click plus 1-day view, platform_default fallback), not purchase value; purchase value remains available in obt_paid_media_conversion_actions filtered on event_name. Do not use for canonical paid-media conversion-value questions.
Compatibility total from the provider ad-performance summary. For Facebook this is Meta Results for the ad set's optimization event (only the conversion event each ad set optimizes for, under that ad set's attribution setting; 0 for reach, traffic and engagement goals; the primary named-conversion set when the ad set's target cannot be resolved), matching Ads Manager's Results column. obt_paid_media_conversion_actions rows with is_results_event = true reconcile to it; every other event stays available there by event_name. For LinkedIn this is external website conversions (post-click plus post-view) and excludes Lead Gen Form leads, which are reported in leads.
Compatibility provider-summary spend divided by provider-summary conversions. Canonical action-based CPA is calculated from total_ad_spend and conversions at a shared grain.
Platform-reported paid reach where available; daily reach is not deduped across wider periods
Reddit add-to-cart events attributed to ad clicks.
Items contained in Reddit-attributed add-to-cart events.
Reddit-attributed add-to-cart value in provider account currency.
Reddit add-to-cart events attributed to ad views.
Click- and view-attributed add-to-cart events.
Total clicks reported for Reddit ads.
Reddit content views attributed to ad clicks.
Reddit content views attributed to ad views.
Click- and view-attributed content-view events.
Account-currency Reddit spend per key conversion.
Account-currency Reddit spend per click.
Account-currency Reddit spend per thousand impressions.
Reddit clicks divided by impressions.
Reddit clicks that met the provider engaged-click definition.
Reddit video impressions that were fully viewable.
Total Reddit ad impressions.
Reddit key conversions attributed to ad clicks.
Reddit key conversions attributed to ad views.
Provider key-conversion total selected as the canonical Reddit conversion metric.
Reddit lead events attributed to ad clicks.
Reddit-attributed lead value in provider account currency.
Reddit lead events attributed to ad views.
Click- and view-attributed lead events.
Native Reddit lead-form submissions.
Reddit page visits attributed to ad clicks.
Reddit page visits attributed to ad views.
Click- and view-attributed page-visit events.
Reddit purchases attributed to ad clicks.
Items contained in Reddit-attributed purchases.
Reddit-attributed purchase value in provider account currency.
Reddit purchases attributed to ad views.
Click- and view-attributed Reddit purchase events.
Provider-reported daily unique users reached; non-additive across dates and entities.
Reddit-attributed purchase value divided by spend.
Reddit signup events attributed to ad clicks.
Reddit-attributed signup value in provider account currency.
Reddit signup events attributed to ad views.
Click- and view-attributed signup events.
Reddit ad spend in the provider account currency.
Reddit video plays reaching ten seconds.
Reddit video plays reaching 25 percent.
Reddit video plays reaching three seconds.
Reddit video plays reaching 50 percent.
Reddit video plays reaching five seconds.
Reddit video plays reaching 75 percent.
Reddit video plays reaching 95 percent.
Reddit video completions divided by video starts.
Reddit video plays reaching 100 percent.
Reddit video plays opened in the expanded player.
Reddit video plays where sound was enabled.
Reddit ad video starts.
Reddit video plays meeting the provider fifteen-second viewability threshold.
Reddit video plays meeting the provider six-second viewability threshold.
Reddit video impressions meeting provider viewability criteria.
Revenue attributed by the ad platform at the base ad performance grain. For Facebook this is the primary named-conversion set's conversion value (conversions source at 7-day click plus 1-day view, platform_default fallback), not purchase value; purchase value remains available in obt_paid_media_conversion_actions filtered on event_name.
Platform-attributed return on ad spend calculated from ad revenue divided by raw spend. For Facebook the numerator is the primary named-conversion set's conversion value, not purchase value (see revenue).
Snapchat-attributed add-to-cart value in account currency.
Add-to-cart events attributed to Snapchat ads.
Android app installs attributed to Snapchat ads.
Total screen time divided by paid impressions at query time.
Snapchat swipe-up actions represented as canonical paid-media clicks.
Snapchat-attributed content-view value in account currency.
Content-view events attributed to Snapchat ads.
Account-currency Snapchat spend per attributed purchase.
Account-currency Snapchat spend per swipe.
Account-currency Snapchat spend per thousand paid impressions.
Snapchat swipes divided by paid impressions.
Earned impressions generated by Snapchat ads.
Paid impressions divided by provider-deduplicated daily reach at query time.
Paid Snapchat ad impressions at the canonical ad-day grain.
iOS app installs attributed to Snapchat ads.
Landing-page views attributed to Snapchat ads.
Native Snapchat lead-form submissions.
Snapchat-attributed page-view value in account currency.
Page-view events attributed to Snapchat ads.
First-order paid Snapchat impressions.
Clicks from ads to a Snapchat Public Profile.
Snapchat-attributed purchase value in provider account currency.
Purchases attributed by Snapchat under the retained swipe and view windows.
Provider-deduplicated daily unique reach; non-additive across dates and entities.
Snapchat-attributed purchase value divided by spend.
Saves generated by Snapchat ads.
Total time Snapchat ads were on screen in milliseconds.
Shares of Snapchat ads.
Snapchat-attributed signup value in account currency.
Signup events attributed to Snapchat ads.
Snapchat spend in the provider ad-account currency.
Snapchat-attributed checkout-start value in account currency.
Checkout-start events attributed to Snapchat ads.
Snapchat-attributed subscription value in account currency.
Subscription events attributed to Snapchat ads.
Paid plus earned Snapchat impressions.
Total app installs attributed to Snapchat ads.
Snapchat-attributed trial value in account currency.
Trial-start events attributed to Snapchat ads.
Snapchat video views lasting at least fifteen seconds.
Snapchat video plays reaching 25 percent.
Snapchat video plays reaching 50 percent.
Snapchat video views lasting at least five seconds.
Snapchat video plays reaching 75 percent.
Snapchat video completions divided by qualified video views.
Snapchat video plays reaching 100 percent.
Snapchat time-based video views.
Snapchat two-second qualified video views.
TikTok paid ad clicks.
Comments on TikTok ads.
TikTok attributed conversions using the account attribution settings.
Account-currency TikTok spend per attributed conversion.
Account-currency TikTok spend per click.
Account-currency TikTok spend per thousand impressions.
TikTok clicks divided by impressions.
Follows attributed to TikTok ads.
TikTok paid ad impressions.
Likes on TikTok ads.
Profile visits attributed to TikTok ads.
Daily TikTok reach; non-additive across dates and entities.
TikTok real-time attributed conversions.
TikTok real-time objective-specific result count.
TikTok objective-specific result count; interpretation depends on campaign objective.
TikTok attributed purchase value in account currency.
TikTok attributed purchase value divided by spend.
Shares of TikTok ads.
TikTok spend in the provider account currency.
TikTok video plays reaching 100 percent.
TikTok video plays reaching 25 percent.
TikTok video views lasting at least two seconds.
TikTok video plays reaching 50 percent.
TikTok video views lasting at least six seconds.
TikTok video plays reaching 75 percent.
TikTok video play actions.
Media spend reported by ad platforms before Maven commission adjustments
Ordered units from commerce-oriented ad platforms where available
Paid video views where available
Attributed orders reported by Walmart Connect
Attributed sales reported by Walmart Connect
Campaign clicks reported by Walmart Connect
Campaign impressions reported by Walmart Connect
Campaign spend reported by Walmart Connect
Items contained in ad-attributed add-to-cart events. Reported by Reddit only.
Ad leads the advertiser marked as qualified in the ad platform. Reported by LinkedIn only; distinct from CRM qualified_leads.
Android app installs attributed to ads. Reported by Snapchat only.
Total app installs attributed to ads. Reported by Snapchat only.
Web sessions attributed to ads by the ad platform (not site analytics web_sessions). Reported by Pinterest only.
Click-through share of add_to_carts. Reported by Reddit only.
Click-through share of signups / complete registrations. Contributing platforms: Reddit click-attributed signups and LinkedIn post-click registrations.
Click-through share of content_views. Reported by Reddit only.
Click-through share of each platform's headline conversions. Contributing platforms: Reddit click-attributed key conversions and LinkedIn post-click conversions.
Click-through share of lead_conversions (pixel Lead events). Reported by Reddit only.
Click-through share of page_visit_conversions. Reported by Reddit only.
Click-through share of purchase_conversions. Reported by Reddit only.
Signup (complete registration) value attributed to ads in provider account currency. Contributing platforms: Reddit and Snapchat.
Content-view value attributed to ads in account currency. Reported by Snapchat only.
Pixel ViewContent conversion events attributed to ads. Contributing platforms: Reddit (click- plus view-attributed) and Snapchat.
Document ads read to 100 percent. Reported by LinkedIn only.
Earned impressions generated by ads (shares and other organic re-exposure). Reported by Snapchat only.
Clicks that met Reddit's engaged-click definition. Reported by Reddit only.
Video plays opened in the expanded player. Reported by Reddit only.
Follows attributed to ads. Contributing platforms: LinkedIn (sponsored content and follower ads) and TikTok.
Video impressions that were fully viewable. Reported by Reddit only.
Checkout-start value attributed to ads in account currency; pairs with initiate_checkouts. Reported by Snapchat only.
iOS app installs attributed to ads. Reported by Snapchat only.
Completed job applications attributed to ads. Reported by LinkedIn only.
Clicks to start a job application. Reported by LinkedIn only.
Pixel Lead conversion events attributed to ads. Contributing platforms: Reddit (click- plus view-attributed) and Pinterest. Distinct from leads, which counts native lead-form submissions.
One-click Lead Gen Form opens. Reported by LinkedIn only.
Video views meeting MRC viewability criteria. Reported by Pinterest only.
Objective-specific result count; interpretation depends on the campaign objective, so group by objective. Reported by TikTok only.
Page-view conversion value attributed to ads in account currency; pairs with page_visit_conversions. Reported by Snapchat only.
Pixel page-visit (PAGE_VIEW) conversion events attributed to ads. Contributing platforms: Reddit (click- plus view-attributed page visits), Pinterest page visits and Snapchat page views. Kept separate from landing_page_views, which counts landing-page loads or clicks.
Paid plus earned impressions. Contributing platforms: Snapchat total impressions and Pinterest impressions (which Pinterest reports as paid plus earned).
First-order paid impressions, excluding earned impressions. Contributing platforms: Pinterest and Snapchat. Generic impressions are paid plus earned on Pinterest and the provider impressions field on Snapchat.
Visits from ads to the advertiser's profile page. Contributing platforms: TikTok profile visits and Snapchat profile clicks (Snapchat counts clicks to the Public Profile), plus LinkedIn company-page clicks at creative/day grain; unreported values remain NULL.
Spend converted to USD by the provider's own FX, not Maven currency normalisation. Reported by LinkedIn only.
Purchase value attributed to ads in provider account currency. Contributing platforms: Reddit purchase value, Pinterest checkout value and Snapchat purchase value (the generic revenue column on Pinterest and Snapchat rows).
Purchase conversion events attributed to ads. Contributing platforms: Reddit purchases (click- plus view-attributed), Pinterest checkouts (Pinterest's completed-purchase event) and Snapchat conversions (Snapchat purchases).
Conversions under real-time attribution (differs from the standard conversions count). Reported by TikTok only.
Real-time objective-specific result count. Reported by TikTok only.
Ads saved by users. Contributing platforms: Pinterest (first-order saves) and Snapchat.
Total time ads were on screen in milliseconds. Reported by Snapchat only.
Sponsored Messaging contact-info shares. Reported by LinkedIn only.
Sponsored Messaging interested clicks. Reported by LinkedIn only.
Sponsored Messaging opens. Reported by LinkedIn only.
Sponsored Messaging sends. Reported by LinkedIn only.
Subscription conversion value attributed to ads in account currency. Reported by Snapchat only.
Subscription conversion events attributed to ads. Reported by Snapchat only.
Time-based video views. Reported by Snapchat only.
Trial-start value attributed to ads in account currency. Reported by Snapchat only.
Trial-start events attributed to ads. Reported by Snapchat only.
Unique viewers reaching fifteen seconds of video; non-additive across dates and entities. Reported by Pinterest only.
Video plays reaching ten seconds. Reported by Reddit only.
Video views lasting at least fifteen seconds. Reported by Snapchat only; distinct from unique_video_15_second_viewers (Pinterest) and viewable_video_15_second_views (Reddit).
Paid video plays reaching 25 percent of the video length. Contributing platforms: Reddit, Pinterest, Snapchat, TikTok and LinkedIn (LinkedIn first-quartile completions).
Paid video views lasting at least two seconds. Reported by TikTok only for now; Snapchat two-second qualified views (which also count swipe-ups) stay in snapchat_ads_video_views until that definition is signed off.
Paid video views lasting at least three seconds. Contributing platforms: Reddit (also the generic video_views on Reddit rows) and Pinterest.
Paid video plays reaching 50 percent of the video length. Contributing platforms: Reddit, Pinterest, Snapchat, TikTok and LinkedIn (LinkedIn midpoint completions).
Paid video views lasting at least five seconds. Contributing platforms: Reddit and Snapchat.
Video views lasting at least six seconds (no viewability gate; distinct from viewable_video_6_second_views). Reported by TikTok only.
Paid video plays reaching 75 percent of the video length. Contributing platforms: Reddit, Pinterest, Snapchat, TikTok and LinkedIn (LinkedIn third-quartile completions).
Paid video plays reaching 95 percent of the video length. Contributing platforms: Reddit and Pinterest.
Paid video plays reaching 100 percent of the video length. Contributing platforms: Reddit, Pinterest, Snapchat and TikTok (100% views). LinkedIn completions (97-100 percent of length) are not included yet; use linkedin_ads_video_completions.
Video plays where sound was enabled. Reported by Reddit only.
Paid video playback starts. Contributing platforms: Reddit (video starts), LinkedIn (video starts) and TikTok (video play actions, which is also what video_views returns on TikTok rows). Other platforms report no starts column; group or filter by platform to compare.
View-through share of add_to_carts. Reported by Reddit only.
View-through share of signups / complete registrations. Contributing platforms: Reddit view-attributed signups and LinkedIn post-view registrations.
View-through share of content_views. Reported by Reddit only.
View-through share of each platform's headline conversions. Contributing platforms: Reddit view-attributed key conversions and LinkedIn post-view conversions (included in LinkedIn conversions).
View-through share of lead_conversions (pixel Lead events). Reported by Reddit only.
View-through share of page_visit_conversions. Reported by Reddit only.
View-through share of purchase_conversions. Reported by Reddit only.
Video plays meeting the provider fifteen-second viewability threshold. Reported by Reddit only.
Video plays meeting the provider six-second viewability threshold. Reported by Reddit only; distinct from video_6_second_views (TikTok, no viewability gate).
Video impressions meeting provider viewability criteria. Reported by Reddit only.
Video completions divided by video starts, with both sides limited to platforms that report a starts column: Reddit and TikTok. LinkedIn is excluded until its 97-100 percent completion threshold is signed off; Pinterest and Snapchat completion rates use different denominators (3-second and 2-second views) and stay separate.
Clicks reported for the selected native asset or ad-container creative row
Conversions for the selected creative row. Ad-container rows sum the is_results_event rows of obt_paid_media_conversion_actions at ad-day grain (Meta Results for Facebook, the primary set elsewhere); native asset rows report the provider's per-asset conversions and are not additive across sibling assets.
Cost per reported video view for creative-performance rows
Cost per conversion for creative-performance rows
Cost per click for creative-performance rows
Cost per thousand impressions for creative-performance rows
Click-through rate for creative-performance rows
Impressions reported for the selected native asset or ad-container creative row
Revenue or conversion value for the selected creative row. Ad-container rows sum the conversion value of the primary conversion set from obt_paid_media_conversion_actions at ad-day grain (not provider purchase revenue); native asset rows report the provider's per-asset revenue and are not additive across sibling assets.
Return on ad spend for creative-performance rows
Spend reported for the selected native asset or ad-container creative row
Video views reported for the selected native asset or ad-container creative row
Linear-pace expected month-to-date spend as of the latest day in range
Configured campaign monthly budget level as of the latest day in range
Daily spend on the pacing fact; sums to month-to-date over a month-to-date window
Month-to-date spend as a fraction of monthly budget as of the latest day in range
Projected month-end spend at current pace as of the latest day in range
Closed CRM deals with deterministic campaign attribution matched to paid delivery
CRM deals with deterministic campaign attribution matched to paid delivery
Won CRM deals with deterministic campaign attribution matched to paid delivery
Paid-media clicks represented in the paid-to-CRM surface
Paid spend divided by attributed CRM deals
Paid spend divided by attributed won CRM deals
Attributed deals backed by a deterministic identity match
Paid-media impressions represented in the paid-to-CRM surface
Paid-media spend on campaign-day rows with CRM attribution coverage; group or filter by spend_currency
Closed CRM deals with deterministic campaign attribution matched to paid delivery
CRM deals with deterministic campaign attribution matched to paid delivery
Won CRM deals with deterministic campaign attribution matched to paid delivery
Attributed deals backed by a deterministic identity match
GA4 key events (site conversions) by geography and channel; GA4 rows only, never added to platform conversions
GA4 day-rows whose key events were fully reported; compare with geo_channel_ga4_days_expected
GA4 day-rows expected for key-event coverage
GA4 revenue by geography and channel
GA4 sessions by geography and channel
Ad platform clicks by geography and channel
Platform-reported conversions (each platform's own attribution) by geography and channel; NULL where the platform does not report them, never added to GA4 conversions
Ad platform impressions by geography and channel
Platform-reported conversion value by geography and channel; NULL where not reported
Ad platform spend by geography and channel, including spend a geo level does not account for (__not_reported__ rows)
Ad platform spend on rows whose conversions the platform reports at that geo level; the CPA numerator
GA4 site conversions divided by GA4 sessions
Each grouped row's share of all GA4 site conversions in the result
Each grouped row's share of GA4 site conversions within its geography
Each grouped row's share of all platform conversions in the result (for example a state's share of the total)
Each grouped row's share of platform conversions within its geography (for example a channel's share of a state)
Spend with reported conversions divided by platform-reported conversions
Provider-attributed value from named primary paid-media conversion actions.
Provider-attributed paid-media conversions at named conversion-action grain. The semantic default selects primary conversion rows to prevent attribution-window and event-source duplication; filter event_name when the user requests a conversion subset. For Facebook, the default total sums all named conversion rows from the conversions source at 7-day click plus 1-day view; filter is_results_event = true for Meta Results (each ad set's optimization event), which is what obt_ad_performance conversions report. For LinkedIn, rows are website conversion rules counted under each rule's own click and view windows, so they include post-view (view-through) conversions; Lead Gen Form leads are not conversions (use leads).
Questions you can ask
Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.
How much did we spend on ads by platform over the last 30 days?
What are the top campaigns by spend?
Show commission-adjusted ad spend by platform
Show top creatives by ROAS with previews
Show creative preview coverage by platform
What conversion events did we record last week by platform?
Show rolled-up conversion events by creative
Connection and sync
You connect Amazon Ads by signing in to it and approving access, so nobody shares a password. The first Amazon Ads sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 60 days in total. After that, each scheduled sync re-reads the last 14 days, so late changes are picked up.
Campaign-level daily performance — spend, clicks, conversions, sales.
Fields: campaign name, campaign status, budget, impressions, clicks, cost, sales, conversions, units ordered, sales 7d, and 5 more
Ad-group-level daily performance — raw Sponsored Ads report grain for ad group diagnostics.
Fields: campaign name, ad group name, impressions, clicks, cost, sales, conversions, units ordered, sales 7d, conversions 7d, and 4 more
How it works
No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.
In the client’s workspace, open Sources, add Amazon Ads and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.
Maven pulls the client’s Amazon Ads data (2 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.
Build the client’s report or deck by asking Claude or ChatGPT through the MCP, set alerts on what matters, and publish to the client’s portal once you approve it.
Works well with
FAQ
Maven exposes 411 governed Amazon Ads metrics, including Ad-Level Add-to-Cart Value, Ad-Level Add to Carts, Ad-Level All Conversion Value, Ad-Level All Conversions, Ad-Level Clicks and Ad-Level Comments — each defined once so it means the same thing in every report.
You can break Amazon Ads metrics down by Entity Level, Campaign, Ad group, Ad, Ad status, Objective, Commission Rate Percent and Media Budget Currency, and more.
Yes. Amazon Ads sits in the same client workspace as sources like Google Analytics 4, Shopify, Google Ads, Facebook Ads and HubSpot, so one report or question can use them together.
Maven syncs campaign performance and ad group performance from Amazon Ads.
Maven refreshes Amazon Ads on a schedule after the source is connected, and shows each source’s last sync time in the client’s workspace, so you can check the data is current before a report goes out.
Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.
Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.
Nothing is charged unless you subscribe.