Filter
User User( id="d914b3ae6a234613991d1eaf4a798aae", external_auth_id="auth0|6278e1c94fa8d9006f899e53", name="charles Godfrey", email="charles.godffrey@mail.com", onboarded="True", amazon_users=.... )
Created At 2022-05-09 09:49:53.017032
Params {"date_from": "2022-03-10", "report_name": "Audit1", "profile_ids": "1634231489365529", "date_to": "2022-05-08", "merchant_type": "seller", "country_code": "US", "merchant_name": "A9N9Z7BACWWEI"}
Result
{
  "ad_groups": {
    "average_per_campaign": 64.0
  },
  "ad_spend": {
    "total": 1519.77,
    "wasted": 1078.54
  },
  "asins": {
    "converting": {
      "total": 10
    },
    "unique": {
      "total": 9
    }
  },
  "branded": {
    "False": {
      "ad_spend": {
        "total": 0,
        "wasted": 0
      },
      "clicks": {
        "click_through_rate": 0,
        "cpc": 0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0,
        "total": 0
      },
      "sales": {
        "summary": {
          "acos": 0,
          "roas": 0,
          "total": 0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "total": 0
        }
      }
    },
    "True": {
      "ad_spend": {
        "total": 0,
        "wasted": 0
      },
      "clicks": {
        "click_through_rate": 0,
        "cpc": 0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0,
        "total": 0
      },
      "sales": {
        "summary": {
          "acos": 0,
          "roas": 0,
          "total": 0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "total": 0
        }
      }
    }
  },
  "budget": {
    "daily_efficiency": {
      "full_spend": 57,
      "high_spend": 1,
      "low_spend": 0,
      "percent_full_spend": 0.9828,
      "percent_high_spend": 0.0172,
      "percent_low_spend": 0.0,
      "percent_zero_spend": 0.0,
      "total_days": 58,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 2.6203,
      "percent_underspend": -1.6203,
      "total": 580.0,
      "total_underspend": -939.77
    },
    "top_daily_underspend": [
      {
        "date": "2022-04-16",
        "percent_spend": 0.999,
        "total": 10.0,
        "total_ad_spend": 9.99,
        "total_underspend": 0.01
      },
      {
        "date": "2022-04-15",
        "percent_spend": 1.037,
        "total": 10.0,
        "total_ad_spend": 10.37,
        "total_underspend": -0.37
      },
      {
        "date": "2022-04-17",
        "percent_spend": 1.144,
        "total": 10.0,
        "total_ad_spend": 11.44,
        "total_underspend": -1.44
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 1
    }
  },
  "clicks": {
    "click_through_rate": 0.0148,
    "cpc": 0.67,
    "total": 2253
  },
  "conversions": {
    "conversion_rate": 0.0377,
    "total": 85
  },
  "impressions": {
    "total": 825917
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 49.0,
      "total": 49
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        },
        "summary": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0,
        "cpc": 0.0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0.0,
        "total": 0
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        },
        "summary": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "top_non_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "percent_converting": 0.0,
          "total": 0
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 223.11
        },
        "summary": {
          "percentage_of_total": 0.4091,
          "total": 621.73,
          "wasted": 398.62
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0194,
        "cpc": 0.64,
        "total": 977
      },
      "conversions": {
        "conversion_rate": 0.045,
        "total": 44
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2031,
          "roas": 4.9238,
          "total": 1098.56,
          "total_orders": 44.0
        },
        "summary": {
          "acos": 0.5659,
          "roas": 1.7669,
          "total": 1098.56,
          "total_orders": 44
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.3414,
            "ad_spend": 51.19,
            "clicks": 77,
            "cpc": 0.66,
            "query": "couples scrapbook",
            "sales": 149.94
          },
          {
            "acos": 0.221,
            "ad_spend": 16.35,
            "clicks": 31,
            "cpc": 0.53,
            "query": "b07dwy446c",
            "sales": 73.97
          },
          {
            "acos": 0.0612,
            "ad_spend": 3.06,
            "clicks": 4,
            "cpc": 0.77,
            "query": "birthday scrapbook",
            "sales": 49.98
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 10.19,
            "clicks": 14,
            "cpc": 0.73,
            "query": "scrapbook paper",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.75,
            "clicks": 17,
            "cpc": 0.51,
            "query": "b07hfc7skn",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.37,
            "clicks": 13,
            "cpc": 0.64,
            "query": "couple scrapbook",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 32,
          "non_converting": 344,
          "percent_converting": 0.0851,
          "total": 376
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        },
        "summary": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0,
        "cpc": 0.0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0.0,
        "total": 0
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        },
        "summary": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "top_non_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "percent_converting": 0.0,
          "total": 0
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        },
        "summary": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0,
        "cpc": 0.0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0.0,
        "total": 0
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        },
        "summary": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "top_non_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "percent_converting": 0.0,
          "total": 0
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 209.94
        },
        "summary": {
          "percentage_of_total": 0.5909,
          "total": 898.04,
          "wasted": 688.1
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0126,
        "cpc": 0.7,
        "total": 1276
      },
      "conversions": {
        "conversion_rate": 0.0321,
        "total": 41
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2051,
          "roas": 4.8756,
          "total": 1023.59,
          "total_orders": 41.0
        },
        "summary": {
          "acos": 0.8773,
          "roas": 1.1398,
          "total": 1023.59,
          "total_orders": 41
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.493,
            "ad_spend": 61.6,
            "clicks": 85,
            "cpc": 0.72,
            "query": "scrapbook album",
            "sales": 124.95
          },
          {
            "acos": 0.303,
            "ad_spend": 30.29,
            "clicks": 43,
            "cpc": 0.7,
            "query": "scrap booking supples",
            "sales": 99.96
          },
          {
            "acos": 0.3239,
            "ad_spend": 24.28,
            "clicks": 35,
            "cpc": 0.69,
            "query": "wedding scrapbook album",
            "sales": 74.97
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 25.9,
            "clicks": 35,
            "cpc": 0.74,
            "query": "leather scrapbook album",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 12.55,
            "clicks": 18,
            "cpc": 0.7,
            "query": "scrapbooking album large",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.37,
            "clicks": 15,
            "cpc": 0.69,
            "query": "scrapbook photo albums",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 31,
          "non_converting": 574,
          "percent_converting": 0.0512,
          "total": 605
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "$",
    "date_from": "2022-03-10",
    "date_to": "2022-05-08",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-09T12:53:14.073977+00:00",
    "market": "US",
    "profile_ids": [
      1634231489365529
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 1506.1304287110738
  },
  "research_types": {
    "ad_spend": 1519.77,
    "percentage_of_total": 1.0
  },
  "sales": {
    "acos": 0.7161,
    "roas": 1.3964,
    "total": 2122.15,
    "total_orders": 85
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.6552,
        "ad_spend": 245.59,
        "sales": 374.85
      },
      "top_duplicate": [
        {
          "acos": 0.5853,
          "ad_groups": [
            "ALL_ALBUMS_Auto",
            "ALL_ALBUMS_Phrase"
          ],
          "ad_spend": 102.38,
          "campaigns": [
            156567342620333,
            215375160541024
          ],
          "match_types": [
            "AUTO",
            "PHRASE"
          ],
          "query": "scrapbook album",
          "sales": 174.93
        },
        {
          "acos": 0.3493,
          "ad_groups": [
            "ALL_ALBUMS_Auto",
            "ALL_ALBUMS_Phrase"
          ],
          "ad_spend": 52.37,
          "campaigns": [
            156567342620333,
            215375160541024
          ],
          "match_types": [
            "AUTO",
            "PHRASE"
          ],
          "query": "couples scrapbook",
          "sales": 149.94
        },
        {
          "acos": 1.02,
          "ad_groups": [
            "ALL_ALBUMS_Auto",
            "ALL_ALBUMS_Phrase"
          ],
          "ad_spend": 25.49,
          "campaigns": [
            156567342620333,
            215375160541024
          ],
          "match_types": [
            "AUTO",
            "PHRASE"
          ],
          "query": "scrap book",
          "sales": 24.99
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 62,
      "non_converting": 900,
      "total": 962
    }
  }
}