Use AdStage for Google Sheets to bring your cross-network data into Google Data Studio.
Step 1: Create a Google Sheet and build a formula with the components you need.
Best practices:
Set the entity level to the lowest you may need, for example ads. Then, include the other entities' names so you can roll up data to the different levels.
Include Aggregate By Day and the KPI, Date, so you can use time series charts like line charts.
Increase the limit so you see more than the default 25 entities.
Example call:
=ads("last 14 days", {"Ad Name", "Ad Group Name", "Campaign Name", "Spend", "Impressions", "Clicks", "Conversions", "Network", "Date"}, {"sort by", "clicks"}, {"aggregate by", "day"}, {"limit", 100})
Step 2: Open a new or existing sheet and click Create New Data Source.
Step 3: Select Google Sheets.
Step 4: Pick the spreadsheet and worksheet in which you built your formula.
Step 5: Create any calculated metrics you'd like, such as CTR and CPA.
Step 6: Add the data source to your sheet and start building!
Need help? Feel free to reach out to us at support@adstage.io if you have any questions.